how to move row next and previous in datatable c#

Question

how to move row next and previous in datatable c#

NazHim 206

hi all
how to. dynamically move row next and previous in datatable in c#
without using database
can possible it?
can provide some code snippet?

with best regards
NazHim

1 answer

Your answer

Answer 1

Karen Payne MVP 35,591 Volunteer Moderator

Sure it's possible. If you load data from a file (xml, json, csv) and display this data in a DataGridView, ListView or ListBox where you assign the DataTable to a BindingSource then the BindingSource becomes the data source for the control then use the language extensions I created in tangent with two buttons, one up one down. This will allow rows to be moved up/down.

From here before saving you might consider having a column to identify the row position and loop through the rows and assign values to the row position column.

Although the following article uses a database as mentioned earlier this can be done without a database but the article does use a database.

Microsoft TechNet Wiki: C# DataGridView - ListBox - CheckListBox - ListView move items up/down

In closing, if I had a non-database version I'd post it but my guess is less than one percent of developers use files as a source for storing information rather than use a database. And some of them are importing/exporting from databases.

NazHim 206 Reputation points

2021-05-16T05:39:41.633+00:00
hi karenpayneoregon
thanks
i am using DataTable without DataSet or bindingsource

DataTable salinvitedetTem = new DataTable();

how can do this?

best regards
NazHim
Karen Payne MVP 35,591 Reputation points Volunteer Moderator

2021-05-16T09:54:18.963+00:00
In regards to DataSet, I don't use one in the code. You need a BindingSource to work with my code samples as the Position property of the BindingSource is part of what makes this work as shown below.

var newIndex = Convert.ToInt32((sender.Position == 0) ? 0 : sender.Position - 1);

And

sender.Position = newIndex;

Timon Yang-MSFT 9,606

@NazHim
It is quite simple to use Datatable and BindingSource together, like this:

            DataTable dataTable = new DataTable();  
            //......  
            BindingSource bindingSource = new BindingSource();  
            bindingSource.DataSource = dataTable;

NazHim 206 Reputation points

2021-05-17T05:33:41.247+00:00

hello Timon Yang-MSFT
worked fine
thanks
Timon Yang-MSFT 9,606 Reputation points

2021-05-17T06:27:37.937+00:00

Can this short code combined with the complete example provided by Karen solve your problem? If you still have any questions, please feel free to ask.

Share via

how to move row next and previous in datatable c#

1 answer

Your answer