Calculate percentage based on other column value using C# and VB.Net in ASP.Net

Question

HiI have three columnsOp1   Op2  Op34        2     26        2      3I want to divide the vaues of Op1Op2 and display the result in Op3 Any advice pleaseAnd also if possible how do i do thisOp1   Op2  Op3  2        4      502        8     25

AnandM · Accepted Answer

Hi  Vikash21Its Possible you need to just bind the updated data once the data is insertedFor egIf you enter the new values for Op1 and Op2 then you have written code on Save Click Button then you need to bind the gridview where it will display the latest updated gridview data which gets binded from Database

AnandM · Answer

Hi  Vikash21I have created a sample which full fill your requirement you need to modify the code according to your needSQLCREATE TABLE DataID INT IDENTITY11 Op1 FLOATOp2 FLOATINSERT INTO Data VALUES42INSERT INTO Data VALUES62HTMLltdivgt    ltaspGridView ID34gvData34 AutoGenerateColumns34false34 AutoGenerateEditButton34true34        OnRowEditing34Edit34 OnRowCancelingEdit34Cancel34 OnRowUpdating34Update34 runat34server34gt        ltColumnsgt            ltaspTemplateField HeaderText34ID34gt                ltItemTemplategt                    ltaspLabel ID34lblID34 Text39lt Eval34ID34 gt39 runat34server34 gt                ltItemTemplategt            ltaspTemplateFieldgt            ltaspTemplateField HeaderText34Op134gt                ltItemTemplategt                    ltaspLabel ID34lblOp134 Text39ltEval34O

Calculate percentage based on other column value using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us