datagridview two column sum and view each row balance c#

Question

datagridview each row two column data sum and view new column view how can i make this using c#

Vinay Singh · Answer

Hi Just user the below query to add two column value and display it in third column. Use this query in you code to fatch the data SELECT column1 column2 SUM (column1+column2) AS RowNumericColSum FROM CustomerOrders GROUP BY column1 column2 ORDER BY ID For detail have a look of the link http://www.dotnet-tricks.com/Tutorial/sqlserver/b4I8120313-Calculate-Running-Total-Total-of-a-Column-and-Row.html http://www.codeproject.com/Questions/797815/How-to-sum-of-two-rows-values-inside-the-datagridv

Vinay Singh · Answer

Hi You dont need to do any thing it will automaticelly bind. have a look of the link to bind datagridview Bind DataGridView With Sql Server Table Using C#.Net In Windows Application

Gokul · Answer

how to add new column for this value datagridview