DataGridView Filter?

[bminaeff]

Hi all,

I have a datagridview with 4 columns. The first column is barcode and I have a button and a textbox. I would like to have a user enter a barcode and on the button click highlight that row. Is the filter the best thing to use in this situation?

I have seen a few people write code to filter on this site, but i seem to get an error that says " cannot perform '=' operation on system.string and system.int32

dim tables as datatablecollection = dataset1.tables
dim view1 as new dataview(tables(0))
dim source1 as new bindingsource()
source1.datasource = view1
datagridview1.datasource = source1
source1.filter = "barcode = " textbox1.text

i know this doesn't do any of the highlighting but I just want to get the records first.

Thanks for the help

 

[SgtJarrow]

The last line....

Is you barcode value in the dataset (i.e. table on server) a numeric or a text value???

For numeric, you need something like:

source1.filter = "barcode = " & textbox1.text

For text, you need something like:

source1.filter = "barcode = '" & textbox1.text & "'"

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[bminaeff]

You sir are correct.

I was looking at this data and seeing all numbers, but it is text since we could have letters.

Now is there a way to return back which row in the data grid it is or just highlight that row?

 

[SgtJarrow]

What do you mean??? You original post should actually be filtering the datagridview to only show those records with the barcode of your text box.

Do you want to just jump to/highlight that row instead of actually using the filter??


=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[bminaeff]

mstrmage1768,

Jump to/highlight is exactly what I want to do.

 

[bminaeff]

This seems to work well, but I have a new question.

Dim index As Integer
Dim style As New DataGridViewCellStyle
style.BackColor = Color.Yellow
index = HostBindingSource.Find("barcode", TextBox1.Text)
DataGridView1.Rows(index).DefaultCellStyle = style
DataGridView1.FirstDisplayedScrollingRowIndex = index

This datagrid reflects data that is held in a SQL table. This SQL table is updated every second or so and the datagridview used to update as my SQL table changed. This doesn't seem to happen anymore. Why is this?

 

[SgtJarrow]

This might help you find your solution.....Not exactly your scenario, but it should help.

My scenario is a datagridview showing some inventory. When the user clicks on a cell, an edit form is displayed. When the user returns from the edit form, the datagridview source is reloaded to get the changes. Long story as to why it had to be this way. The only problem was that everytime the datagridview was reloaded, it returned to the first record in the list. So I used the below code to capture the current rowindex, store it, open the edit form, return, reload the datagridview, and finally jump to the rowindex that began the process.

        Me.intCurrentId = Convert.ToInt32(Me.VInventoryByWarehouseAndAllocationGroupDataGridView.CurrentRow.Cells(0).Value.ToString)
        Dim FirstDisplayedIndex As Int32 = Me.VInventoryByWarehouseAndAllocationGroupDataGridView.Rows.GetFirstRow(DataGridViewElementStates.Displayed)

        Dim frm As New EditInventory
        frm.intInventoryId = Me.intCurrentId
        frm.ShowDialog()

        Me.VInventoryByWarehouseAndAllocationGroupTableAdapter.Fill(Me.DsSims.vInventoryByWarehouseAndAllocationGroup)

        Me.VInventoryByWarehouseAndAllocationGroupDataGridView.FirstDisplayedScrollingRowIndex = FirstDisplayedIndex

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[SgtJarrow]

You beat me to the punch and used the same basic solution I did.

I expect your data truly is updating, but since you have a FirstDisplayedScrollingRowIndex set, it doesn't seem to change because you are always at the same location...

Maybe not, but that would be my first guess....

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[bminaeff]

When you say you expect that the data truly is updating, do you mean in SQL? If so, then yes it is. Maybe I should step back, my barcode comes in with a weight from a PLC, and when I get this data I go up to an SAP system which determines if the weight is in tolerance. When it is I insert this barcode with a date and time to a SQL table with some string that I get from SAP. While running the users can see what the decision was by looking at this datagridview. Everytime a new barcode came in the datagridview would add another row which would be added to the top since the data was sorted by time. The table was cleaned up everyday at midnight so date is not a concern. They wanted a way to search for older barcode hence where I am now, but it now seems that the SQL table gets new data but it does not populate the datagridview.

Do you think it is because of the FirstDisplayedScrollingRowIndex? If so, is there someway I can unset that or should I set it to 0 or something?

Thanks for the help.