Try:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand com = new SqlCommand("SELECT name FROM myTable WHERE id=@ID", con))
{
com.Parameters.AddWithValue("@ID", iD);
using (SqlDataReader reader = com.ExecuteReader())
{
if (reader.Read())
{
myTextBox.Text = (string) reader["name"];
}
}
}
}
"tnx... one doubt instead of using datareader can we use datatable.. if we can means ...tel me with example..."
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand com = new SqlCommand("SELECT name FROM myTable WHERE id=@ID", con))
{
com.Parameters.AddWithValue("@ID", iD);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(com);
da.Fill(dt);
myTextBox.Text = (string) dt.Rows[0]["name"];
}
}