System.Data.DataTable.Select C# (CSharp) Method

Select() public method

Returns an array of all objects.
public Select ( ) : DataRow[]
return DataRow[]
        public DataRow[] Select()
        {
            DataCommonEventSource.Log.Trace("<ds.DataTable.Select|API> {0}", ObjectID);
            return new Select(this, "", "", DataViewRowState.CurrentRows).SelectRows();
        }

Same methods

DataTable::Select ( string filterExpression ) : DataRow[]
DataTable::Select ( string filterExpression, string sort ) : DataRow[]
DataTable::Select ( string filterExpression, string sort, DataViewRowState recordStates ) : DataRow[]

Usage Example

Example #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            #region Check Login
            CheckRegionAdminSession();
            #endregion Check Login

            #region Initialize Values and Form Execution
            strPortfolioID = CCLib.Common.Strings.GetQueryString("PortfolioID");
            dtPortInfo = CCLib.Common.DataAccess.GetDataTable("select p.Username,GradeNumber,FirstName,LastName,p.UserName,u.institutionName from Portfolio p join Userinfo u on p.Schoolid = u.schoolid where portfolioid=" + strPortfolioID);
            strSQL = " select p.Username,p.Fullname,p.Address,p.City,p.State,p.Zip,p.Phone,p.Email,p.Password,p.IsImport ";
            strSQL += " from Port_Parent_View as p join Portfolio on p.Username = Portfolio.Username ";
            strSQL += " where PortfolioID=" + strPortfolioID + " and p.PortTypeID=" + PortTypeID;
            dtParents = CCLib.Common.DataAccess.GetDataTable(strSQL);
            drsParentByImport = dtParents.Select("IsImport=1");
            drsParentByInput = dtParents.Select("IsImport=0");

            strUsername = (dtPortInfo.Rows.Count > 0) ? dtPortInfo.Rows[0]["Username"].ToString() : "";

            #endregion Initialize Values and Form Execution

            #region Properties For The Region Base Class
            TitleBar = "Parent/Guardian Access Accounts";
            SubTitleBar = "Parent/Guardian Access Accounts";
            #endregion Properties For The Region Base Class
        }
All Usage Examples Of System.Data.DataTable::Select
DataTable