PC Review


Reply
Thread Tools Rate Thread

How can i "see" the next record

 
 
giannis
Guest
Posts: n/a
 
      11th Feb 2007
How can i know ("see") the next record using the BindingSource
without move to the next record ?


 
Reply With Quote
 
 
 
 
Cor Ligthert [MVP]
Guest
Posts: n/a
 
      11th Feb 2007
Giannis,

In hundred ways, one of them. BindingSource.position + 1.

http://msdn2.microsoft.com/en-us/lib....position.aspx

Cor


"giannis" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> How can i know ("see") the next record using the BindingSource
> without move to the next record ?
>
>



 
Reply With Quote
 
giannis
Guest
Posts: n/a
 
      11th Feb 2007
When i use the BindingSource.position + 1 the form display the next record.
I want to know the value of the next record without the form display the
next record.


 
Reply With Quote
 
Cor Ligthert [MVP]
Guest
Posts: n/a
 
      11th Feb 2007
Giannis,

Are you sure of that, it would be in my idea new VB code. Are you not mixing
this up with BindingSource.Position += 1

I cannot see your code but BindingSource.Position + 1 gives you in my idea
the next record.

Cor

"giannis" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> When i use the BindingSource.position + 1 the form display the next
> record.
> I want to know the value of the next record without the form display the
> next record.
>



 
Reply With Quote
 
giannis
Guest
Posts: n/a
 
      11th Feb 2007
Cor Ligthert [MVP] wrote:
> BindingSource.Position + 1 gives you in my idea the next record.


What code must i write to take the value of the next record ?
Can you indicate me ?


 
Reply With Quote
 
Cor Ligthert [MVP]
Guest
Posts: n/a
 
      11th Feb 2007
First show me a piece how you do it, I can not give you a sample from 1:1000

Cor

"giannis" <(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> Cor Ligthert [MVP] wrote:
>> BindingSource.Position + 1 gives you in my idea the next record.

>
> What code must i write to take the value of the next record ?
> Can you indicate me ?
>
>



 
Reply With Quote
 
ClayB
Guest
Posts: n/a
 
      11th Feb 2007
If the underlying DataSource for the BindingSource is a DataTable,
then the object retrieved from the BindingSource by indexing it will
be a DataRowView. Below is code that shows how to get at a field once
you have a DataRowView. If you underlying datasource is something
other than a DataTable, then the object retrieved will be some other
type.

Dim drv As DataRowView =
CType(bindingSource1(bindingSource1.Position + 1), DataRowView) '
Dim someIntValue As Integer = CInt(drv("Col1")) ' Col1 is name
of column in DataTable

==================
Clay Burch
Syncfusion, Inc.

 
Reply With Quote
 
giannis
Guest
Posts: n/a
 
      11th Feb 2007
We have a form (form1) with a Text box (box1) that takes values
from a BindingSource. The currency value for the box1 is :
"me.box1.text"
How can we find (with the BindingSource.Position +1) the next value
for the box1 before we move to the next record ? (BindingSource.movenext)
Sorry for my english ....


 
Reply With Quote
 
Cor Ligthert [MVP]
Guest
Posts: n/a
 
      11th Feb 2007
Have a look at the code from Clay.


"giannis" <(E-Mail Removed)> schreef in bericht
news:ur$(E-Mail Removed)...
> We have a form (form1) with a Text box (box1) that takes values
> from a BindingSource. The currency value for the box1 is :
> "me.box1.text"
> How can we find (with the BindingSource.Position +1) the next value
> for the box1 before we move to the next record ? (BindingSource.movenext)
> Sorry for my english ....
>



 
Reply With Quote
 
giannis
Guest
Posts: n/a
 
      11th Feb 2007
Thank you very much all two !!!


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Feature Request: "Link to record" Window should come with "push-pin"button to allow for batch linking mduijkers@gmail.com Microsoft Outlook BCM 1 4th Dec 2007 12:17 AM
"Delete Record" not working after adding "Edit Record" button. Mike Janes Microsoft Access 7 20th Aug 2006 03:10 PM
"Date updated" in "one" record any time a "many record" changes? =?Utf-8?B?RWxpemFiZXRoIFN3b29wZQ==?= Microsoft Access Form Coding 8 19th Aug 2006 11:53 AM
Hide "Record" "Closed Caption" "Parental Control" indicators while in full screen Jordan ATI Video Cards 0 18th Feb 2005 05:21 PM
"Can't add record(s); join key of table "SUBFORMS UNDERLYING TABLE NAME" not in record set" Error message Dave the wave Microsoft Access Form Coding 5 10th Jun 2004 11:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:21 AM.