it's the code in the event keypress on a textbox. when i execute, the result
show about 30sec or more. i like it was fast.
Private Sub TBNOMREP_KeyPress(ByVal sender As Object, ByVal e As
System.Windows.Forms.KeyPressEventArgs) Handles TBNOMREP.KeyPress
cmmsp_find.Parameters.Item("@rep").Value = textbox_rep.Text
conn.Open()
cmmsp_find.ExecuteNonQuery()
SQLCON.Close()
Me.LoadDataSet()
End Sub
"a" <a@a.com> escribió en el mensaje
news:#m**************@TK2MSFTNGP10.phx.gbl...
Please post your code and we will try to help.
Kevin
"sel" <se*@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl... hi guys,
could anybody tell me ... why the conextion of with ado.net is slowly?
maybe Idon't used the componets adecudely or maybe I don't do the correct
process to conection of database. when i execute a query the result show 30s
before. my table has about 2000 records. please help me.