请教,我导入excel模板数据时,总示F1列不属于表,反复检查过数据表、语句和模板,没找出问题来,请大家帮助排查一下吧,谢谢;
```c#
conn = new SqlConnection("server=192.168.100.247;database=Whmesinfo;user=sa;password=whyy@2021");
conn.Open();
try
{
if (log == true)
{
System.Data.DataTable dt = new System.Data.DataTable();
System.Data.DataTable dtTemp = dtTempImport; //导入的模板
for (int i = 0; i < dtTemp.Rows.Count; i++)
{
if (i == 0)
continue;
string strsql = @"INSERT INTO [dbo].[w_Qctableg]
([sampledate],[reportdate],[name],[batchNo],[samplepoint],[samplelocation],[checkno],[region],[AIT],[MOULD],[CACLY],[SFM],[SLM],[ABM],[result],[note])
values
(@sampledate,@reportdate, @name, @batchNo, @samplepoint, @samplelocation,@checkno,@region,@AIT, @MOULD,@CACLY, @SFM, @SLM, @ABM,@result, @note)";
SqlCommand comm = new SqlCommand(strsql, conn);
comm.Parameters.AddWithValue("@sampledate", dtTemp.Rows[i]["F1"]);
comm.Parameters.AddWithValue("@reportdate", dtTemp.Rows[i]["F2"]);
comm.Parameters.AddWithValue("@name", dtTemp.Rows[i]["F3"]);
comm.Parameters.AddWithValue("@batchNo", dtTemp.Rows[i]["F4"]);
comm.Parameters.AddWithValue("@samplepoint", dtTemp.Rows[i]["F5"]);
comm.Parameters.AddWithValue("@samplelocation", dtTemp.Rows[i]["F6"]);
comm.Parameters.AddWithValue("@checkno", dtTemp.Rows[i]["F7"]);
comm.Parameters.AddWithValue("@region", dtTemp.Rows[i]["F8"]);
comm.Parameters.AddWithValue("@AIT", dtTemp.Rows[i]["F9"]);
comm.Parameters.AddWithValue("@MOULD", dtTemp.Rows[i]["F10"]);
comm.Parameters.AddWithValue("@CACLY", dtTemp.Rows[i]["F11"]);
comm.Parameters.AddWithValue("@SFM", dtTemp.Rows[i]["F12"]);
comm.Parameters.AddWithValue("@SLM", dtTemp.Rows[i]["F13"]);
comm.Parameters.AddWithValue("@ABM", dtTemp.Rows[i]["F14"]);
comm.Parameters.AddWithValue("@result", dtTemp.Rows[i]["F15"]);
comm.Parameters.AddWithValue("@note", dtTemp.Rows[i]["F16"]);
comm.ExecuteNonQuery();
SqlCommand cmd = new SqlCommand(SqlString, conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
}
MessageBox.Show("导入成功");
}
你可以断点看一下DataTable里面的属性名称是什么,应该不是F1