I have a form that has 15+ ComboBoxes and when I select values from
those ComboBoxes those ComboBox selections must be used as filter to search
through a large table in my database. A gridView will display the
returned data.
I have used the same format of code throughout the rest of my project
and it works perfectly, But when I select an item from my "Location"
DropDownBox and select a CHILD node to search through my database I get the error 'Input string was not in a correct format' and I'm guessing its because i am using null values
here is my Location.cs Class
region Properties [Key] public int LocationID { get; se; } [Column("Location")] public string LocationName { get; set; } private int? _ParentLocationID; [Column] public int? ParentLocationID { get { return _ParentLocationID; } set { if (value == 0) { _ParentLocationID = null; } else { _ParentLocationID = value; } } } [Column] public int SiteID { get; set; } [Column] public bool Active { get; set; }region Method public static IEnumerable<Location> LoadActiveLocations(int siteID) { iThNkContext db = new iThNkContext(); var LocationList = (from l in db.Locations where(l.SiteID == siteID && l.Active == true) orderby l.LocationID select l).ToList(); return LocationList; }And here is the code I am using in my .aspx file
RadTreeView trvLocation = (RadTreeView)cboLocation.Controls[2].FindControl("trvLocation"); if (trvLocation.SelectedValue != "") { var locationID = Convert.ToInt32(trvLocation.SelectedValue); //Error predicates.Add(p => p.LocationID == locationID); }On the //Error line is where I am getting the 'Input string was not
in the correct format' error, any suggestions please. I cant understand
why I am having this problem or how to get values from child nodes.
thank you in advance