title: Easier way of getting 1 cell from a SQL Server database
body: <p>Right now I'm adding data to a dataset and then selecting the first row and column in the first table of that data. There must be some shorter way of doing this?</p>
  
  <pre><code>SqlCommand LoadCmd = new SqlCommand("Select start_tid from EKGDATA where ekgmaaleid = @ekgmaaleid", GlobalVariables.offCon);
  LoadCmd.Parameters.AddWithValue("@ekgmaaleid", maaleid);
  
  SqlDataAdapter da = new SqlDataAdapter(LoadCmd);
  DataSet ds = new DataSet();
  
  da.Fill(ds);
  
  string dato = Convert.ToString(ds.Tables[0].Rows[0][0]);
  </code></pre>