Trouble writing a select query [closed]

问题:

I want to select table data in my page. Kindly provide a solution for my select query.

This is my code:

con.Open()
cmd = New SqlCommand("select name from wq where id='" + TextBox1.Text + "'", con)
dr = cmd.ExecuteReader
While dr.Read
    TextBox2.Text = dr(0)
End While
dr.Close()
con.Close()

回答1:

It looks like vb code if you want c# code then use following code

    cmd = new SqlCommand("select name from wq where id='" + TextBox1.Text + "'", con);
    con.Open();
    dr = cmd.ExecuteReader();
    dr.Read();
    TextBox2.Text = dr[0].ToString();
    dr.Close();
    con.Close();