error in vb.net

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nandhanvijay
    New Member
    • Apr 2007
    • 17

    error in vb.net

    hi friends

    am new to .net. am using vb.net 05 and sql server 2000. am getting error in my program. plz help to correct and learn
    Code:
     (vb.net)
    Imports System.Data.SqlClient
    Imports System.Data.Sql
    
    
    Public Class Form1
    
        Dim myDataSet As DataSet
        Dim myConnection1 As New SqlClient.SqlConnection()
    myConnection1.ConnectionString = "Data Source=vijay;" & _
    "Initial Catalog=NorthwindSQL;"
        Dim mySelectCommand1 As New SqlClient.SqlCommand()
    mySelectCommand1.CommandText = "SELECT Address, City, Region, PostalCode FROM Customers"
    mySelectCommand1.Connection = myConnection1
        Dim myDataAdapter1 As New SqlClient.SqlDataAdapter()
    myDataAdapter1.SelectCommand = mySelectCommand1
    myDataSet = New DataSet("MyNewDataSet")
    myDataAdapter1.Fill(myDataSet)
    End Class
    my errors are
    myconnection1 has not declared
    mydataadapter1 has not declared
    mydataset has not declared
    but i have declared every thing why its say like that
    help me
    thanks in advance
    Regards
    vijay
  • radcaesar
    Recognized Expert Contributor
    • Sep 2006
    • 759

    #2
    You may miss some assembly references like

    System.Data
    System

    Comment

    Working...