473,666 Members | 2,238 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DataReaders, DataAdapters, DataTables, DataSets and DataHeadache!

6 New Member
Hi.
I have a few questions and I am hoping some kind programmer out there can offer me some guidance.

I am trying to understand database interaction in .NET, and I'm having a really hard time as I have previously only used recordsets with Classic ASP.


Question 1.
I beleive that a DataReader is the nearest thing to Classic ASP Recordset. Is this correct?

Question 2.
I understand that the DataSet works in a 'disconnected architechture' which makes connections to the DB only when it needs to. So If I need to make an INSERT and a SELECT, then the dataset will open and close a connection for each action.
In Classic ASP I would open a single connection and perform both operation within that connection. Surely there is alot more overhead/latency with opening and closing 2 connetions?

Question 3.
I understand that the DataSet can contain multiple tables and records within memory. If a thousand users are browsing a webpage, surley this will crash the server? Is this not a major memory overhead?


I hope this isn't to long-winded to explain, and any help will be much appreciated. If you need any help with Classic ASP I will be happy to return the favour.
Dec 13 '07 #1
0 874

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2064
by: Jade | last post by:
Hi, I just wanted to ask a quick question regarding datasets. I am creating 3 tables using a dataadapter. what i want to know is that is the relationship created between these datatables automatically?? Will the integrity rules automatically be enforced or do i need to recode this in vb.net? Also do the datatables created have the same schema as my
2
1352
by: Adam Clauss | last post by:
Alright, as much as I've done CSharp, I've done very little with databases with it. So I'm just kind of messing around with, learning how it works. I am using the ADO.NET adapter provided with MySQL in a very simple web application. I have the connection, data adapter, and typed datasets created. In response to a button submit, I perform the following: accountsDataAdapter.Fill(accountsDS1); Label_Accounts.Text =...
2
4326
by: Z D | last post by:
Hello, I'm currently using Remoting (HTTP/Binary) to remote a simple object. Everything is working fine except for one function that returns an arraylist of datatables. When I call this function, nothing is returned (ie length of array =0). However, if I comment out my config file so that the DLL is run locally instead of remoting it, everything works fine!!
7
1781
by: Guadala Harry | last post by:
I'm trying to design all of my data access logic into one centralized assembly. I'm wondering how to implement DataReaders. There's plenty of documentation on passing DataSets to the client from the middle tier... but what about DataReaders? Do I have to bypass the centralized data access assembly when I want to use DataReaders? Thanks.
1
1579
by: psb | last post by:
I thought this was weird?? is this a bug in framework 1.0??? (1.0 is the version I am running against) --------------------------- dim dtAll as new datatable dim dtTmp as datatable dtTmp = LoadDataTable("select top 100 from table...") for i=0 to dtTmp.rows.count -1 ''''ERROR ON THIS LINE''' dtAll.Rows.Add(dtTmp.rows(i))
5
1174
by: Ryan Ternier | last post by:
I know how this should be done in regards to nTier, but it seems a bit inneficient, and was wondering if there's a solution that I havn't thought of yet. (I'm switching this loop to For Each Row as DataRow in.... to kill the one int that's not needed.) For intCount1 = 0 To objData.DataSet.Tables("tblSecondaryNumbers").Rows.Count - 1 rowTemp = objData.DataSet.Tables("tblSecondaryNumbers").Rows(intCount1)
4
2148
by: John Dalberg | last post by:
I noticed the starterkits timetracker & issue tracker load data from a database into custom collections (arraylists) which bind to a datagrid. What are the advantages of using custom collections over simpler objects like datareaders or datatables? John Dalberg
3
1584
by: cj | last post by:
I've used datatables and datasets before. Datasets being able to hold more than one table and datatables being only one table. My mind keeps coming up with recordsets. I can't remember how they fit into the picture. I'm going to be reading some records from a table in a sql db.
10
1770
by: Doug | last post by:
If I am grabbing a lot of rows (say 10,000 from SQL) would I be helping or hurting the network by using a DataReader? I would think helping because it's really only returning 1 row at a time, but I'm not sure. Are there good articles out there that explain how the DataReader does this as well as any that discuss performance problems/benefits?
0
953
balabaster
by: balabaster | last post by:
I have my SQL database with the following structure: Table1( PrimaryKey Int Not Null Identity(1, 1) Primary Key, TextData Varchar(50) Not Null ) Table2( PrimaryKey Int Not Null(Identity(1, 1) Primary Key, ForeignKey Int Not Null Foreign Key References Table1(PrimaryKey),
0
8440
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8866
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8781
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8550
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7381
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4193
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4365
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2769
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2006
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.