c# DataTable、DataSet、DataReader

C# DataTable 详解

dataTable.Rows.Count == 0 //判断DataTable 为空

循环执行dataTable数据

DataTable dtSelect = (DataTable)this.ucGrid_main.DataSource;
string sql = string.Empty;
for (int i = 0; i < dtSelect.Rows.Count; i++)
{
　　DataRow dr = dtSelect.Rows[i];
　　if (dr["ISSELECT"].ToString() == "1")
　　{
　　　　string sCode = dtSelect.Rows[i]["ERP_WZBH"].ToString();
　　　　string sName = dtSelect.Rows[i]["MC"].ToString();
　　　　sql += " insert into base_material(code,name,name_old,time_create,creater,valid)";
　　　　sql += " values('" + sCode + "','" + sName + "','" + sName + "',GETDATE(),'" + Pub.Sys.mUserInfo.UserNo + "','1')";　　　　
　　}
}

 

 更新、修改DataTable列数据并返回给gridview

            float WeightTotal = float.Parse(this.text_WeightTotal.Text);
            DataTable dtSelect = (DataTable)this.ucGrid_selected.DataSource;
            for(int i = 0; i <= dtSelect.Rows.Count-1; i++)
            {
                float DetailWeightPlan = float.Parse(dtSelect.Rows[i]["weight_plan"].ToString());
                decimal weight = (decimal)((DetailWeightPlan / WeightPlan) * WeightTotal);
                dtSelect.Rows[i]["weight"] = weight;
            }
            this.ucGrid_selected.DataSource = dtSelect;

 

遍历datatable的几种方法（C# ）

 

C#中DataSet、DataTable、DataReader的区别

 

C# DataTable和DataRelation