My coworker decided to write a little helper function to supplement the already written GetData()
private DataTable GetData(string sql, string connectionString)
{
DataSet ds = new DataSet();
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(sql, con))
{
using (SqlDataAdapter adapt = new SqlDataAdapter(cmd))
{
adapt.Fill(ds);
}
}
con.Close();
}
return ds.Tables[0];
}
private string GetOneItemFromDB(string sql, string connectionString)
{
DataTable dt = GetData(sql, connectionString);
return dt.Rows[0][0].ToString();
}