protected int populate_DDL()
{
int val;
SqlConnection con = GetSqlCon.GetCon();
SqlDataAdapter com = new SqlDataAdapter("GetWorkshopNamesByRegion", con);
com.SelectCommand.CommandType = CommandType.StoredProcedure;
com.SelectCommand.Parameters.AddWithValue("@param1", DdlRegiao.SelectedValue);
DataSet ds1 = new DataSet();
if (com != null)
{
com.Fill(ds1);
}
con.Open();
DdlOficinas.DataSource = ds1;
DdlOficinas.DataTextField = "WorkshopName";
DdlOficinas.DataValueField = "WorkshopName";
DdlOficinas.DataBind();
con.Close();
val = Badges.CountWorkshopsInRegion(DdlRegiao.SelectedValue);
if (val == -1)
{
Response.Redirect("~/Error.aspx");
}
return(val);
}