ADO.NET 101: Data Rendering with a DataGrid Control - Adding a SQL Connection

(Page 4 of 7 )

This is easily accomplished by dragging the SQLConnection control from the Data tab of the Toolbox onto the design pane as shown.

Now if you right click the SQLConnection that you added, you may examine its properties and also make entries to this connection object. Adding a SQLConnection object has not established a connection, as you need to make the SQLConnection by defining the Connection String. This is done easily by clicking in the empty area by the side of the ConnectionString item in this dialogue, and following the instruction, which consists of choosing an existing connection, namely SQLConenction1. This is already shown as being finished in the next picture.

If you examine the ConnectionString you will see all the items you chose in the Data Link Properties window previously as in:

workstation id=XPHTEK;packet size=4096;integrated
security=SSPI;data source="XPHTEK\NetSDK"; persist
security info=False;initial catalog=Northwind

Next: Adding a SQLCommand >>
 

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!