Click here to Skip to main content
15,902,715 members
Home / Discussions / C#
   

C#

 
AnswerRe: namespace name 'ArrayList' could not be found Pin
Abhinav S1-Jul-10 18:56
Abhinav S1-Jul-10 18:56 
QuestionHow to find the character in list Pin
raju_shiva1-Jul-10 18:15
raju_shiva1-Jul-10 18:15 
AnswerRe: How to find the character in list Pin
Abhinav S1-Jul-10 18:53
Abhinav S1-Jul-10 18:53 
Generalget the list of all page labels(numbers) Pin
TweakBird1-Jul-10 17:45
TweakBird1-Jul-10 17:45 
QuestionUnhandled exception handler problem Pin
Super Lloyd1-Jul-10 15:45
Super Lloyd1-Jul-10 15:45 
AnswerRe: Unhandled exception handler problem Pin
Luc Pattyn1-Jul-10 17:05
sitebuilderLuc Pattyn1-Jul-10 17:05 
GeneralRe: Unhandled exception handler problem Pin
Super Lloyd1-Jul-10 19:16
Super Lloyd1-Jul-10 19:16 
QuestionVS2010 Chart Control [modified] Pin
It_tech1-Jul-10 8:54
It_tech1-Jul-10 8:54 
Hi all,

Could you please let me know which property of the chart object will allow me to format values in Currency?

I want to have my Y axis to show Currency Amonut Like ($100,$200,%300 etc...)

Here is my code..

How can i format the chart control so that the revenue apprears in £ sign?

At the moment its jUst showing Numbers not having a $ sign.

Here is Code:

With dt



.Columns.Add(New DataColumn("Hours", System.Type.GetType("System.String")))
.Columns.Add(New DataColumn("Revenue", System.Type.GetType("System.String")))

.PrimaryKey = New DataColumn() {dt.Columns("Hour")}

End With

Using con As SqlConnection = New SqlConnection(Session("ConnectionString").ToString)
Using com As SqlCommand = New SqlCommand(strCommand, con)
con.Open()
Dim i As Integer = 0
Using reader As SqlDataReader = com.ExecuteReader
While reader.Read()
' Dim sSeries As String = reader(0).ToString.Trim.


Dim sSeries As String = reader.GetName(i)
Dim dr As DataRow
Dim sData As String = ConvertToString(reader(0))
If sData = "Total" Then

Else

' For f As Integer = 1 To reader.

dr = dt.NewRow()
'dr("Hour") = reader.GetName(i)
Try
dr("Hours") = Convert.ToString(reader(0))
dr("Revenue") = Convert.ToDecimal(reader(1))
Catch ex As Exception
End Try

dt.Rows.Add(dr)

dt.AcceptChanges()
End If

End While
Dim Count As Integer = dt.Rows.Count
If Count = 0 Then
Exit Sub
End If
With Chart1

.Titles.Add("Revenue Generated by Hour and Channel ")
.Series.Clear()
.Series.Add("Revenue")
.ChartAreas.Clear()
.ChartAreas.Add("ChartArea1")
.ChartAreas("ChartArea1").AxisX.Title = "HOUR"
.ChartAreas("ChartArea1").AxisY.Title = "Revenue"
.Series("Revenue").ChartType = SeriesChartType.Column
.Series("Revenue").IsValueShownAsLabel = True


.DataSource = dt
.Series("Revenue").XValueMember = "Hours"
.Series("Revenue").AxisLabel = "Revenue"
.Series("Revenue").XAxisType = AxisType.Primary
.Series("Revenue").YValueMembers = "Revenue"
.DataBind()
.Legends.Add("Legend1")
.AlignDataPointsByAxisLabel()
End With

modified on Thursday, July 1, 2010 3:18 PM

AnswerRe: VS2010 Chart Control PinPopular
Pete O'Hanlon1-Jul-10 13:13
mvePete O'Hanlon1-Jul-10 13:13 
GeneralRe: VS2010 Chart Control Pin
It_tech1-Jul-10 18:51
It_tech1-Jul-10 18:51 
GeneralRe: VS2010 Chart Control Pin
Daniel Grunwald2-Jul-10 0:37
Daniel Grunwald2-Jul-10 0:37 
GeneralRe: VS2010 Chart Control Pin
DaveyM692-Jul-10 1:35
professionalDaveyM692-Jul-10 1:35 
GeneralRe: VS2010 Chart Control Pin
Pete O'Hanlon2-Jul-10 2:23
mvePete O'Hanlon2-Jul-10 2:23 
Questionto handle Multiple clients.... Pin
yum 20101-Jul-10 8:08
yum 20101-Jul-10 8:08 
AnswerThe hardest part of dealing with mulitple clients Pin
Ennis Ray Lynch, Jr.1-Jul-10 8:27
Ennis Ray Lynch, Jr.1-Jul-10 8:27 
Questionsending serialized listview over tcp Pin
teknolog1231-Jul-10 7:31
teknolog1231-Jul-10 7:31 
AnswerRe: sending serialized listview over tcp Pin
Not Active1-Jul-10 7:50
mentorNot Active1-Jul-10 7:50 
GeneralRe: sending serialized listview over tcp [modified] Pin
teknolog1231-Jul-10 8:10
teknolog1231-Jul-10 8:10 
QuestionHelp in Regular expressions Pin
shankbond1-Jul-10 6:53
shankbond1-Jul-10 6:53 
AnswerRe: Help in Regular expressions Pin
OriginalGriff1-Jul-10 8:46
mveOriginalGriff1-Jul-10 8:46 
GeneralRe: Help in Regular expressions Pin
shankbond1-Jul-10 18:24
shankbond1-Jul-10 18:24 
GeneralRe: Help in Regular expressions Pin
OriginalGriff1-Jul-10 21:49
mveOriginalGriff1-Jul-10 21:49 
GeneralRe: Help in Regular expressions Pin
shankbond4-Jul-10 1:10
shankbond4-Jul-10 1:10 
GeneralRe: Help in Regular expressions Pin
OriginalGriff1-Jul-10 22:04
mveOriginalGriff1-Jul-10 22:04 
GeneralRe: Help in Regular expressions Pin
shankbond4-Jul-10 1:08
shankbond4-Jul-10 1:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.