Stored Procedures and Transfer Methods
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