Dataset - Error
From: Papri Chakravorty (anonymous_at_discussions.microsoft.com)
Date: Tue, 8 Jun 2004 18:06:01 -0700
Yesterday I was trying to just populate a datagrid with a dataset.
I used the following code in the page load event after using connection, adapter and data set
in the design mode
Dim nC As SqlConnection = New SqlConnection("data source=SEAFS;initial catalog=Northwind;integrated security=SSPI;persist security info=False;workstation id=CHAKP;packet size=4096")
Dim selectCMD As SqlCommand = New SqlCommand("SELECT CustomerID, CompanyName FROM Customers", nC)
selectCMD.CommandTimeout = 30
Dim DA As SqlDataAdapter = New SqlDataAdapter()
DA.SelectCommand = selectCMD
Dim DS As DataSet = New DataSet()
.When i tried to build and browse,
it gave me the following error
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
Can you please let me know what is causing this?
I cannot proceed with the following chapters unless I get this clear.