DataSource from a remote SQL Server
Posted on 2006-11-05
I want to create a datasource which connects to a remote SQL server. I can connect to that server with the following code:
Dim strConnectionString As String
strConnectionString = "Data Source=xxx.xxx.xxx.xxx;Initial Catalog=xxx;User Id=xxx;Password=xxx;"
Dim SQLConnection As New SqlClient.SqlConnection(strConnectionString)
However, I don't know how to create a Data Source to use with datagrids, etc.