using SQL:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
Dim connectionString As String = "Data Source=MyServer;Initial
Catalog=MyDB;UID=MyUID;pwd=MyPWD"
Dim sql As String = "SELECT Some Stuff"
Dim connection As New SqlConnection(connectionString)
Dim dataadapter As New SqlDataAdapter(sql, connection)
Dim ds As New DataSet()
connection.Open()
dataadapter.Fill(ds, "my_table")
connection.Close()
DataGridView1.DataSource = ds
DataGridView1.DataMember = "my_table"`
End Sub
using SP:
Dim da As New SqlDataAdapter, ds As New DataSet
Dim conn As New SqlConnection
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.