Data Value tracing Grid

Anantsharma · April 13th, 2005, 10:47 PM

Hi Programmers,

Well I am in process to develope a Windows App in VB.NET.

I need to display some records (80-90 thousand rows) in a Grid. On the form, there will be a Textbox where user will type something. Typing anything here will have to trace the item in a particular column of grid and the moment user finds the required record, he will hit enter and the value from a columm from selected/traced record will be captured in a variable. I have done this a lot with VB6 using a class file and module and DbGrid control. You must be aware that the DbGrid of VB6 is bound to a recordset. Moving inside recorset, automatically moves a record pointer in DbGrid.

In VB.NET, DataGrid is also bound control. Can someone just give me an idea to open my wings towards this task.

I am looking for HOW TO logic and flow.

Hope you got my point !!!

Cheers...Anant

jaucourt · April 27th, 2005, 04:28 PM

You'd have to use the keypress event

Code:

Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress

Code:

    End Sub

Set the datasource of the datagrid to be a dataview. Every time a key is pressed, amend the RowFilter property of the dataview to be whatever has been typed in the textbox, for example:

Code:

dv.RowFilter=string.format("LastName='{0}'",textbox1.text)

Think this will do the trick. As for 'saving the values in a variable on enter', just trap the Leave event of the textbox and grab the first row of the dataview:

Code:

selectedRow=dv.Item(0)