Hello,
I'd like to pass data between two pages but unable to get code to work. Code
is below and any help is appreciated:
*************** *************** *************** *************** **********
'Page1.aspx
<%@ import namespace="Syst em.Data" %>
<%@ import namespace="Syst em.Data.sqlclie nt" %>
<%@ Page Language="vb" Debug="true" Classname="Page 1" %>
<script language="vb" runat="server" ClassName="Sele ctionPage" >
Public ReadOnly Property GridData() As System.Object
Get
' Datasource of Datagrid1 is a data table inside a dataset
Return ddl.SelectedIte m()
End Get
End Property
Sub Page_Load(Sende r As Object, E As EventArgs)
getdata()
End Sub
sub getdata()
Dim MyConnection As SqlConnection = new
sqlConnection(" server=sqlserve r;uid=app;pwd=p assword;databas e=pubs")
Dim Sql as string = "Select au_id, au_lname, au_fname from Authors"
Dim dr as New SQLCommand(sql, Myconnection)
Dim reader as sqldatareader
Dim Values as ArrayList = new ArrayList()
Myconnection.Op en()
reader = dr.ExecuteReade r()
While reader.read()
Values.Add(read er.item("au_id" ).ToString())
End While
ddl.DataSource = values
ddl.DataBind()
Myconnection.Cl ose()
reader.close()
end sub
Sub Transfer(ByVal sender As System.Object, ByVal e As System.EventArg s)
Server.Transfer ("page2.aspx ")
End Sub
</script>
<html>
<body>
<form runat="server">
<asp:DropDownLi st id="ddl" runat="Server" />
<br>
<br>
<asp:Button id="Button1" runat="server" OnClick="Transf er" text="Submit"
/>
</form>
</body>
</html>
*************** *************** *************** *************** *******
'Page2.apsx
<%@ Page Language="VB" %>
<%@ Reference Page="page1.asp x" %>
<script runat="server">
Dim objSendingPage As SendingPage
Sub Page_Load()
If Not IsPostBack Then
objSendingPage = CType(context.H andler, SendingPage)
End If
receivingddl.Va lue = objSendingPage. GridData
'receivingDG.Da taBind()
End Sub
</script>
<html>
<body>
<form id="Form1" method="post" runat="server">
<b>Visiting Page2.aspx</b>
<asp:lable id="receivingDd l" runat="server" />
</form>
</body>
</html>
*************** *************** *************** *************** ******
TIA
