Need help with sql server(urgent)

[ryanlum]

hey guyz.. i usd the following code but i am not able to connect to the server.... whats wrong with my code?

it crashes when i declare my data adapter

  Dim myConnection As New SqlClient.SqlConnection
        Dim myCommand As New SqlClient.SqlCommand
        Dim myConnectString As String = "Data Source=192.168.100.123;Initial Catalog=postmalaysia;User ID=sa;Password="
        Dim DataAdapter As New SqlClient.SqlDataAdapter

        Dim Dataset As DataSet

       Dim DataSet As New DataSet

        Dim sqlconnection As New SqlClient.SqlConnection(myConnectString)

        myConnection = New SqlConnection
        myConnection.ConnectionString = myConnectString
        myConnection.Open()

        DataAdapter = New SqlDataAdapter("Select * from Bill", myConnectString)

        DataAdapter.Fill(DataSet, "Bill")
        Dim dataview = New DataView
        DataGrid1.DataSource = DataAdapter
        DataGrid1.DataBind()

[Nikhil Aggarwal]

You need to modify your code a little bit to something like this

Dim myConnection As New SqlClient.SqlConnection
Dim myConnectString As String = "Data Source=192.168.100.123;Initial Catalog=postmalaysia;User ID=sa;Password="
Dim dataAdapter As New SqlClient.SqlDataAdapter
Dim dataSet As New DataSet
myConnection.ConnectionString = myConnectString
myConnection.Open()
dataAdapter = New SqlClient.SqlDataAdapter("Select * from Bill", myConnection)
dataAdapter.Fill(dataSet, "Bill")
DataGrid1.DataSource = dataSet.Tables(0)
myConnection.Close()
DataGrid1.DataBind()