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;