sjchin Posted March 28, 2003 Posted March 28, 2003 May i know what different between datareader and DataSet? When to used these 2? As i know both also working fine in connect to DB. Quote
wyrd Posted March 28, 2003 Posted March 28, 2003 DataReader is just a basic object that reads one record at a time and needs to be connected to the database. DataSet can work in "disconnected" mode and can represent your entire database in memory. Quote Gamer extraordinaire. Programmer wannabe.
Moderators Robby Posted March 28, 2003 Moderators Posted March 28, 2003 Actually, a Dataset is always disconnected. Quote Visit...Bassic Software
*Gurus* Derek Stone Posted March 28, 2003 *Gurus* Posted March 28, 2003 I like to think of it like this... the DataSet is Microsoft's favorite child, while the DataReader get's little reference, and remains in his room where few people will find him. Quote Posting Guidelines
sjchin Posted March 28, 2003 Author Posted March 28, 2003 May i know if i want to used 2 connect SQL at a same time,which shall i used? I try DataReader, when i try to connect other datareader, it appear error and ask me to close my 1st reader before open 2nd, may i know what the problem? Quote
*Gurus* Derek Stone Posted March 28, 2003 *Gurus* Posted March 28, 2003 You can only have one DataReader associated with a connection at a time. Open another connection and associate the second DataReader with it. Quote Posting Guidelines
sjchin Posted March 28, 2003 Author Posted March 28, 2003 How about Can i do it in DataSet? Can it support 2 connect SQL at the same time in 1 connection? Quote
*Gurus* Derek Stone Posted March 28, 2003 *Gurus* Posted March 28, 2003 Yes, you can have multiple DataSets per connection, since they really aren't associated with any connection object per se. Quote Posting Guidelines
Moderators Robby Posted March 28, 2003 Moderators Posted March 28, 2003 Or you can have multiple tables associated with a single Dataset. Quote Visit...Bassic Software
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.