How to add a string in a bindingsource to a given position after sorting? FROM#

Question

I create my datagrid with the link:

SqlDataAdapter adapter = new SqlDataAdapter(Datenbank.cmd); dataSet1.Tables.Clear(); adapter.Fill(dataSet1, "Table"); bs = new BindingSource(); bs.DataSource = dataSet1.Tables["Table"]; dataGridView1.DataSource = bs; 

Now I sort it:

  bs.Sort = "customer DESC"; 

Now I want to add a new line to 0

  dataSet1.Tables[0].Rows.InsertAt(newRow, 0); 

However, it will not be inserted at position 0

A similar issue with deleting at position x - which was resolved here -> question

thought about using bs.insert(0,newRow) , but he says that external objects cannot be added to this list

How to add a string in a bindingsource to a given position after sorting?

Answer 1

Here is a solution that works to add to the top of the list - I have no idea if this is the best solution, but it works. There are many other ways to approach the problem, including things like creating your own collection of bindings that allows you to insert into a sorted list that can give the best code with certain points of view, but it is at least simple.

Here is the code that includes creating a datatable.

 public partial class Form1 : Form { BindingSource bs; DataTable dt; public Form1() { InitializeComponent(); dt = new DataTable("Customers"); DataColumn dc; dc = new DataColumn(); dc.DataType = typeof(int); dc.ColumnName = "CustomerID"; dt.Columns.Add(dc); dt.Columns.Add(new DataColumn("LastName")); dt.Columns.Add(new DataColumn("FirstName")); // Concatenation of first and last names dt.Columns.Add(new DataColumn("FullName")); dt.Columns.Add(new DataColumn("Address")); dt.Columns.Add(new DataColumn("City")); dt.Columns.Add(new DataColumn("State")); dt.Columns.Add(new DataColumn("Zip")); dt.Columns.Add(new DataColumn("Phone")); dc = new DataColumn(); dc.DataType = typeof(DateTime); dc.ColumnName = "LastPurchaseDate"; dt.Columns.Add(dc); dc = new DataColumn(); dc.DataType = typeof(int); dc.ColumnName = "CustomerType"; dt.Columns.Add(dc); dt.Columns.Add("HiddenSort", typeof(bool)); // Populate the table dt.Rows.Add(2, "Baggins", "Bilbo", "Baggins, Bilbo", "Bagshot Row #1", "Hobbiton", "SH", "00001", "555-2222", DateTime.Parse("9/9/2008"), 1, false); dt.Rows.Add(1, "Baggins", "Frodo", "Baggins, Frodo", "Bagshot Row #2", "Hobbiton", "SH", "00001", "555-1111", DateTime.Parse("9/9/2008"), 1, false); dt.Rows.Add(6, "Bolger", "Fatty", "Bolger, Fatty", "ProudFeet Creek", "Hobbiton", "SH", "00001", "555-1111", DateTime.Parse("9/9/2008"), 1); dt.Rows.Add(4, "Elessar", "Aragorn", "Elessar, Aragorn", "Citadel", "Minas Tirith", "Gondor", "00000", "555-0000", DateTime.Parse("9/9/2008"), 4, false); dt.Rows.Add(5, "Evenstar", "Arwin", "Evenstar, Arwin", "Citadel", "Minas Tirith", "Gondor", "00000", "555-0001", DateTime.Parse("9/9/2008"), 4, false); dt.Rows.Add(3, "Greyhame", "Gandalf", "Grayhame, Gandalf", DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, DBNull.Value, 3, false); BindingSource bs = new BindingSource(); bs.DataSource = dt; dataGridView1.DataSource = bs; dataGridView1.Columns["HiddenSort"].Visible = false; dataGridView1.Sorted += new EventHandler(dataGridView1_Sorted); } void dataGridView1_Sorted(object sender, EventArgs e) { foreach (DataRow dr in dt.Rows) { dr["HiddenSort"] = false; } } private void button1_Click(object sender, EventArgs e) { DataRow dr = dt.Rows.Add(2, "Testing", "Bilbo", "Baggins, Bilbo", "Bagshot Row #1", "Hobbiton", "SH", "00001", "555-2222", DateTime.Parse("9/9/2008"), 1, true); DataView dv = dt.DefaultView; if (dataGridView1.SortedColumn == null) { dv.Sort = "[HiddenSort] desc"; } else { string sortname = dataGridView1.SortedColumn.Name; dv.Sort = "[HiddenSort] desc, [" + sortname + "] asc"; } } } 

The trick here is to add a new HiddenSort column to the datatable, which allows us to sort the data based on whether the row is new or not. This, combined with capturing the sort column from the DataGridView, allows you to keep the old sort order and keep the position of new rows.