SQL Beginners Problem !

*** edited by: master4eva ***


Please enclose your code in < code ></ code> tags (without the spaces). This will make your code easier to read online; therefore, encouraging a response to be faster. It is to your own benefit for your question to be answered in future.





I have already done the editing to include the < code ></ code> tags for this post.


*********





Hi,


I am following tutorials in a book to try and implememnt a basic select query using SQL.


However i am following all the instructions, which includes entering this header:





<%@ Page Language="VB" Explicit="True" Debug="True" %>


<%@ import Namespace="System.Data" %>


<%@ import Namespace="System.Data.SqlClient" %>





Then i am dragging a data grid onto my form, constructing a select query in query builder, however the resultamt code i get is totally different than the one in book.


The ideal poutcome refers to the SQL client, SQL reader etc, however in my code below, there is NO mention of SQL at all...simply dbconnection, IDatareader.





can anyone help me out here..I know it's probably soemthing simple.but I'm stumped, and I've followed everything in the book.





H





Function Page_Load() As System.Data.IDataReader


Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=F:My Documents"& _


"shopping.mdb"


Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)





Dim queryString As String = "SELECT [Product].* FROM [Product]"


Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand


dbCommand.CommandText = queryString


dbCommand.Connection = dbConnection





dbConnection.Open


Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)





Return dataReader


End Function