求教代码问题,VS2003用C#做winForm窗体,往数据库中添加数据出错 数据库winformc#VS2003 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这是代码private void button1_Click(object sender, System.EventArgs e){string str;string a1 = this.textBox1.Text;string a2 = this.textBox2.Text;string a3 = this.textBox3.Text;string a4 = this.textBox4.Text;string a5 = this.textBox5.Text;string a6 = this.textBox6.Text;string a7 = this.textBox7.Text;string a8 = this.textBox8.Text;string a9 = this.textBox9.Text;str = "INSERT INTO individualinfo (用户姓名,手机号码,密码,性别,身份证号,驾驶证号,电子邮箱,邮政编码,家庭住址) VALUES ('" + a1 + "','" + a2 + "','" + a3 + "','" + a4 + "','" + a5 + "','" + a6 + "','" + a7 + "','" + a8 + "','" + a9 + "')";SqlConnection conn = new SqlConnection();conn.ConnectionString = "server=(local);uid=sa;password=sa;database=CarRental;";conn.Open();//和数据元建立连接SqlCommand comm = new SqlCommand();comm.Connection = conn;comm.CommandType = CommandType.Text;comm.CommandText = str;comm.ExecuteNonQuery();SqlCommand cmd = new SqlCommand();cmd.Connection = conn;cmd.CommandType = CommandType.StoredProcedure;cmd.CommandText = "addke";SqlParameter pm = new SqlParameter("@xm", SqlDbType.Char ,10);pm.Direction = ParameterDirection.Input;pm.Value = textBox1.Text;cmd.Parameters.Add(pm);SqlParameter pm1 = new SqlParameter("@sj", SqlDbType.Char ,20);pm1.Direction = ParameterDirection.Input;pm1.Value = textBox2.Text;cmd.Parameters.Add(pm1);SqlParameter pm2 = new SqlParameter("@mm", SqlDbType.Char, 20);pm2.Direction = ParameterDirection.Input;pm2.Value = textBox3.Text;cmd.Parameters.Add(pm2);SqlParameter pm3 = new SqlParameter("@xb", SqlDbType.Char, 10);pm3.Direction = ParameterDirection.Input;pm3.Value = textBox4.Text;cmd.Parameters.Add(pm3);SqlParameter pm4 = new SqlParameter("@sfz", SqlDbType.Char, 30);pm4.Direction = ParameterDirection.Input;pm4.Value = textBox5.Text;cmd.Parameters.Add(pm4);SqlParameter pm5 = new SqlParameter("@jsz", SqlDbType.Char, 30);pm5.Direction = ParameterDirection.Input;pm5.Value = textBox6.Text;cmd.Parameters.Add(pm5);SqlParameter pm6 = new SqlParameter("@yx", SqlDbType.Char, 50);pm.Direction = ParameterDirection.Input;pm.Value = textBox7.Text;cmd.Parameters.Add(pm6);SqlParameter pm7 = new SqlParameter("@yz", SqlDbType.Char, 10);pm1.Direction = ParameterDirection.Input;pm1.Value = textBox8.Text;cmd.Parameters.Add(pm7);SqlParameter pm8 = new SqlParameter("@zz", SqlDbType.Char, 100);pm2.Direction = ParameterDirection.Input;pm2.Value = textBox9.Text;cmd.Parameters.Add(pm8);cmd.ExecuteNonQuery();conn.Close();} 我用的是SQL2000其中还有个用户编号,但我设置成会自动+1的情况,所以不添加用户编号了,这会出错吗 跟用户编号没多大关系cmd不要用CommandType.StoredProcedure 用CommandType.Text你在出错语句前输出str的内容看下sql对不对MessageBox.Show(str);cmd.ExecuteNonQuery(); @xm INSERT INTO individualinfo (用户姓名 表列名,所有列名相同 求教 C# COMException未处理?高分悬赏 用户登录问题(新手). winform的focus问题,很奇怪,大家遇到过的帮帮忙 改变msAgent的大小 vs.net2003项目开发完做安装包,如何将项目引用的activex控件一起打包? 关于接口实现的疑问? 太菜的问题,主要是我很菜!关于变量的问题! 奇怪的CHARINDEX C# 编码问题 请问哪个区是讨论关于WPF和WPF\E的 asp.net c#淘宝api怎么获取当前使用的优惠价格 C#模拟登录网站后post get出现问题
string str;
string a1 = this.textBox1.Text;
string a2 = this.textBox2.Text;
string a3 = this.textBox3.Text;
string a4 = this.textBox4.Text;
string a5 = this.textBox5.Text;
string a6 = this.textBox6.Text;
string a7 = this.textBox7.Text;
string a8 = this.textBox8.Text;
string a9 = this.textBox9.Text;
str = "INSERT INTO individualinfo (用户姓名,手机号码,密码,性别,身份证号,驾驶证号,电子邮箱,邮政编码,家庭住址) VALUES ('" + a1 + "','" + a2 + "','" + a3 + "','" + a4 + "','" + a5 + "','" + a6 + "','" + a7 + "','" + a8 + "','" + a9 + "')";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=(local);uid=sa;password=sa;database=CarRental;";
conn.Open();//和数据元建立连接
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandType = CommandType.Text;
comm.CommandText = str;
comm.ExecuteNonQuery();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "addke";
SqlParameter pm = new SqlParameter("@xm", SqlDbType.Char ,10);
pm.Direction = ParameterDirection.Input;
pm.Value = textBox1.Text;
cmd.Parameters.Add(pm);
SqlParameter pm1 = new SqlParameter("@sj", SqlDbType.Char ,20);
pm1.Direction = ParameterDirection.Input;
pm1.Value = textBox2.Text;
cmd.Parameters.Add(pm1);
SqlParameter pm2 = new SqlParameter("@mm", SqlDbType.Char, 20);
pm2.Direction = ParameterDirection.Input;
pm2.Value = textBox3.Text;
cmd.Parameters.Add(pm2);
SqlParameter pm3 = new SqlParameter("@xb", SqlDbType.Char, 10);
pm3.Direction = ParameterDirection.Input;
pm3.Value = textBox4.Text;
cmd.Parameters.Add(pm3);
SqlParameter pm4 = new SqlParameter("@sfz", SqlDbType.Char, 30);
pm4.Direction = ParameterDirection.Input;
pm4.Value = textBox5.Text;
cmd.Parameters.Add(pm4);
SqlParameter pm5 = new SqlParameter("@jsz", SqlDbType.Char, 30);
pm5.Direction = ParameterDirection.Input;
pm5.Value = textBox6.Text;
cmd.Parameters.Add(pm5);
SqlParameter pm6 = new SqlParameter("@yx", SqlDbType.Char, 50);
pm.Direction = ParameterDirection.Input;
pm.Value = textBox7.Text;
cmd.Parameters.Add(pm6);
SqlParameter pm7 = new SqlParameter("@yz", SqlDbType.Char, 10);
pm1.Direction = ParameterDirection.Input;
pm1.Value = textBox8.Text;
cmd.Parameters.Add(pm7);
SqlParameter pm8 = new SqlParameter("@zz", SqlDbType.Char, 100);
pm2.Direction = ParameterDirection.Input;
pm2.Value = textBox9.Text;
cmd.Parameters.Add(pm8);
cmd.ExecuteNonQuery();
conn.Close();}
cmd不要用CommandType.StoredProcedure 用CommandType.Text你在出错语句前输出str的内容看下sql对不对
MessageBox.Show(str);
cmd.ExecuteNonQuery();
表列名,所有列名相同