DataBinding + DataTable as DataSource - very strange behaviour
-
Hi all There is a subtle bug what i can't resolve. Please help. snippet 1
this.bindingSource.DataSource = this.dataTable; this.bindingSource.DataSource = null; this.bindingSource.Dispose(); /* Fill method read data by using data reader for this table. When this table contains many records (about 150000) this operation (Fill) consume about 1 minute. */ this.dataTable.Fill();
snippet 2/* this.bindingSource.DataSource = this.dataTable; this.bindingSource.DataSource = null; this.bindingSource.Dispose(); */ Now i comment all code above, and supposingly this don't have any matter as such as i just return all to initiali state. BUT Now this operation (Fill) consume about 30 seconds. */ this.dataTable.Fill();
Any idea please. 30 more seconds very critical for me. THANK. -
Hi all There is a subtle bug what i can't resolve. Please help. snippet 1
this.bindingSource.DataSource = this.dataTable; this.bindingSource.DataSource = null; this.bindingSource.Dispose(); /* Fill method read data by using data reader for this table. When this table contains many records (about 150000) this operation (Fill) consume about 1 minute. */ this.dataTable.Fill();
snippet 2/* this.bindingSource.DataSource = this.dataTable; this.bindingSource.DataSource = null; this.bindingSource.Dispose(); */ Now i comment all code above, and supposingly this don't have any matter as such as i just return all to initiali state. BUT Now this operation (Fill) consume about 30 seconds. */ this.dataTable.Fill();
Any idea please. 30 more seconds very critical for me. THANK.