• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1224
  • Last Modified:

Run sql query on onmouseover and display results

APS .NET / AJAX
I want to run a sql query when the user does mouseover to few links on my ASP .NET page and display the results on a popup or tool tip window.
This query will hit sql and show special details of that particular item.
Do not want to pre-load information because the query is pretty long and would slow my page load very much.
Thanks,
0
melinalt
Asked:
melinalt
  • 2
  • 2
2 Solutions
 
CakinciCommented:
I can suggest some few tips to make reading data procedure from SQL that i am using in my projects;

1-Using stored procedure will decrease the reading time.
2-Inside the store procedure try to avoid using unneseccarily joins. And select only required fileds. Try to give "where" parameters inside the SP. So the query will select the specific Sql line.
3-If you will only read values not write anything to sql use Datareader component only.(Do not use Dataadapter and Dataset component togother i mean\ only datareader)
4-If you have liblaries directly spesific to your SQL database like SQLDatareader use that one rather than normal datareader.

I hope those information will help.
0
 
melinaltAuthor Commented:
Thanks for your information Cakinci.
I actually need to display information on an onmouseover action.
I am looking for an option to display data comming from sql on an onmouseover action in my project.
preferible an AJAX control.
0
 
striker46Commented:
While this doesn't address this specific question 100%, it can be of help regarding how to retrieve MySQL results with AJAX. The external page in the example uses PHP, but I don't think there's any reason why ASP or other languages would not work. The missing part is putting the results in a tooltip, which I personally don't know how to do.

Regards
0
 
striker46Commented:
0
 
melinaltAuthor Commented:
Even though the answers where not quite what I was looking for they both help me to realize the solution.
I created an accordion ajax control to display the list of item, however, the ajax onmouse over function (which should show run a sql statment) didn't work because it kept calling a button to execute sql and causing postback.  since it was in onmouseover the page didnt' stop flicking.
I used ajax to show the initial list and a basic javascript function to open a different page onmouseover.  The new page executes the SQL and displays the results.
Thank you both.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now