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
}
}