| Displaying Two DataTables In One DataGrid |
| .netBips |
| Typically one dataGrid is bound with one DataTable. However, consider the case of two tables both having a common key column called ID. Say one table contains personal information about employees and another table contains some official information. EmployeeID is the common in both the tables and both tables have same number of rows (equal to the no of employees). How to display such tables in one DataGrid? Read on to know more. |
|
| Exposing Proprietary Data the .NET Way |
| MSDN |
| The .NET Framework comes with the OLE DB managed provider, which is meant to be a bridge that gives you immediate access to all the existing OLE DB providers. This component saves your current investments, as applications can continue successfully calling into existing OLE DB providers. The point, though, is another. In .NET, exposing proprietary data requires a more thoughtful choice, mostly because you have multiple and equally powerful options from which to choose.
|
|
| File Upload with ASP.NET |
| The Code Project |
| Back in the ASP world uploading files via a web page was a tricky problem. The problem was that due to the encryption type of the form used to submit the file from the clients browser receiving such files on the server side was a complex task. Data had to be retrieved as a safe byte array and decrypted before it could be used. Most of the people resorted to 3rd party DLLs,a few wrote their own DLLs and some even wrote purely ASP solutions to this problem using VBScript. Fortunately for us, .NET Framework SDK comes with a few classes that make uploading of the files simple from the web developer point of view. |
|
| FIX: System.ArgumentOutOfRangeException occurs intermittently with ADO.NET |
| http://www.kbalertz.com/ |
| (836874) - In an ADO.NET application, you may intermittently receive the following exception error message: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index |
|
| FIX: System.ArgumentOutOfRangeException occurs intermittently with ADO.NET |
| http://www.kbalertz.com/ |
| (836874) - In an ADO.NET application, you may intermittently receive the following exception error message: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index |
|
| Generic Data Provider |
| The Code Project |
| Generic Data Provider. An approach to make applications database independent. |
|
| How to update a database from a DataSet Object by using Visual C++ .NET 2003 |
| http://www.kbalertz.com/ |
| (837625) - Discusses a sequence of steps that explain how to update a database using a DataSet object is Visual C++ .NET 2003 |
|
| How to update parent-child data with an identity column from a Windows Forms Application by using a Web service in Visual C++ .NET |
| http://www.kbalertz.com/ |
| (815711) - Discusses how to create an ASP.NET Web service to access and to update a database. The article discusses how to modfiy data that is in two tables that have a parent-child relationship with an identity column that uses the Web service. |
|
| How to update parent-child data with an identity column from a Windows Forms Application by using a Web service in Visual C++ .NET |
| http://www.kbalertz.com/ |
| (815711) - Discusses how to create an ASP.NET Web service to access and to update a database. The article discusses how to modfiy data that is in two tables that have a parent-child relationship with an identity column that uses the Web service. |
|
| HOW TO: Populate a DataSet Object from a Database by Using Visual C++ .NET |
| http://www.kbalertz.com/ |
| (818779) - This step-by-step article describes how to fill a DataSet object with the results of one or more database queries and then how to access the data after the query is loaded in the DataSet object. DataSet objects are in-memory objects that can hold... |
|
| HOW TO: Populate a DataSet Object from a Database by Using Visual J# .NET |
| http://www.kbalertz.com/ |
| (320625) - DataSet objects, a key part of data access in the Microsoft .NET Framework, are in-memory objects that can hold tables, views, and relationships. This article shows how to fill a DataSet object with the results of one or more database queries, and how... |
|
| HOW TO: Read and Write BLOB Data by Using ADO.NET with Visual J# .NET |
| http://www.kbalertz.com/ |
| (320629) - The GetChunk and the AppendChunk methods are not available in ADO.NET on DataReader columns, DataSet columns, or Command parameters. This article describes how to use Visual J# .NET to read and write binary large object (BLOB) fields. Requirements The... |
|
| Inside .NET Managed Providers |
| MSDN |
| When compared to full-fledged OLE DB providers, Microsoft .NET managed providers have a lot to offer. First off, they deliver a simplified data access architecture that often results in improved performance without the loss of functional capabilities. Furthermore, .NET managed providers directly expose provider-specific behavior to consumers through methods and properties. They also involve a much smaller set of interfaces than OLE DB providers. Last but not least, .NET managed providers work within the boundaries of the Common Language Runtime (CLR) and require no COM interaction. For SQL Server 7.0 and SQL Server 2000, the managed provider hooks up directly to the wire level, gaining a substantial performance advantage. |
|
| Revisiting the Use of ADO in .NET Applications |
| MSDN |
| In a previous installment of this column, I talked about the tools and the techniques available within the .NET Framework to import ADO code in .NET applications. In that article, I ended up creating DataTable-derived classes based on an ADO Recordset schema and contents. Starting with Beta 2, using such a handcrafted class is no longer needed to import a recordset in a .NET application. The data adapter class now natively provides the ability to import the information held in ADO recordsets into .NET data structures.
|
|