Insert and update in DLinq DataGridview

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrus - 28 Mar 2008 22:52 GMT

I tried to edit data in DataGridView.
Insert and delete operations in grid are not saved to database. Updating
works OK.

How to force grid to save Insert and Delete operations also ?

Andrus.

Northwind db = CreateDB();
var list = new BindingList<Customer>(db.GetTable<Customer>().ToList() );
DataGridView grid = new DataGridView { Dock = DockStyle.Fill, DataSource =
list };
Form f = new Form { Controls = { grid } };
Application.Run(f);
db.SubmitChanges();

Reply to this Message

Andrus - 29 Mar 2008 09:20 GMT

> How to force grid to save Insert and Delete operations also ?

>Insert may be easy to implement, you just need to attach new objects to
>DataContext (with the Attach() method).
>Delete is probably going to be a bit harder... :)

For insert/update I'm currently using the following code in save button:

void save_Click(object sender, System.EventArgs e) {
Grid.EndEdit();
if (!Validate())
return;
foreach (TRow row in Customers) {
if (!row.IsNew)
continue;
Grid.RowTable.Add(row);
}
int i = 1;
try {
DataBase.SubmitChanges();
} catch (Npgsql.NpgsqlException ex) {
MessageBox.Show("Cannot save");
return;
}
}

For delete I use in grid delete event:

if (row.IsNewRow)
return true;
BindingList<TEntity> bl = DataSource as BindingList<TEntity>;
RowTable.Remove(bl[row.Index]);
Rows.Remove(row);

Insert requires to implement IsNew property like

public abstract class EntityBase {
/// <summary>
/// True if row entity is new, not stored in db
/// </summary>
public bool IsNew {
get {
return (int)GetValue("Id") != 0;
}
}

I looked into MS samples. They assign bindinglist to bindingsource then
bindingsource to DataGridView DataSource. It seems that grid allows
automagically to insert and update data without writing such code.

So I'm interested which is the proper way.

Andrus.

Reply to this Message

Rate this thread:

Insert and update in DLinq DataGridview

Free Magazines