| Data Transfer From Microsoft SQL Server to Excel |
| C# Corner |
| The Interoperability services help our life very easy to work with COM Applications like Excel. .NET platform provides necessary services to use existent application written in visual basic, C++ and so on. In this application, we will see how we can transfer data from Microsoft SQL Server into Excel spreadsheet. |
|
| DataAdapter Events |
| .NET Xtreme |
| DataAdapter class(OleDb and Sql) exposes three events that can be used as record and respond to the changes being made to the database. |
|
| DataBound DataPanel with TextBox and CheckBox v1.0 |
| GotDotNet |
| The DataPanel lets you databind the DataSet, DataTable, DataView, or DataRow to the panel and work with data in the same manner as in a DataGrid in edit mode. This functionality is very useful for editing a large number of fields in a Web form. The current implementation provides support for a DataTextBox and DataCheckBox within the container. These controls are mapped to a DataColumn name and allow for updates on the DataRow you're editing. The container handles the edit update and cancel buttons and it has Visual Studio .NET design time support. A comprehensive ReadMe is provided with screenshots and a walkthrough. |
|
| DataCalendar |
| The Code Project |
| A data-driven, templated sub-class of the ASP.NET Calendar control |
|
| DataGrid Filter |
| The Code Project |
| How to customize DataGrid column & Filter data |
|
| DataList vs. DataGrid in ASP.NET |
| MSDN |
| This month I want to look at two of the more specialized controls that come with the ASP.NET Framework: the DataList and the DataGrid. Both of these controls are full-featured data-managing tools. In addition to providing a simplified UI programming model for displaying data, ASP.NET includes facilities for binding data sources to these controls so you don't have to write all the code necessary to fish around a database and present your content. This month I'll compare and contrast the DataGrid and DataList controls, starting with DataGrid. |
|
| DataLoaders - Unified Data to Object Binding |
| The Code Project |
| A framework to completely separate objects from their data source - allowing any data source to be used without prior consideration in your code or designs. Databases, text files, web services and potentially anything else can all be used or swapped transparently. |
|
| DataTable.Select Method Leaks Memory from the Index When You Set Some Specific Filter Properties |
| http://www.kbalertz.com/ |
| (814470) - When you set some specific filter properties, the DataTable.Select method may leak memory. |
|
| Designing an Extensible DAL |
| DotNetJunkies |
| Filip walks you through how to design an extensible DAL. |
|
| Discussion Forum Board |
| Master C# |
| This example updates the previous forum example that I had written for beta1. A lot has changed since then, even though from outside the forum has the same looks internally a lot has changed! Due to this I have taken the trouble to elaborate this example into easy to understand pieces. |
|
| Displaying a Directory Structure in a DataGrid |
| DotNetJunkies |
| Recently, I had a requirement to create a data-dump as a directory structure and display the same in a DataGrid. In this article, I'll cover the concept of obtaining the directory structure and displaying it in a DataGrid. |
|
| DotLucene: Full-Text Search for Your Intranet or Website using 37 Lines of Code |
| The Code Project |
| An introduction to DotLucene, open source full-text search engine. |
|
| Dynamic Control Validation (textbox,combobox) at Runtime using container control (Form etc.) |
| The Code Project |
| Dynamic Control Validation (textbox,combobox) at Runtime using container control |
|
| Dynamic DataGrid Paging and Sorting Using A DataReader |
| DotNetJunkies |
| In a previous article I demonstrated one of nine ways one could page and bi-directionally sort a DataGrid. I opted for the hidden field method. This method, among the eight others works fine, and it all depends on how you want to approach this based on any given factors in your app. The problems we'll be discussing here lay not with either the paging or sorting aspects of it, but rather in implementing the most efficient manner in retrieving data and presenting it to the client. |
|
| Dynamically load controls into a DataGrid: Part 2 |
| The Code Project |
| A method for emulating a complex class. |
|
| Editable DataGrid without link buttons |
| The Code Project |
| This article explains how to make an ASP.NET editable DataGrid. |
|
| Editing and Deleting Items in the DataTable and DataView |
| DotNetJunkies |
| In last weeks article I explained how to add a new item to a DataTable and a DataView. In this weeks article we'll discuss editing and deleting items in both the DataView and DataTable objects. |
|
| Enable ReadOnly Mode for your WebForms! |
| The Code Project |
| this article will show you, how to implement a readonly mode for webforms |
|
| Enhanced DataSet Quick Watch |
| The Code Project |
| A VS.NET add-in to visualise standard and typed DataSets, DataTables and DataRows whilst debugging |
|
| 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 Manager |
| The Code Project |
| An article on how to upload files to a server and how to display the directories and files in a ASP.NET DataGrid |
|
| 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: Data Bound User Control Updates Only First Bound Column |
| Microsoft Support |
| When you try to update more than one column of a table by using a bound user control that has multiple bound properties, only the modified data for the first bound property is updated in the table. You may notice this behavior only for the first row... |
|
| FIX: Data Bound User Control Updates Only First Bound Column |
| http://www.kbalertz.com/ |
| When you try to update more than one column of a table by using a bound user control that has multiple bound properties, only the modified data for the first bound property is updated in the table. You may notice this behavior only for the first row... |
|
| 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 |
|
