VB data reports

ashishahuja25 used Ask the Experts™
If i put a textbox on a form and enter employee name in textbox at RUN TIME, then how to write PARAMETERIZED query in command object to generate a RUNTIME report while dealing with Sql Server-2000 ?

 Plese send me code along with the method to do this?

  To conclude, user enters some thing in a textbox while running the application and report showing the details pertaining to only that value entered by the user( say employee name or student name)should come ?

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
"Creating ADO Parameter Queries with Visual InterDev 6.0"

In particular, the sections you'd be concerned with are:

"The Basics of Parameter Queries"
"A Typical SQL Server Parameter Query"
"Writing the ASP/ADO Code for SQL Server Parameter Queries"

That should give you the general idea.

Here's some actual VB6/ADO code:
This is written to use Microsoft's Pubs sample database.
Éric MoreauSenior .Net Consultant
Top Expert 2016

Author of the Year 2009

Hi ashishahuja25,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept farsight's comment(s) as an answer.

ashishahuja25, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept THIS comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
DanRollins -- EE database cleanup volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial