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的几种方法(C# )
C#中DataSet、DataTable、DataReader的区别