这是保存插入文本框中值的代码,可是每一次保存以后都会有好多条相同的记录,这是为什么
try
{
// SqlConnection con = new SqlConnection("server=(Local);user id=sa;pwd=;DataBase=cgb"); SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=company;Integrated Security=True;Pooling=False");
con.Open();
string InsertSql1 = "Insert Into cgbt(cgrq,ddh,ck,cglx,htbh,gys,gysdz,lxdh,jhr,jhfs,jhdd,jhrq,sfkp,fplb,fkyd,ydzffs,jkfs,jbr,jbbm,zje,bz)values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox23.Text + "','" + TextBox24.Text + "','" + TextBox5.Text + "','" + DropDownList3.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + DropDownList4.Text + "','" + DropDownList5.Text + "','" + TextBox12.Text + "','" + DropDownList6.Text + "','" + DropDownList7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "')";
string InsertSql2 = "Insert Into spb(hpbh,hpmc,gg,dw,pp,cd,sl,dj,je,shuilv)values('" + TextBox13.Text + "','" + TextBox14.Text + "','" + TextBox15.Text + "','" + TextBox16.Text + "','" + TextBox17.Text + "','" + TextBox18.Text + "','" + TextBox19.Text + "','" + TextBox20.Text + "','" + TextBox21.Text + "','" + TextBox22.Text + " ')";
SqlCommand com1 = new SqlCommand(InsertSql1, con);
SqlCommand com2 = new SqlCommand(InsertSql2, con); com1.ExecuteNonQuery();
com2.ExecuteNonQuery();
SqlDataAdapter ada1 = new SqlDataAdapter("Select * From cgb,spb", con);
try
{
// SqlConnection con = new SqlConnection("server=(Local);user id=sa;pwd=;DataBase=cgb"); SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=company;Integrated Security=True;Pooling=False");
con.Open();
string InsertSql1 = "Insert Into cgbt(cgrq,ddh,ck,cglx,htbh,gys,gysdz,lxdh,jhr,jhfs,jhdd,jhrq,sfkp,fplb,fkyd,ydzffs,jkfs,jbr,jbbm,zje,bz)values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox23.Text + "','" + TextBox24.Text + "','" + TextBox5.Text + "','" + DropDownList3.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + DropDownList4.Text + "','" + DropDownList5.Text + "','" + TextBox12.Text + "','" + DropDownList6.Text + "','" + DropDownList7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "')";
string InsertSql2 = "Insert Into spb(hpbh,hpmc,gg,dw,pp,cd,sl,dj,je,shuilv)values('" + TextBox13.Text + "','" + TextBox14.Text + "','" + TextBox15.Text + "','" + TextBox16.Text + "','" + TextBox17.Text + "','" + TextBox18.Text + "','" + TextBox19.Text + "','" + TextBox20.Text + "','" + TextBox21.Text + "','" + TextBox22.Text + " ')";
SqlCommand com1 = new SqlCommand(InsertSql1, con);
SqlCommand com2 = new SqlCommand(InsertSql2, con); com1.ExecuteNonQuery();
com2.ExecuteNonQuery();
SqlDataAdapter ada1 = new SqlDataAdapter("Select * From cgb,spb", con);
解决方案 »
- 【急】c#打包问题,,,在线等!!!
- 怎样用webbowser.document.cookie获取的cookie设置CookieContainer
- 想请教高手们多给一点关于c#中this 的用法和一些例子!谢谢了!
- C#控制word程序的版本问题,一直在苦恼中,希望高手解决一下
- 急求救ASP。NET里面怎么使用COOKIE架设购物篮
- 一个类的static 成员函数要操作该类的非static数据成员/成员函数 怎么做才可以?
- 还是IIS6.0的问题,搞了一天都没有好!希望各位帮一下忙!
- 关于时钟的问题,如果在timer1_Tick事件里运行的耗时比Interval还要大,那么程序就不停的循环,像死机一样,怎么解决?
- 在程序中有三个窗体Form,如何使得其中最开始的Form被激活?
- c#中 怎样将string转化为 把每个char用2个byte表示?而不是一个byte
- VSTO开发Excel自定义公式
- c# windows form编程控件中是否有哪个可以自定义模板的?
//发这么长的代码谁都会懒得看的.
//你可以尝试在这两段代码前设置断点
SqlCommand com1 = new SqlCommand(InsertSql1, con);
SqlCommand com2 = new SqlCommand(InsertSql2, con);
//然后把InsertSql1&InsertSql2的值取出来给大家看看.