I have been trying to connect to a SQL Server DB. I used Server Explorer to set up the connection and the data adapter. I set up the data set through code. When i try to fill the table the program fails. Anything can help.
Heres some code to get started:
Dim strSQL As SqlCommand = TandAConnection.CreateCommand()
strSQL.CommandText = "Select * from TandATask"
TandAAdapter.SelectCommand = strSQL
Catch ex As Exception
TaskGridBinding = New Binding("Data Source", TandADataset, "TaskTable")
What is wrong here?