cmdinsert.ExecuteNonQuery();语句出错!
黑暗的救赎 2003-10-18 10:10:58 代码如下:(部分代码省略了)
string strcmd="select * from userinf where username='"+this.TextBox_uid.Text+"'";
try
{
SqlCommand cmd=new SqlCommand(strcmd,this.myconnect);
System.Data.SqlClient.SqlDataReader dr=cmd.ExecuteReader();
if(dr.Read())
{
this.msg.InnerHtml+="该用户名已经存在"+"<br>";
}
else
{
string strinsert="insert into userinf(username,password) values('ffff','dsfdfs')";
//我随便写的 SqlCommand cmdinsert=new SqlCommand(strinsert,this.myconnect );
cmdinsert.ExecuteNonQuery();
this.msg.InnerHtml+="户名注册成功"+"<br>";
this.msg.InnerHtml+="您的用户名是:"+this.TextBox_uid.Text +"<br>";
}
}
catch(SqlException ee)
{
this.msg.InnerHtml+=ee.Message;
}