Select an existing connection manager from the list, or create a new connection by clicking New.
Create a new connection manager by using the Configure ADO.NET Connection Manager dialog box.
Data access mode
Specify the method for selecting data from the source.
Table or view
Retrieve data from a table or view in the ADO.NET data source.
Retrieve data from the ADO.NET data source by using a SQL query.
Preview results by using the Data View dialog box. Preview can display up to 200 rows.
When you preview data, columns with a CLR user-defined type do not contain data. Instead the values <value too big to display> or System.Byte display. The former displays when the data source is accessed by using the ADO.NET provider, the latter when using the SQL Server Native Client provider.