网页帐号登陆的代码问题

来源：百度知道编辑：UC知道时间：2024/06/18 05:20:36

SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings ["testConn"].ConnectionString );
string sql = "select count (*) from yonghu info where UserName='" + tb_yh.Text + "' and UserPwd ='" + tb_mm.Text + "'";
sqlconn.Open();
SqlCommand sqlcmd = new SqlCommand(sql,sqlconn);
object result = sqlcmd.ExecuteScalar();
if (result != null )
{
Response.Redirect("http://www.baidu.com");
}
else
{
Response.Write("用户名或密码输入错误");
}
sqlconn.Close();
代码为上面那个可是不管输入什么都可以登入，要怎么改才能在有注册的用户才能登陆。。。
是c#

SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["testConn"].ConnectionString);
SqlCommand myCommand = new SqlCommand("select count (*) from yonghu info where UserName=@UserName and UserPwd =@Userpwd", myConnection);

SqlParameter parUserID = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
parUserID.Value = tb_yh.Text ;
SqlParameter parUserpwd = new SqlParameter("@Userpwd", SqlDbType.VarChar, 50);
parUserpwd.Value = tb_mm.Text ;
myCommand.CommandType=CommandType.Text;
myCommand.Parameters.Add(parUserID);
myCommand.Parameters.Add(parUserpwd);
myConnection.Open();
SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
if(result.read())
{
Response.Redirect("网页帐号登陆的代码问题网页限制帐号的登陆怎么办？网页代码的问题!!! 网页代码的问题. 网页代码的问题网页代码的问题~ 网页的代码问题网页代码的问题`` 显示登陆页面的情况网页代码网页登陆代码