C#：DataSet和DataTable用法

PS：此文仅做记录，不做他用

• DataSet

 

         CDictionary cDictionary = new CDictionary();            DataSet dsept = new DataSet();            dsManageDept = cDictionary.GetDictionary("TABLE1", "1=1 AND ABC <> '1' ORDER BY 1");            DataView dvDept = dsManageDept.Tables[0].DefaultView;            this.ddlDept.DataSource = dvDept;            this.ddlDept.DataTextField = "M_NAME";            this.ddlDept.DataValueField = "M_ID";            this.ddlDept.DataBind();

 

 

• DataTable

                string strSql = BingSQL();                     DataTable dt = cHanderOperater.GetDataTableBySql(strSql);                int iRowCount;//总记录数                if (dtd != null)                {                    //取得所有行数                    iRowCount = dtd.Rows.Count;                }                else                {                    iRowCount = 0;                }