private void BindClaimSkuSubCategory()
{
DropDownListSubCategory.ClearSelection();
DropDownListSubCategory.DataSource = ClaimSku.GetClaimSkuSubCategoryListByClaimSkuCategory(Convert.ToInt32(DropDownListCategory.SelectedValue));
DropDownListSubCategory.DataTextField = "Description";
DropDownListSubCategory.DataValueField = "ClaimSkuSubCategoryId";
DropDownListSubCategory.DataBind();
}
private void BindClaimSkuSubCategory()
{
DropDownListSubCategory.DataSource = ClaimSku.GetClaimSkuSubCategoryListByClaimSkuCategory(Convert.ToInt32(DropDownListCategory.SelectedValue));
DropDownListSubCategory.DataTextField = "Description";
DropDownListSubCategory.DataValueField = "ClaimSkuSubCategoryId";
DropDownListSubCategory.DataBind();
//DropDownListSubCategory.Items.Insert(0, new ListItem("Please select", "0"));
}
protected void DropDownListCategory_SelectedIndexChanged(object sender, EventArgs e)
{
AltKategori a = new AltKategori();
a.KategoriId.Id = Convert.ToInt16(DropDownListCategory.SelectedItem.Value);
AltKategoriDb db = new AltKategoriDb();
DropDownListSubCategory.DataSource = db.GetSubCategory(a);
DropDownListSubCategory.DataTextField = "AltKategori_Ad";
DropDownListSubCategory.DataValueField = "AltKategori_ID";
DropDownListSubCategory.DataBind();
}
protected void DropDownListCategory_SelectedIndexChanged(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["Registration"].ConnectionString;
SqlConnection connec = new SqlConnection(constr);
string S = "spGetSubCat";
SqlCommand com = new SqlCommand(S, connec);
com.Parameters.AddWithValue("@id", int.Parse(DropDownListCategory.SelectedItem.Value));
connec.Open();
com.CommandType = CommandType.StoredProcedure;
DropDownListSubCategory.DataSource = com.ExecuteReader();
DropDownListSubCategory.DataValueField = "subcat id";
DropDownListSubCategory.DataTextField = "sub cat name";
DropDownListSubCategory.DataBind();
connec.Close();
}