Connecting VB .NET with SQL Dbase

[etenge]

Help me with the code or tutorial on how to connect vb .net with sql. dbase. thank you

[Teme64]

Have you ever tried googling?
http://www.google.com/search?q=VB.NET+%22SQL+Server%22+connect
gave a plenty of examples.

[savi3]

Import the SqlClient first.

Then Establish the connection by

Sqlconnection conn=new Sqlconnection();
SqlCommand cmd=new SqlCommand("Query",conn);
cmd.ExecuteNonQuery();

[Jx_Man]

See this site....
There are all about connection string to databases..
Just looking what you needed there.

[Alexpap]

A simple Insert Statement Function made by me for another project.

Function Insert(ByRef Conn As OleDbConnection, ByRef connection_string As String, ByRef Transaction As OleDbTransaction, ByRef ConnCommand As OleDbCommand, ByRef CommandText As String)
        Dim da As New OleDbDataAdapter

        Conn = New OleDbConnection(connection_string)

        Conn.Open()

        Transaction = Conn.BeginTransaction

        ConnCommand.Connection = Conn
        ConnCommand.Transaction = Transaction


        ConnCommand.CommandText = CommandText

        Try
            da.InsertCommand = ConnCommand
            da.InsertCommand.ExecuteNonQuery()

            Transaction.Commit()

            MessageBox.Show("Saved succesfully", "Adding Data", MessageBoxButtons.OK, MessageBoxIcon.Information)

        Catch ex As Exception

            Transaction.Rollback()
            MessageBox.Show(ex.Message)


        End Try

        Conn.Close()
        ConnCommand.Dispose()
        da.Dispose()
        Transaction.Dispose()

        Return Nothing
    End Function

Hope i helped!