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
Expand|Select|Wrap|Line Numbers
- (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
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