Forms Data Controls :: Create Bar Graph From ArrayList And DataSource?
Jan 16, 2011
I have a web page where a GridView will be shown with a column of different products and another column with checkboxes. Checking on the checkboxes will be equivalent to selecting the products. The selected products are saved to an arraylist. Then, the user has to click on a button located on the same page to analyze the selected products. On clicking the button, he/she will be directed to another page where a bar graph will be shown. The bar graph will be the result of having analyzed the products. How do I create the bar graph where the products are taken from the arraylist but I can make use of the datasource within the chart control to retrieve more detailed info(such as product sales) from the database, taking into account the products from the arraylist?
I have an arraylist that contains some values. (e.g. playerName). I also queried for values in the database (e.g. playerName, playerSales) and I need to match the playerName in the arraylist to the corresponding ones that I did a query from the database. (match those with the same playerName). From there, I need to create a bar graph with the respective playerName and their sales (playerSales).
A portion of the code is shown below:
[Code]....
The arraylist I mentioned was saved to a session to be used in another page. Is my code right? And how can I create the graph from the values?
I am creating a bar graph and line graph. I am using 2 dropdown list for the date and category. The user can chose the date and category that he want to view. I also have a upload button for the user to upload the excel file and dispaly the data in girdview.
However i have error whenever i want to view the graphs.. I have upload my code in the attachment. Pls take a look. I do the coding invb.
I cant even seem to start. i drag the chart icon into the ground and then the sqldatasource. tie them too together. and then im completely lost. i tried tieing x&y values with sum,customer name but they just arent working correctly
On checking the checkbox, the user will actually be selecting the products that he/she wants. The selected products will be stored in an arraylist by using a foreach loop through the gridview. The arraylist will then be saved to a session before being redirected to another page. (a button will be clicked after the selection of products to proceeed to another page)
On the redirected page, a bar graph needs to be generated based on the products selected previously and also the product sales (this is retrieved from the database).
How can I generate this bar graph without having to code the whole graph out?
i have some survey in my site with 5 radiobuttonlist answers after user vote the answer send to sql table. i want to display the votes in very simple way (horizontal 5 lines by percents) can any one direct me to solution or article? please i need the most simple solution (no colors, no pie no complex graphs) just 5 lines (line for each answer) that long or short by percents......
i want to create a arraylist which will able to store user info like (username,machineIP,port ) for each user in the list & retrive this data when needed . any one tell me how i can do it or any alternative way without database or xml file.
I want to add array list in sqlcommand.but i don't no how to pass it. My code is.
ArrayList ProductId = new ArrayList(); for (int i = 0; i < ShipmentPackage.Items.Count; i++) { ProductId.Add(ShipmentPackage.Items[i].ProductVariant.ProductID); } select * from TableName where id= ProductId(ProductId is my Arraylist)
I'm trying to convert some code from VB to C# on a site i'm working on and can't seem to get the arraylist to function properly.
Here is what we currently have in the codebehind:
[Code]....
Which we then call from the page using:
[Code]....
I want to convert this to C# as the rest of the code on the new site is in C# and I'm having problems with the ArrayList. I've got the other parts of the code all converted fine it's just the GetContent Function that isn't working right. Here's what I have:
[Code]....
I got an error on the "objSDR.Item" part of the code saying "SqlDataReader doesn't have definition for Item" and so if I changed this to the code above. Only problem now is I can't call this from the page using the code below as there is no "Item" in the GetContent Function any more
I have Bar Chart with two Series on X axis one for Month and Other for Productvalue now if the product value is Zero then nothing is displaying on graph is there any way to show the atleast value of the product as integer Zero.
I have a requirment to draw a graph (Cartesion chart), where the data will be changed 40 to 50 times within hour , i want to refresh data automatically.
Which chart component should i use for drawing graph and how do i make sure that the data will be refreshed very fast on the graph web page.
I have a GridView control of 5 columns out of which 2 are actually computed (there cell values comes from column 1, 2 and 3) columns. I want to save all the values of my gridview columns in a 5 dimension ArrayList and then lateron bind that ArrayList with a repeator control.
This seems like it should be extremely simple. I have a list of x,y cords in SQL table that I am pulling out into a reader. I am then trying to bind my points to a point (have to use it since I can't find scatter) chart control.
Where Xpos = the x cord column and Ypos = the y cord column.The chart generates but my problem is that I am getting multiple x values that are the same. For example I have (67, 45) and (67,54).I would think there would be one x value for 67 with the two points on it, at 45 and at 54.Instead I am getting 2 x values listed, both for 67, one with 45 and one with 54.
Just as a test I listed these values in excel (in 2 columns) and did a scatter plot and it generated what I expected (2 items plotted on the same x value, one above the other. Is there a setting I am missing or does the chart control "Point" not have this capability.
I've been trying to bound an arraylist to a grdview for display and managed to work out the following:
[Code]....
At the point where rows are added to dt, i'm trying to get arraylist (Tweet) to be read row by row to insert each of it's fields into dt. There is no error but when run in browser, each cell of the gridview shows 'DataExtraction.Tweet'.I'm not sure where to go from here.
I have a gridview that contains template fields with textboxes that is used to look up inventory items. The page loads using an arraylist to display a gridview control with a predetermined number of rows. There is also drop down control that allows the user to add additional rows to the gridview if needed.
Currently when a user has already entered some data if you use the drop down to add more empty rows all the original entrys are removed. I want to save the original data and then add empty rows at the end.
>>
Private Sub LoadDataGrid(ByVal numberOfRows As Integer) Dim Counter As Integer Dim GridList As New ArrayList For Counter = 0 To numberOfRows GridList.Add(New LibVB.Form2VB(Counter)) Next gvEnterParts.DataSource = GridList gvEnterParts.DataBind() End Sub <<
I'm lost, kind of a newbie to .net, have been working on this for 2 days! d.
I am fresh to asp.net. I m using vb to write it. Could someone who is professional guide me? I want to input data from textbox to "unknown size" array or arraylist, and bind it to gridview. I have more than 1 data to input. Do i need to use loop to bind?
I have an ArrayList of strings called 'vins'. I have set DataGrid1's data source set to 'vins'. When I check off create columns automatically at runtime the DataGrid is populated with the correct values from the arraylist, however I'm not sure how to reference them. I'm trying to make it so that a user can click on a link after any VIN number and have that referenced and deleted from the arraylist. bind this ArrayList to the DataGrid and then be able to reference them.
I'm trying gridview templateField DropDownList bind with arraylist. When i set bindsource i got this error. "//Error Object reference not set to an instance of an object."
i need to select the values inside an arraylist into a listbox control, when i am doing the loop of the arraylist only the last value of the array stays selected, i need all values of the array list to stay selected, here is the code.
' businessTypeList is an array list that contains values 39 31 51 but only 51 stays selected in the list box i need to maintain selected all three.
For i = 0 To (ddaEdit.businessTypeListID.Count) - 1
I am building an stock exchange sort of application. I would like to know Is it possible to create graphs using crystal reports or is there any other technology in .NET for building a graph which we usually see in stock exchange application.
I am trying to find duration of an mp4 file using direct show component of windows using the Dotnet wrapper(directShow-lib 2005). But the method i used was GetDuration of IMediaSeeking interface. But this returns zero as duration.After searching i found the following statement:"It doesn't matter whether it's in a container or not, it only matters whether you have a parser/reader for it. There is no stock DirectShow parser to read raw H.264 files and no third-party one I can think of. Also, whether IMediaSeeking would work with such a raw file is implementation-dependent. Last, most H.264-related filters use MPEG2Video or VideoInfo2 and neither works with MediaDet, so you would have to build the graph yourself."