Why does this line of code take 15 seconds to run?

3 ⤊

Why does this line of code take 15 seconds to run?

// point to data table
dataGridView1.DataSource = m_DataTable;

2007-08-17 05:02:25 · 3 answers · asked by Zefram 2 in Computers & Internet ➔ Programming & Design

3 answers

Check out the MSDN link regarding tuning.

2007-08-17 05:49:41 · answer #1 · answered by MarkG 7 · 1⤊ 0⤋

It could the way your connecting to the database. If the database is very busy then it could be lag that is causing this to take some time to get through the line of code. This is the only idea I have for the reason this would take a long time to connect. Check the connection settings within your code.

2007-08-17 12:09:32 · answer #2 · answered by Anonymous · 1⤊ 0⤋

Try using a datareader to fill the grid

2007-08-17 12:14:54 · answer #3 · answered by youngboy1606 7 · 1⤊ 0⤋