how to establish database connection with ms sql server in window application

[Nikhil21]

database connection with ms sql server in window application by using vb.net

[sonia.sardana]

Example of Gridview DataBinding with the database
Imports System.Data.SqlClient
Public Class Form1
Dim con As New SqlConnection("Data Source=ABC-17372608800\SQLEXPRESS;Database=sonia;integrated Security=true")
Dim da As SqlDataAdapter
Dim ds As New DataSet

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
da = New SqlDataAdapter("select * from student", con)
da.Fill(ds, "student")
DataGridView1.DataSource = ds.Tables("student")
End Sub
End Class

[Shashi Sadasivan]

It is no different to connecting the database with Asp .Net applications

For how to create a connection string please refer to connectionstring.com