ADO.NET 3.5 cookbook
This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, California :
O'Reilly
2008.
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627335706719 |
Tabla de Contenidos:
- ADO.NET 3.5 Cookbook, 2nd Edition; Who This Book Is For; What You Need to Use This Book; How This Book Is Organized; What Was Left Out; Conventions Used in This Book; About the Code; Using Code Examples; Comments and Questions; Safari® Books Online; Acknowledgments; 1. Connecting to Data; Connections, Connection Strings, and Connection Pooling; 1.1. Storing Connection Strings; Solution; Discussion; Protected configuration; Hardcode in the application; Universal data link (UDL) file; Windows registry; Custom file; 1.2. Building a Connection String; Solution; Discussion
- 1.3. Connecting to SQL ServerSolution; Discussion; OLE DB; ODBC; 1.4. Connecting to a Named Instance of SQL Server; Solution; Discussion; 1.5. Connecting to SQL Server Using an IP Address; Solution; Discussion; 1.6. Connecting to SQL Server Using Integrated Security from ASP.NET; Solution; Discussion; 1.7. Connecting to an Oracle Database; Solution; Discussion; OLE DB; ODBC; 1.8. Connecting to an OLE DB Data Source; Solution; Discussion; 1.9. Connecting to an ODBC Data Source; Solution; Discussion; 1.10. Connecting to a Microsoft Access Database; Solution; Discussion
- 1.11. Connecting to a Password-Protected Microsoft Access DatabaseSolution; Discussion; 1.12. Connecting to a Microsoft Access Database from ASP.NET; Solution; Discussion; Configure the Access computer; 1.13. Connecting to a Microsoft Excel Workbook; Solution; Discussion; 1.14. Connecting to a Text File; Solution; Discussion; 1.15. Changing the Database for an Open Connection; Solution; Discussion; 1.16. Setting Connection Pooling Options; Solution; Discussion; Oracle; OLE DB; ODBC; 1.17. Taking Advantage of Connection Pooling; Solution; Discussion; OLE DB; ODBC
- 1.18. Using Transactions with Pooled ConnectionsSolution; Discussion; 1.19. Displaying a Connection Property Dialog Box; Solution; Discussion; 1.20. Displaying the Data Link Properties Dialog Box; Solution; Discussion; 1.21. Monitoring Connections; Solution; Discussion; ODBC; 2. Working with Disconnected Data Objects; 2.1. Creating a DataColumn and Adding It to a DataTable; Solution; Discussion; 2.2. Creating a DataTable and Adding It to a DataSet; Solution; Discussion; 2.3. Mapping Table and Column Names Between a Data Source and DataSet; Solution; Discussion
- 2.4. Mapping .NET Data Provider Data Types to .NET Framework Data TypesSolution; Discussion; 2.5. Adding a Calculated Column to a DataTable; Solution; Discussion; 2.6. Creating a Unique Constraint; Solution; Discussion; 2.7. Creating Single- and Multi-Column Primary Keys; Solution; Discussion; 2.8. Creating an Autoincrementing Primary Key; Solution; Discussion; 2.9. Creating a Foreign Key Constraint; Solution; Discussion; 2.10. Creating a Data Relation; Solution; Discussion; 2.11. Building a DataSet Programmatically; Solution; Discussion
- 2.12. Adding a Column to a Child DataTable That Displays Data from the Parent Table
