Dataset / Datatable in Visual Developer 2008

ravno

I am developing a Windows-application - database mssql - visual basic.
I add Datasets to forms, bind them to daatagridview/textboxes - fill with dataadapter - everything's fine so far.

Here's my question:

how do I programmaticaly move from a record/datarow i a dataset to another.
I know the value of the key-field and want that record to be shown.
If I use the dataset.datatable.findbykey-method, the program finds the record, but it doesn't move there.
Anybody with good ideas ?

ravno

OuTCasT

You have to use a currency manager to navigate through the datasets rows.

Expand|Select|Wrap|Line Numbers

  
'Commands and adapter for the Employee masterfile

Dim sqlEmployeeCommand As SqlCommand

Dim sqlEmployeeAdapter As SqlDataAdapter

Dim sqlEmployeeDataTable As DataTable

'Currency Managers for Commands above

Dim sqlEmployeeManager As CurrencyManager
 
'lblPaymentPeriod.Text = strPaymentPeriod

sqlEmployeeCommand = New SqlCommand("SELECT * FROM EmployeeDetails order by EmployeeID", sqlcon)

sqlEmployeeAdapter = New SqlDataAdapter(sqlEmployeeCommand)

sqlEmployeeDataTable = New DataTable

sqlEmployeeAdapter.Fill(sqlEmployeeDataTable)

' Fill Table with EmployeeDetails

lblPaymentPeriod.DataBindings.Add("text", sqlEmployeeDataTable, "EmployeePaymentType", True)
 
sqlEmployeeManager = DirectCast(Me.BindingContext(sqlEmployeeDataTable), CurrencyManager)

When you want to navigate forward :

Expand|Select|Wrap|Line Numbers

sqlEmployeeManager.Position += 1

Backwards:

Expand|Select|Wrap|Line Numbers

sqlEmployeeManager.Position -= 1

[SIZE=2]
[/SIZE]

ravno

Thank you for the answer.

It looks as the same functionality, I get from:
databindingsource.movenext() or databindingsource.movelast()

What I really want is
"move to the record, where Key=something"

In Access2000 I did it this way:
Dim rs As DAO.Recordset
Set rs = Me.Recordset.Clone
rs.FindFirst "MemberId = " & someValue
Me.Bookmark = rs.Bookmark
rs.Close

All in all I still have some trouble working with datasets programmatically.
How do I eg adress values in the 'current record' in a dataset.datatable ?

I have a form with a dataset - showed in a datagrid. I can use the grid to navigate the recordset, but how do I access the dataset, when I need a value stored in the dataset ?
In Access I do it like this:
value=recordset.fields!fieldname or
value=me.recordset.fieldname

The search-problem above could be described:

dataset.movefirst
while dataset.currentrecord.keyvalue<>mykeyvalue and not eof
dataset.movenext
end while
if not eof then
doSomeThing(dataset.currentrecord.keyvalue)
end if

ravno

OuTCasT

So you want to search the dataset for a specific entry correct. i added a toolstriptextbox where they can type in the specific employeecode so they can retrieve the information for that code.

[SIZE=2][/SIZE]

Expand|Select|Wrap|Line Numbers

  
If ToolStripTextBox1.Text = "" Then Exit Sub

Dim SavedRow As Integer = sqlEmployeeManager.Position

Dim FoundRows() As DataRow

sqlEmployeeDataTable.DefaultView.Sort = "EmployeeID"

FoundRows = sqlEmployeeDataTable.Select("EmployeeID LIKE '" + ToolStripTextBox1.Text + "*'")

If FoundRows.Length = 0 Then

sqlEmployeeManager.Position = SavedRow

Else

sqlEmployeeManager.Position = sqlEmployeeDataTable.DefaultView.Find(FoundRows(0).Item("EmployeeID"))

End If

ravno

Hi OuTCasT
I didn't make it work - but your use of 'position' really made something:

In my form I have
- dataset DS with a datatable DT
- a bindingsource BS, where
BS.DataSource=DS
BS.DataMember=DT
- a tableAdapter and a tableadaptermanager

- a datagridview with DataSource=BS

The command
BS.Position=BS.Find("KeyName",keyvalue)
moves focus/currentrecord in the dataset - and the datagridview - to the wanted row/record.

DS.DT.Rows(BS.Position).Item("ColumnName") let me acces the data.

Don't know, if it's the 'authorized' way to do things, but it works for me.
Thanks
ravno

OuTCasT

At least you got it working and you can access the desired information. :)

Dataset / Datatable in Visual Developer 2008

re: Dataset / Datatable in Visual Developer 2008

re: Dataset / Datatable in Visual Developer 2008

re: Dataset / Datatable in Visual Developer 2008

re: Dataset / Datatable in Visual Developer 2008

re: Dataset / Datatable in Visual Developer 2008

Similar Visual Basic .NET bytes

/bytes/development

/bytes/it

/bytes/about