I would like to display totals row for my jQuery Grid without grouping and I'm using summaryType: 'sum' for each column.let me know what else does it require to be done??
View 6 Replies I have developed my application using ASP.NET with Visual Basic. I have a table that contains 3 fields. The name of the table is "Customer" and the names of the fields are "Name", "Address", and "Amount". I have a gridview that displays these three columns. I want to summarize the value in the "Amount" column for each record and display the summarize value in the footer of the "Amount" column.
I added some code to the "ItemTemplate" and "FooterTemplate" of the template for the "Amount" field and wrote two functions One function adds the value of the "Amount" field to a variable called "TotalAmount" and the second function 'gets' the value stored in the "TotalAmount" variable.
I am not getting any error messages and all of the items are displayed in the gridview but I am not displaying anything at the bottom of the "Amount" column. What more do I need to do?
This is my code for the "Amount" template:
<asp:TemplateField
HeaderText="Amount"
SortExpression="Amount">
<EditItemTemplate>
<asp:TextBox
ID="TextBox1"
runat="server"
Text='<%# Bind("Amount") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label
ID="Label1"
runat="server"
Text='<%# Bind("Amount", "{0:c}") %>'>
<%#SumAmount(Eval("Amount")) %></asp:Label>
</ItemTemplate>
<FooterTemplate>
<%#GetTotalAmount() %></FooterTemplate>
<FooterStyle
BorderColor="Black"
BorderStyle="Solid"
/>
</asp:TemplateField>
This is the code in my .vp file
Dim TotalAmount as decimal 0.0
Function SumAmount(ByVal Amount
As
Decimal)
As
Decimal
TotalAmount = TotalAmount + TotalAmount
End
Function
Function GetTotalAmount()
As
Decimal
Return TotalAmount
End
Function
i am using sql server reporting service, in My report i have a Salaray column in which i have to show the page wise totals in every page and grand total in last page..
example : first page salary total - 10000
second page salary total - first page total(10000) + second page total and so on I did use the =sum(ReportItem("Salary").value) but it does not consider the previous page value..
I have a requirement to build a grid with column header grouping. Each column header of the grid can have nested column. On expanding the column header subsequent columns will be displayed.Is it possible with asp.net grids
View 2 RepliesI am working on ASP MVC 2 application. I have used the following jquery plugin & css
<link href="../../Content/ui.jqgrid.css" rel="stylesheet" type="text/css" />
I am having problems with displaying the totals in the footer of a gridview. I am writing a page whereby users can enter comments and marks for an online photo competition.
The page has a details view to enter the comment and mark. Its has a details view where the photo is displayed. It has a gridview where the comments and marks that have been entered are displayed.
It works well - the details view allows comment and mark entry and the gridview show the comments and marks as they are entered. The problems are twofold. Firstly the total shows double the marks that should be displayed. Secondly, when you leave the page and then return later, you have to refresh the page before it will show the latest comment and mark even though it shows this immediately after entering the data.
Ive provided my code below:
[code]....
i want to make a twitter like registration form using jquery and save data in database and display it in a grid after submitting data.this is what i got on net
<script src="Script/jquery-1.4.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$("#.addbutton").click(function () {
[Code]....
am using asp.net mvc.. i have db2 database with one table..... i have a stroed procedure with input parmater as useridi need to pass userid to get all the results from table to display in jquery grid on UIplease
View 4 Repliesi wants to have grouping with my grid view. in which there is category and subcategory according to that category.
i wants to display sub category subtotal at the end of each sub category group and category total at the of category group.
I am using master page and content page approach. i could mange to show image from folder in listview whose Url are saved in my Database.the code i use:
[Code]....
I trying to use the appraoch which is shown in the link.http://codeasp.net/blogs/raghav_khunger/microsoft-net/1289/use-lightbox-to-show-images-whose-paths-are-stored-in-databasebut i failed to do.Can anybody guide me how to impelment lightbox in above example with my listview code i am using.
Is there a plugin that can group data and present it in a tiled format? I'd like to implement JQuery in place of the .NET Listviews that I am currently using. My current Listviews dynamically group three fields per div, with each div presented in two columns by three rows with paging.
I've looked at many plugins through numerous Google searches, and have yet to find one.
I want to develop some crosstab also know as pivot reports in Asp.net with x-axis and y-axis being dynamics, allowing grouping by row and column, for example: have products in y-axis and date in x-axis having in body number of sells of a given product in a given date, if date in x-axis are years, i want subtotals for each month for a product (row) and subtotals of sells of all products in date (column)
I know there are products available to build reports, but i am using Mysql, so Reporting Service is not an option. It's not necessary for the client build additional reports, i think the simplest solution is having a control to display such information and not using crystal report (which is not free) or something more complex, i want to know if is there an available free control to reach my goal.
I am using tablix and use row and column grouping ,on column grouping column text is getting displayed in top to bottom formet but i want to display in bottom to top formet .
View 1 RepliesI have a grid view that needs to be shown group wise. The grouping of the data should be dynamic and that is based on the column that is selected.
In general it should list all the rows and based on the coloumn header selected, all the rows should group by that column and should be listed under it. That also needs the template column for the check box and while group by there should be a check all option available for each group.
Even having the collapse and expand option for each groups is required.
I currently use VS 2005 and later will use 2008 and 2010, but will use the aspx code and not xaml.
i want to show Total in sum Fields in DataGrid Footer and Also show group wise Data in DataGrid.
Here is my Code.
Imports System.Data
Imports System.IO
Imports System.Data.SqlClient
Public cn As SqlConnection
[Code]....
I am doing a online web application whereby user is able to enter in new template as well as search for template. The Add template is located outside the grid view and if user clicks on the button, it will load the grid view that is populated with data as there is a row of empty fields at the bottom. However when I click on the Add Template button, the grid view does not appear.
This is my business logic that I used it to search for records as well to click on the Add Template button to add in new records:
[Code]....
[Code]....
[Code]....
i have a grid view which displays only one value and i need to extract that value and display it in a textbox?
View 4 RepliesI have a grid view which displays some values. now i have to calculate row wise sum of those values for each row and then display against them.i tried this code but i am getting error as Input String Was not in Correct Format.
public void gv_RowCreated(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int total = Convert.ToInt32(e.Row.Cells[1].Text) + Convert.ToInt32(e.Row.Cells[2].Text) + Convert.ToInt32(e.Row.Cells[3].Text) + Convert.ToInt32(e.Row.Cells[4].Text) + Convert.ToInt32(e.Row.Cells[5].Text) + Convert.ToInt32(e.Row.Cells[6].Text) + Convert.ToInt32(e.Row.Cells[7].Text);
((Label)gv.FindControl("Label8")).Text = Convert.ToString(total);
}
}
I want to know what is the best jquery ASP MVC grid plugin out there in market?
View 3 RepliesI have created 3 tabs in first and second tab DIV I have Asp.net FormView, on Second tabs I have Asp.net GridView. On GridView we have edit link on each row of grid. Now issue is that when i click on edit link of grid Template of grid will change to edit template but tab automatically goes to first tab. I need it should remain on second tab where grid is there I try to use select on clientclick My code as followsThis is under document ready
[Code]....
This is under another script
[Code]....
This is grid in aspx page Where you can see on line 18,19,22 and 23 I am calling onclientclick select()
[Code]....
I have four dropdowns on a page. Lets say for example all four are set to "3".When I click calculate my totals are returning as "3333" instead of "12".
Code:
Dim totals As Integer
totals = ddl1.SelectedValue + ddl2.SelectedValue + ddl3.SelectedValue + ddl4.SelectedValue
lbltotals.text = totals.tostring
I have tried to implement the jquery grid from this following site. [URL]
I have faced two problems which are as follows:
1. I m not getting values in my controller (DynamicGridData(e.g. sidx,sord,page,rows)) which returns JsonData to the page to display in the grid?
2. I have tried to convert some C# code to VB but getting the following error
S0133: Implement QueryMethod 'ToArray'
Original C# code is as follows:
[Code]....
i converted above code as following in to vb.net , but iam getting an error :S0133: Implement QueryMethod 'ToArray'
[Code]....
I'm using a local RDLC report in VS2008 / .NET 3.5 which includes a Matrix. It works fine and shows its corresponding Rows, Columns, and Data values as specified.
How can I add row totals / column totals in order to show sum of Data values both horizontally and vertically?
through all the frustration I have settled most of my MVC frustrations and got my jQuery Grid to display data based on user input (parameters), and of course, life just wouldn't be fun without more problems to solve.How do you handle jQuery Grid editing (not the edit in place) in an MVC application. I know you use the editUrl property of the grid to access the Controller in the MVC application, but it doens't seem to take any parameters. Can anyone provide a sample of using jQuery Grid in an MVC application. PLEASE DO NOT GIVE ME LINKS TO ALL THE EXAMPLES OUT THERE....unless you find one specifically that does editing, deleting, and adding, because I have spent the past month looking on the web and in the jQuery documentation
View 9 Replies[code]....
i need to display the Grid1 here?