I have a comboboxedit control that has a requery event taking three integer parameters. The FillDataTable method in the BO looks like this:
public
This actually works (thanks for the help earlier this week!). The problem comes in when the combobox hits one of the resulting columns. It is the "orderid" field. It gets to the following code:[Browsable(false),BusinessFieldDisplayInEditor(),Description(""),DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]public System.Int32 orderid{ get { return (System.Int32)this.CurrentRow["orderid"]; <--*** OFFENDING CODE *** } set { this.CurrentRow["orderid"] = value; }}
The get_orderid() method kicks out a "Specified cast is not valid" error. If I place the parameters into the SQL Query Analyzer, I get a result set that does have an orderid and it is an integer value.
Any ideas about what I should do or where to look for a solution?Thanks!!Bill