ADO.NET 101: Data Rendering with a DataGrid Control - Connecting to a SQL Server database

(Page 3 of 7 )

There are two MSDE databases on this machine and the procedure for connecting to one of them will be described.

In the Sever Explorer window above, right click on the node Data Connections and choose Add Connection, which brings up the Data Link Properties page as shown below. You need to type in or choose from the drop down the name of the server; here the MSDE server XPHTEK\NetSDK has been chosen. Then you need to choose a method of authentication, which is in this case, the Windows Integrated method of authentication.

Finally you need to choose a database. If your earlier information is correct (server name and authentication method), you should be able to display all the databases from the drop down and display. You may choose any one of the databases to work with. On the other hand if any of the above information is incorrect you will not be able to connect to a database. You may also test the connection once all the information is given to this window as shown.

Next: Adding a SQL Connection >>
 

More ASP Articles
More By Jayaram Krishnaswamy

Comments On: ADO.NET 101: Data Rendering with a DataGrid Control

· "When the controls are bound to a data source, the three controls Repeater,...    · I was away on a holiday where I did not have access to a computer(unbelievable, but...   >>> Post your comment now!