The problem is that we have 5 different categories and we have to calculate the percentage of products sold in each category. Then we have to show that in sort of a chart. The interface of chart is shown here
http://img64.imageshack.us/img64/5397/52805880.gif although this chart has 14 boxes but I will be using 20 boxes in the final chart, the reason for that is that I want each box to represent 5% of sales. Now the question is suppose that the percentage for sales in each category is 34.4%, 12.6%, 23.2%, 22.6% and 7.2%. How do I convert these values to nearest 5 and then fill each box with that color. For example 34.4% means that almost 35% or 7 boxes will be colored with that color. The problem is that the sum of all of these must always be 20. I understand that this will not be very precise representation but this is the demand from the user.
I have a grid view to show a listing of domestic sales and international sales. I share the same grid view for both. So if i select 'Domestic' radio button, i have to change the label of first column as 'SalesNo' and also set the sort expression as 'sales_No', if i select 'International' radio button, i have to change the label of first column as 'ExportNo' and also set the sort expression as 'export_No'. How can i do it using C# ?
I want to add unlimited categories and sub categories facility, But I couldn't solve it for last two days.
1. DB
CategID,CategName,parentid
Data:
CategID CategName Parent ID 1 Electronics 0 (where 0 means it is main category) 2 TV 1 (Self Join whith the categ id Electronics) 3 Panasonic 2 4 LG 2 5 Toys 0 6 Girls Toys 5 7 Boys Toys 5 8 Criket Related 7 9 Dolls 6
Here I want to display this data in Combo Box like
I am building a little app to upload a picture and various downloads for different file types for the photos, but I also need be able to select the catergory they will go into. So I have two tables one that stores the catergory names and one that holds the paths to the photos and downloads the tables are related through the catergoryID.
What I need is those catergories to show up in the photo's and downloads table so that when I go to upload the photos I will be able to select the categories.
I have also built the DataSet and the Business Logic.
I am using the new ASP control "Chart", but I have some problems with it: I can't see anything when I execute the aspx. The data is binded to a ObjectDataSource, like this:
I have a column in gridview which displays float values. But while the same value in chart I need to round off to nearest whole number and display it in chart.
I m having a problem in showing chart with datatable. I want to show my chart as shown in below image. How can i do this in ASP.net using MS chart controls
I'm developing a stocks evolution chart with Microsoft Chart Controls and I need to show the initial and final dates on the AxisX labels but I can't do it.
I google and found many solutions like set the properties:
On the sample below the initial date was Jul 26, 2007 and the final was Jul 26, 2010, this is what I need to show on the chart labels, the others dates don't make difference and can be showed in any interval.
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'm trying to create a very simple Column chart. There are 10 items in X axis, but chart shows only 3 of their labels. For clarification, I'm trying to show Product sales count in chart. There are 10 products. In X axis, chart shows 10 products but, only 3 of them has a label for product name. It should be a setting for this, bu I couldn't find it.
On my X Axis, I have months. The chart shows up to 11 points, i.e. Jan - Nov of the same year, but when I add 12 points (Jan - Dec), it will do an auto label thing and change the interval for every 4 months.
How can I change the graph so that it shows 12 months before it does the auto labels?
Here is the server control code I am currently using.
I have a simple chart control on my form. it displays data fine in X and Y axis. On X axis, i have time period (1 day,1 week, to 30 Years- total of 27 points on x axis) and Y axis has interest rate.
when the cursor is moved in the chart area, I want to show the exact value of Y axis. Just like yahoo finance shows when we click on a graph of a stock symbol. Say on my chart, when user hovers on say 2 Y on the graph, it should show the exact interest rate which is on the Y axis.
I´ve got a chart control (column type) and must show many elements at y axis, but when system generates the chart draw, it´s shows only odd elements: For example: My chart must show a colunm containing systems (x) and error incidences (y):
I would like to populate a dropdownlist with all users who are in the Sales role. I am using the .Net Membership and Roles tables in my SQL 2005 DB (aspnet_Users, aspnet_Roles...).
Im using asp.net 2.0 with Visual studio 2005... My requirement is i want to show my balance sheet from MS SQL 2005 database to graphical Chart... so Would u guyz will let me know the best high qulaity chat which support asp.net 2.0 with Visual studio 2005..
I want to find the sum of sales column from the table. Like today is 16-01-2014, i want the sum of sales column of 7 days back i.e. till 09-01-2014. I cannot put static dates as everyday date will change and every day i want that query to automatically see 7 days back records.
I want to show the data either in Chart control or Gridview control. When the user selects an option to see the data either in chart control or grid view control, that specific control has to show up and other control has to become invisible.
So far, I am able to populate data successfully in the chart control. If the user chooses "Grid view" option, how can I show the data in grid view control in the same location. I don't want the gridview control to be shown in a pop up window or any other window.
I have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.
I have a drop downlist,and next to it there is an MS bar chart.i want to change the datate of the MS chart ,once the user selects another year from the dropdownlist.
When the page loads ,the chart displays the default year(2011) and it works.The problem is that is does not change the data when you select another year from the dropdownlist.
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.