How to find a position of a row in datagrid

Question

0.00/5 (No votes)

See more:

Hi Everyone,

I want to delete a row from datagrid according to the passed values, for that 1st i need to find at which row all values are matching. For this I have to find the position of a row.Below is the code I am trying to write.

dbcheck = "select * from qpoo where pono='" & txtpono.Text & "' and itemcode='" & ComboBox1.SelectedItem & "' and serialno='" & txtserialno.Text & "'"
     Dim da As New SqlCeDataAdapter
     Dim ds As New DataSet
     da = New SqlCeDataAdapter(dbcheck, cn)
     da.Fill(ds, "qpoo")
     If ds.Tables("qpoo").Rows.Count = 0 Then
         MsgBox("Scanned item is not present")
         txtserialno.Text = ""
     Else
         dr(0) = txtpono.Text
         dr(1) = ComboBox1.SelectedItem
         dr(2) = txtserialno.Text
         Table1.Rows.Remove(dr)
     End If

Any help is kindly appreciated.

Thanks in advance.

[edit]Code block added - OriginalGriff[/edit]

Posted 30-Mar-11 22:45pm

Saumyavemula

Updated 30-Mar-11 23:02pm

OriginalGriff

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)

Albin Abel · Answer 1 · 2011-03-31T03:04:00

Hi to find some value use your underlying data source than searching in a UI element. To search your value you can use Filter expressions in your data table or else the Find method on the DataRow collections. Here is an example how to find using the select method on the data table

C#

DataRow[] rows=dt.Select("ProductName='Product1'");
foreach(DataRow row in rows)
{
    dt.Rows.Remove(row);
}

(I hope this simple code snippet is not difficult for you to convert to vb.net). The key is just the select method.

where dt refers to a data table.Bind the filtered table to the data grid. If you want to remove those rows from the database then get the ids from the filtered rows and construct the delete query.

Even better way create a new DataView and use its RowFilter which has same syntax as this select method and bind the dataview to the grid. So your original datatable is unaffected. Choice is yours.