SELECT <column_name> FROM <table_name></table_name></column_name>
Now in the front part you can do....
connect to data server..
SqlConnection Con = new SqlConnection(Connstr);
string str = "SELECT <column_name> FROM <table_name> <where condition="">";
SqlCommand cmd = SqlCommand(str, Con);
SqlDataAdapter Adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
Adapter.Fill(dt);
lbl.text = dt.Rows[0].ItemArray[0].ToString();
</where></table_name></column_name>
Now you can find selected column data in the label....