sure you can do that.
Steps:
1)Create connection object
2) open connection
3) create sqlcommand to read the data by passing the select query
4)execure reader
5) then labelname.text=Reader["Columnname"].ToString();
try
{
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select * from table",
myConnection);
myReader = myCommand.ExecuteReader();
while(myReader.Read())
{
label.text=myReader["Column1"].ToString();
}
}
catch (Exception e)
{
messagebox.show(e.ToString());
}
you can find more at
Beginners guide to accessing SQL Server through C#[
^]