Select Query is not working

Saafia NM

Table Name:Index

ID	Keyword
123,345,567	Test

I tried to get the ID values in a TextBox2 using following Code while entering the Keyword in TextBox1:

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());

protected void Button1_Click(object sender, EventArgs e)

{

SqlCommand cmd = new SqlCommand("select ID from Index where Keyword=@keyword",con);

cmd.Parameters.AddWithValue("@keyword",TextBox1.Text);

con.Open();

SqlDataReader dt = cmd.ExecuteReader();

if (dt.Read())

{

TextBox2.Text = dt.ToString();

}

But i got the result as

"System.Data.SqlClient.SqlDataReader" in the TextBox2 ; what is the problem in my code???

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar10y ago
Accepted answer
Try this

SqlDataAdapter cmd = new SqlDataAdapter("select ID from Index where Keyword=@keyword",con);
cmd.SelectCommand.Parameters.AddWithValue("@keyword",TextBox1.Text);
DataTable dt = new DataTable;
cmd.Fill(dt);
if (dt.Rows.Count>0)
{
TextBox2.Text = dt.Rows[0]["ID"].ToString();
}

If it helps you select it as correct answer.
Amit Kumar10y ago
Hi,
Use it after SqlDataReader dt = cmd.ExecuteReader();

using (var reader = cmd.ExecuteReader())
{
if (dt.Read())
{
intQ = int.Parse(dt[0].ToString());
}
else
{
intQ = 0;
}
}
TextBox2.Text = intQ.ToString();

It work properly...
Saafia NM10y ago
Thank You Sir!!!
Ranjit Powar10y ago
are you using above code?
Amit Kumar Singh10y ago
Error Msg
Saafia NM10y ago
Still facing same problem
Amit Kumar Singh10y ago
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString.ToString());