Display deleted rows in DataGrid

[Guest]

Hello,

I use DataGrid that displays data from DataTable. When I delete a row, this
row disapears in DataGrid and changes it's status in DataTable.

I there any way how to display everything what's in DataTable?
I want that user will see all changes made and after clicking some "Commit"
button those changes will be saved into the database.

Thanks a lot
Vladimir

 

[Guest]

Hmmm.

Make the first cell a Delete checkbox. Click all the rows you want to
delete (make sure they can all be uniquely identified). Have a Command
button labeled Delete. As each check box is checked, add that row to a second
grid. On clicking the Delete button, do the delete.

 

[Guest]

Have a look at RowStateFilter. The following code displays unchanged, new,
modified and deleted rows.

DataView dataView = (DataView)((CurrencyManager)dataGrid1.BindingContext[
dataGrid1.DataSource, dataGrid1.DataMember ]).List;
dataView.RowStateFilter = System.Data.DataViewRowState.CurrentRows |
System.Data.DataViewRowState.Deleted;

Then I would use a custom DataGridTextBoxColumn class to colour the rows
depending on the RowState.

public class CustomDataGridTextColumn : DataGridTextBoxColumn
{
protected override void Paint(System.Drawing.Graphics g,
System.Drawing.Rectangle bounds, System.Windows.Forms.CurrencyManager source,
int rowNum, System.Drawing.Brush backBrush, System.Drawing.Brush foreBrush,
bool alignToRight)
{
Brush newForeBrush = null;
DataRow dataRow = ((DataView)source.List)[ rowNum ].Row;

switch (dataRow.RowState)
{
case DataRowState.Added:
newForeBrush = new SolidBrush(Color.Blue);
break;
case DataRowState.Deleted:
newForeBrush = new SolidBrush(Color.Red);
break;
case DataRowState.Modified:
newForeBrush = new SolidBrush(Color.Green);
break;
default:
break;
}

if (newForeBrush != null)
{
base.Paint(g, bounds, source, rowNum, backBrush, newForeBrush,
alignToRight);
newForeBrush.Dispose();
}
else
{
base.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight);
}
}
}

Regards,
Phil.

 

[Guest]

Thanks a lot Phil,

this completely solved my problem.

Vladimir

Have a look at RowStateFilter. The following code displays unchanged, new,
modified and deleted rows.

DataView dataView = (DataView)((CurrencyManager)dataGrid1.BindingContext[
dataGrid1.DataSource, dataGrid1.DataMember ]).List;
dataView.RowStateFilter = System.Data.DataViewRowState.CurrentRows |
System.Data.DataViewRowState.Deleted;

Then I would use a custom DataGridTextBoxColumn class to colour the rows
depending on the RowState.

public class CustomDataGridTextColumn : DataGridTextBoxColumn
{
protected override void Paint(System.Drawing.Graphics g,
System.Drawing.Rectangle bounds, System.Windows.Forms.CurrencyManager source,
int rowNum, System.Drawing.Brush backBrush, System.Drawing.Brush foreBrush,
bool alignToRight)
{
Brush newForeBrush = null;
DataRow dataRow = ((DataView)source.List)[ rowNum ].Row;

switch (dataRow.RowState)
{
case DataRowState.Added:
newForeBrush = new SolidBrush(Color.Blue);
break;
case DataRowState.Deleted:
newForeBrush = new SolidBrush(Color.Red);
break;
case DataRowState.Modified:
newForeBrush = new SolidBrush(Color.Green);
break;
default:
break;
}

if (newForeBrush != null)
{
base.Paint(g, bounds, source, rowNum, backBrush, newForeBrush,
alignToRight);
newForeBrush.Dispose();
}
else
{
base.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight);
}
}
}

Regards,
Phil.

Hello,

I use DataGrid that displays data from DataTable. When I delete a row, this
row disapears in DataGrid and changes it's status in DataTable.

I there any way how to display everything what's in DataTable?
I want that user will see all changes made and after clicking some "Commit"
button those changes will be saved into the database.

Thanks a lot
Vladimir

 

[Guest]

Glad to be of some help.

Phil.

Thanks a lot Phil,

this completely solved my problem.

Vladimir

Have a look at RowStateFilter. The following code displays unchanged, new,
modified and deleted rows.

DataView dataView = (DataView)((CurrencyManager)dataGrid1.BindingContext[
dataGrid1.DataSource, dataGrid1.DataMember ]).List;
dataView.RowStateFilter = System.Data.DataViewRowState.CurrentRows |
System.Data.DataViewRowState.Deleted;

Then I would use a custom DataGridTextBoxColumn class to colour the rows
depending on the RowState.

public class CustomDataGridTextColumn : DataGridTextBoxColumn
{
protected override void Paint(System.Drawing.Graphics g,
System.Drawing.Rectangle bounds, System.Windows.Forms.CurrencyManager source,
int rowNum, System.Drawing.Brush backBrush, System.Drawing.Brush foreBrush,
bool alignToRight)
{
Brush newForeBrush = null;
DataRow dataRow = ((DataView)source.List)[ rowNum ].Row;

switch (dataRow.RowState)
{
case DataRowState.Added:
newForeBrush = new SolidBrush(Color.Blue);
break;
case DataRowState.Deleted:
newForeBrush = new SolidBrush(Color.Red);
break;
case DataRowState.Modified:
newForeBrush = new SolidBrush(Color.Green);
break;
default:
break;
}

if (newForeBrush != null)
{
base.Paint(g, bounds, source, rowNum, backBrush, newForeBrush,
alignToRight);
newForeBrush.Dispose();
}
else
{
base.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight);
}
}
}

Regards,
Phil.

Hello,

I use DataGrid that displays data from DataTable. When I delete a row, this
row disapears in DataGrid and changes it's status in DataTable.

I there any way how to display everything what's in DataTable?
I want that user will see all changes made and after clicking some "Commit"
button those changes will be saved into the database.

Thanks a lot
Vladimir