If your using a dataset (especially a typed one) use the BeginLoadData
method.
i.e.
Dim myStrongDataset1 as new myStrongDataSet1
myStrongDataset1.MyTable.BeginLoadData()
myDataAdapter.Fill(myStrongDataset.MyTable)
myStrongDataset1.myTable.EndLoadData()
this turns off notifications which can cause performance problem.s
You can also use the currency manager to assist this with
dim cm as CurrencyManager
cm = BindingContext(myStrongDataset1, "MyTable")
cm.SuspendBinding
myStrongDataset1.MyTable.BeginLoadData()
myDataAdapter.Fill(myStrongDataset.MyTable)
myStrongDataset1.myTable.EndLoadData()
cm.ResumeBinding
HTH,
CJ
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:O8**************@TK2MSFTNGP11.phx.gbl...
I got a tables which got 10,000 records.
user will input the invoice no as key.
my strConnection = "select * from invoice_Table where invno ='" &
(Me.txtInvoiceNo.Text) &"' "
in my form, there are over 20 textbox.
If i use databinding to bind each textbox. will it become slow ???
if i move the position, will it slow ??
Thanks