I am working on a machine scheduling app in VB for our production department and am looking for some type of gantt chart and/or calendar (preferably like outlook) component that I can add to my form. Does anyone know where I can find one?
View 2 RepliesI am using visual studio 2010 to create a VB reporting website. I found a blog which tells me how to use range bar chart to create a gantt chart. But I got some problems with how to group the bars(tasks) on task names.
My database structrue is shown below:
Taskname StartTime EndTime
task1 2012-03-01 8:00 2012-03-01 10:00
task2 2012-03-01 9:00 2012-03-01 14:00
task1 2012-03-01 17:00 2012-03-01 18:00
task2 2012-03-03 18:00 2012-03-03 19:30
I would like use the above data to generate a gantt chart like this:
task1 task1
----- ---
task 2 task 2
------------------------- -------
In visual studio's report designer, I first added a range bar chart. Then dropped the taskname filed to the category fileds. So my understanding is the range bars will be grouped by task name. For the data fields, I dropped starttime(start value) and endtime(top value). I also set the 'draw side by side' property to false. But when I run my website, I could only see one task for each task type in the gantt chart( one task1 and one task 2) . It didn't show me all the tasks. So my incorrect result is shown below:
task1
------
task 2
-------------------------
No matter how many records are there in my database, the gantt chart only shows the first record for each task type.
hi im a student and i have a project. i already have my transactions in my program and my probs is i dont know how to generate my gantt chart. im using visual studio 2008.
View 3 RepliesI have a chart in Excel that I'd like to use a subtitle on. There is no SubTitle Property on the chart object, so I looked in the Excel User interface and found that you can only create a sub-title by using a text box. The text box looks like its associated with the chart, not the worksheet, so how would I access that text box from code?
View 1 RepliesI'm looking to export my project view (tasks, resource and gantt) into excel, so it's similar to the Gannt Chart view in Project. I found a piace of code on the internet that will export the task list, with hierarchy (see below) but it doesn't include the gantt and I'm having trouble finding even a list of variable names that I could use to try and create one.Here is the code:
'Copyright Jack Dahlgren, Feb 2002
Option Explicit
Dim xlRow As Excel.Range[code].......
using the calendar from the webfor tools, NOT CALENDAR EXTENDER, and my question is, is there a way to add text to a specific day of the calendar, for example, that i want to click on the number where its shows 29 of the month december, then it shows me a texbox or anything that takes data from my, and i type anything in there, like an event or something, then i click on a button to save my entry, and next time i visit my page i see that day that i clicked on changed its color and shows my text when i hoover the mouse on top of it,
View 7 RepliesI'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[Code]....
I have X and Y data columns coming from database.
I have to show scatter plot chart with Linear, Exponential, Log, power using asp.net chart control.
My requirement is to graph (scatter graph) data from 2 arrays. I can now connect the data from the array and use it on the chart. My question is, how do I set the graph's X- and Y- axes to show consistency in their intervals?
[Code]...
I'm trying this example but it doesn't seem to work. It gives a IndexOutOfRangeException:I'm using a txt file where the columns are Tab seperated.)
Imports System.Windows.Forms.DataVisualization.Charting
Imports System.Data
Imports System.Data.OleDb
[code].....
How do I dynamically add or remove a chart series on a WinForm. To date all my MS Charting experience has been dealing with ASP.Net charts with static sql select statment to a SQL Database. In the new project that I have been assigned I have different cities with different amounts of points that they want monitored. One city might have 3 an another might have 5 or 7 so I can't hard code the amount of series that I need. It needs to be set up so the amount of series can be flexible depending on the city selected and then display those points on the chart.
View 4 RepliesWhen i'm tryed to print Data chart the resolution of the chart changed as shown:
View 3 RepliesI'm developing a finance software and I want the user to enter a bill and pick the due date via month calendar. I getting it to work was the easy part, but now I only want one month calendar, for each time a user enters in a bill and picks a date.every time the user goes to pick a due date I have to call one of the several I have on screen.Here is my code that I have so far:Add due date button:
Me
The month calender:
Me
.TxtDueDate3.Text = MonthCalendar3.SelectionRange.Start.Date.ToShortDateString()Me.TxtDueDate3.Text
= MonthCalendar3.SelectionRange.End.Date.ToShortDateString()[code].....
I've got a datatable with two columns "Status" (string) and "Total" (integer).
Status Total
Success 34
Missing 2
Failed 10
I want to databind this into a pie chart with each Status per slice but I'm not sure what method of data binder is required?
I am using microsoft chart controls in VB.net. The graph data currently comes from my database, but all the series and chart formats were made before runtime. I want to know how to make charts on runtime, being able to select the x axis from my dataset and multiple y columns from my dataset.
View 1 RepliesI can not figure out how to get the chart to display the labels. When I try and add labels, the lines get messed up. Also, if I try and do multiple lines it does not always work out very well. I tried different ColumnLabels and they behave very strange as well. What I want is to be able to have several lines. Each with their own label. And also, I want to specify text for each point at the very bottom of the graph. Let me know what suggestions you have. [Code]
View 3 Repliesi wish to create line chart, pie chart and bar chart using vb.net of visual studio 2005.Second question is i wish to copy a few data into datagridview from microsoft office tools such as access or excel using shortcut key 'ctrl+C' and 'ctrl+V'.code to do the 2 functions above without installing additional tools?
View 5 RepliesGot a chart control i wanna make from a data table. the table looks like this:
the chart i want will look like this:
'''
''''
[code].....
I'm having problem with MS Chart chart type column. If there are only 9 bar in the chart like the following picture, then the axis-x label show up properly.
However, there are more than 9 bars bar the chart, the axis-x label wont show up properly, some of them just dissappear.
Here's my mark-up for the chart:
<asp:Chart ID="chtNBAChampionships" runat="server">
<Series>
<asp:Series Name="Championships" YValueType="Int32" Palette="Berry"
[Code]....
I don't know it works with only 9 bars? Is there any way to make the chart work properly? Also, if possible, how to make each bar have different color.
I have the smallest dataset in the world that simply consists of a month (text) and and amount. I want to produce a chart showing the month along the y-axis and the value up the x-axis. How do I do it? I have dragged the chart control onto the report page and populated the dataset. The chart shows but nothing like what I would expect. Just to make it simple I populated the dataset with an amount equivalent to the month number so it should show as 1 in January, 2 in Feb etc...However no matter where I drag the dataset's column names I don't get what I want. Where am I going wrong?
I use this simple loop to populate the dataset:
dsSales.Tables("Sales").Clear()
For i As Integer = 1 To 12
dsSales.Tables("Sales").Rows.Add(MonthName(i), i)
Next
ReportViewer1.RefreshReport()
I get this as a result:
I can't figure out how to plot anything on this chart...finally got it to actually display a pie chart, now I'm trying to somehow bind a data source to it and from there, select the series data..I have added the database to the project as a data source but I don't know how to bind it to the pie chart. some other info: this db has 100's of tables and the program I'm working on is going to be a "status monitor" of sorts that will contain about 6-8 different types of charts all plotting different info for me in chart form.I want to bind this one data source to all the charts and just have them display different information (based on the sql query perhaps)
View 9 RepliesBasically I've coded an Excel 2007 project in VB.NET 2010 that allows you to create charts with a fair amount of interactivity. I want the user to be able to save and reopen this workbook and still have that interactivity in any already-created charts, so they don't have to re-create them.
When I create the charts, I use Sheet1.Controls.AddChart(...), which returns a Microsoft.Office.Tools.Excel.Chart with which I can handle events and such. However, when I reopen the file and look through the Sheet1.Controls collection, there are no Chart objects. Accessing the charts through Sheet1.ChartObjects.Chart gives me Interop Charts, when I need the Tools Charts.
How can I add another calendar in a toolbox?? anyone knows how to add a well design calendar.. Because I don't like the design of the calendar in the toolbox. It cannot change the font type and font color.
View 2 RepliesI created my own custom date picker consisting of an ASP TextBox, Button, and Calendar complete with CSS styles, javascript code, and event handling vb code.I want to use this date picker multiple times on my form. I know the wrong way to do this would be to copy all the code and just adjust each name accordingly.How can I put those controls, styles, and code into a single entity?
View 1 RepliesIn my Project for user selecting date, i have provided an calender control. when i am running the source code from visual studio,the calender is displaying properly. But when the same project is displayed in IIS,calender is displaying with out broders.
View 5 RepliesI am using calendarextender control in asp.net.It displays only date ,not time.But while inserting to database ,time is inserted automatically.But while retrieving the data from database using date in where condition ,no correponding records displays.What modification in storedprocedure i can do to resolve this problem.
View 2 RepliesI am working with calendar inside GridView using VB. I have some NULL date on the DDBB. I can fix the problem using EVAL, but when I try to save the date from the calendar, I got an error telling me that their is no @variable declared.[code]Everything is fine but I got: Must declare the scalar variable "@tDate" trying to save.This is beacuse I'm not using Bind, but with BIND I cannot run checkDate.
View 1 RepliesI found this code on msdn showing how to create a calendar drop down in a data grid view:
HERE
I am looking for some guidance on how to implement this code. Do I need to create the grid programmatically or can this be used with an existing dgv?
Let's say I'm making a calendar program and I want to leave it open all day. When 2pm rolls around I want it to tell me I have a meeting in 5 minutes...how would I go about this? Do I have to have a sub that's constantly running and slowing down my comp or is there a function/better way that is going to surprise me?
View 1 RepliesIm sorry if this is a stupid request but I cant find any information or at least any usefull information on this. I have a database program just now that requires information to be stored in a database.
Right now I have the users entering dates manually, and I would like to have a small image that they click to bring up a calender, select the date which will then be automatically entered into a textbox. The calender must be able to go back in time as well as forward.
Im fairly new to VB but have experiance in Java. Would somebody be able to either provide me with the code or at least a walkthrough how do it.