tags:

views:

25

answers:

1
Q: 

ADO.NET Performance : Which Approach will faster and resonable?

Hi all,

I want to select certain amount of data from one table. Based on those data, I want to check another two tables and insert into 2 tables.

So I want to iterate the resulted data. Which way is better(faster) and reasonable using DataReader or DataTable?

Thanks in advance RedsDevils

+1  A: 

You end up creating a reader to fill the table. The reverse isn't true, So I would stick with the dataReader.

-Josh

JoshRoss  2010-10-14 02:09:55
Thanks Josh. How about my MS SQL Database is 2000? Is there any way to avoid DataTable?
RedsDevils  2010-10-14 02:11:28
If possible, create a stored procedure on the server. That way you don't have to bring back anything.
JoshRoss  2010-10-14 02:24:27
Here is the BOL link to creating a proc... http://msdn.microsoft.com/en-us/library/ms187926.aspx
JoshRoss  2010-10-14 02:27:14

related questions

Best way to get a comma delineated string into xml format?
Table NewRow() Causes Memory Leak
Querying DataColumnCollection with LINQ
Compare datatables
.NET DataTable skips rows on Load(DataReader)
OOP and DataTables for Rank Amateurs
"Endless scrolling" effect in a HTML table
How do you convert a DataTable into a generic list?
How do I display only certain columns from a data table?
Getting Count from Grouped DataTable in VB via Linq
DataTable + DataGrid Data Binding Performance Againsts Custom Data Source Object + Data Grid
.NET Fastest way to iterate through rows in a datatable?
Cast or convert when retrieving data from a database?
How can I make a globally accessible datatable in a Winforms application?
DataGridView's bound table only generates one RowChanged event on a double-click. How do I make it do two?
Abstracting storage data structures within XPath
Speed of DataSet row/column lookups?
How do I bind the result of DataTable.Select() to a ListBox control?
How many DataTable objects should I use in my C# app?
Trigger update on DataTable bound to DataGridView
DataTable to readable text string
.Net - Returning DataTables in WCF
Datatables, Dataviews and distincts! (ASP.Net/VB)
Datatable vs Dataset
Check for changes to a SQL table?