Hello Friends,
Throughout the application(ASP.NET and VB.NET),how can we use same dataset and its tables?I mean to say that dataset is created when HomePage is loaded.Can we use the contents of this dataset in all the pages of the website? If your answer is yes,how can this be done?

Thank you. friends,I am waiting for some kind replies.


Gaurav

__________________
Gaurav

If you want to use the data retrieved in the page load all over the app, you have to set it into a session variable. Then to retrive it, you neet to convert the session var to your ds object.

'set the session var
Session("ds") = yourdataset

'retrieve the session var
dim ds as new dataset
ds = CType(session("ds"),yourdataset)

Jim

Thank you Jim.
Yes, you are right. We can do this by using Session. But Cannot we do this by declaring a variable of datatype DATASET in global.asax and then storing our dataset in this variable and using it throughout the application. I am not sure if it can be done or not..... so please guide me .

Thanks again


Gaurav

This is from VS Help:

This example loads a dataset and stores it in application state so that it is available to all Web Forms pages and other processes in the Web application. The event fires when the application runs the first time (when the first user gets the first page of the application after the Web server is active).

Example
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
    SqlDataAdapter1.Fill(DsRegion1)
    Application("dsRegion") = DsRegion1
End Sub
Compiling the Code
This example requires:

A Web application with a Global.asax file. The Application_Start handler is created in the Global.asax file.
A data connection configured to connect to the SQL Server Northwind database.
A typed dataset named dsRegion1, which is an instance of the typed dataset class dsRegion. For details, see Creating Typed Datasets with the Component Designer.
A data adapter called SqlDataAdapter1 configured to read information from the Northwind Region table.
Note If you open the Global.asax file in the Web Forms designer, you can drag data components onto it just as you would onto a Web Forms page.
The application must have permission to access the database. For details, see Access Permissions for Web Applications.
After this event handler has run, any page or component in the application has access to the information. For example, a Web Forms page can get access to the Region table without having to connect to the database and query it. The Web Forms page might include code such as the following to get the table and make it available for data binding:

Private Sub Page_Load(ByVal sender As System.Object, _
        ByVal e As System.EventArgs) Handles MyBase.Load
    DsRegion1 = CType(Application("dsRegion"), dsRegion)
    DataGrid1.DataBind()
End Sub

Thank you again Jim.
In my application, I want user to enter his login_ID and password. Then, this information will be send to the database and if it matches, the corresponding row will be stored in the Dataset and the user will be redirected to the new page. Now, I want to use this row(containing all user information) in dataset in all the pages. I think Using Global.asax is not a correct solution to it. So, what should i prefer to use in my home page?session state or application state.

If you are storing user data then use session state.

Thanks Jim.
I hope my problem has been sorted out. I will try this in my application. Have a nice time ...