I have a simple Devexpress Gridview.
Here code;
[code]...
Is there any way calculate sub total of Unit Price column in Devexpress?
For this example; I just want total of Unit Price column (18 + 19 + 4.5 + 14 + 18 + 263.5 + 18 + 46 + 14 + 14 + 15 = 430) in the bottom..
How can i do that?
i am having a problem in counting subtotal in a gridview in asp.net
the gridview contains details like
[code].....
i need to calculate the sum of the user entry for each item and display into the resultant lable.
when ever the user entry is made the value in the result lable should be updated,i am binding a javascript function to the userentry textbox in rowdatabound event in code behind.in the javascript i am able to roll over all the rows of table using jquery, and calculate the value. here is the catch, the labletodispresult should be for that item group only, i.e. i need to get the sum of userentry for A -1,A-2, A-3 rows and seperately for B-1,B-2,B-3 rows, the i am using a class for the userentry textbox, and using this
[code]...
this gives me all the textboxes sum value, but i need the values based on the Item group.
On behalf of this article : [URL] .....
Lets assume i have four columns
Sr Company Date Billing amount
1 Imtiaz Super Market 11/12/1991 2000
2 Naheed mart 11/12/1991 4000
3 Imtiaz Super Market 11/12/1991 3000
Now it must group by the company name and show running total and net total like :
Sr Company Date Billing amount
1 Imtiaz Super Market 11/12/1991 2000
2 Imtiaz Super Market 11/12/1991 3000 5000
3 Naheed mart 11/12/1991 4000
4 Naheed mart 11/12/1991 5000 9000 14000
NOTE : it must support paging and must be binded with data table
I have a devexpress gridview one of the column contains url. I need on url clik highlight this row and if user click another url in another row highlight and unselect previous.
View 1 Repliesmy 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
[code]....
[Code]....
I'm using reporting services in visual studio 2005.
I'm using a matrix and it looks like this.
[code]....
How can I achieve something like this. Is a gridview the best option or is there a better control.
I need the 1st column editable so users can type in values. Then the sub total and total must be automatically calculated.
gridviewhelper cannot subtotal 2 column
Name HD CPU
A 1 2
A 3 3
4 5
I have trawled through the entire web and found that most examples show how to add a total to the footer.
However, I am not after this and I want to add a total for the column 'Office sqm' for each group of addresses ONLY when the value of the 'Summed' is equal to Yes.
[code]....
I have a gridview with columns as Item,price,quantity. I want to calculate for each row which should be like:
total=price*quantity and finally calculate the total for all the items..
I'm trying to include jQuery in an ASP.NET web site that also uses DexExpress controls, but no matter how I include my script, the $ function is always anonymous and the jQuery function is undefined. I suspect the DevExpress 'plumbing' script is overriding jQuery.
View 2 RepliesWithout paging function, i can loop through the gridview by using
var sum = 0;
var gridViewCtlId = '<%=timesheetView.ClientID%>';
var grid = document.getElementById(gridViewCtlId);
var gridLength = grid.rows.length;
so with gridLength i can loop through the gridview to sum all rows. However, when I use paging event of gridview, i use the page size to loop through all rows, but it occurs errors because the last page may not have enough rows.
well i want to calculate data from a gridview field, you can see below the structure of my main page:
[Code]....
My Table1 contain these lines:
[code]....
I have a simple gridview control on .aspx page. It has one combo box in the gridview control and rest of the columns in the gridview control are all bound controls.
When the user picks something from combo box, I should multiply the number (picked from the combo box) with other number in the same row (meaning in a different column on the same row). I want to do all this in server controls not thru JQuery or Javascript.
Basically my problem is I am able to read data from unbound combo box control in the grid. But I should be able to read the contents of another bound column in the same row and perform multiplication between those two fields.
Code:
<asp:GridView ID="GridViewActuals" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="gl_number"
onrowcommand="GridViewActuals_RowCommand" Height="285px"
onrowdatabound="GridViewActuals_RowDataBound"
onrowupdated="GridViewActuals_RowUpdated"
Font-Names="Verdana" onrowupdating="GridViewActuals_RowUpdating1">
[Code] ....
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.
How to do sum 2 differences fields as a new column in Subtotal ? I know to do in Microsoft Access and that is easier.
View 2 RepliesHow to use Grid with check box in devExpress . i have grid with data i want to get the valuse if the check box is checked
View 2 RepliesWill there be any problems if I use DevExpress controls and Telerik controls on the same web page. Imagine I am nesting them insider one another.
I am wondering if they would conflict each other during AJAX calls.
Ive got problem with intellisense in markup for example:
When I type
<dxwgv:ASPxGridView ID="grid" runat="server">
<Columns>
< -- here I hit ctrl + space and only normla html tags are shown: a, abbr ... --
But I would like to have available columns instead :/
</Columns>
</ dxwgv:ASPxGridView>
first, this is my table... (i will list down *important data only)
[code]....
With all this i will come out with a table/Gridview?
Display Value: UserID, FullName....., HrsNeeded
see the table below in which I calculated Grand Total of column in the Footer, but how to calculate GrandTotal at the end of each Row.
[code]....
Here I have shown intime and outime in gridview. How to find time difference in gridview itself?
View 1 RepliesI 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 {
[Code] ..
i need to insert row in asp.net gridView, the output should be as shown below :
SR.NO
ACCOUNT NAME
DATE
NARRATION
DEBIT AMOUNT
CREDIT AMOUNT
BALANCE
[code]...
here the total is the row that i want to add, hw can i do this.
How to calculate input values by each row in gridview ?
Example input quantity is 10, then generate the serial number for each row quantity is 1
Actual expect result