这个登陆功能的代码缺了一部分，需要怎么补充

Question

protected void LoginSubmit_click(object sender，EventArgs e)
{
string uname = name.Text.Trim( );
string pwd = password . Text.Trim( );
sqlConnection connection = new SqlConnection(ConfigurationIManager.connectionStrings["connectionString"].Tostring();
string sql = string.Format("select count(*) from userinfo where username='{0]}’ and passwond= '(1]""，uname，pad);
sqlcommand command = new sqlcommand(sql，connection);
connection.Open();
int a = (int)command.Executescalar();
connection.Close();
if (a > 0)//登陆成功{
Session[ "admin_user" ] = uname;}
else {//登陆失败
Response.write(" ");}
}

Answer 1

这是按你的要求修改的完整代码

 protected void LoginSubmit_click(object sender, EventArgs e)
        {
            string uname = name.Text.Trim();
            string pwd = password.Text.Trim();
            SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ToString());
            string sql = string.Format("select count(*) from userinfo where username='{0}'  and passwond= '{1}'", uname, pwd);
            SqlCommand command = new SqlCommand(sql, connection);
            connection.Open();
            int a = (int)command.ExecuteScalar();
            connection.Close();
            if (a > 0)
            {
                //登陆成功
                Session["admin_user"] = uname;
            }
            else
            {
                //登陆失败
                Response.Write(" ");
            }
        }