₦airaland Forum

pls N'lander,

I need help on how to connect vb.net to sql server using Oledb or sqlConnection, i have connected it through ADOB, but i want to connect with Library

Pls in a comprehensive way

You will need to import the SQLCLIENT/OLEDB name space

Imports System.Data.SqlClient
Public Class LoginForm
Private cs As New SqlConnection("Data Source=DENSMAN-PC\SQLEXPRESS;Initial Catalog=aba;Integrated Security=True" ' You can change this to reflect the actual location of your database
End class

'import ur namespace
import system.data
import system.data.sql
import system.data.sqlclient
Dim constr as string="ur connection string"
'when u attach the databae check the properties to get ur 'connection string.
dim sqlcon as new sqlconnection(consrt)

'this should work out. . .