Showing query results on form
Showing query results on form
Showing query results on form
Showing query results on form
Showing query results on form
Showing query results on form Showing query results on form Showing query results on form Showing query results on form Showing query results on form Showing query results on form Showing query results on form Showing query results on form
Showing query results on form Showing query results on form
Showing query results on form
Go Back  Xtreme Visual Basic Talk > > > Showing query results on form


Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2013, 08:15 AM
PeetSoft's Avatar
PeetSoft PeetSoft is offline
Centurion
 
Join Date: Jun 2003
Location: HHW - the Netherlands
Posts: 184
Default Showing query results on form


Might be simple, but just can't find it.

Having a tableadapter, a Dataset, Bindingsource and -navigator, I can moveprev and movenext through my dataset and display field values on form.labels

Users will go through the dataset to adapt records from time to time

After a query I need to display the found record in my form.labels

How do I get i.e. record 13 to show after query? Can this be done at once or do I have to use a datareader and update all form.labels?

tia
__________________
-----------------------------------------------------
If debugging is the art of removing bugs, then
programming must be the art of inserting them.
I do comply with Flyguy's signature (If he still had one)
Reply With Quote
  #2  
Old 09-05-2013, 08:35 AM
DrPunk's Avatar
DrPunkShowing query results on form DrPunk is offline
Senior Contributor

* Expert *
 
Join Date: Apr 2003
Location: Never where I want to be
Posts: 1,403
Default

I'm sorry but I don't really understand what you are asking.

I'm confused by you showing data in form.labels, then saying you need to find record in form.labels, then saying you want to update form.labels with data.
__________________
There are no computers in heaven!
Reply With Quote
  #3  
Old 09-05-2013, 10:36 AM
PeetSoft's Avatar
PeetSoft PeetSoft is offline
Centurion
 
Join Date: Jun 2003
Location: HHW - the Netherlands
Posts: 184
Default

DrPunk,

I am refreshing my db every day, saving an Excel attachment and exporting field values to an .mdb

I'm having a field value time, a timer will check every minute whether there is a record with that time (the query mentioned above). If there is such a record return the data and display this on my form.

My bindingnavigator shows last record accessed, but when the query finds a record, I need to have that record displayed in my form.labels instead of last record accessed
__________________
-----------------------------------------------------
If debugging is the art of removing bugs, then
programming must be the art of inserting them.
I do comply with Flyguy's signature (If he still had one)
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Showing query results on form
Showing query results on form
Showing query results on form Showing query results on form
Showing query results on form
Showing query results on form
Showing query results on form Showing query results on form Showing query results on form Showing query results on form Showing query results on form Showing query results on form Showing query results on form
Showing query results on form
Showing query results on form
 
Showing query results on form
Showing query results on form
 
-->