Re: DataGrid Row Searching

This is what I ended up with - you pass in a dataview and the key value you
want to find, and it will return the row. The hardest part was finding how
to get access to the dataview that the grid is bound to, which appears to be:

DirectCast(grdEmployee.BindingContext(dsDataSet, "Employee").Current,
DataRowView).DataView

I'm not sure why, but that seems to work. It seems like there should be an
"easier" way to get at this, but now that I found it, it doesn't matter all
that much. It was very hard to pull out the right dataview object because
i'm bound to a dataset and not a dataview.

This will only work for tables with a single primary key (which covers all
of my tables - we use an ID for all PKs)

Private Function GetRowBySinglePrimaryKey(ByVal dvDataView As DataView,
ByVal strKey As Object) As Integer
Try
Dim II As Integer
For II = 0 To dvDataView.Count - 1
If dvDataView(II)(dvDataView.Table.PrimaryKey(0).ToString) =
strKey Then
Return II
End If
Next
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Function

"Cor Ligthert [MVP]" wrote:

Keith,

You are right I thought the primary key was used by this but it is the sort
property. So it is sorting what you don't want. Sorry

Than you have in my idea only as option something as this.

dim i as integer
dim dv as DirectCast(grdEmployee.DataSource,DataView)
For i from 0 to dv.Count -1
if dv(i)("EmployeeId") = WhatIWant then exit for
Next
Row in the grd = i

Don't think it is slow behind the scene is a lot of looping done.

Not tested but this seems very simple for me.

Cor


"Keith" <Keith@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:171D7271-F224-454E-BF3E-93B279D282DF@xxxxxxxxxxxxxxxx
Doesn't seem to be working right.

I've tried the following 3 things in an attempt to get the correct row
(intRow = ...), but all return -1:

Dim strSort As String
Dim dvEmployee As DataView =
DirectCast(grdEmployee.BindingContext(dsDataSet, "Employee").Current,
DataRowView).DataView
strSort = dvEmployee.Sort
Dim dvTemp As New
DataView(dsDataSet.Tables("Employee"))
dvTemp.Sort = strSort
intRow = dvTemp.Find(objRow("EmployeeID"))
intRow = dvEmployee.Find(objRow("EmployeeID"))

dsDataSet.Tables("Employee").DefaultView.Sort = strSort
intRow =
dsDataSet.Tables("Employee").DefaultView.Find(objRow("EmployeeID"))

"Cor Ligthert [MVP]" wrote:

Keith,

Both the dataview (defaultview) and the currencymanager are in my idea
ussable to get the position of a row in a datagrid.

In my idea is it the best if you use the dataview.find, than you get an
index, that index is the same as the row in a DataGrid. (Your datasource
should than be the dataview or better the defaultview of the table).

http://msdn2.microsoft.com/en-us/library/system.data.dataview.find.aspx

I hope this helps,

Cor

"Keith" <Keith@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:C68DE8FE-3073-4445-B8D4-FA653CBE0DDA@xxxxxxxxxxxxxxxx
Cor,

This is a completely different method of validation than I described.
This
would go through each DataRow and set the RowError property if it is
invalid,
which would then give the standard error flag next to the rows in the
DataGrid on a refresh. This also doesn't explain anything about how to
select the cell with the first instance of an error.

The problem with this method of validation for me is that if I have
errors
in the child tables (which are displayed in their own DataGrids), you
will
not see the error unless you select a row in the parent table that the
child
row belongs to. Your link might be something I'd do in addition to
what I
have now, but I need more than just that.

What I need specifically:
- How do I select a cell in a datagrid based on its primary key/ID,
regardless of how the data is sorted in the grid? Remember the fact
that
the
ID is not visible through the DataGrid.Item(row,col) property, since
I'm
filtering the visible columns with the TableStyles.GridColumnStyles().

"Cor Ligthert [MVP]" wrote:

Keith,

Will this not better help you, this field is reflected in the
datagrid?

http://msdn2.microsoft.com/en-us/library/system.data.datarow.rowerror.aspx

Cor

"Keith" <Keith@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:EB260C96-0349-4BDD-818C-557694851975@xxxxxxxxxxxxxxxx
Background:

I have a parent table (Employee) with two child tables (Phone and
Email)
I have a datagrid bound to the dataset, with datamember = Employee
for
the
employee table
I have two other datagrids for the Phone and Email bound to the same
dataset, with DataMember = EmployeeToPhone and EmployeeToEmail
relations,
respectively.

This allows me to select an employee in the employee grid, and the
phone
numbers and emails for that employee in the phone/email grids and
the
relations are maintained without me having to do anything special.

The problem I'm currently having is with validation. After the user
is
completely done with their updates, I loop through all the datarows
in
the
GetChanges(Added) and GetChanges(Modified) method of each
DataSet.DataTable.
If I encounter an invalid cell value, I would like to send focus
back
to
that
cell in the datagrid.

Here are my problems:
1. Based on the information that I have at the time (the DataRow
and
column
mapping name of the incorrect-valued cell), I can't find a way to
figure
out
what row and column numbers this corresponds to in the DataGrid.
2. Now, say the user has a column sorted - this doesn't affect the
dataset,
only the datagrid. How can I get the right row/column to select
now?
3. Lastly, for the Phone and Email grids, I will need to first
select
the
Parent row in the Employee datagrid before selecting the right Cell
to
send
focus to for editing. How do I do this (maybe the answers in 1 or 2
may
help
me with this one, but I am still stuck on this).

Thanks in advance!









.

Relevant Pages

  • Re: DataGrid Row Searching
    ... would go through each DataRow and set the RowError property if it is invalid, ... How do I select a cell in a datagrid based on its primary key/ID, ... I have a parent table (Employee) with two child tables ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DataGrid Row Searching
    ... dim dv as DirectCast ... that index is the same as the row in a DataGrid. ... How do I select a cell in a datagrid based on its primary key/ID, ... I have a datagrid bound to the dataset, with datamember = Employee ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DataGrid Row Searching
    ... Dim strSort As String ... that index is the same as the row in a DataGrid. ... How do I select a cell in a datagrid based on its primary key/ID, ... I have a parent table (Employee) with two child tables (Phone and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DataGrid Row Searching
    ... that index is the same as the row in a DataGrid. ... How do I select a cell in a datagrid based on its primary key/ID, ... I have a parent table (Employee) with two child tables (Phone and ... This allows me to select an employee in the employee grid, ...
    (microsoft.public.dotnet.framework.adonet)
  • DataGrid - Ghost Cell Refresh Issue
    ... I've a datagrid which source is a dataview based on a dataset. ... The trouble starts when clicking on a cell within a datagridtextbox ... value of the cell I had clicked when displaying All Customers overlaps ...
    (microsoft.public.dotnet.framework.windowsforms.controls)