How to connect sql database server to vb.net?

Question

Pravesh Singh · Answer

You can hardcode it like this

Collapse | Copy Code

var connection = New System.Data.SqlClient.SqlConnection(connectionString)

connection.Open()

or you can do it more independently

var factory = System.Data.Common.DbProviderFactories.GetFactory(providerString)

var connection = factory.CreateConnection()

connection.ConnectionString = connectionString

connection.Open()

forum