String sql2.CommandText = "insert into [user] (name,age,tel,mobile) values ('" + strname + "','" + strsex + "','" + strage + "','" + strtel + "','" + strmobile + "')";
改为:
String sql2.CommandText = "insert into [user] (name,sex,age,tel,mobile) values ('" + strname + "','" + strsex + "','" + strage + "','" + strtel + "','" + strmobile + "')";
String sql2.CommandText = "insert into [user] (name,age,tel,mobile) values ('" + strname + "','" + strsex + "','" + strage + "','" + strtel + "','" + strmobile + "')";
该为:
//String sql2.CommandText ,这个string好像是多余的吧~~~~~~
sql2.CommandText = string.Format( "intser into [user](name,sex,age,tel,mobile) values ('{0}', '{1}', '{2}', '{3}', '{4}')", strname ,strsex ,strage ,strtel ,strmobile );
使用string.Foramt()可以有效的处理字符串拼接处理,而且还不容易出错~~~~
if (strname!="" && strmobile!="")
{
右括号加了没