请问一下,我的数据库插入,需要在当前表单(日期、批号和车间),新增录入,在新增表单(很多项),点击确定后,将文本框内容都插入到数据库里面,但我确定,没有反应,数据库里面,也没有内容,代码和表单截图如下,请看看哪里有问题;
```c#
private void btnsave_Click(object sender, EventArgs e)
{
Form1 form1 = new Form1();
DateTime inputdate = form1.dateTimePicker1.Value;
string inputworkshop = form1.comworkshop.Text;
string inputbatchNo = form1.batchNo.Text;
string inputprocess = comprocess.Text;
string inputteams = comteams.Text;
string inputbanci = textbc.Text;
string inputproname = comproduct.Text;
string inputspec = comspec.Text;
string inputunit = comunit.Text;
string inputstate = comstate.Text;
string inputdaypro = daypro.Text;
string inputsumpro = sumpro.Text;
string inputpax = pax.Text;
string inputulh = ulh.Text;
string inputnote = note.Text;
SqlConnection Conn = new SqlConnection("server= 192.168.100.247; database= Whmesinfo;User= Sa;Password=whyy@2021");
Conn.Open();
string str = "select count(*) from w_prohourcount where batchNo='" + inputbatchNo.ToString() + "'";
SqlCommand com = new SqlCommand(str, Conn);
int intcont = Convert.ToInt32(com.ExecuteScalar());
if (intcont > 0)//判断数据库中是否有相同的录
{
//Response.write("alert('对不起!不允许填写相同记录!')");
Console.WriteLine("不允许填写相同记录");
}
else
{
try
{
string SqlString = @"INSERT INTO [dbo].[w_prohourcount]
(date,workshop,teams,banci,process,batchNo,proname,spec,unit,daypro,sumpro,state,pax,ulh,note)
values
(@date,@workshop,@teams,@banci,@process,@batchNo,@proname, @spec,@unit,@daypro,@sumpro,@state,@pax,@ulh,@note)";
SqlCommand comm = new SqlCommand(SqlString, Conn);
comm.Parameters.AddWithValue("@date", inputdate);
comm.Parameters.AddWithValue("@workshop", inputworkshop);
comm.Parameters.AddWithValue("@teams", inputteams);
comm.Parameters.AddWithValue("@banci", inputbanci);
comm.Parameters.AddWithValue("@process", inputprocess);
comm.Parameters.AddWithValue("@batchNo", inputbatchNo);
comm.Parameters.AddWithValue("@proname", inputproname);
comm.Parameters.AddWithValue("@spec", inputspec);
comm.Parameters.AddWithValue("@unit", inputunit);
comm.Parameters.AddWithValue("@daypro", inputdaypro);
comm.Parameters.AddWithValue("@sumpro", inputsumpro);
comm.Parameters.AddWithValue("@state", inputstate);
comm.Parameters.AddWithValue("@pax", inputpax);
comm.Parameters.AddWithValue("@ulh", inputulh);
comm.Parameters.AddWithValue("@note", inputnote);
comm.ExecuteNonQuery();
MessageBox.Show("数据保存成功!");
}
catch (Exception ex)
{
// 显示保存失败的错误信息
MessageBox.Show("保存失败:" + ex.Message);
}
finally
{
// 关闭数据库连接
Conn.Close();
}
}
}
找到原因了,主要是验证批号那里检验有问题,暂时注释掉就解决了;
不知道你这个问题是否已经解决, 如果还没有解决的话: