Click here to Skip to main content
15,906,574 members
Home / Discussions / Database
   

Database

 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 11:02
professionalRichard Andrew x6431-May-17 11:02 
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 
Richard Andrew x64 wrote:
IOW, I don't want my form to only appear on screen after all 150,000 rows have been pulled from SQL Server.
Then how?

You mentioned a "form", so I'd assume WinForms with a DataGridView. In which case you don't use a datatable, but a list. You add to the list from a different thread, in batches of 50. Virtualize the DataGridView. Start the actions as soon as the form is displayed.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

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 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
w1424323-May-17 20:45
w1424323-May-17 20:45 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
Richard Deeming24-May-17 8:22
mveRichard Deeming24-May-17 8:22 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
w1424324-May-17 17:32
w1424324-May-17 17:32 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
Richard Deeming25-May-17 0:51
mveRichard Deeming25-May-17 0:51 
AnswerRe: Sql server: create table with column that support unique and multiple nulls Pin
ZurdoDev24-May-17 3:15
professionalZurdoDev24-May-17 3:15 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
Richard Deeming24-May-17 8:19
mveRichard Deeming24-May-17 8:19 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
ZurdoDev24-May-17 8:24
professionalZurdoDev24-May-17 8:24 

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.