请教,我用了5个textbox 和datetimepicker 组件
private void button1_Click(object sender, EventArgs e)
{
string pm = pm2.Text;
string xh = xh2.Text;
string price = jg2.Text;
string csl= sl2.Text;
string cname = cm.Text;
string date1 = sj.Text;
if (pm2.Text == "" || sj.Text == "" || jg2.Text == "" || sl2.Text == "" || cm.Text == "")
{
if (pm2.Text == "")
{ MessageBox.Show("品名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
pm2.Focus();
return;
}
if (jg2.Text == "")
{ MessageBox.Show("价格不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
jg2.Focus();
return;
} if (sl2.Text == "")
{ MessageBox.Show("数量不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
sl2.Focus();
return;
}
if (cm.Text == "")
{ MessageBox.Show("厂名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
cm.Focus();
return;
}
if (sj.Text == "")
{ MessageBox.Show("时间不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
sj.Focus();
return;
}
}
else
{
SqlConnection myConn = new SqlConnection("user id=sa; password=123; initial catalog='g&s'");
myConn.Open();
try
{ SqlCommand myComm = new SqlCommand("insert into cg values ('" + pm + "','" + xh + "','" + csl + "','" + price + "','" + cname + "','"+date1+"'", myConn);
myComm.ExecuteNonQuery();
MessageBox.Show("数据已经添加成功", "温馨提示");
myConn.Close();
}
catch (Exception )
{
MessageBox.Show("数据添加失败", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
} }
为什么我这个程序可以运行但是数据无法成功添加,请问哪里出错了!我数据库时间上用了datetime 类型
private void button1_Click(object sender, EventArgs e)
{
string pm = pm2.Text;
string xh = xh2.Text;
string price = jg2.Text;
string csl= sl2.Text;
string cname = cm.Text;
string date1 = sj.Text;
if (pm2.Text == "" || sj.Text == "" || jg2.Text == "" || sl2.Text == "" || cm.Text == "")
{
if (pm2.Text == "")
{ MessageBox.Show("品名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
pm2.Focus();
return;
}
if (jg2.Text == "")
{ MessageBox.Show("价格不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
jg2.Focus();
return;
} if (sl2.Text == "")
{ MessageBox.Show("数量不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
sl2.Focus();
return;
}
if (cm.Text == "")
{ MessageBox.Show("厂名不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
cm.Focus();
return;
}
if (sj.Text == "")
{ MessageBox.Show("时间不能为空", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
sj.Focus();
return;
}
}
else
{
SqlConnection myConn = new SqlConnection("user id=sa; password=123; initial catalog='g&s'");
myConn.Open();
try
{ SqlCommand myComm = new SqlCommand("insert into cg values ('" + pm + "','" + xh + "','" + csl + "','" + price + "','" + cname + "','"+date1+"'", myConn);
myComm.ExecuteNonQuery();
MessageBox.Show("数据已经添加成功", "温馨提示");
myConn.Close();
}
catch (Exception )
{
MessageBox.Show("数据添加失败", "警告提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
} }
为什么我这个程序可以运行但是数据无法成功添加,请问哪里出错了!我数据库时间上用了datetime 类型
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货