Member Avatar for akosiadrian
akosiadrian 0 Newbie Poster

hi guys,

im having problems connecting to my database using vb.net and sql server 2k5. below is the code im currently using and it is having problems. please help me solve this problem. Thanks


adapter.connection = conn is the one having problems
the problem is connection is not a member of system.data.sqlclient.sqldataadapter

Imports System.Data
Imports System.data.SqlClient

Public Class search

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim adapter As New SqlDataAdapter
        adapter.Connection = conn
        adapter.SelectCommand = New SqlCommand("Select * PPCC_CD.dbo.save_details")
        Dim result As DataSet
        Try
            adapter.Fill(result)
            MessageBox.Show(result.Tables(0).Rows(0).Item(0).ToString)

        Catch ex As Exception
            MessageBox.Show("Error: Sql Select statement failed!")
        End Try


    End Sub
End Class
  • 1 Contributor
  • 0 Replies
  • 66 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.