public void UpdateGridview() { SqlConnection conn = new SqlConnection(@"data source = DESKTOP-VKU3EK5; integrated security = true; database = ExterminatorDB"); SqlDataAdapter da = null; DataSet ds = null; DataTable dt = null; string sqlsel = "SELECT * FROM Pest"; try { // conn.Open(); SqlDataAdapter opens connection by itself da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(sqlsel, conn); ds = new DataSet(); da.Fill(ds, "PestList"); dt = ds.Tables["PestList"]; GridViewPest.DataSource = dt; GridViewPest.DataBind(); } catch (Exception ex) { LabelMessage.Text = ex.Message; } finally { conn.Close(); // SqlDataAdapter closes connection by itself; but can fail in case of errors } }
public void UpdateDropdown() { SqlConnection conn = new SqlConnection(@"data source = CHRISTOFFER-PC; integrated security = true; database = pest_exterminators"); SqlDataAdapter da = null; DataSet ds = null; DataTable dt = null; string sqlsel = "SELECT * FROM pests"; try { // conn.Open(); SqlDataAdapter opens connection by itself da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(sqlsel, conn); ds = new DataSet(); da.Fill(ds, "PestList"); dt = ds.Tables["PestList"]; GridViewPest.DataSource = dt; GridViewPest.DataBind(); DropDownListPests.DataSource = dt; DropDownListPests.DataTextField = "pest_name"; DropDownListPests.DataValueField = "pest_id"; DropDownListPests.DataBind(); DropDownListPests.Items.Insert(0, "Select a Pest"); } catch (Exception ex) { LabelMessage.Text = ex.Message; } finally { conn.Close(); // SqlDataAdapter closes connection by itself; but can fail in case of errors } }