Database Select To Label

Hello!


I am trying
to select info from a database (MS-SQL) and show that whit a label. And don’t really
get every thing to work. So I am glad for that help I can get.


 

SqlConnection myConnection = new SqlConnection();


       
myConnection.ConnectionString = "data
source='XXX';User ID='XXX';Password=XXX;database='XXX'";


        myConnection.Open();


        SqlCommand dataCommand = new
SqlCommand();


        dataCommand.Connection
= myConnection;


       
dataCommand.CommandText = "SELECT XXX,XXX FROM XXX";


        SqlDataReader dataReader =
dataCommand.ExecuteReader();


        string notis1 = dataReader;


        Label1.Text = notis1;


        myConnection.Close(); Any help whould be helpfoul.