ArrayList list1 = new ArrayList();
DataTable dt = GetDgvToTable(this.skinDataGridView1);
string str = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
switch (dt.Rows[i]["BJ"])
{
case "DCF-电磁阀()":
str = "DCF";
break;
case "DJ-电机()":
str = "DJ";
break;
case "DYB-电源板()":
str = "DYB";
break;
case "JPB-键盘板()":
str = "JPB";
break;
case "JPXP-键盘芯片()":
str = "JPXP";
break;
case "JSXP-计算器芯片()":
str = "JSXP";
break;
case "LLJ-流量计()":
str = "LLJ";
break;
case "SKXP-税控芯片()":
str = "SKXP";
break;
case "XSB-显示板()":
str = "XSB";
break;
case "YB-油泵()":
str = "YB";
break;
case "YQ-油枪()":
str = "YQ";
break;
case "ZB-主板()":
str = "ZB";
break;
default:
break;
}
dt.Rows[i]["BJ"] = str;
}
foreach (DataRow item in dt.Rows)
{
StringBuilder sb = new StringBuilder(" INSERT INTO JYJBJ (CCBH, BJ, BH, XLH, SL)VALUES ");
sb.Append(" ( '" + txb_Number.Text + "'");
sb.Append(" , '" + Convert.ToString(item["BJ"]) + "'");
sb.Append(" , '" + Convert.ToString(item["BH"]) + "'");
sb.Append(" , '" + Convert.ToString(item["XLH"]) + "'");
sb.Append(" , '" + Convert.ToString(item["SL"]) + "')");
list1.Add(sb.ToString());
}
///
/// DataGridView转换DataTable
///
///
///
public DataTable GetDgvToTable(DataGridView dgv)
{
DataTable dt = new DataTable();
// 列强制转换
for (int count = 0; count < dgv.Columns.Count; count++)
{
DataColumn dc = new DataColumn(dgv.Columns[count].Name.ToString());
dt.Columns.Add(dc);
}
// 循环行
for (int count = 0; count < dgv.Rows.Count; count++)
{
DataRow dr = dt.NewRow();
for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)
{
dr[countsub] = Convert.ToString(dgv.Rows[count].Cells[countsub].Value);
}
dt.Rows.Add(dr);
}
return dt;
}
DataTable转 DataGridView 循环获取每一个字段存入list
最新推荐文章于 2023-08-30 21:41:55 发布