Please help I am new to the ASP.NET
I have created a page using WEBMATRIX. And I have a database with only one table 'Qoutes' with the following fields QCode and QDescription created with Microsoft Access. So first, I want to connect this page to the database so that when the page loads the content of the table 'Qoute' be displayed in the table. The other problem is if I want to see, say one qoute only on the next page with link of the QCode, how do I send the QCode to the next page or how do I create a session variable.
Thanks in advance.
Comments
Cn = New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("MdbTest.mdb"))
Cn.Open()
Dim Qry As String
Qry = "Select Count(Id) from Employee"
Dim Cmd As New OleDbCommand(Qry, Cn)
lblHeader.Text = "Employee List (" & Cmd.ExecuteScalar() & ")"
Cmd.Dispose()
Qry = "Select * from Employee"
Ds = New DataSet()
Dim Da As New OleDbDataAdapter(Qry, Cn)
Da.Fill(Ds, "Employee")
dgEmployee.DataSource = Ds
dgEmployee.DataBind()
Cn.Close()