Click here to Skip to main content
15,845,279 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Statement question. Pin
Jeff Varszegi7-Nov-03 3:43
professionalJeff Varszegi7-Nov-03 3:43 
GeneralRe: SQL Statement question. Pin
theJazzyBrain7-Nov-03 5:04
theJazzyBrain7-Nov-03 5:04 
Generaluser acces spermissions Pin
ranjjj6-Nov-03 1:10
ranjjj6-Nov-03 1:10 
GeneralRe: user acces spermissions Pin
perlmunger6-Nov-03 11:57
perlmunger6-Nov-03 11:57 
GeneralRe: user acces spermissions Pin
ranjjj6-Nov-03 18:36
ranjjj6-Nov-03 18:36 
GeneralRe: user acces spermissions Pin
perlmunger7-Nov-03 6:38
perlmunger7-Nov-03 6:38 
GeneralProblem in using OleDbDataReader Pin
sivaramakrishna5-Nov-03 23:14
sivaramakrishna5-Nov-03 23:14 
GeneralRe: Problem in using OleDbDataReader Pin
Mike Dimmick6-Nov-03 3:32
Mike Dimmick6-Nov-03 3:32 
In ADO.NET, you can only have one command executing against a connection at a time. The DataReader has exclusive use of a connection while it's open.

You can do one of two things: you can either open a second connection to execute the 'child' commands, or you can use a DataSet to store the results of the two commands. The first option is very wasteful of resources. The second option allows you to set up DataRelation objects which allow you to navigate the child rows using the DataRow object's GetChildRows method.

If you plan to do the second, you might as well ask for both tables in the same query batch, generating two result sets.

You could also perform a join on the server side, depending on what you actually need to do with the data.
GeneralRe: Problem in using OleDbDataReader Pin
sivaramakrishna7-Nov-03 20:06
sivaramakrishna7-Nov-03 20:06 
Generaldbo Pin
Hugo Hallman5-Nov-03 13:19
Hugo Hallman5-Nov-03 13:19 
GeneralSQL! Pin
Silly Boy5-Nov-03 7:18
Silly Boy5-Nov-03 7:18 
GeneralRe: SQL! Pin
Jeff Varszegi5-Nov-03 8:34
professionalJeff Varszegi5-Nov-03 8:34 
GeneralRe: SQL! Pin
andyharman5-Nov-03 12:49
professionalandyharman5-Nov-03 12:49 
GeneralEncoding problem using ADO Stream Pin
Firas Rashid4-Nov-03 3:59
Firas Rashid4-Nov-03 3:59 
GeneralAlternative SQL Queries based on Table Data Pin
Jo Fredrickson3-Nov-03 22:58
Jo Fredrickson3-Nov-03 22:58 
GeneralRe: Alternative SQL Queries based on Table Data Pin
andyharman5-Nov-03 12:35
professionalandyharman5-Nov-03 12:35 
GeneralRe: Alternative SQL Queries based on Table Data Pin
Jo Fredrickson5-Nov-03 15:59
Jo Fredrickson5-Nov-03 15:59 
GeneralMSADO 2.5 Pin
Kant3-Nov-03 16:46
Kant3-Nov-03 16:46 
GeneralRe: MSADO 2.5 Pin
Mike Dimmick5-Nov-03 2:51
Mike Dimmick5-Nov-03 2:51 
GeneralRe: MSADO 2.5 Pin
Kant5-Nov-03 6:01
Kant5-Nov-03 6:01 
GeneralFULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 13:53
devvvy3-Nov-03 13:53 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
Jeff Varszegi3-Nov-03 15:28
professionalJeff Varszegi3-Nov-03 15:28 
GeneralRe: FULL LEFT/RIGHT JOIN Pin
devvvy3-Nov-03 15:30
devvvy3-Nov-03 15:30 
GeneralTrouble Running Sql Script from Code Pin
perlmunger3-Nov-03 12:42
perlmunger3-Nov-03 12:42 
GeneralRe: Trouble Running Sql Script from Code Pin
Jeff Varszegi3-Nov-03 15:54
professionalJeff Varszegi3-Nov-03 15:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.