473,320 Members | 1,881 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

query to database

sel
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.
Nov 20 '05 #1
4 954
a
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.

Nov 20 '05 #2
sel
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.


Nov 20 '05 #3
Hi,

Not really sure what you are trying to accomplish here. You open a
connection, Execute a query which returns no results, then close a different
connection, and finally you call loaddataset. Are you sure the first few
steps are necessary?

Ken
---------------
"sel" <se*@hotmail.com> wrote in message
news:uu****************@tk2msftngp13.phx.gbl...
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.
>
>



Nov 20 '05 #4
Hi Sel,

In addition to Ken, why do you not make your own simple program where you
have eliminiated all the work in different classes with one class which does
what you want to do, than you can investigate if it goes real slow or that
there are some things that maybe are done to often.

The benefit of that as well is that when it still is not working you can
show it to us and with that we can probably help you.

Just an idea.

Cor
Nov 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: jaysonsch | last post by:
Hello! I am having some problems with a database query that I am trying to do. I am trying to develop a way to search a database for an entry and then edit the existing values. Upon submit, the...
3
by: Nick Truscott | last post by:
<? // scoreinput.php - input a match score when match selected from list ?> <html> <head> <basefont face="Verdana"> </head> <body>
15
by: Rolan | last post by:
There must be a way to enhance the performance of a query, or find a plausible workaround, but I seem to be hitting a wall. I have tried a few tweaks, however, there has been no improvement. ...
7
by: Bernard Lebel | last post by:
Hello, I'm stumbled at a serious problem, and quite frankly getting desparate. This is a rather long-winded one so I'll try to get straight to the point. I have this Python program, that...
13
by: forbes | last post by:
Hi, I have a user that used the Query Wizard to create a query in Access. Now she claims that her master table is missing all the data that was excluded from the query. Can you create anything...
1
by: Pradeep83 | last post by:
Hi All Problem : I am unable to retrieve the data from the table in postgres database using C application which i have written in solaris os. Query: How to check whether connection is there...
2
by: Bob Alston | last post by:
If you have an access form with record source being a straightforward query and where clause in the form definition, will the query be sent to the back end jet/Access database and executed there,...
3
by: mnjkahn via AccessMonster.com | last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window...
32
by: wexx | last post by:
I have been looking for some time now (reading books off Safari, searching through forums,etc) I have found no solution to this problem. I turn to anyone of you that may be able to help me. I'm...
2
by: existential.philosophy | last post by:
This is a new problem for me: I have some queries that open very slowly in design view. My benchmark query takes about 20 minutes to open in design view. That same query takes about 20 minutes...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.