请教个问题,我想加个判断,若有表格数据的导入,就保存生效,若是空点该保存按钮,就请给个提示,目前的代码如下,不知怎么设置,做为向下的,能导入表格数据的触发条件,请指导一下;
```c#
private void btnsave_Click(object sender, EventArgs e)
{
conn = new SqlConnection("server=192.168.100.247;database=Whmesinfo;user=sa;password=whyy@2021");
conn.Open();
if (log == false) ;
{
MessageBox.Show("请您先导入数据,再保存");
return;
}
if (log == true) ;
{
try
{
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][0]);
comm.Parameters.AddWithValue("@reportdate", dtTemp.Rows[i][1]);
comm.Parameters.AddWithValue("@name", dtTemp.Rows[i][2]);
comm.Parameters.AddWithValue("@batchNo", dtTemp.Rows[i][3]);
comm.Parameters.AddWithValue("@samplepoint", dtTemp.Rows[i][4]);
comm.Parameters.AddWithValue("@samplelocation", dtTemp.Rows[i][5]);
comm.Parameters.AddWithValue("@checkno", dtTemp.Rows[i][6]);
comm.Parameters.AddWithValue("@region", dtTemp.Rows[i][7]);
comm.Parameters.AddWithValue("@AIT", dtTemp.Rows[i][8]);
comm.Parameters.AddWithValue("@MOULD", dtTemp.Rows[i][9]);
comm.Parameters.AddWithValue("@CACLY", dtTemp.Rows[i][10]);
comm.Parameters.AddWithValue("@SFM", dtTemp.Rows[i][11]);
comm.Parameters.AddWithValue("@SLM", dtTemp.Rows[i][12]);
comm.Parameters.AddWithValue("@ABM", dtTemp.Rows[i][13]);
comm.Parameters.AddWithValue("@result", dtTemp.Rows[i][14]);
comm.Parameters.AddWithValue("@note", dtTemp.Rows[i][15]);
comm.ExecuteNonQuery();
SqlCommand cmd = new SqlCommand(SqlString, conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
}
MessageBox.Show("导入成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
MessageBox.Show("请导入内容后,再保存");
}
finally
{
conn.Close();
}
}
}
```
你数据存在哪呢,我怎么没有找到
dtTempImport的注释是导入的模板,按理说里面应该只有格式,没有数据才对