displsying large volume of text in a label control form the database

[suxxess]

I need help

I just started learning .net with C# and

I would like to to know how to display a particlular record from the statement below

"SELECT content FROM tbl_sitecontent WHERE pagetitle = 'Home' "

i do not want to use a datagrid or a repeater of any sort is there a way it can be bound to a label control

thank u

[dotexe]

I need help

I just started learning .net with C# and

I would like to to know how to display a particlular record from the statement below

"SELECT content FROM tbl_sitecontent WHERE pagetitle = 'Home' "

i do not want to use a datagrid or a repeater of any sort is there a way it can be bound to a label control

thank u

string select = "SELECT content FROM tbl_sitecontent WHERE pagetitle = 'Home' ";
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comm = new SqlCommand(select,conn);
conn.Open();
SqlDataReader dr = comm.ExecuteReader();
while(dr.Read())
{
label1.Text += dr[0].ToString();
}
conn.Close();