|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
Computing Values from a DataTable
|
| Total Hit (1075) |
When checking out the blogs at weblogs.asp.net, I found Darren Neimke's interesting entry for today on computing aggregated data in a DataTable. In his blog entry, Darren mentions two not well-known features of the DataTable: the Expression property of the DataColumn class and the DataTable's own Co
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dropdown list for the foreign key of a table in a datagrid
|
| Total Hit (1022) |
The script populates an ArrayList with values from the database and then binds the list to the dropdown inside the datagrid. You would want to do something similar, but you'll need to store the foreign key as well as the text.
|
| Rating
|
|
|
|
|
|
Obtaining Data Based Upon Multiple Selections From a ListBox...
|
| Total Hit (1009) |
This article will demonstrate how to allow multiple selections in a ListBox control and how to build a WHERE clause on the fly that will fill a DataGrid with data based upon the selections made in the ListBox. There is really no new ground broken here. The article just demonstrates a technique or tw
....Read More |
| Rating
|
|
|
|
Reading Excel (.xls) Files with ADO.NET...
|
| Total Hit (4396) |
Since Excel has an OleDB provider, we can use ADO.NET's OleDb functionality to connect to Excel. It does take a little preparation on the Excel side however. You might think that since Excel has rows and columns we might be able to use that and refer to A1 and B3, etc. We can't (as far as I know). W
....Read More |
| Rating
|
|
|
|
Returning Resultsets Using Sql Server Stored Procedures...
|
| Total Hit (896) |
Every modern database system has a stored procedure language. SQL Server is no different and has a relatively sophisticated and easy to use system. This article will not attempt to go into depth in explaining SQL Server stored procedure programming - there are whole books devoted to the subject. Ins
....Read More |
| Rating
|
|
|
|
Export DataSets to Excel...
|
| Total Hit (2006) |
Often we need to load the data from a dataset into an excel spreadsheet to be manipulated and/or saved off to a local file. There are several ways to accomplish this using either Crystal Reports or ActiveReports. However there is a simple, elegant way to do the same thing without the need for a repo
....Read More |
| Rating
|
|
|
|
Using the Microsoft Managed Provider for Oracle...
|
| Total Hit (796) |
Microsoft has brought the power and speed of the Managed Provider for SQL Server to the Oracle database. In this article we see how to use it directly, and to call a stored procedure with a join.
|
| Rating
|
|
|
|
Returning Multiple Resultsets with the DataReader
|
| Total Hit (914) |
Recently I was asked to create a data entry page for a table with 35 columns, 10 of which needed to be DropDownLists (combo boxes). It seemed very inefficient, and required too many coding key strokes, to go to the database 10 times to get the values for the DropDownLists. I started looking for a be
....Read More |
| Rating
|
|
|
|
Use the DataReader to Process Data One Row at a Time
|
| Total Hit (5500) |
At times you may find the need to do some processing of rows from a database before they are displayed to the user. We all remember processing classic ado recordsets one row at a time. You can do the same thing with .Net's DataReader which produces a very fast forward-only stream of database table d
....Read More |
| Rating
|
|
|
|
Use MTS Transactions?
|
| Total Hit (898) |
A transaction is an operation or set of operations that succeeds or fails as a logical unit. A good example of a transaction is the transfer of funds from one bank account to another. In this case, the funds must be debited from the first account and credited to the second account before the operati
....Read More |
| Rating
|
|
|
|
Displaying Images from SQL Server database in ASP.NET DataGrid
|
| Total Hit (825) |
ASP.NET DataGrid web control can be bound quickly with any database table like SQL server. For most of the data types all you need to do is to add a bound column and set its datafield property to the column name from the table. However, displaying image data type i.e. binary data is not that easy. I
....Read More |
| Rating
|
|
|
|
|
|
|
|
|
|
Creating Search Pages with Index Server and .NET
|
| Total Hit (976) |
Combine the ADO.NET techniques you know - and perhaps some you don't know - with the power and flexibility of Microsoft Index Server and ASP.NET to create easy - yet powerful - custom search pages for your Web site.
|
| Rating
|
|
|
|