my code is calculate to current rowafter update quantity but other rows don't affect and not calculate i need to calculate all rows i think i need to use for loops but i dont know how to do it
I have following codebehind in ASPx - VB.Net in my aspx project, i want sum a template column (txtAmount) to show another TXSum template (without any postback) any one give me a better soluation in javascript.
I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.
In my webpage i am trying to create a order by gridview here item selected by user from dropdown and on selction of dropdown price display in next to item dropdown label price.now user insert quantity from next grid textbox and next is label amount shold disply calculate amount on price and quantity.i also want to use javascript for this prob.what i did that item and price displaying and user make input from textbox now want to calculation but how textbox recieve input and amount label dispaly calculate amount.
My database is SQL and i am using a stored procedure as under. The output is almost correct and i want to rectfy a small error in it
ALTER PROCEDURE [dbo].[Report]( @year int, @month int ) AS
BEGIN
SET NOCOUNT ON
declare @d smalldatetime declare @total int
[CODE]...
in the above procedure i didnt use the str_dt which is the person joined in that comapnt initially. The mistake i had noticed is that if a person joines in 3 jan 2014 and the date and year selected in dropdownlist is Dec 2013. The person who had joined in 3 Jan 2014 is also gets displayed in it. but it should not be.
GridViewDetails uses templatefields. In edittemplate I put a button called "ButtonUpdateAdjustAmount" with OnClick="Update_AdjustAmount" in the EditItemTemplate for the "Amt to be Adj" column. There is also a textbox. My user's should be able to edit the textbox, but I also want the ability to click the button and the textbox populated with the correct calculated value. The formula varies based on the "code" column which is a dropdownlist called "DropListCode".
I am fairly new to asp.net, vb, etc...so forgive my code writing. Eventually I need to also put the same functionality on the insertrow for my gridview. But first wanted to get the edit one working. I am using templatefields for all columns and the FooterTemplate to perform the Insert New Detail Line.
I can get the functionality to work for the first data row and only if I take out the If code.SelectedValue = ... line and leave 1 static formula. However that isn't going to work. If DropListCode.SelectedValue is DNR then AdjAmt should be ((q_ordered - q_received) * cost). If DropListCode. SelectedValue is OV then AdjAmt should be (RKNumber * cost). If DropListCode.SelectedValue is NB the AdjAmt should be ((q_received - q_ordered) * cost). If DropListCode.SelectedValue is DAM then AdjAmt should be (RKNumber * cost)
I have 5 gridviews, all of of them have a Checkbox template field. I already did SUM of a specific column in the gridviews and displayed the Total in the gridview footers.
There is a submit button on the page as well.(this is not in a template column in the gridview)
what i do is select some rows in the gridviews by ticking the checkbox. Then I click on the submit button and the values change in the database and page refreshes with the new Total in the gridview footers. Any row that was ticked. the checkbox for that row in the gridview gets disabled. so cannot change the value again.
Now i want a way to show a popup with a SUM of those rows that are ticked recently and the SUM of already ticked and disabled rows before the values change for the ticked rows in the gridview when the submit button is clicked.
I just want to calculate the Grand Total of the quantity. So basically i want to sum up all the quantity for each row and show the total at the bottom of the page. I don't want to use the total and the price column in this example. How can i modify this code and just sum up only the total quantity without referencing the price and the total? here is the javascript
<script type="text/javascript"> $(function () { $("[id*=txtQuantity]").val("0"); }); $("[id*=txtQuantity]").live("change", function () { if (isNaN(parseInt($(this).val()))) { $(this).val('0'); } else {
I have a requirement like need to get the numbers from diffrent tables and calculate the growth rate using the formula like ((number2-number1)/number1)*100 and bind it to gridview. Right now I am getting the numbers from each table, calculating growth rate @code behind and save the result into temp table and next getting the result from temp table and bind it to gridview. this is very lengthy process and low performanance.
How to do growth rate on the fly and bind it to gridview. Finally the gridview data should be growth rate desc order.
In the following link the writer clearly explains. how to use it.
[URL]
but I also want to calculate the the total salary of column (Salary) nd the total count should be shpown in footer which will be below of salary last column. How to acheive it.
Binding the Remarks label as footer in my second gridview.
Here's the image
I set the DataKeyName of the Parent gridview to EmpNo and LeaveTraId, I wanted to pull those datakeys up to include in my query getting the value Remarks field from database.
I used OnRowDataBound event of parent grid to populate the second grid.
I have a table where each month I need to find the SkipUtgang value of current month (ex: 779) and the value of SkipUtgang in previous month (ex: 788); then Sum the two values; and finally multiply the result with the number of day of current month (ex: 31). as example, I have the below table:
