C# - Combine Data From Multiple Sources - Display In ASP GridView
Feb 5, 2010
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?
View 1 Replies
Similar Messages:
Mar 9, 2011
I have a repeater like so:
[Code]....
Problem is, I also want to show the viewer the available number of spots in the room. But this requires somehow pull in either the current_occupancy / max_occupancy or in performing a calculation (e.g. max_occupancy - current_occupancy = actual_available) and then returning that with the room.
The end result I'm looking for is to return each room in a button control with text that looks like this:
"Room 1 - 2 Open" "Room 8 - 1 Open" and so on
View 2 Replies
Jul 16, 2010
I need to display some data in a gridview. Its shipping data.
Part of the data can come from a generic database query. Static shipping data that can be looked up from the database. Part of the data is external and has to be queryed from USPS. Any suggestions on what is the best way to accomplish this.
Should I just programmatically fill the gridview from the code behind doing the database lookup manual and filling the gridview with manual data then going out and filling the rest of the gridview with the data obtained from the USPS service?
View 2 Replies
Jan 1, 2010
Here is the situation. I need to hit ~50 servers and grab some data from a file. I then want to display a few rows for each in an ASP.NET GridView control.
I tried doing this with Threads/ThreadPool and successfully gather all the data in session.
What I'd like to do, and what I am having a hard time figuring out, is update the grid for the user after each server is done loading.
If I put the databinding code in the thread, it will only display whatever has loaded by the time the response is sent back to the client. If I take it out of the thread, I'd have to wait until all threads were done to send the response, and that doesn't do what I want.
I seeing some stuff about Asynchronous Client Callbacks, but I'm not sure if that's what I need to be using. I have no idea how to manipulate a GridView from Javascript.
View 4 Replies
Nov 10, 2010
i am trying to combine two boundfields into one calculated column to display in Gridview like:
[code]....
View 8 Replies
Aug 26, 2010
I've created a set of CrystalReports (*.rpt files) for an ASP.NET web app on a development server. I call each report using the following code:
[Code]....
When I transfer the *.rpt files to a different server, the reports display data from the development server; even when I change "Constants.DatabaseName" to point to the new server. It seems like the *.rpt file saves the database connection information from the ODBC File DNS used when creating the report.Has anyone experienced this problem? I'm looking for a solution so I don't have to create multiple copies of my *.rpt files for each server environment (i.e., Dev, Test and Production servers).
View 2 Replies
Feb 1, 2011
So I have been trying to follow serenarules posts about persistence layers, but I seem to be missing something.
The persistence layer is an architectural layer whose job is to provide an abstract interface to information storage mechanism(s).
This makes sense to me, but I am still having a hard time with this.
So in what cases is this necessary? When you are pulling similar data from multiple information sources?
View 7 Replies
Feb 23, 2011
I have one view page (MyView.aspx) and many data sources to bind on this page. Lets say it has Books, Publishers, Comments, etc. Each one of those has an object which provides a List, List, etc. In my view, what are my optiosn for multilple model biding? I want to check to see if each one is empty, and then enumerate it. But I can't check Model.Count() because wouldn't Model be made of all those objects if I set the page to inheriet from? What are my options? Should I load each content area in a control/partial view? Or can I just dump each object into ViewData and then check the count by casting in the view?
View 2 Replies
Jan 17, 2011
I want to have one datagrid use two different data sources, the two datasaet I use have all the same cloumn names, the only difference is that the come form different databases. I wan tto have the data source be chosen by a dropdown list box. Is this possible or do I have to use two datagrid and just make on invisiable as needed.
View 1 Replies
Aug 18, 2015
I have a question in gridview, I want to combine my two or more records into a single cell with two rowsfor Example i have a ID, Name, Year Start, and Year End for Column name in database and i want call it into my gridview that the Year Start and Year End will combine to Year like:
In Database
ID Name Year Start Year End
1 Yourname 2010 2015
In Gridview:
ID Name Year
1 Yourname 2010 2015
in a year column i want it to two row..
View 1 Replies
Jul 22, 2013
I created 3 product table . A,B and c.
I show product of table in different gridview.
Now I am using one search box. but how to search product name with image in one query all of three table....
Simple how to search product from multiple table and show result...
View 1 Replies
Aug 18, 2015
I want to bind three column with one row in gridview in asp.net with c#,
i want like this,
Name | Info
----------------------
name | lastname
| phone number
| address
I get this by default
name | last name | phone number | address
View 1 Replies
Dec 5, 2010
I'm fairly new to all this, but have slowly been teaching myself C# and ASP.net MVC over the past year or so...I really tried to search for this, but haven't been able to find anything - it may be I'm using the wrong terminology!I'm using ASP.NET MVC2 with EF4 connected to a SQL Express db. Situation: Without getting into too much specifics, I have one table called 'Plan.' Under 'Plan' are several different categories that are related to a single Plan item [say Category A, Category B, Category C and Category D]. Each 'Category X' table has a beginDate, endDate and other details specific to that category.
I'd like to be able to create a summary page that combines all items from Category A, Category B, Category C, and Category D and sorts by beginDate - but only need a few of the columns [eg - begin/end date, name, id].
View 1 Replies
Jun 1, 2010
We use the caching and logging application blocks from entlib 4.1. We want to keep the configuration of those two in seperate files. How can we achieve this?It looks like entlib is always using the selected Source as it configuration.I tried the following:
[code...]
But this doesn't work because the application blocks always use the selected Source attribute value.
View 1 Replies
Sep 20, 2010
I have a gridview which sources information dynamically from database.
Here when i go for the default "AllowSorting" flag equal to true, i am able to achieve sorting of all displayed columns except the textBox control column whose values refreshes to zero.
View 2 Replies
Jul 18, 2010
I want to display my data from sql in a grid view. Here the problem is how do I display more than one row under one column.For example, I have A, B columns in sql and then when displaying in Grid, I want to display as in B it contain apple,ball under column "B" with a comma seprator.
A B
1 apple
2 apple
2 ball
View 5 Replies
Jul 9, 2010
I have a store procedure that loops through items and returns multiple 1 row returns.The gridview will only show the first return, and no more because each return from the SP is labeled as row 1. Is there a way to change my SP or have gridview assign a new row number to the returns?My SP:
[Code]....
and my return:
[Code]....
View 6 Replies
May 7, 2015
Gridview code :
<div class="table-responsive">
<asp:UpdatePanel ID="ExistingBuilderGrid_UpdatePanel" runat="server">
<ContentTemplate>
<asp:GridView ID="ExistingBuilderGrid" CssClass="table" EnableViewState="False" AutoGenerateColumns="False"
[Code]....
I want to merger both Fields and both Values column HEADER to one Header cell like Business Assigned Resource ...
NOTE:
dont merge the data cells , only merge header cells
View 1 Replies
Aug 18, 2015
I am working on Online shopping website where end user can select multiple items at a time and i need to show them in Cart-item where he has selected his choice items. I want to do this by Cookies in that As user clicks on Add-To-Cart button it gets stored in cookies and in the Show-My-Cart-Item page it shows all the selected items in GridView format.
Anyhow I got following code:
<div>
<asp:DropDownList ID="ddlCookies" runat="server"></asp:DropDownList>
<br />
<asp:Button ID="btnSave" runat="server" Text="Save Cookie" OnClick="btnSave_Click" />
</div> <div >
<asp:Label ID="lblCookies" runat="server"></asp:Label>
[CODE]
But I am unable to get all the cookies values except DropDownList Value. And in gridView I get only last ddl value. Though I have used foreach loop But it does not work. How we get all the records in gridview.
View 1 Replies
Sep 5, 2013
how to put three rows of one table data in gridview one coloumn
how to add text1,text2,text3 rows data in upper as i write but the proper code
<asp:BoundField ItemStyle-Width = "150px" DataField = "LT_SHOWNAMETEXT1" HeaderText = "SHOW NAME"/>
<asp:BoundField ItemStyle-Width = "150px" DataField = "LT_TEXTTYPE" HeaderText = "TEXT TYPE"/>
<asp:BoundField ItemStyle-Width = "150px" DataField = "text1,text2,tex3 " HeaderText = "TEXT"/>
[Code].....
View 1 Replies
Feb 10, 2010
i want to get multiple row data from a data base table and display 1 record per specific group as shown below in a gridview. for example.
two columns with this data.
1 Good
1 Bad
1 Neutral
1 N/A
2 Excellent
2 Poor
3 Yes
3 No
3 Maybe
The data needs to display in the gridview as such.
1 Good Bad Neutral N/A
2 Excellent Poor
3 Yes No Maybe
View 2 Replies
Jul 23, 2012
I have the above html for gridview instead of first name, middle name, last name
I need one single column name
<asp:GridView ID="gridview1" runat="server" Width="450px" DataKeyNames="id" OnRowCommand="OnRowCommand"
AllowSorting="True" Height="170px" AutoGenerateColumns="False" AllowPaging="True"
OnPageIndexChanging="gridview1_PageIndexChanging">
[Code] ....
View 1 Replies
Jan 8, 2014
have a GridView with two columns: Part Number | Part Details
When I search for the part number 12345, the gridview will display like this
PartNumber | PartDetails
12345 | image1 (image1 will see as document picture)
If I search Part Number and doesn't get any data results in gridview the information will be:
PartNumber | PartDetails
0 | image2 (image2 will see as red cross picture)
How to change the image2 in the same column cell 1 in the GridView when the data results are "0" ?
Here is my code:
<asp:GridView
Width="570px"
runat ="server"
ID="grdView1"
[Code]....
View 1 Replies
Oct 6, 2010
If 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
View 2 Replies
Mar 3, 2010
I have 4 different select statements which i sequently assign to an sqlDataSource like this:
sqlNoutatiProduse.SelectCommand = select;
and i keep the results in different DataViews like
MySession.Current.dataViewNoutatiProduse1 = (System.Data.DataView)sqlNoutatiProduse.Select(DataSourceSelectArguments.Empty);
Is it possible to combine into a single DataView the results of these queries?
View 1 Replies