How do you set the current row of a dataset?
I want to bind a control to a field from the 5th row in a dataset.
I fill the dataset, then I want to set the row to the 5th row and then do
the databinding.

Dataset1.tblMyTable.CurrentIndex = 5 or something like that maybe?



'Sets the value for a field using index number......
Dataset1.tblMyTable(1).FieldName = strName

'Iterates through rows of a dataset but does not set the row
explicitly......
For Each myRow In DataSet1.tblMyTable.Rows
strName = myRow("FieldName")
Next

I understand how to do that but it does not do what I need.

The row I want to show is based on the "index" or row number. I may want to
show row 5 then row 100 then row 48. So I need to be able to set the current
row to 5.

How do I do that?
Dataset1.tblMyTable.CurrentIndex = 5 or something like that maybe?



"Eliyahu Goldin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Make a DataView that will contain only the row you want to show and bind
> your control to the DataView.
>
> Eliyahu
>
> "Craig" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > How do you set the current row of a dataset?
> > I want to bind a control to a field from the 5th row in a dataset.
> > I fill the dataset, then I want to set the row to the 5th row and then
do
> > the databinding.
> >
> > Dataset1.tblMyTable.CurrentIndex = 5 or something like that maybe?
> >
> >
> >
> > 'Sets the value for a field using index number......
> > Dataset1.tblMyTable(1).FieldName = strName
> >
> > 'Iterates through rows of a dataset but does not set the row
> > explicitly......
> > For Each myRow In DataSet1.tblMyTable.Rows
> > strName = myRow("FieldName")
> > Next
> >
> >
>
>

Make a DataView that will contain only the row you want to show and bind
your control to the DataView.

Eliyahu

"Craig" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How do you set the current row of a dataset?
> I want to bind a control to a field from the 5th row in a dataset.
> I fill the dataset, then I want to set the row to the 5th row and then do
> the databinding.
>
> Dataset1.tblMyTable.CurrentIndex = 5 or something like that maybe?
>
>
>
> 'Sets the value for a field using index number......
> Dataset1.tblMyTable(1).FieldName = strName
>
> 'Iterates through rows of a dataset but does not set the row
> explicitly......
> For Each myRow In DataSet1.tblMyTable.Rows
> strName = myRow("FieldName")
> Next
>
>

Hi Craig,

How do you do that databinding for that 5th row, you makes me curious,

I assume it is aspnet, because if it is windowsform it is easy to tell
however that does not work on a webform.

Cor

I am using webforms.

I want to do a 'next page' or 'previous page' function using a web form I
was going to use the row number of the dataset and increment each time or
decrement it each time and rebind the form.

How would I do the 'next page' or 'previous page' functionality using a web
form?

I know I can refer to any row in a dataset but it seems ridiculous that I
can't set the row of a dataset.

Why doesn't the tool box have a next record navigation functionality built
in, Interdev did?


"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:OSo$(E-Mail Removed)...
> Hi Craig,
>
> How do you do that databinding for that 5th row, you makes me curious,
>
> I assume it is aspnet, because if it is windowsform it is easy to tell
> however that does not work on a webform.
>
> Cor
>
>

Are you using a datagrid?

The index is of course the way Eliyahy showed you.

So that I do not need to answer anymore.

Cor

No it is using textbox controls on a single page.

I have created a datagrid and set the paging to 1. That worked. But a
complex form can be easier as a webform full of controls.

So any ideas?


Name _________
Address _________

"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Are you using a datagrid?
>
> The index is of course the way Eliyahy showed you.
>
> So that I do not need to answer anymore.
>
> Cor
>
>

Hi Craig

In my opinion did you got the idea for that from Eliyahu.

Know that a dataset and your currentindex does not persist when you do not
set it in a session (or a viewstate or a cache, however the last should be a
nonchanging dataset).

Cor

Eliyahu said....

Make a DataView that will contain only the row you want to show and bind
your control to the DataView.
and...
Dataset1.tblMyTable.Rows[5] or Dataset1.tblMyTable[5]

I don't see how that helps. I just want to bind the controls to he first
row, then the user clicks a next button and then I'll bind the controls to
the next row etc. I don't care if the dataset has to be refilled etc. and
I'll maintain the current row in a ViewState("Currentrow") variable.

So how can I set the row number in the dataset?

Maybe I'll just stick to a datagrid with paging set to 1.



"Cor Ligthert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Craig
>
> In my opinion did you got the idea for that from Eliyahu.
>
> Know that a dataset and your currentindex does not persist when you do not
> set it in a session (or a viewstate or a cache, however the last should be
a
> nonchanging dataset).
>
> Cor
>
>

Dataset1.tblMyTable.Rows[5] or Dataset1.tblMyTable[5]

Is that what you are after?

Eliyahu

"Craig" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I understand how to do that but it does not do what I need.
>
> The row I want to show is based on the "index" or row number. I may want
to
> show row 5 then row 100 then row 48. So I need to be able to set the
current
> row to 5.
>
> How do I do that?
> Dataset1.tblMyTable.CurrentIndex = 5 or something like that maybe?
>
>
>
> "Eliyahu Goldin" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Make a DataView that will contain only the row you want to show and bind
> > your control to the DataView.
> >
> > Eliyahu
> >
> > "Craig" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > How do you set the current row of a dataset?
> > > I want to bind a control to a field from the 5th row in a dataset.
> > > I fill the dataset, then I want to set the row to the 5th row and then
> do
> > > the databinding.
> > >
> > > Dataset1.tblMyTable.CurrentIndex = 5 or something like that maybe?
> > >
> > >
> > >
> > > 'Sets the value for a field using index number......
> > > Dataset1.tblMyTable(1).FieldName = strName
> > >
> > > 'Iterates through rows of a dataset but does not set the row
> > > explicitly......
> > > For Each myRow In DataSet1.tblMyTable.Rows
> > > strName = myRow("FieldName")
> > > Next
> > >
> > >
> >
> >
>
>