正常添加一条数据没有问题,如果连续添加就只能添加第一条数据,后面的没有添加到数据库,不知道是什么原因!部分代码如下! if (TextBox1.Text != "")//产品一
{
string id1 = "insert into chp(mingcheng,leixing,tupian,jieshao,kucun,guige,bianhao,shijian,xianshi)values('" + TextBox1.Text + "','" + DropDownList1.SelectedValue.ToString() + "','" + Label8.Text + "','" + TextBox4.Text + "','充足','" + TextBox3.Text + "','" + TextBox2.Text + "',#" + DateTime.Now.ToShortDateString() + "#,'是')";
try
{
con.OleDbcom(id1); }
catch { Response.Write("<script lanuage=javascript>alert('未知错误!!')</script>"); }
} if (TextBox5.Text != "")//产品二
{
string id2 = "insert into chp(mingcheng,leixing,tupian,jieshao,kucun,guige,bianhao,shijian,xianshi)values('" + TextBox5.Text + "','" + DropDownList2.SelectedValue.ToString() + "','" + Label13.Text + "','" + TextBox8.Text + "','充足','" + TextBox7.Text + "','" + TextBox6.Text + "',#" + DateTime.Now.ToShortDateString() + "#,'是')";
try
{
con.OleDbcom(id2); }
catch { Response.Write("<script lanuage=javascript>alert('未知错误!!')</script>"); }
}
{
string id1 = "insert into chp(mingcheng,leixing,tupian,jieshao,kucun,guige,bianhao,shijian,xianshi)values('" + TextBox1.Text + "','" + DropDownList1.SelectedValue.ToString() + "','" + Label8.Text + "','" + TextBox4.Text + "','充足','" + TextBox3.Text + "','" + TextBox2.Text + "',#" + DateTime.Now.ToShortDateString() + "#,'是')";
try
{
con.OleDbcom(id1); }
catch { Response.Write("<script lanuage=javascript>alert('未知错误!!')</script>"); }
} if (TextBox5.Text != "")//产品二
{
string id2 = "insert into chp(mingcheng,leixing,tupian,jieshao,kucun,guige,bianhao,shijian,xianshi)values('" + TextBox5.Text + "','" + DropDownList2.SelectedValue.ToString() + "','" + Label13.Text + "','" + TextBox8.Text + "','充足','" + TextBox7.Text + "','" + TextBox6.Text + "',#" + DateTime.Now.ToShortDateString() + "#,'是')";
try
{
con.OleDbcom(id2); }
catch { Response.Write("<script lanuage=javascript>alert('未知错误!!')</script>"); }
}
解决方案 »
- 求解asp:DropDownList控件的刷新问题
- 三个人开发一套CMS 需要多久?
- Invalid attempt to Read when reader is closed.
- 关于Cookie的问题
- 请问要怎么遍历一个Model对象呢?
- url重写 正则表达式问题
- 想做个新闻采集,页面内容用webclient抓回来后,求1个提取新闻内容的正则表达式,
- 怎么打开别人的源文件阿?
- Server.tranfer可以跳转,可是用Response.redirect不成功
- Please tell me how to pop up a MessageBox.
- 关于IIS 7.5默认页面设置的问题,在线等高手解答
- 开发网站用什么操作系统好?
{
string id1 = "insert into chp(mingcheng,leixing,tupian,jieshao,kucun,guige,bianhao,shijian,xianshi)values('" + TextBox1.Text + "','" + DropDownList1.SelectedValue.ToString() + "','" + Label8.Text + "','" + TextBox4.Text + "','充足','" + TextBox3.Text + "','" + TextBox2.Text + "',#" + DateTime.Now.ToShortDateString() + "#,'是')";
int cm = con.OleDbcom(id1);
if(cm>0)
{
string id2 = "insert into chp(mingcheng,leixing,tupian,jieshao,kucun,guige,bianhao,shijian,xianshi)values('" + TextBox5.Text + "','" + DropDownList2.SelectedValue.ToString() + "','" + Label13.Text + "','" + TextBox8.Text + "','充足','" + TextBox7.Text + "','" + TextBox6.Text + "',#" + DateTime.Now.ToShortDateString() + "#,'是')";
}}