Hi
Here is my code written in Global.asax.
vb file
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
' Fires when the application is started
Dim ds1 As New DataSet()
Dim FS As FileStream
Dim Reader As StreamReader
FS = New FileStream(Server.MapPath("XMLData.xml"), FileMode.Open, FileAccess.Read)
Reader = New StreamReader(FS)
ds1.ReadXml(Reader)
FS.Close()
Dim view As DataView
view = New DataView(ds1.Tables(0))
Application("Source") = view
End Sub
In my aspx file
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'to use of application state to read a dataset in Application_Start
Response.Write("Testing")
Dim source As DataView
source = Application("Source")
MyDataGrid.DataSource = source
MyDataGrid.DataBind()
End Sub
Data is available in the XML file.
Thanks,
Apry