Forms Data Controls :: Displaying Totals For Columns In A Grid View?

Jul 13, 2010

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

View 3 Replies


Similar Messages:

Forms Data Controls :: How To Get The Names Of All The Columns In The Grid View

Jun 21, 2010

tried to use gridview.columns.count to see if there are any columns bt it shows zero, second how shall i et the names of columns in the gried view at runtime i need them to be stored in an string array

View 2 Replies

Forms Data Controls :: Add A Column At The End That Adds The Totals Of The Columns 8,9,10,11,12?

Aug 16, 2010

i ve googled this and admitly there is a lot of information out there but it all seems so complex just to add a "totals" column basically, i have a gridview as below

[code]....

Basically i want to add a column at the end that adds the totals of the columns 8,9,10,11,12 etc etc

i know theres a lot of blogs out there but they seem to complicate this more then it should ...

View 2 Replies

Forms Data Controls :: How To Bind Grid View Columns Dynamically

Feb 9, 2010

I am developing an application using ASP.NET with C#.NET.in my application i have a gridview control and radobutton list having the values as Manufacturer and Distributor. based on the radiobutton selected value,the gridview will bindedup.

i am using SQL SERVER 2005 as backend server. in my database i have one table with columns as

1.mfropendate

2.mfrclosedate

3.mfrawarddate

4.distopendate

5.distclosedate

6.distawarddate

My gridview has 3 columns as Opendate,closedate,awarddate.

if user select the radiobutton as manufacturer,only mfropendate,mfrclosedate,mfrawarddate have to bind. and if user select the distributor the remaining 3 fields will have to bind. for that i had write a storedproc as create procedure sp_GetDraftBids as begin select mfropendate as opendate,mfrclosedate as closedate,mfrawarddate as awarddate, distopendate as opendate,distclosedate closedate,distawarddate awarddate from draftbids end GO

i.e i had taken the alias names for that fields so that i will bind the only 3 columns to grid view as opendate,closedate,awarddate.

My gridview code is

[Code]....

here i had taken the same alias names as i have to bind only 3 columns to gridview.when i run my application i am getting the records in data table with column names as opendate,closedate,awarddate,opendate1,closedate1,awarddate1.i.e it does not allow the same alias name.

for two radio button conditions i.e for manufacturer and distributor the gridview binded with opendate,closedate and awarddate columns as i had binded the gridview boundfields withat names.

but when user select the distributor radiobutton i have to bind the opendate1,closedate1 and awarddate1 to the gridview. for that should i can i change the storedproc are any other solution is there?

View 5 Replies

Forms Data Controls :: Resize The Width Of Columns Of Grid View?

Apr 14, 2010

How to resize the width of columns of grid view? I want a column 250px wide.How I can do this?

View 4 Replies

Forms Data Controls :: How To Access To Grid View Columns Properties

Jun 25, 2010

I have search for a long long time and could not find a solution to access to grid view's column properties. I have binded a grid view through this method, the bindGridView function will return a table with columns and rows.

The problem here is I cound not access to columns properties such as Grid_View.Columns.Count or Grid_View.Columns[0]."something". It seems like the grid_view does not have any column. But I can access to the Rows properties.

I have put this code within a (!IsPostBack) and set the AutoGenerateColumns to true?

I need to access to columns badly as I need t add additional column to the binded grid view.

[Code]....

View 6 Replies

Forms Data Controls :: How To Craete Dynamic Columns In Grid View

Jan 28, 2011

I am working on the dynamic grid view(create dynamic columns).I need some thing like that given bellow in the fig:

columns1,2,3 are dynamic and the modules under the columns are also dynamic. to create grid like that.

Column1
Column2
Column3
Module1
Module2
Module3
Module4
Module5
Module6
Module7
Module8

View 2 Replies

Forms Data Controls :: Displaying Days Between Two Dates In Grid View?

Jul 16, 2010

i have ending date comming from sqldatabase and other is current ,now i want to show in a column of gridview days left i.e.(ending date - current date)

View 2 Replies

Forms Data Controls :: Grid View DataFormatString Currency Displaying In $ When It Should Be £

Jun 11, 2010

I'm using:

[Code]....

to format the currency values and on my local machine everything works correctly displaying the currency in £ (pounds).

I moved my code onto the server that it will be run from and it's displaying in $ (dollars).

Our technical team that look after the server (Development aren't allowed access to the admin side of things) say that the server is set up for UK.

Where should they be looking to be able to set the server to display the data correctly?

View 2 Replies

Forms Data Controls :: Change The Displaying Items in A Grid View?

Mar 20, 2010

i want to change , the displaying items in a grid view and on the way the text value of a lable at the same click on a link ... ? it means that i need the connectionstring or somthing in the properties to change with the link click

View 5 Replies

Forms Data Controls :: Dynamically Created Rows And Columns Of Grid View?

Jun 2, 2010

Need row editing on page_load for all the cells and need to validate each cell entry. Means cell1 one entery isvalid it fills thrid cell and insert or update to a table in the database. How do i handle on tab clicking to update in databse.

View 1 Replies

Forms Data Controls :: Comparing Two Columns In A Grid View To Avoid Duplication?

Aug 6, 2010

I have a condition to check weekdays with a particular time corresponding

to that day that were added to a grid view using a drop down list and two text boxes.

The drop down list has weekdays and textboxes has from and to time.

I have to verify a condition to avoid duplication of same day with same time should not occur in the table twice.

(i have used time picker jquery to get time.)

how should i write the condition in sql and use that in C#

View 5 Replies

Forms Data Controls :: Setting Visibility Of TemplateField Columns In Grid View?

Oct 27, 2010

i have a grid view with all columns as TemplateFields( No BoundField). Based on certain condition i have to set Visibility of few columns false. Suppose when there is no column 'CaseList2' in the DataTable, then the second column of the grid (whose column index is 1 )should be invisible. But when the Gridview binds it gives error DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'CaseList2'

i googled it and found that

GridView1.Columns[1].Visible = false;

should work. But its not working actualy.

Code:

[Code]....

Codebehind:

[Code]....

View 3 Replies

Forms Data Controls :: Displaying Data In A Grid View Control When Set A Row To Visible = False

Aug 23, 2010

I have a problem displaying data in a Grid View control when set a row to visible = false when a certain condition is true.

For example, if a DataRowData value has a condition set to true (custom in table) I set the visible property to false, so the data row will not be visible at run time.

The problem is that I'm using paging (10 rows per page) and if 8 of those rows fall into the true condition that won't show the row, that grid view page will only show two rows of data in page 1. The worst scenario is that if I go to page 2 of the grid view and all the rows (10) fall into the true condition, that grid view page will not show any data at all.

How can I show 10 rows of data at all times in a gridview? In other words, I would like to just show the visible rows at all times.

View 4 Replies

Forms Data Controls :: Write A Code For Displaying A Files And Folders Of Server Directory Using Grid View In .net?

Jun 12, 2010

how can we write a code for displaying a files and folders of server directory using Grid View in asp.net?

View 3 Replies

Forms Data Controls :: Trying To Generate A Grid View From Database, In One Of My Database Columns The Values Are 'y' And 'N'?

Jan 8, 2010

I am trying to generate a Grid view from database, in one of my database columns the values are 'y' and 'N'. and i need to show this values in a check box .I tried to keep a check box in item template and tried to bind it, but could get much success.

[Code]....

View 6 Replies

Forms Data Controls :: Have A Grid View With Some Coulmns Like Name,Phone No Etc With Edit,Delete Column In Grid View?

May 27, 2010

i have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view

View 5 Replies

Forms Data Controls :: Custom Grid View Header - Grid View Row Created Event Versus Gridview Row Databound Events

Aug 24, 2010

It happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .

Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically behaviour of both the events in !Postback and page.Postback .

View 2 Replies

Forms Data Controls :: Click Button Outside Grid View And Display The Grid View Upon Load?

Feb 9, 2011

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]....

View 6 Replies

Forms Data Controls :: Extract Value In Grid View And Display It In A Textbox In Grid View ?

Jun 8, 2010

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 Replies

Forms Data Controls :: Create An ASP Grid With Dynamic Columns With An Ability To Freeze Columns And Rows

Sep 20, 2010

I created a gridview that is made up of 4 gridviews and using a stored procedure to populate it. I create columns at runtime because the number of columns changes all the time.To make the grids editable I am adding template fields at runtime as I create the columns, this is to ensure that a user is able to edit the cells and some foot values update. Reason why I have four grids is to freeze rows and columns like in excel using javascript. The problem is that performance is very bad especially in IE, the grids take a long time to load. I am not sure if this is caused by the data load or the creation of text boxes. see some of the code below for my _aspx page:

[Code]....

View 1 Replies

Forms Data Controls :: Force Grid View To Select Next Row On A Button_click Which Is Outside The Grid?

Jun 23, 2010

Have a GridView with a templated select button hidden and using

e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .

When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .

View 3 Replies

Forms Data Controls :: How To Edit Grid View (draged The Grid To The Aspx Page)

Sep 29, 2010

I have a grid view that does add, edit update and delete. ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that.

View 4 Replies

Web Forms :: Displaying Selected Grid View Items In The Treeview?

Jan 18, 2010

I am working with grid view and tree view. My requirement is when the item is selcted in the gridview it should bind it to the particular node of tree view. Can you please help me out. Its very urgent. Can you please send me with the sample code.

View 2 Replies

Forms Data Controls :: Website Run Very Slow Using Tree View And Grid View

Sep 7, 2010

speed Performane i create a web site but it very slow run i use tree view and grid view but i do it run very fast

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved