| After only two days, you're well on your way to becoming a database expert! Two days ago, you were introduced to databases and took a quick look at how to use them with ASP.NET. Yesterday, you dug deep and got into the DataSet and data binding controls in Web forms. Up until now, however, you haven't taken an in-depth look at the intrinsic objects of ADO.NET. Today you'll learn about ADO.NET, its framework, and how it works with ASP.NET. There's going to be a lot of theory in today's lesson, but it will be spiced up with a lot of examples. By the end of today, you should be able to access any type of data store from your ASP.NET pages and use them to produce dynamic, data-enabled pages. Today's lesson will cover the following: How to modify data in a DataSet How to manipulate DataRows and DataTables How to make changes in a DataSet be automatically reflected in the data source, using an OleDbCommandBuilder object How to use an OleDbConnection object How to use an OleDbCommand object How to use an OleDbDataReader object How to use an OleDbDataAdapter object |