Hello,
Would anyone have an idea how to programmatically :
1. Connect to an SQL Server database
2. Select data by using either a SQL Stored Procedure or View
3. Then bind it to a DataGrid?


Public SQLconn As SqlConnection
Public strConn As String = "SERVER=SER01;DATABASE=dbNoelTest;UID=sa;PWD=;"
Public strSQL As String

SQLconn = New SqlConnection(strConn)
strSQL = "SELECT * FROM tblOrderSearch"
Dim SQLda As New SqlDataAdapter(strSQL, strConn)
Dim SQLds As New DataSet()



.....thanks