|
|
|
 |
| Free ADO.NET 2.0 Tutorials and Articles | | http://www.davidhayden.com/articles.aspx | | Free ADO.NET 2.0 Tutorials and Articles from David Hayden. ADO.NET topics include batch updates for improved performance, typed dataset, sorting and searching a DataTable, custom expressions, DataAdapter and database connections, data providers, the DBConnectionStringBuilder and the SqlConnectionStringBuilder, performance, tips and more. | | |
|
| Update Data Using Windows Form and .NET Data Sets | | http://www.akadia.com/services/dotnet_update_form.html | | Article: "Update Data Using Windows Form and .NET Data Sets." Discusses the ADO.NET object model, DataTables and DataColumns, DataRelations, rows, the DataAdapter, database updates from DataSets, how an update is transmitted to the data source, accessing data, updating a record, deleting a record, and creating new records. | | |
|
| Calling Stored Procedures with ADO.NET | | http://www.developer.com/db/article.php/10920_3438221_4 | | Tutorial: "Calling Stored Procedures with ADO.NET," by Paul Kimmell. Discusses calling stored procedures with ADO.NET, a quick primer for writing SQL Server stored procedures, using ADO.NET transactions, an optimal approach, testing your stored procedure, generating and archiving SQL script, creating connections, creating a command object, filling a DataTable, invoking DeleteCustomer, and fetching output parameters. | | |
|
| Efficient Use of an ADO.NET Data Component | | http://www.15seconds.com/issue/031120.htm | | Tutorial: "Efficient Use of an ADO.NET Data Component," by Nathan Zobrist. Discusses the technique of creating and using an application-wide data component, creating a new project, setting up a program framework, creating an MDI application with the MDI parent maintaining the data component, constructing a data component, using the Server Explorer in Visual Studio, declaring a DataComponent object, changing the default constructors of child forms, setting the DataSouce property, and programmatically setting the Table Property of the DataView to the DataTable in the data component. | | |
|
| Using ADO.NET for Beginners | | http://www.codeproject.com/kb/database/databaseacesswithadonet1.aspx | | Tutorial: "Using ADO.NET for Beginners," by Huseyin Altindag. Discusses a simple ADO.NET data base application, what ADO.NET is, connecting to an ADO.NET database, using DataSet, using the DataAdapter, displaying data in a DataGrid, DataBindings for TextBoxes, using the CurrencyManager, navigating through records with the Next, Previous, Last and First buttons, and how to trap keystrokes in the DataGrid. | | |
| |
|
|
| |
 |
|
|
|
|