导入excel模板数据时,总提示F1列不属于表,

请教,我导入excel模板数据时,总示F1列不属于表,反复检查过数据表、语句和模板,没找出问题来,请大家帮助排查一下吧,谢谢;

img

img


```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