Creating a DataAdapter Object Using Visual Studio .NET In this section, you'll learn how to create a DataAdapter using Visual Studio .NET. Note You'll find a completed VS | Creating a DataAdapter Object Using Visual Studio .NET In this section you ll learn how to create a DataAdapter using Visual Studio .NET. Note You ll find a completed VS .NET project for this section in the DataAdapter directory. You can open this project in VS .NET by selecting File Open Project and opening the file. You ll need to change the ConnectionString property of the sqlConnection1 object to connect to your database. You can also follow along with the instructions in this section by copying the DataReader directory to another directory and using that project as your starting point. Open your form by double-clicking in the Solution Explorer window. Next create a SqlDataAdapter object by dragging a SqlDataAdapter object from the Data tab of the Toolbox to your form. When you drag a SqlDataAdapter object to your form you start the Data Adapter Configuration Wizard as shown in Figure . Figure The Data Adapter Configuration Wizard Click the Next button to continue. You now select the database connection you want to use or you can create a new one. Pick your connection to the Northwind database or create a new connection if you don t have an existing one as shown in Figure . Figure Choosing your data connection Click the Next button to continue. Next you set your query type to Use SQL statements. As you can see from Figure you set your query type to use SQL statements create new stored procedures or use existing stored procedures. The SQL statements or stored procedures are then used in the SelectCommand InsertCommand UpdateCommand and DeleteCommand properties of your SqlDataAdapter object. You ll learn about the latter three properties in Chapter 11 they are used to insert update and delete rows. Figure Choosing your query type Make sure you ve picked Use SQL statements and click the Next button to continue. You now generate the SQL statements for your SqlDataAdapter. You can either enter a .
