binding, pulldata twice after EndEdit

[Axel_H]

Hello,

i have a strange behavior with binding, sorting and row.EndEdit.

I have a DataTable connected to a Bindingsource and a Textbox which is binded to the BindingSource.

In the DataTable there is one Column (DataType is String) which is Sorted.

So then i add four rows, which contains the values "1" "2" "4" and "5".


With a Button_Click_Event, i add an new row, go to new position of the row

and set the Text-Member of the textbox to -> "3".

After that i call the Row.EndEdit() and what happened is:

The row is sorted to the proper position,

but the row number 2 with the value "2" is overwritten with "3", why????


The issue is shown in the following code (you can copy it inside an new project and start):

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Text;
using System.Data;
using System.Windows.Forms;

namespace BindingSourceExamples
{
public class Form1 : Form
{
[STAThread]
static void Main()
{
Application.EnableVisualStyles();
Application.Run(new Form1());
}

public Form1()
{
this.Load += new EventHandler(Form1_Load);
}

private DataTable table;
private BindingSource bs;
private TextBox textBox1;
private Button button1;
private Binding binding1;

void Form1_Load(object sender, EventArgs e)
{
// Create a new DataTable.
table = new DataTable();

// Create column.
DataColumn column = new DataColumn();
column.DataType = System.Type.GetType("System.String");
column.ColumnName = "Column1";
column.AutoIncrement = false;
column.Caption = "FS1FGNR";
column.ReadOnly = false;
column.Unique = false;
table.Columns.Add(column);

// Add Rows
DataRow row1 = table.NewRow();
row1[column.ColumnName] = "1";
table.Rows.Add(row1);

DataRow row2 = table.NewRow();
row2[column.ColumnName] = "2";
table.Rows.Add(row2);

DataRow row3 = table.NewRow();
row3[column.ColumnName] = "4";
table.Rows.Add(row3);

DataRow row4 = table.NewRow();
row4[column.ColumnName] = "5";
table.Rows.Add(row4);


// Add BindingSource
bs = new BindingSource();
bs.DataSource = table;

// Do Sorting
bs.Sort = column.ColumnName;

// Add Controls
textBox1 = new TextBox();
textBox1.Location = new Point(23, 70);
textBox1.Size = new Size(150, 20);

button1 = new Button();
button1.Text = "ADD";
button1.Click += new EventHandler(this.button1_Click);
button1.Location = new Point(23, 25);
button1.Size = new Size(100, 40);

this.ClientSize = new Size(292, 266);
this.Controls.Add(this.button1);
this.Controls.Add(this.textBox1);


// Add Binding
binding1 = new Binding("Text", bs, column.ColumnName, true, DataSourceUpdateMode.OnPropertyChanged);
textBox1.DataBindings.Add(binding1);


}


private void button1_Click(object sender, EventArgs e)
{
// Add New Row
DataRow newRow = table.NewRow();
table.Rows.Add(newRow);

// Set Position to new Row
int cnt = -1;
foreach (DataRowView row in ((DataView)bs.List))
{
cnt++;
if (Object.Equals(row.Row, newRow))
{
bs.Position = cnt;
break;
}
}

//Set Value
textBox1.Text = "3";

//EndEdit to do Sorting
((DataRowView)bs.List[0]).EndEdit();
}
}

I cannot explain this behavior, can u?

Is this a bug?


Thanks for help.

Continue reading...