＋设为首页 ＋添加到收藏夹
Sql="SELECT * FROM sys_user WHERE usr_id="+ Txtusr_id.Text +"";
MyDs=new DataSet();
MyAdpt=new System.Data.SqlClient.SqlDataAdapter(Sql,MyConn);
MyAdpt.Fill(MyDs,"search");
if (MyDs.Tables["search"].Columns.Count<=0)
{
Response.Write("Count="+MyDs.Tables["search"].Columns.Count);
if ((System.Boolean)(Txtusr_pwd.Text==Txtusr_pwdsure.Text))
{
Sql="INSERT INTO sys_user (usr_id,usr_name,usr_pwd) VALUES(@usr_id,@usr_name,@usr_pwd)";
Pama();
Response.Write("<script>alert(保存成功！)</script>");
SetNull();
BindGrid();
}
else
{
Response.Write("<script>alert(密码验证出错，请重新输入！)</script>");
}
}
else
{
Response.Write("Count="+MyDs.Tables["search"].Columns.Count);
Response.Write("<script>alert(用户编号重复，请重新输入！)</script>");
SetNull();
}
那个Count的怎么总是>0 呢？我的数据库表里面没有这条记录啊。晕～～
ds.Tables[0].Rows.Count
你的是列,而不是行!
Columns该为Rows
列数是大于０的。Columns
用Rows
