Click here to Skip to main content
15,882,241 members
Home / Discussions / Database
   

Database

 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
Mycroft Holmes11-Jun-17 23:39
professionalMycroft Holmes11-Jun-17 23:39 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 18:55
karengsh14-Jun-17 18:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 20:10
Mazahir Habib1-Jun-17 20:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 22:16
professionalJohn C Rayan1-Jun-17 22:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 22:25
professionalMycroft Holmes1-Jun-17 22:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 13:59
indian1431-Jun-17 13:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 1:18
mveRichard Deeming2-Jun-17 1:18 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 11:02
professionalRichard Andrew x6431-May-17 11:02 
I'm using ADO.NET.

Entity Framework is not an option.

Suppose I have an IDataReader instance that was created from calling a stored procedure that returns 150,000 rows.

If I create a DataTable, and then call DataTable.Load(IDataReader), does it:

1. Read all available rows into the table at once?

2. Read only those rows that are necessary to return whatever rows I read from the DataTable?

3. Some hybrid of the above two scenarios?


I'm interested in implementing a solution that only reads data from the server upon demand.

IOW, I don't want my form to only appear on screen after all 150,000 rows have been pulled from SQL Server.

Thank you very much for your insight.



The difficult we do right away...
...the impossible takes slightly longer.

AnswerRe: Loading Data on Demand Pin
Richard Deeming31-May-17 11:44
mveRichard Deeming31-May-17 11:44 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:05
professionalRichard Andrew x6431-May-17 13:05 
AnswerRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:01
professionalMycroft Holmes31-May-17 13:01 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:07
professionalRichard Andrew x6431-May-17 13:07 
GeneralRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:21
professionalMycroft Holmes31-May-17 13:21 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:28
professionalRichard Andrew x6431-May-17 13:28 
AnswerRe: Loading Data on Demand Pin
Eddy Vluggen31-May-17 13:21
professionalEddy Vluggen31-May-17 13:21 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:36
professionalRichard Andrew x6431-May-17 13:36 
GeneralRe: Loading Data on Demand Pin
Eddy Vluggen1-Jun-17 0:35
professionalEddy Vluggen1-Jun-17 0:35 
AnswerRe: Loading Data on Demand Pin
Jörgen Andersson31-May-17 22:18
professionalJörgen Andersson31-May-17 22:18 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6416-Jun-17 11:20
professionalRichard Andrew x6416-Jun-17 11:20 
QuestionSQL server: How to get backup file information using SMO Pin
w1424326-May-17 17:52
w1424326-May-17 17:52 
AnswerRe: SQL server: How to get backup file information using SMO Pin
Eddy Vluggen2-Jun-17 1:44
professionalEddy Vluggen2-Jun-17 1:44 
QuestionHow to create SQL Server backup folder Pin
w1424326-May-17 17:44
w1424326-May-17 17:44 
QuestionSSRS - dynamic columns depending on client parameter Pin
Danpeking24-May-17 23:33
Danpeking24-May-17 23:33 
QuestionSql server: create table with column that support unique and multiple nulls Pin
w1424323-May-17 20:03
w1424323-May-17 20:03 
AnswerRe: Sql server: create table with column that support unique and multiple nulls Pin
Maciej Los23-May-17 20:27
mveMaciej Los23-May-17 20:27 

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.