Forms Data Controls :: Display Gridview Data From Multiple Sources?
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
Similar Messages:
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
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
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
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
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
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
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
Jun 28, 2010
I want to display my data from sql in a grid view. Here the problem is how do I display more than one columns under one column. For example, I have A, B, C, D, E, F columns in sql and then when displaying in Grid, I want to display as 3 columns A, B, C and under column "B" I want to Display D, E, F.
View 19 Replies
Aug 5, 2010
I currently have 2 table in my SQL Server MisShip and MisShipDetails. MisShip holds the header level information such as MisShip ID (pk), Invoice Number, Date, Recevied By, Comments, Credit Received, Credit Amount, and Credit Memo. MisShipDetails hold the product level details including MisShip Details ID (pk), MisShip ID (fk), MisShipCode, UPC, Product Description, Qty Ordered, Qty Received, Unit Cost, and Amount to be Adjusted. There is a 1 to many relationship between MisShip and MisShipDetails. A particular misship can have many products that were misshipped. Our codes are used to determined reasons why a product would be considered MisShipped (did not receive, damaged, not billed on invoice, etc...)
I have fully functioning forms that my stores use to input the misship data. I am working on a corporate form that our Accounting can use to "close" out the misship when credit is received.
So my MisShip Credit Entry Form is a gridview which displays the header level info about the misship along with a calculation of the Total Amount to be Adjusted which is a formula based on the product details for the misship and the specific codes given to them. That's all working fine.
The question came up how the account person could know what misship codes are associated with a particular invoice. Obviously if I add that column to the SqlDataSource Select statement my misship records are duplicated in the gridview. Ultimately I just need a way to display the distinct codes that are in the MisShipDetails for a particular misship id (where misship_id=@misship_id and @misship_id is the selected row of the gridview?). I must be over thinking this somehow b/c I've tried several ways and can't get the data to do what I want.
What is the easiest way to acheive viewing this data associated to my existing gridview. I don't want to change things up too much b/c they've already approved the ease of use of my gridview, editting, along with it's interactive search capability to locate a particular invoice. But they want the ability to view the details behind it as well. I can post my gridview code if needed. I'm kind of a newbie at this stuff so code examples I can't seem to find the right search keywords to find website information to assist me...been looking for more than 6 hours now.
View 2 Replies
Jun 9, 2010
I would like to display students and their grades with a GridView and LinqToSQL like this:
[Code]....
I found this topic but it doesn't answer my question: http://forums.asp.net/t/1557987.aspx
I have a many-to-many relationship between students and assignments called "grades".The grade for the assignment is stored in that table in a "gradeNumber" column.The many-to-many relationship seems to be a problem.I tried adding a TemplateField to my grid:
[Code]....
It doesn't work:
...student does not contain a property with the name grade.
It does work when I use class.name however to get a student's class he is in.In code students .grade[0].something works however My LINQ entities are extended with custom code to allow me to retrieve studentx.Assignments or assignmentx.Students.(I would also like to specify which assignments should be displayed in the grid.)
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
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
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
Mar 12, 2010
how to use a multiline text box that i could copy data into. Lets say addresses one on each line and then click submit and have it display those records in the database (SQL) in a gridview?
View 7 Replies
Nov 19, 2010
I have a page in which i need to show data in the form of a grid. Each row in the grid is made up of 2 sub-rows, the first sub-row consists of a dropdown, a textbox & a textarea. Whatever is entered in these controls should be displayed in the second sub-row in the form of labels at runtime (i.e. using javascripts)
There can be multiple rows like this. The grid would have a max of 30 row, not more than that. create this which one would be better, in terms of performance & complexity, a GridView or a DataRepeater?
View 2 Replies
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
Mar 31, 2011
so I know that DataTables are often used as the DataSources for gridviews. Lately, I have found that I can also use generic lists as data sources for gridviews. But I figured that out by simply trying it to see if it worked.
I have looked all over the web and simply cannot find any kind of inclusive list or description of exactly which data structures can be used as the data source for a gridview. Does anyone know if there is such a list, or some kind of reference that I can look to for this info?
Although it sounds like an obvious question, like there is obviously one out there and I just haven't looked, my experience has been that it's just not so.
View 1 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
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
