Connection

[trimp]

How To Connect The Vb.net With Sql

[pkombli]

How To Connect The Vb.net With Sql

declare the sqlclint

connection
command
dataset


later

using connetion string u can

ex:
dim cn as new sqlconnetion
cn.connetionstring="use provider"
cn.open()

[kunal pawar]

this link may help you

http://www.aspnettutorials.com/tutorials/database/connect-sql-datasource-vb.aspx
http://www.freevbcode.com/ShowCode.asp?ID=2226

[jamesd0142]

try using this

Dim Cmd As OleDb.OleDbCommand
    Dim Con As OleDb.OleDbConnection
    Dim Sql As String = Nothing
    Dim Reader As OleDb.OleDbDataReader
    Dim ComboRow As Integer = -1
    Dim Columns As Integer = 0
    Dim Category As String = Nothing
    Dim da As System.Data.OleDb.OleDbDataAdapter
    Dim oDS As New System.Data.DataSet
 
Con = New OleDb.OleDbConnection("Provider=sqloledb;Data Source=server;Initial Catalog=database;User ID=sa;Password=" & txtserverpassword.Text)
 
sql = ""
 
'Run Query
            oDS.Clear()
            Con.Close()
            Cmd = New OleDb.OleDbCommand(Sql, Con)
 
            Con.Open()
            da = New OleDbDataAdapter(Sql, Con)
            da.Fill(oDS, "Table2")
            DGV.DataSource = oDS.Tables("Table2").DefaultView
            DGV.Refresh()
            ToolStripStatusLabel1.Text = "Query Run Successfully"
        Catch
            ToolStripStatusLabel1.Text = "Query Did Not Run Successfully"
        End Try