howto use dr in ASP.C#

Vote count:

0

I am learning to use select query for my program . This my code.

con.Open();

SqlCommand cmd = new SqlCommand("select id from qw where name='" + TextBox1.Text + "'", con);
SqlDataReader dr = SqlDataReader();
dr = cmd.ExecuteReader();
dr.read();
TextBox2.Text = dr[0].Tostring();
dr.close();
con.Close();

it show this error message

'System.Data.SqlClient.SqlDataReader' is a 'type' but is used like a 'variable'

asked 31 secs ago

Balaji

17

howto use dr in ASP.C#