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

Database

 
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 
GeneralRe: Too much time consumed while binding datatable to grid Pin
Michael Potter7-Sep-07 3:21
Michael Potter7-Sep-07 3:21 
That is a lot of rows for a grid! You may want to look into dynamic loading (a few rows at a time). This is how I normally load a DataGridView:

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

int totalRows = dt.Rows.Count;
this.grd.Rows.Add(totalRows);
DataRow dr;
for (int i = 0; i < totalRows; i++)
{
    dr = dt.Rows[i];
    this.grd.Rows[i].Tag = dr; //For an editing reference
    this.grd.Rows[i].Cells[0].Value = dr["FirstColumn"].ToString();
    this.grd.Rows[i].Cells[1].Value = dr["SecondColumn"].Tostring();
}

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 
AnswerRe: Sql server Date Diff Pin
Frank Kerrigan5-Sep-07 1:01
Frank Kerrigan5-Sep-07 1:01 

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.