Hi,
You connect to the Server (Anderson\VSDOTNET) and set nwind as the default database (initial catalog). Table level is only relevant in subsequent SQL statements. The simplest way to get the connection string right is probably to drag the relevant table onto a form and look in the 'Designer generated code' region for the ConnectionString constructed by .NET .
HTH,
Viv
>>
When the Server Explorer is open in VS.NET. There are several connections. Towards the bottom I see
SQL Servers
+ Anderson
- Anderson\VSDOTNET
+ Master
+ msdb
- nwind (with a cord image comming from it)
+ Database Diagrams
- Tables
+ Employees
etc.
What would the connection string look like to make the connection with the Employee table within the NWIND Database
>>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only