Form loading take time

Question

Hi...
I have a windows application which takes too time in loading
while I am performing only single task on load event,,
I am getting invoices from database onload...

and form take too much time approxmatily 15 seconds..

how can i increase the speed of the form.

Prabhu Raja · Answer

I think it depends upon your Query Execution time that depends on both Visual Studio and Sql Server. And Also Sometimes it may depend on your processor speed RAM etc. But i Suggest you to use DataReader instead of DataTable. It will be Speed enough. SqlConnection con = SqlConnection(Your Connection String); con.Open(); SqlCommand com = new SqlCommand(select invoiceno from Only_invoices order by invoiceno asc); Com.Connection = con; SqlDataReader reader = cmd.ExecuteReader(); While( reader.Read()) { this.cmbinvoice.Items.Add( reader[0].ToString() ); } Thank You

Kanhialal kk · Answer

@ Sam Hobbs ... sir there is only following code on page load.. adpt = new SqlDataAdapter(select invoiceno from Only_invoices order by invoiceno asc conn); dt = new DataTable(); adpt.Fill(dt); if (dt.Rows.Count > 0) { cmbinvoice.BeginUpdate(); foreach (DataRow row in dt.Rows) { this.cmbinvoice.Items.Add(row[invoiceno].ToString()); } cmbinvoice.EndUpdate(); }

Sam Hobbs · Answer

You have not provided any information for someone to be able to help you. Apparently the problem is that it is taking a long time to retrieve all the invoices. So you need to nanalyze why that is and what can be done. If you need help then you need to explain what your program is doing to get the data.

Mamta M · Answer

You need to use the BeginUpdate and EndUpdate methods. That will greatly improve performance and speed. http://msdn.microsoft.com/en-us/library/system.windows.forms.combobox.beginupdate.aspx

Kanhialal kk · Answer

@Mamta M... yes there are thousands invoice to display in combobox.. ..

Narayan · Answer

Try to use background worker to load the data from the invoices from database .

Mamta M · Answer

1)Are there many invoices that you are retrieving? How many? 2) Find out ways to speed up your data retrieval operation. 3) Find out if you can place the code to get the data in any other method instead of Load.