// 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(); }