Dim DBConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:/Inetpub/wwwroot/newfolder/BooksDB.mdb")
        DBConnection.Open()

        '-- Issue an SQL command through the database connection
        Dim SQLString As String
        SQLString = "SELECT BookID, BookType, BookTitle, BookPrice, BookQty " & _
                    "FROM Books ORDER BY BookID"
        Dim DBCommand = New OleDbCommand(SQLString, DBConnection)

        '-- Retrieve a recordset of selected records from the database
        Dim DBReader = DBCommand.ExecuteReader()

        '-- Bind data reader to GridView control
        BookGrid.DataSource = DBReader
        BookGrid.DataBind()


this code works fine , but when i use sqldatareader it isnt working.below is my code .just tell me wats wrong.both are done on buttons click event


  Dim sqlconnection As New SqlConnection("Data Source=GWSHJ;Initial Catalog=Northwind;User ID=sa;Password=EkLi05SQLgws")
        Dim cmd = New SqlCommand("SELECT CategoryID, CategoryName, Description FROM Categories", sqlconnection)
        ' cmd.CommandType = Data.CommandType.Text
        Try
            sqlconnection.Open()
             Dim reader As SqlDataReader()
            reader = cmd.ExecuteReader() GridView1.DataSource = reader
            GridView1.DataBind()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

hi
 ur code is right
ru using the same line
 Dim cmd = New SqlCommand("SELECT CategoryID, CategoryName, Description FROM Categories", sqlconnection)
then try
dim cmd as sqlCommand=New SqlCommand("SELECT CategoryID, CategoryName, Description FROM Categories")
cmd.connection=sqlconnection

may this help

thanks,
if u no this answer.can u tel me.

Hi

protected WebApplication2.dsGrd dsGrd;

if (Session["GridDataSet"].ToString() != "NEW")
            {

                dsGrd = (WebApplication2.dsGrd) Session["GridDataSet"];

            }
            else
                dsGrd= new WebApplication2.dsGrd();


this was done in asp.net 1.1.
i want the same to be done in 2.0 how to do it.and if possible write the code in vb.net.How do you call the dataset in asp.net 2.0.ive created an xsd schema called dsGrd.or shud we use table adapetr for this.im very confused.pls tell me.