Visual Studio .NET 2002?includes a built in database management tool (similar to Microsoft Enterprise Manager).
The following functions?are available with this tool.
- Retrieve and edit data
- Create tables, views, and stored procedures (Enterprise & Architect Version only)
DETAILS
To connect to your Microsoft SQL Server database with Visual Studio .NET, follow the steps listed below:
- Open Server Explorer (View?-> Server Explorer)
- The Server Explorer should show up on the left hand side of the IDE
- Right click on "Data Connections" and select "Add Connection"
- Enter the Server Name in the first textbox (do not use the drop down box). MS SQL Server name can be found in the MS SQL server section of the control panel.
- Check "Use a specific user name and password:"
- Enter your SQL username & password
- Select your database from the dropdown list
- Click "Ok"
- Once connected, you should see a new entry in the Data Connections Section
MORE INFORMATION
If you currently do not have an MS SQL Server database hosted with us you can?order this?service through the control panel.
