You have to retrieve data in DataTable or DataSet
e.g.
try{
SqlConnection con = new SqlConnection("");
con.Open();
SqlCommand cmd = new SqlCommand("select * from tablename", con);
cmd.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "ss");
dataGridView1.DataSource = ds.Tables["ss"];
dataGridView1.DataBind();
TextBox1.Text=ds.Tables["ss"].Rows[0]["ColumnName"].toString();
Label1.Text=ds.Tables["ss"].Rows[0]["ColumnName"].toString();
}
catch
{
MessageBox.Show("No Record Found");
}