C#做登陆界面连接sql server的问题

[陈烦烦]

做了一个仿淘宝界面登陆框,打算是当输入用户名和密码时,到数据库中查询,有数据匹配则显示"登陆成功",否则显示"登陆失败"
但是运行之后显示界面，输入数据库已有账号测试时显示System.Data.SqlClient.SqlException:“Could not find stored procedure 'selectsql'.”
标志在sdr = cmd.ExecuteReader();这句上
想问问怎么解决
全代码这在
private void button1_Click(object sender, EventArgs e)
{
string str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=tmall;Integrated Security=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
String selectsql = "Select * from client where name='" + textBox1.Text + "'and password='" + textBox2.Text + "'";

SqlCommand cmd = new SqlCommand("selectsql", conn);
cmd.CommandType = CommandType.Text;
SqlDataReader sdr;
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
test.Text = "登录成功";
}
else
{
test.Text = "登录失败";
return;
}

}

[键盘敲出字]

先把语言的基础打好了再来写代码吧

private void button1_Click(object sender, EventArgs e)
        {
            string str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=tmall;Integrated Security=True";
            SqlConnection conn = new SqlConnection(str);
            conn.Open();
            String selectsql = "Select * from client where name='" + textBox1.Text + "'and password='" + textBox2.Text + "'";
            //原来的
            SqlCommand cmd = new SqlCommand("selectsql", conn);
            //修改为
            SqlCommand cmd = new SqlCommand(selectsql, conn);
            cmd.CommandType = CommandType.Text;
            SqlDataReader sdr;
            sdr = cmd.ExecuteReader();
            if (sdr.Read())
            {
                test.Text = "登录成功";
            }
            else
            {
                test.Text = "登录失败";
                return;
            }

        }

[jerysab]

引用 2 楼 a755362405 的回复:

先把语言的基础打好了再来写代码吧

private void button1_Click(object sender, EventArgs e)
        {
            string str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=tmall;Integrated Security=True";
            SqlConnection conn = new SqlConnection(str);
            conn.Open();
            String selectsql = "Select * from client where name='" + textBox1.Text + "'and password='" + textBox2.Text + "'";
            //原来的
            SqlCommand cmd = new SqlCommand("selectsql", conn);
            //修改为
            SqlCommand cmd = new SqlCommand(selectsql, conn);
            cmd.CommandType = CommandType.Text;
            SqlDataReader sdr;
            sdr = cmd.ExecuteReader();
            if (sdr.Read())
            {
                test.Text = "登录成功";
            }
            else
            {
                test.Text = "登录失败";
                return;
            }

        }

[良朋]

错误提示已经很明显了，此处不应加引号。
SqlCommand cmd = new SqlCommand("selectsql", conn);

[enaking]

SqlCommand cmd = new SqlCommand("selectsql", conn); 去掉双引号，看来你没有基础啊。需要打一下基础哦，不然照你现在状态后面会很困难。

[陈烦烦]

最好能详细讲下，新手上路