Click here to Skip to main content
15,914,162 members
Home / Discussions / Database
   

Database

 
GeneralRe: High Volume of Insert Statement Pin
logicon5-Sep-07 9:33
logicon5-Sep-07 9:33 
GeneralRe: High Volume of Insert Statement Pin
Colin Angus Mackay5-Sep-07 9:45
Colin Angus Mackay5-Sep-07 9:45 
GeneralRe: High Volume of Insert Statement Pin
logicon5-Sep-07 11:05
logicon5-Sep-07 11:05 
GeneralRe: High Volume of Insert Statement Pin
Colin Angus Mackay5-Sep-07 12:36
Colin Angus Mackay5-Sep-07 12:36 
QuestionKeyword search in Stored Proc Pin
martin_hughes5-Sep-07 4:08
martin_hughes5-Sep-07 4:08 
QuestionToo much time consumed while binding datatable to grid Pin
Nouman Bhatti5-Sep-07 1:42
Nouman Bhatti5-Sep-07 1:42 
AnswerRe: Too much time consumed while binding datatable to grid Pin
Michael Potter5-Sep-07 3:58
Michael Potter5-Sep-07 3:58 
GeneralRe: Too much time consumed while binding datatable to grid Pin
Nouman Bhatti6-Sep-07 19:49
Nouman Bhatti6-Sep-07 19:49 
Thanks for your reply..
but can i have a sample application/code

bcz i tried it by writing a code as u mentioned
i had a 70MB file that contain more than 8,000,00 rows
the code is as follows

foreach(DataColumn dc in dt.Columns)
{
this.grd.Columns.Add(dc.ColumnName,dc.Caption);
}

Object[] obj = new Object[dt.Columns.Count];
foreach (DataRow dr in dt.Rows)
{
int i = 0;
foreach (object ob in dr.ItemArray)
{
obj[i] = ob;
i++;
}
grd.Rows.Add(obj);
i = 0;
}


GeneralRe: Too much time consumed while binding datatable to grid Pin
Michael Potter7-Sep-07 3:21
Michael Potter7-Sep-07 3:21 
QuestionCrystal Report Query Engine error Pin
santhoshmohan4-Sep-07 23:48
santhoshmohan4-Sep-07 23:48 
AnswerRe: Crystal Report Query Engine error Pin
Frank Kerrigan5-Sep-07 0:47
Frank Kerrigan5-Sep-07 0:47 
JokeRe: Crystal Report Query Engine error Pin
Colin Angus Mackay5-Sep-07 1:21
Colin Angus Mackay5-Sep-07 1:21 
QuestionInvoking function inside a Stored procedure affect perfomance?? Pin
Vipin.d4-Sep-07 23:06
Vipin.d4-Sep-07 23:06 
AnswerRe: Invoking function inside a Stored procedure affect perfomance?? Pin
Vasudevan Deepak Kumar4-Sep-07 23:15
Vasudevan Deepak Kumar4-Sep-07 23:15 
GeneralRe: Invoking function inside a Stored procedure affect perfomance?? Pin
Vipin.d5-Sep-07 4:35
Vipin.d5-Sep-07 4:35 
AnswerRe: Invoking function inside a Stored procedure affect perfomance?? Pin
Frank Kerrigan5-Sep-07 0:56
Frank Kerrigan5-Sep-07 0:56 
QuestionFilter the Null Column Pin
RichardBlare4-Sep-07 22:59
RichardBlare4-Sep-07 22:59 
AnswerRe: Filter the Null Column Pin
Vipin.d4-Sep-07 23:07
Vipin.d4-Sep-07 23:07 
GeneralRe: Filter the Null Column Pin
RichardBlare4-Sep-07 23:34
RichardBlare4-Sep-07 23:34 
AnswerRe: Filter the Null Column Pin
Vasudevan Deepak Kumar4-Sep-07 23:40
Vasudevan Deepak Kumar4-Sep-07 23:40 
AnswerRe: Filter the Null Column Pin
kumarrumak5-Sep-07 0:48
kumarrumak5-Sep-07 0:48 
AnswerRe: Filter the Null Column Pin
Frank Kerrigan5-Sep-07 1:00
Frank Kerrigan5-Sep-07 1:00 
QuestionDST Implementation Pin
ramdil4-Sep-07 22:46
ramdil4-Sep-07 22:46 
AnswerRe: DST Implementation Pin
Vasudevan Deepak Kumar4-Sep-07 23:44
Vasudevan Deepak Kumar4-Sep-07 23:44 
QuestionSql server Date Diff Pin
Praveen0294-Sep-07 21:35
Praveen0294-Sep-07 21:35 

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.