Slow Datatable.Rows.Add()

Question

Quick question everyone I have an application in which I am accessing a MySql Database. Everything is fine except for when I try to add some lines to a DataTable. The very first Row I Add takes 6-7 seconds after that I never have that problem again until I restart the application. Following is a snippet of code where the problem occurs: [code] dsDoctorList.Clear(); DataTable dtDocAppts = dsDoctorList.Tables[DoctorAppts]; DataTable dtDocs = docSql.PullDocs(); //Load Doctor Number and Name foreach(DataRow dr in dtDocs.Rows) { DataRow myRow = dtDocAppts.NewRow(); myRow[doctor] = dr[doctor]; myRow[name] = dr[name]; //Right here is where it takes so long on the first add dtDocAppts.Rows.Add(myRow); } [/code] Does anyone have any suggestions as to what is causing this. Thanks Kendal

kendalgoodrich · Answer

I figured it out. It had something to do with the fact that dsDoctorList.Tables[DoctorAppts] was bound to the datagrid. I guess since it was bound to the datagrid accessing and adding a row took longer. I bound the datatable to the datagrid at design time. Once I set the datamember of the datagrid to NONE and after loading the datatable I set the datamember at runtime and it worked quickly. I don't understand it but it works. Does that sound right or do you know why it would act like that????? Thanks for your help Kendal

Andrzej Wegierski · Answer

Use AcceptChanges() after Clear(). Try to use Merge(DataTable) method of DataSet -or- Try to use BeginLoad() ... LoadDataRow() ... EndLoad(). See help.

kendalgoodrich · Answer

For sure it is that line. I step through debug up to that line when I get to that line and hit the step key it takes 6-7 seconds to get to the very next line. So I am sure that it is on that line. I use that table on other forms in my application before it even gets to this form and it never takes this long. I just don't understand it. Thanks for trying to help. Thanks Kendal

Mahesh Chand · Answer

Are you sure the time is being taken by Table.Rows.Add method not by the code prior to that? I dont think there is any logic in Add method but I could guess opening connection getting all tables etc may take some when you connect first time. Once a connection is created then it is faster after that.