Hi guys,
I have 2 RadComboBoxes, the First ComboBox 'ProductGroups' gets populated directly from a SQL database, once i have made a selection from the 'ProductGroups' ComboBox the Second RadComboBox 'Products' should be populated automatically Only with the data that is related to the selectedValue made from the First ComboBox. So If an item was NOT selected from the first comboBox the second ComboBox Will not be populated.
ProductGroups (1st) box populates properly i am just having issues populating the second Box with data, the Second ComboBox does not have any TreeViews inside of it, its just single item select.
Here are my 2 Classes i am using
And here is the other code i am using to do the actual populating
I dont get any Errors, the second RadComboBox just isnt populating.
Thanx in advance
I have 2 RadComboBoxes, the First ComboBox 'ProductGroups' gets populated directly from a SQL database, once i have made a selection from the 'ProductGroups' ComboBox the Second RadComboBox 'Products' should be populated automatically Only with the data that is related to the selectedValue made from the First ComboBox. So If an item was NOT selected from the first comboBox the second ComboBox Will not be populated.
ProductGroups (1st) box populates properly i am just having issues populating the second Box with data, the Second ComboBox does not have any TreeViews inside of it, its just single item select.
Here are my 2 Classes i am using
public
class
ProductGroup
{
#region Properties
[Key]
public
int
ProductGroupID {
get
;
set
; }
[Column(
"ProductGroup"
)]
public
string
ProductGroupName {
get
;
set
; }
[Column]
public
bool
Active {
get
;
set
; }
#endregion
#region Methods
public
static
IEnumerable<ProductGroup> GetActiveProductGroups()
{
iThNkContext db =
new
iThNkContext();
var ProductGroupList = db.ProductGroups.Where(grp => grp.Active ==
true
).OrderBy(p => p.ProductGroupName);
return
ProductGroupList.ToList();
}
#endregion
}
public
class
Product
{
#region Properties
[Key]
public
int
ProductID {
get
;
set
; }
[Column(
"Product"
)]
public
string
ProductName {
get
;
set
; }
[Column]
public
bool
Active {
get
;
set
; }
[Column]
public
int
ProductGroupID {
get
;
set
; }
#endregion
#region Methods
// Checks for active products and will only return active ones in the form of a list.
public
static
IEnumerable<Product> GetActiveProducts(
int
productGroupID)
{
iThNkContext db =
new
iThNkContext();
var productList = db.Products.Where(p => p.ProductGroupID == productGroupID && p.Active ==
true
).OrderBy(p => p.ProductName);
return
productList.ToList();
}
#endregion
}
And here is the other code i am using to do the actual populating
protected
void
cboProductGroup_ItemsRequested(
object
sender, RadComboBoxItemsRequestedEventArgs e)
{
cboProductGroup.DataSource = iThNkPOCO.Models.ProductGroup.GetActiveProductGroups();
cboProductGroup.DataBind();
}
protected
void
cboProductGroup_SelectedIndexChanged(
object
sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
cboProduct.DataSource = iThNkPOCO.Models.Product.GetActiveProducts(Convert.ToInt32(e.Value));
cboProduct.DataBind();
}
I dont get any Errors, the second RadComboBox just isnt populating.
Thanx in advance