How to add Column and Row for total in datagrid

To achieve the desired outcome of adding an extra column for total and a row in the footer for calculations in your datagrid, you can follow these steps:

1. Modify Your SQL Query: You need to modify your SQL query to calculate the total price for each item. You can achieve this by multiplying the ItemPrice with Quantity within your SQL query. Here's an example of how you can modify your SQL query:

SqlCommand cmd = new SqlCommand("SELECT ID, Item, ItemPrice, Quantity, (ItemPrice * Quantity) AS TotalPrice FROM tblItem", conn.con);

2. Update DataGrid Column Configuration: After updating your SQL query, you need to configure your datagrid to display the new TotalPrice column. You can do this either programmatically or through the designer. Ensure that you add a column for TotalPrice in your DataGrid configuration.

3. Calculate Total in Code Behind: To calculate the total sum of all item prices in the datagrid, you can iterate through the rows of the DataTable after it is populated and sum up the TotalPrice for each row. Here's an example of how you can calculate the total:

decimal totalSum = 0;

foreach (DataRow row in table.Rows)
{
    totalSum += Convert.ToDecimal(row["TotalPrice"]);
}

// Assign the total sum to a label or another UI element to display in the footer row

4. Display Total in Footer Row: Finally, you can add a footer row to your datagrid where you display the total sum calculated in the previous step. You can add this row by either programmatically injecting it into the datagrid or by using the designer with a predefined footer template.

By following these steps, you can successfully populate and calculate your data in the datagrid with an additional Total column and a footer row displaying the total sum. If you encounter any specific challenges or need further assistance with a particular step, feel free to ask for more guidance.