编程菜鸟求助,请牛人们帮我看看,这段注册程序为什么运行不了呢?跪拜跪拜!
string srtcon = "Data Source=JUZI-PC\\SQLEXPRESS;Initial Catalog=Mybs;Persist Security Info=True;User ID=bs;Password=1";SqlConnection conn = new SqlConnection(srtcon);
conn.Open();
string strSql = "insert into MemberInfo(MemberID,MemberRName,MemberPassword,MemberName,MemberAge,MemberGender,MemberBirthday,MemberEmail,MemberAddress,MemberPhone,MemberPhoto,MemberType,MemberCardNo,Member) values (";
strSql = strSql + "'" +TbMId.Text + "',";
strSql = strSql + "'" + TbMRname.Text + "',";
strSql = strSql + "'" + TbMpsaaword.Text + "')";
strSql = strSql + "'" + TbMname.Text + "')";
strSql = strSql + "'" + Tbmage.Text + "')";
strSql = strSql + "'" + TextBox1.Text + "')";
strSql = strSql + "'" + TbMbirthday.Text + "')";
strSql = strSql + "'" + Tbmail.Text + "')";
strSql = strSql + "'" + Tbaddress.Text + "')";
strSql = strSql + "'" + Tbphone.Text + "')";
strSql = strSql + "'" + Tbphoto.Text + "')";
strSql = strSql + "'" + TextBox2.Text + "')";
strSql = strSql + "'" + TbCardno.Text + "')";
strSql = strSql + "'" + TbResume.Text + "')";
SqlCommand cmd = new SqlCommand(strSql, conn);
cmd.ExecuteNonQuery();
conn.Close();
lbmessage.Text = "您的注册信息已经提交成功!恭喜您成为了我们的会员!" --------------------编程问答-------------------- 单步执行跟踪会不会啊。
strSql = strSql + "'" + TbMpsaaword.Text + "'[color=#FF0000])";
strSql = strSql + "'" + TbMname.Text + "')";
strSql = strSql + "'" + Tbmage.Text + "')";
strSql = strSql + "'" + TextBox1.Text + "')";
strSql = strSql + "'" + TbMbirthday.Text + "')";
strSql = strSql + "'" + Tbmail.Text + "')";
strSql = strSql + "'" + Tbaddress.Text + "')";
strSql = strSql + "'" + Tbphone.Text + "')";
strSql = strSql + "'" + Tbphoto.Text + "')";
strSql = strSql + "'" + TextBox2.Text + "')";
strSql = strSql + "'" + TbCardno.Text + "')";[/color]
上面一眼就看出多拼接了个括号进去了
strSql = strSql + "'" + TbResume.Text + "')"; --------------------编程问答-------------------- 把那堆括号改为逗号才是 --------------------编程问答-------------------- 可以讲解的清楚点么?我还是不会。。。。 --------------------编程问答-------------------- strSql = strSql + "'" +TbMId.Text + "',";
strSql = strSql + "'" + TbMRname.Text + "',";
strSql = strSql + "'" + TbMpsaaword.Text + "',";
strSql = strSql + "'" + TbMname.Text + "',";
strSql = strSql + "'" + Tbmage.Text + "',";
strSql = strSql + "'" + TextBox1.Text + "',";
strSql = strSql + "'" + TbMbirthday.Text + "',";
strSql = strSql + "'" + Tbmail.Text + "',";
strSql = strSql + "'" + Tbaddress.Text + "',";
strSql = strSql + "'" + Tbphone.Text + "',";
strSql = strSql + "'" + Tbphoto.Text + "',";
strSql = strSql + "'" + TextBox2.Text + "',";
strSql = strSql + "'" + TbCardno.Text + "',";
strSql = strSql + "'" + TbResume.Text + "')";
这里可能还有类型问题。
我怀疑你数据库连接都不对呢。
string srtcon = "Data Source=JUZI-PC\\SQLEXPRESS;Initial Catalog=Mybs;Persist Security Info=True;User ID=bs;Password=1";
这里的数据库、用户、密码都对了吗。
--------------------编程问答-------------------- 这样的情况单步跟踪一下,看SQL是不是有问题,一个一个地检查下,一看生成的SQL就是有问题的 --------------------编程问答-------------------- 先练习基本功,这个别人帮不了你.sql语句的问题,跟踪调试,软件开发的基本功,问人能力很难提高 --------------------编程问答-------------------- 这样写不是更简单些吗??
string strSql = "insert into MemberInfo(MemberID,MemberRName,MemberPassword,MemberName,MemberAge,MemberGender,MemberBirthday,MemberEmail,MemberAddress,MemberPhone,MemberPhoto,MemberType,MemberCardNo,Member) values (
'" +TbMId.Text + "','" + TbMRname.Text + "','" + TbMpsaaword.Text + "', '" + TbMname.Text + "','"+ Tbmage.Text + "',
'"+ TextBox1.Text + "',
'"+ TbMbirthday.Text + "',
'" + Tbmail.Text + "',
'" + Tbaddress.Text + "',
'" + Tbphone.Text + "',
'" + Tbphoto.Text + "',
'" + TextBox2.Text + "',
'" + TbCardno.Text + "',
'" + TbResume.Text + "');
SqlCommand cmd = new SqlCommand(strSql, conn);
补充:.NET技术 , C#