// RETRIEVE
void PopulateGVFood()
{
string selectedFood = tbSearch.Text.Trim();
DietTrackingBO diettrackingbo = new DietTrackingBO();
DataTable dt = new DataTable();
dt = diettrackingbo.getFoodData(selectedFood);
gvFood.DataSource = dt;
gvFood.DataBind();
//using (SqlConnection con = new SqlConnection(connectionString))
//{
// using (SqlCommand cmd = new SqlCommand())
// {
// cmd.CommandText = "SELECT * FROM Food WHERE Food LIKE '%' + @Food + '%'";
// cmd.Connection = con;
// cmd.Parameters.AddWithValue("@Food", tbSearch.Text.Trim());
// DataTable dt = new DataTable();
// using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
// {
// sda.Fill(dt);
// gvFood.DataSource = dt;
// gvFood.DataBind();
// }
// }
//}
}
// RETRIEVE
void PopulateGridView()
{
string selectedFood = tbSearch.Text.Trim();
DietTrackingBO diettrackingbo = new DietTrackingBO();
DataTable dt = new DataTable();
dt = diettrackingbo.getFoodData(selectedFood);
gvFood.DataSource = dt;
gvFood.DataBind();
}