protected bool val() //VAL是类型转换函数。把字符串转换为数值。

显示全部楼层 · 2010-6-18 15:51:41

protected bool val() //VAL是类型转换函数。把字符串转换为数值。

{

string conn = Convert.ToString(ConfigurationManager.ConnectionStrings["SmallHouseConn"]);

SqlConnection sqlcon = new SqlConnection(conn);

sqlcon.Open();

string sqlstr = "select count(*) from homeHold where uid='" + TextBox2.Text.ToString() + "'";
//Response.Write(sqlstr);

SqlCommand scd = new SqlCommand(sqlstr, sqlcon);

int count = Convert.ToInt32(scd.ExecuteScalar());

//Response.Write(count);

//Response.End();

if (count <= 0)

{

return true;

}

else

{

return false;

}

}
}
谁能帮我详细解释一下啊

千问 · 2010-6-18 15:51:41

protected bool val() //判断是否有uid为查询内容的数据{//获取web.config里的连接数据库字符串string conn = ConfigurationManager.ConnectionStrings["SmallHouseConn"].ToString();//打开数据库连接SqlConnection sqlcon = new SqlConnection(conn);sqlcon.Open();//查询字符串查询是否有uid为关键字的数据string sqlstr = "select count(*) from homeHold where uid='" + TextBox2.Text