Research datagrid using bank.mdb vb.net

Question

4.00/5 (1 vote)

See more:

Research datagrid using bank.mdb vb.net

Personnel is with a serious problem in trying fzr a research in the datagrid ...preciso to compare three textbox with three columns in the grid and non to getting. Somebody oh it can help me. I already tried of everything more I don't get.

Use banco.mdb for filling the grid
It follows my code oh not this making anything, this code oh it only works if I fill the datagrid without using banco.mdb.
Somebody can tell me the one that this acontencendo!
.....................
"""Pessoal estou com um problema sério em tentar fzr uma pesquisa no datagrid...preciso comparar tres textbox com tres colunas no grid e não to conseguindo. Alguém ai pode me ajudar. Já tentei de tudo mais não consigo.
Uso banco.mdb pra preencher o grid
Segue o meu código ai mais não esta fazendo nada, este código ai só funciona se eu preencher o datagrid sem usar o banco.mdb.
Alguém pode me dizer o que esta acontencendo!"""
......................

VB

For i = 0 To DataGrid1.Rows.Count - 1
    If DataGrid1.Rows(i).Cells(1).Value = textbox1.Text AndAlso _
    DataGrid1.Rows(i).Cells(2).Value = textbox2.Text AndAlso _
    DataGrid1.Rows(i).Cells(3).Value = textbox3.Text Then


    Me.DataGrid1.FirstDisplayedScrollingRowIndex = i
        Me.DataGrid1.Rows(i).Selected = True

        textbox4.Text = RS1.Fields(4).Value
        textbox5.Text = RS1.Fields(5).Value
        textbox6.Text = RS1.Fields(6).Value
        textbox7.Text = RS1.Fields(7).Value


    Else
        textbox4.Text = "?"
        textbox5.Text = "?"
        textbox6.Text = "?"
        textbox7.Text = "?"
    End If
    Exit Sub
Next

Posted 22-Jan-13 2:39am

Antonio Ademir Bernardi

Updated 22-Jan-13 3:07am

Sandeep Mewara

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Antonio Ademir Bernardi · Answer 1 · 2013-01-22T03:32:00

á got fzr the research, I only had to change some things in the code ...confiram...

For i = 0 To DataGrid1.Rows.Count - 1
If DataGrid1.Rows(i).Cells(1).Value = textbox1.Text.ToString And _
DataGrid1.Rows(i).Cells(2).Value = textbox2.Text.ToString And _
DataGrid1.Rows(i).Cells(3).Value = textbox3.Text.ToString Then

Me.DataGrid1.SelectionMode = DataGridViewSelectionMode.FullRowSelect
Me.DataGrid1.FirstDisplayedScrollingRowIndex = i
Me.DataGrid1.Rows(i).Selected = True
textbox4.Text = DataGrid1.Rows(i).Cells(5).Value

textbox5.Text = DataGrid1.Rows(i).Cells(6).Value
textbox6.Text = DataGrid1.Rows(i).Cells(7).Value
textbox7.Text = DataGrid1.Rows(i).Cells(8).Value
Else
'textbox4.Text = "?"
'textbox5.Text = "?"
'textbox6.Text = "?"
'textbox7.Text = "?"
End If
Exit Sub
Next

It was not easy more I got
My project only lacked this, now this completinho ...ABRAÇOS