我在登录页面中出错 [英] I Got Error in Login Page

问题描述

SqlConnection con = new SqlConnection("conDb");
        con.Open();
        //Look at the login table for login credentials.
        SqlCommand cmd = new SqlCommand("Select * from Login where Username=? and Password=?", con);

        cmd.Parameters.Add("@username", SqlDbType.VarChar);
        cmd.Parameters["@username"].Value = this.TextBox1.Text;

        cmd.Parameters.Add("@password", SqlDbType.VarChar);
        cmd.Parameters["@password"].Value = this.TextBox2.Text;

        SqlDataReader dr = null;

        dr = cmd.ExecuteReader();

        if (dr.HasRows)
        {
            Response.Redirect("Default.aspx?username=" + this.TextBox1.Text);

        }

我在dr = cmd.ExecuteReader();中出现错误

感谢您宝贵的重播

con.Close();

I gor error in dr = cmd.ExecuteReader();

thanks for valuable replay

con.Close();

推荐答案

如果您没有提供足够的信息，则可能无法获得确切的解决方案.

您的连接字符串似乎不正确.请参阅下面的链接以获取正确的语法.

http://www.connectionstrings.com/sql-server

You may not get exact solution for your problem if you do not provide enough information.

Your connection string seems to be incorrect. Refer below link for proper syntax.

http://www.connectionstrings.com/sql-server

Change Your COde

SqlConnection con = new SqlConnection(conDb);
       con.Open();
       //Look at the login table for login credentials.
       SqlCommand cmd = new SqlCommand("Select * from Login where Username=@username and Password=@password", con);

       cmd.Parameters.Add("@username", SqlDbType.VarChar);
       cmd.Parameters["@username"].Value = this.TextBox1.Text;

       cmd.Parameters.Add("@password", SqlDbType.VarChar);
       cmd.Parameters["@password"].Value = this.TextBox2.Text;

       SqlDataReader dr = null;

       dr = cmd.ExecuteReader();

       if (dr.HasRows)
       {
           Response.Redirect("Default.aspx?username=" + this.TextBox1.Text);

       }

这篇关于我在登录页面中出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！