ReArrange Data Gridview Rows

Question

0.00/5 (No votes)

See more:

i have a datagredview with 50 rows , make search on grid and want to set that particular row on the top.

SQL

For Each dr As DataGridViewRow In DGAccount.Rows
               If dr.Cells(3).Value = txtAcID.Text.Trim Then
                   dr.Selected = True
                   DGAccount.FirstDisplayedScrollingRowIndex = dr.Index
                   DGAccount.CurrentCell = dr.Cells(3)
                   DGAccount.Update()
                   Exit For
               End If
           Next

Can any body help me how can i rearrange datagrid .

Thanks

Posted 19-Jan-14 22:22pm

Naim_86

Add a Solution

Comments

TnTinMn 21-Jan-14 0:35am

It is not completely clear what your intent is. Based on the code you have shown, it appears that you want to scroll to to the selected account Id. But then you state "rearrange datagrid"; this implies that you may want to make the found row the first row (not just first scrolled to row).

If it is just scrolling, change "dr.Cells(3).Value" to "dr.Cells(3).Value.ToString()" so that you are comparing string values. Your code appears fine for a DataGridView configured with MultiSelect=False.

If you want to rearrange the displayed row order, I can provide you an example of how to do this using "LINQ to DataSets".

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)

Dinesh.V.Kumar · Answer 1 · 2014-01-20T00:26:00

Instead of searching the grid, please search the datatable that is bound to the grid. You will be able to filter the record faster. Transfer the filtered records to another datatable and bind the new datatable to the grid. This way it will be easy for you rather than searching the grid...

I assume you are working in a web application

VB

Dim dr() as DataRow
Dim dt1 as DataTable
dt1=dt.clone()
dr=dt.Select(" AccountID='" & txtAcId.Text.Trim &"'")
for each dr1 as DataRow in dr
  dt1.ImportRow(dr1)
next

DGAccount.DataSource = dt1
DGAccount.DataBind()

Hope it helps!!

Dinesh Kumar V