Dim objDataSet As [u]DataSet</u> = New DataSet (Keeps saying that type is expeected for DataSet, but I copied the code directly from the book).

Maybe Next Time...

Hey,

Seems u r working on VB.NET. Its not like VB Code. If u r on VB.NET. make sure to import System.Data.SQLClient namespace. In Books, every block doesn't shows these things. They use to warn this at starting of book. Further u have to take care to include such things.

Hope u got the idea. Bette if u can Provide some more code segment whatever u have written.

B. Anant

yeah i imported that namespace i simplly called wrox and emailed them, but here is my code.

Imports System.Data
Imports System.Data.SqlClient

Public Class Form1
    Inherits System.Windows.Forms.Form

    Dim objconnection As SqlConnection = New _
        SqlConnection("server=(local);database=Company;use r id=sa;password=")

    Dim objDataAdapter As New SqlDataAdapter
    Dim objDataSet As DataSet = New DataSet

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        objDataAdapter.SelectCommand = New SqlCommand
        objDataAdapter.SelectCommand.Connection = objconnection
        objDataAdapter.SelectCommand.CommandText = _
            "SELECT CompanyName, Address, Phone" & _
            "FROM Companies"
        objDataAdapter.SelectCommand.CommandType = CommandType.Text

        objconnection.Open()

        objDataAdapter.Fill(objDataSet, "companies")

        objconnection.Close()

        grdCompany.DataSource = objDataSet
        grdCompany.DataMember = "companies"

        objDataAdapter = Nothing
        objconnection = Nothing


Maybe Next Time...