How to get a total colum from two input column in DataGrid

SADAM HUSSAIN

9y1.8k

hi guys. how to calculate the two input columns values to Total column. plz help me..

private void dgSubject_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)

{

if (e.EditAction == DataGridEditAction.Commit)

{

var column = e.Column as DataGridBoundColumn;

if (column != null)

{

var bindingPath = (column.Binding as Binding).Path.Path;

else if (bindingPath == "Subject1")

{

var el = e.EditingElement as TextBox;

if (el!=null)

{

// How to Calculate the Subject1,Subject2,Subject3 Columns

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted answer
Try this
private void dataGrid1_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
       {

TextBox textBox = e.EditingElement as TextBox;
       if (e.Column.Header.ToString().ToLower().Equals("subject1"))
       {
var subject1=  Convert.ToInt32(textBox); // current editing item is subject1
var subject2= Convert.ToInt32(item["Subject2"]);
var subject3=  Convert.ToInt32(item["Subject3"]);
item["Total"] = subject1 + subject2 + subject3;
}
}
// same else if condition will be applicable for subject2 and subject3
Do let me know if it helps
SADAM HUSSAIN9y ago
How to use in datagrid event & how to calculate all row in a datagird :)
Amit Gupta9y ago
Hey Sadam,
There are many ways to achieve this. One of the simplest method is to add expression in column that perform auto calculation based on your expression.

Have a look to below snippet
var dt = new DataTable ();
dt.Columns.Add ("subject1");
dt.Columns.Add ("subject2");
dt.Columns.Add ("subject3");
dt.Columns.Add ("Total").Expression = "subject1 + subject2 + subject3");

Gridview.ItemsSource = dt.DefaultView;

Thats all you have to do.

Do let me know if it solves your problem