Slow Datatable.Rows.Add()

kendalgoodrich

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

kendalgoodrich22y ago
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
+1
Andrzej Wegierski22y ago
Use AcceptChanges() after Clear(). Try to use Merge(DataTable) method of DataSet -or- Try to use BeginLoad() ... LoadDataRow() ... EndLoad(). See help.
+1
kendalgoodrich22y ago
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
+1
Mahesh Chand22y ago
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.
+1