Stored Procedures and Transfer Methods

Feb 13 2004 7:13 AM
I have 2 .aspx pages, "Page1" and "Page2". Page1 has values in textboxes and labels which need to be transferred to Page2 without using Session["variables"]. On page2, all the values are passed into labels from which a stored procedure adds a row to a table. I am working with Visual Studio and an Oracle 9i Database. I have tried using properties like the one below // On Page1 public TextBox XY { get { return XTextBox; } set { XTextBox = value; } } // On Page2 //Call the property from the previous page Page1 PrevPage; PrevPage = (Page1) Context.Handler; //Filling the values in this.XLabel.Text = PrevPage.XY.Text; then I take the value of the XLabel and use it in a Stored Procedure to add a row to a table. I have tested the Stored Procedure on its own and it works. I have tested passing values from Page1 to Page2 using Session["variables"] and it works. But when I test the above code I recieve the following error: Specified cast is not valid. It tells me to review the stack trace, but i cannot find any info to help me. Has anyone come accross this error before? If so how do you remedy it? Or is there some constraint or violation using the above code with a Stored Procedure and an Oracle Database?? any info would be greatly appreciated thanks

Answers (1)