Forms Data Controls :: Combine Two Boundfields Into One Calculated Column To Display In Gridview?
Nov 10, 2010i am trying to combine two boundfields into one calculated column to display in Gridview like:
[code]....
i am trying to combine two boundfields into one calculated column to display in Gridview like:
[code]....
Is there a way to Sort a Gridview by a Calculated Column? I have a gridview with template fields using lablels and a linq datasource. Those columns sort just fine. I can not get the Calculated column to sort, because there is no sort expression to use...
View 4 Replieshow to create calculated column using boundfield in gridview?
i want to create a new column using the existing records?
how to create calculated column with gridview boundfield?
View 2 RepliesI have 2 amount columns (Amount and TotAmount) in my gridview. In Amount column data comes from database. I want to display the total of amounts in Amount column in my TotAmount column (So there would be just one value in TotAmount column irrespective of the number of columns in Amount column). How can I do this.
View 18 RepliesI have a couple of things that are not working with my Gridview:
1) I've managed to display 3 columns in one column (see code above) but the data is separated by commas, how can I display each data item in separate rows.
2) How can I make the data unique, as I have added the distinct command which I configured in my SQL data source
3) I need the rows to not display nulls, but at the moment it isn't displaying the row if one of the columns is null?
[Code]....
Split off from http://forums.asp.net/t/1595139.aspx:
I have an additional column called 'KPI %' in my gridview that calculates the percentage of two template fields and thus I cannot use the sortexpression on it. How can I sort the contents of the 'KPI %' column in ASC or DESC format?
One of the gridviews looks like this:
Q1 SQ1 A1
Q1 SQ1 A2
Q1 SQ1 A3
Q1 SQ2 A1
Q1 SQ2 A2
Q1 SQ2 A3
[Code]....
All fields are BoundFields (except radiobuttons). They can't be converted to templates, I am using boundfields for row-level displaying in RowDataBound.Each row has a radiobutton and only one radio button should be selected per subquestion (SQ).How I can ensure only one answer is selected per subquestion? On radiobutton click or on submit?
have an ASP.net 4.0 page containing a GridView, where during the Page_Init event I'm dynamically adding BoundField columns to the gridview. I also have some custom sorting and paging methods that I use with this gridview, which result in postbacks on the page. In Chrome, Firefox, Safari, and Opera the gridview behaves as expected. HOWEVER, in IE 6, 7, or 8 when I click to sort a column in the gridview, or go to the next page of results in the gridview, it does not bind on postback, returning nothing back to the browser. Again, in anything but Internet Explorer, paging and sorting (frankly any postback event) brings back the gridview in its expected state. I only have the problem in IE. Relevant snippets of my code follow, where you'll see my Page_Init event calling a method in my WebFunctions class to add the BoundField columns for the table I pass to it, and my Page_Load event that calls the method in the user control responsible for binding my dataset to the gridview. Initial page load works in all browsers, but postback loading of the gridview only works in non-IE browsers.
[Code]....
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
View 4 Replieswant to display gridview column heading when mouse over to the particular column in the gridview.
View 9 RepliesI have a gridview with 3 columns. In second column I want to display some text in 2 rows and then a gridview.
Here is my code:
[Code]....
The problem is my third row is displayed as a row under first column. How do I make it a separate column in my girdview. Not sure what is going wrong.
I am writing a currency converting module for one of our applications. I have a list of products, a list of currencies we are interested in seeing prices for, and a list of currency rates. I want the user to be able to select which currencies from the list they see in the GridView. I also want to be able to amend my list of currencies and include a new currency, without having to make additional changes to this module. So my GridView display has to be "dynamic". Essentially I am planning on ending up with a GridView that has the following columns:
Part No - Description - USD Price - AUD Price - GBP Price
The USD price would be static as it's our base currency, the AUD and GBP are user selected and could have potentially any number of currencies listed. I would normally use a DataSet and DataTables for this work, but I am sure there is a "better" way to do it using System.Collections.Generics. Right now I have all of the data I need in List collections, but there does not seem to be a way to define how these collections relate to each other, or combine these collections into one so it can be bound to a GridView. Should I be looking at something other than List to achieve this or do I need to go back to my original approach of a DataSet and DataTables.
**UPDATE / SOME CODE**
I will explain a little bit more about what I have setup so far.
1) List of Products & Currencies - These come from an SQL DB via LINQ, so they can be any of the System.Collections.Generics objects, e.g. List, IEnumerable etc.
2) Currency Rates - These I am pulling from the European Bank public XML file. I download the file, strip the data I need out of it and currently store that as a List object.
I could store the currency rates in the database table as well, but then I have to have some sort of background process that goes and updates the rates each day. This way the rates only get updated when someone accesses the report function (which is only going to happen occasionally). So I would rather grab the latest rates "on demand". What I know I need to end up with is some object that has the following structure:
PartNo - Description - Base Price - Currency Price 1, Currency Price 2, Currency Price 3
Where the number of Currency Prices is undefined, as it's based on what currencies the user wants the report to display. It's the undefined part that I am struggling with, essentially how can I create a structured object, that I don't know the complete structure of until runtime?
My gridview displays fields from a table and allows for edit, delete and insert. I need to add a column with a derived field which will be calculated every time the user is either entering a new row or editing the value of the weight field which is one of the fields of the gridview. This calculation is done in the fly and won't be saved in the database.
View 8 RepliesI have a table with the following structure:
Attribute
-------------
AttributeId
WeekNo
DayNo
Attribute1
Attribute2
Attribute3
Attribute4
Attribute5
........ likewise.
I want to display these data in a gridview in the following manner
Sunday Monday Tuesday ............ (till Saturday) - should be gridview columns, I can retrieve this using dayno
Attribute 1
Attribute 2
Attribute 3
Attribute 4
like wise attributes should be taken in to rows.Is this possible in a gridview, if so how can I do that?
These are the part of the javascript:
var gridViewCtl2 = null;
var selRow = null;
var gridViewCtlName2 = 'GridView2';
gridViewCtl2 = document.getElementById(gridViewCtlName2);
selRow = gridViewCtl2.rows[2];
Now I want to diaply a particular column (eg. 5th column) into a HTML text box or asp control (Label).
eg.
Text1.value = selRow.......
How can I do that?
how to retrieve the column number in gridview
i am able to get the row number using this syntax <%# Container.DataItemIndex + 1 %>
but what about column number?
My requirement is i have to display column wise records in GridView control.
I am thinking to create a user control for this.
See the attachment of sample screen.
Sandeep
My requirement is i have to display column wise records in GridView control.
I am thinking to create a user control for this.
See the attachment of sample screen.
Sandeep
I am having trouble with displaying double data in gridview bound coulumn. I want it to display as it is... But it gets rounded off when displayed.
Like my 1.34 displays 1.00
1.57 - 2.00
and so on. But i want it to display as it is i mean with decimal points, without rounding it off.
i have a gridview of a list of VehicleRequisition's with a column whose itemtemplate is as follows.
[Code]....
[Code]....
I like to use GridView because it is easy and flexible to work with. However, I found it quite frustration when it comes to display a column with a large chuck of words into the value of that particular column. Is there anyway to restrict how many words should only be display in a particular column rather than let it expands to cope up to display all the word. For example, I'm trying to display 20w and normally it would display
wwwwwwwwwwwwwwwwwww
but I would like to limit to 5 words in a line so it's going to be
wwwww
wwwww
wwwww
wwwww
How to populate a gridview column, from sqlserver2005 database table.I've tried this:
Response.BinaryWrite((
byte[])dr["_reportattcmt"]);
But this would display data on to page. but how to do it on to gridview coloumn
I have gridview where there is column charges. If charges value is $0.00, I need to display it as BLANK or NULL that is it should be empty. I tried few DataFormatStrings but no luck.
View 3 RepliesIf I have two two columns: Date1 and date2,I would like to display in GridView1 than one column.
Example:
Date1 = 10/06/2010
Date2 = 07.10.2010
GridView1 (date1 + date2) = 06.10.2010 - 07.10.2010
i would like to know some of these:
how to combine two table from database into one gridview?
is it possible to add in a textbox into gridview?
why my checkbox is not showing in the gridview. this is the UI and the code. the UI display the data i retrieved from the database but why is the image and the checkbox not showing?
[Code]....