sql How to get a value from a sql server database and display it in a label using c#?

[Shammikit]

i want to get a value from a column in my sql server database and display it in a label. so far i tried this but it didnt work.any suggestions how to get this working?

   SqlDataReader myReader = null;
    SqlCommand    myCommand = new SqlCommand("select details from Pictures where id ='"+x+"'");
    myReader = myCommand.ExecuteReader();
    label1.Text = myCommand.ToString();

 

[quantomworks]

Stack overflow is that way --> http://stackoverflow.com/questions/tagged/sql
 

[P4ZD4]

What does myCommand.ToString() return?

[Yamoto42]

You should really be using DataSets and TableAdapters if you're doing much meaningful database interaction.  They provide a strongly typed and locally cached abstraction over your actual database interface.