Northwind; doing this doesn't affect dependent objects in your project.
Adding a typed Data Set generates an XSD schema, Northwind Data for this example, and adds 1,197 lines of VB 2005 code to the Northwind Data Set. Partial classes are a new VB 2005 and C# feature that enable extending a class, such as Northwind Data Set, with additional class files. Read Xml(str Path "Custs No Schema.xml", Xml Read Mode.
This option requires attaching a copy of to your SQL Server or SQLX instance, so click the Change button to open the Change Data Source dialog, select Microsoft SQL Server in the Data Source list, and click Continue to open the full version of the Add Connection dialog. Alternatively, select a local or networked SQL Server or MSDE instance that has a Northwind or Northwind CS database. Accept the default Use Windows NT Integrated Security option, and open the Select or Enter a Database Name list and select Northwind. Sql Client as the Provider, and Data Source=localhost; Integrated Security=True; Database=Northwind as the Connection String. Click Next to display the Save the Connection String to the Application Configuration File page.
Click Test Connection to verify the Sql Connection object, as shown in Figure 1-6. Click OK to close the dialog and return to the Choose Your Data Connection page, which displays Server Name. Mark the Yes, Save the Connection As checkbox and accept the default Northwind Connection String as the connection string name. Click Next to open the Choose Your Database Objects page, which displays treeview Tables, Views, Stored Procedures, and table-returning Functions.
Expand the Tables node and mark the Customers table.
Accept Northwind Data Set as the Data Set Name, as shown in Figure 1-7.
Learn why you shouldn’t get distracted by new DB technology, how Facebook is using a RDBMS to do the data slicing and dicing they can’t in Hadoop, and more. NET and typed Data Sets are the preferred method for retrieving and updating relational tables, although Data Sets aren't limited to processing relational data.
VB 2005 uses the Public Partial Class class Name statement to identify a partial class file. Auto) The real-world scenario for persisting and reloading Data Sets is more complex than that shown here.
You must choose Project➪Show All Files to see Northwind Data Set. Later chapters describe how to save and reload pending Data Set changes that haven't been committed to the base tables. Auto argument is the default, so including it is optional.
Figure 1-7 Selecting a table automatically generates the Select Command that retrieves all table rows, and an Update Command, Insert Command, and Delete Command for base table updates. Click Finish to generate the Northwind Data Set typed Data Set and display it in the Data Sources window.
Expand the Customers node to display the Customers table's columns, as shown in Figure 1-8 The new Sql Connection object you created in preceding Steps 3 through 5 appears under Server Explorer's Data Connections node as Server Name. You can rename the node in Server Explorer to a simpler name, such as localhost.