Pragmatic ADO.NET: Data Access for the Internet World
Developers need a way to interact with all data platforms in a uniform way, and Microsoft has attempted time and again to meet this need with its Universal Data Access strategy. In developing ADO.NET, Microsoft has made their additions of support for XML and disconnected data sets easier to use. This tutorial will guide the reader through ADO.NET from the top down, showing readers the hows and whys of using ADO.NET with lots of examples they can mold into their own projects right away. It is intended to be an introduction to ADO.NET for developers with some knowledge of data access. While it will show readers how ADO.NET follows on its predecessors, it will be written to avoid repeating any remedial instruction in databases and storage theory.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Commanding the Database
9 other sections not shown
Other editions - View all
ADO code ADO.NET ASP.NET blank DataSet DataSet business logic BusinessPhone caching Chapter cmd.CommandText cmd.ExecuteReader column Command objects CommandBuilder conn.Close conn.CreateCommand conn.Open connection pooling connection string Console.WriteLine constraint Create a DataAdapter Create the command Create your blank CustomerID customerTable data access data binding data source database data database server Database=ADONET DataColumn DataReader DataRow DataSet DataSet dataSet DataTable DataView DBDSN default delete DiffGram disconnected example Fill the DataSet FirstName HomePhone INSERT Invoice InvoiceID InvoiceItems InvoiceNumber LastName method Microsoft MiddleName minOccurs="0 namespace null ODBC OLE DB parameter primary key public class Recordset relationship result set retrieve scalability SELECT Server Managed Provider Server=localhost shown in Listing specify SQL Server SQL Server Managed SqlCommand cmd SqlDataAdapter("SELECT SqlDbType.NVarChar SqlParameter stnng stored procedure syntax transaction true type="xs:string Typed DataSet update the database updParams updParams updParams updQry Windows Forms write XmlDataDocument XPath xs:element