|
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
|
|
|
|
|
I've checked. That's not C# - not even with some hinky dink extension methods going on there. Please take your VB.NET out of our nice case sensitive forum.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Thanks for your comment.
DataTable dt = new DataTable();
{
006 dt.Columns.Add(new DataColumn("Hours", System.Type.GetType("System.String")));
007 dt.Columns.Add(new DataColumn("TotalCall", System.Type.GetType("System.String")));
008 dt.Columns.Add(new DataColumn("Minutes", System.Type.GetType("System.String")));
009 dt.Columns.Add(new DataColumn("Revenue", System.Type.GetType("System.String")));
010
011 dt.PrimaryKey = new DataColumn[] { dt.Columns("Hour") };
012
013 }
014
015 using (SqlConnection con = new SqlConnection(Session("BMEAS_ConnectionString").ToString)) {
016 using (SqlCommand com = new SqlCommand(strCommand, con)) {
017 con.Open();
018 int i = 0;
019 using (SqlDataReader reader = com.ExecuteReader) {
020 while (reader.Read()) {
021 string sSeries = reader.GetName(i);
022 DataRow dr = null;
023 string sData = ConvertToString(reader(0));
024
025 if (sData == "Total") {
026
027 } else {
028 dr = dt.NewRow();
029 try {
030 dr["Hours"] = Convert.ToString(reader(0));
031 dr["TotalCall"] = Convert.ToString(reader(1));
032 dr["Minutes"] = Convert.ToString(reader(2));
033 dr["Revenue"] = Convert.ToDecimal(reader(3));
034 } catch (Exception ex) {
035 }
036
037 dt.Rows.Add(dr);
038
039 }
040
041 }
042 int Count = dt.Rows.Count;
043 if (Count == 0) {
044 return;
045 }
046
047 {
048 Chart1.Series("Default").Color = Color.MediumSeaGreen;
049 Chart1.Series("Default").BackSecondaryColor = Color.Green;
050 Chart1.Series("Default").BackGradientStyle = GradientStyle.DiagonalLeft;
051
052 Chart1.Series("Default").BorderColor = Color.Black;
053 Chart1.Series("Default").BorderWidth = 2;
054 Chart1.Series("Default").BorderDashStyle = ChartDashStyle.Solid;
055
056 Chart1.Series("Default").ShadowOffset = 2;
057
058 Chart1.Titles.Add("Revenue Generated by Hour and Channel ");
059 Chart1.Series.Clear();
060 Chart1.Series.Add("Revenue");
061 Chart1.ChartAreas.Clear();
062 Chart1.ChartAreas.Add("ChartArea1");
063 Chart1.ChartAreas("ChartArea1").AxisX.Title = "HOUR";
064 Chart1.ChartAreas("ChartArea1").AxisY.Title = "Revenue";
065
066 Chart1.Series("Revenue").ChartType = SeriesChartType.Column;
067 Chart1.Series("Revenue").IsValueShownAsLabel = true;
068
069 Chart1.DataSource = dt;
070 Chart1.Series("Revenue").XValueMember = "Hours";
071 //.Series("").AxisLabel = "Hours"
072 Chart1.Series("Revenue").AxisLabel = "Revenue";
073 Chart1.Series("Revenue").XAxisType = AxisType.Primary;
074 Chart1.Series("Revenue").YValueMembers = "Revenue";
075
076 Chart1.DataBind();
077 Chart1.Legends.Add("Legend1");
078 Chart1.AlignDataPointsByAxisLabel();
079 }
080 // .Legends.Add("Legend1")
081
082 {
083 Chart2.Titles.Add("Total Calls and Minutes Generated By Hour");
084 //.Titles.Add(
085 Chart2.Series.Clear();
086 Chart2.Series.Add("TotalCall");
087 Chart2.Series.Add("Minutes");
088 // .Series.Add("Revenue")
089 Chart2.ChartAreas.Clear();
090 Chart2.ChartAreas.Add("ChartArea1");
091 Chart2.ChartAreas("ChartArea1").AxisX.Title = "HOUR";
092 Chart2.ChartAreas("ChartArea1").AxisY.Title = "Minutes";
093
094
095 Chart2.Series("Minutes").ChartType = SeriesChartType.Column;
096
097 //.Series("Minutes")("DrawingStyle") = "Emboss"
098 Chart2.Series("Minutes").IsValueShownAsLabel = true;
099
100 Chart2.Series("TotalCall").ChartType = SeriesChartType.Column;
101
102 Chart2.DataSource = dt;
103
104 Chart2.Series("TotalCall").XValueMember = "Hours";
105 Chart2.Series("TotalCall").YValueMembers = "Totalcall";
106 Chart2.Series("Minutes").XValueMember = "Hours";
107 Chart2.Series("Minutes").YValueMembers = "Minutes";
108 Chart2.DataBind();
109 Chart2.Legends.Add("Legend1");
110 Chart2.AlignDataPointsByAxisLabel();
111 }
112 // .Legends.Add("Legend1")
113
114 }
115 }
116 con.Close();
117 }
|
|
|
|
|
That's still isn't valid C#. The converter you used sucks.
Why don't you try the VB forum?
|
|
|
|
|
Signature updated! 
DaveIf this helped, please vote & accept answer!
Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
|
|
|
|
|
Like it.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
hi everyone,
I have done single client-server application using c#. Now i have to made that application for multiple clients. kindly guide me.
Regards
|
|
|
|
|
Is they always seem to call at the same time demanding an on site visit Friday at 4:30pm.
If you have implemented a "single" client-server application the multiple client application should work with no changes. There is no difference. Ahem, there should be no difference. When a TCP connection is established from the Listening port he OS assigns it a temporary high number port so the listener can continue to listen. No work should need to be done. The only other issue is if your command processing does not support the ability to distinguish different requests from different clients but again that is such a large area.
|
|
|
|
|
hi, I've been looking for a way to send a listview from server to client over tcp. I managed to serialize the listview but stuck on sending it through network.Below is the piece of code I could manage to write and still I don't know what to do how to receive that listview. Any help is appreciated
MemoryStream ms = new MemoryStream();
BinaryFormatter bf = new BinaryFormatter();
bf.Serialize(ms, lst);
byte[] byt = new byte[1024];
byt = ms.ToArray();
streamWrite.Write(byt);
|
|
|
|
|
You can't serialize a listview control, you can serialize the contents of the control however.
What research have you done on TCP connections? Do you understand you need to open a channel between the client and server?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Here is what I have, I can currently send strings to client with streamWrite() method but don't know what method used to send for serialized objects
public void sendSerialized()
{
IPHost = Dns.GetHostEntry(Dns.GetHostName());
TcpListener tcpListener = new TcpListener(IPHost.AddressList[0], 8080);
tcpListener.Start();
while (true)
{
Socket handlerSocket = tcpListener.AcceptSocket();
if (handlerSocket.Connected)
{
ntrStream = new NetworkStream(handlerSocket);
streamWrite = new StreamWriter(ntrStream);
ListView lst = new ListView();
MemoryStream ms = new MemoryStream();
BinaryFormatter bf = new BinaryFormatter();
bf.Serialize(ms, lst);
byte[] byt = new byte[1024];
byt = ms.ToArray();
streamWrite.Write(byt);
}
}
}
modified on Thursday, July 1, 2010 2:28 PM
|
|
|
|
|
Hi,
I am new to regular expressions, I am having a problem regarding matching a specific keyword in certain condition.
string regexstring="\\bhtml\\b|[.]net\\b";
Regex rgx = new Regex(regexstring, RegexOptions.IgnoreCase);
MatchCollection matcol = null;
string st_data = "I am a .net developer, but also know about asp.net, vb.net ; I work on c#/asp.net platform. I also know dhtml, html4.0, html/xml etc etc.";
st_data = System.Web.HttpUtility.HtmlDecode(Regex.Replace(st_data, @"<(.|\n)*?>", string.Empty));
matcol = rgx.Matches(st_data);
foreach (Match mat in matcol)
{
}
I tried various variations but of no use.
I want to match html4.0 but some how I need only html out of it.kind of substringed match.
I hope You understand my point.
Please help
any help shall be appreciated.
Thanks
Shankbond
|
|
|
|
|
I'm not sure exactly what you are trying to do, but have a look at match-but-don't-capture groups ( ?: )
Or, explain exactly what you want to achieve and I'll have a look.
Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.
|
|
|
|
|
Hi,
I tried looking this stuff, but may be I did something wrong with match-don't capture.
1) I want the regex to match --> html56 but capture only html also
2) match 45html but capture only html,
3) and don't match or capture at all abchtmldef (not surrounded by alphabets one word only)
4) match html
I used \b(?:\d*)html(?:\d*)\b
It would be nice if someone can help.
Thanks
Shankbond
|
|
|
|
|
The match to do that is quite simple:(?:\d|\s)(?<data>html)(?:\d|\s)
Find (but do not capture) either a digit or a whitespace,
Find and capture in a group called data the four characters 'h', 't', 'm', 'l' in that order,
Find (but do not capture) either a digit or a whitespace.
But I doubt that will solve your problem!
What are you trying to achieve? It looks as if you are trying to process a CV and extract all the relevant job skills without manually looking at it. If so, then you may need to be a bit more clever / thorough about it, particularly with a trigger word such as "html" which appears in every web page...
Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.
|
|
|
|
|
OriginalGriff wrote: particularly with a trigger word such as "html" which appears in every web page...
Yes You are absolutly right. I did that with the help of a javascript.
Thanks
Shankbond
|
|
|
|
|
Just to add to what I said, go and get a copy of Expresso - it examines and generates Regular expressions.
Expresso[^] It's free, and really can help create and understand complicated expressions. You can also feed it a sample file that you want to examine and it will show you what the Regex will capture.
I wish I'd written it!
Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.
|
|
|
|
|
Thanks but I already have one  ,
my query is solved now I got the solution by using
(?<=\\d+(\\.\\d*)?|\\b)html(?=\\d+(\\.\\d*)?|\\b)
but I am having a new query now?
(?:.....) is also a non capturing group so I can theoretically use it in place of look ahead and look behind but that does not work here?
any solutions?
Thanks
Shankbond
|
|
|
|
|
can someone really explain that; I am curious about it.
Thanks
Shankbond
|
|
|
|
|
First of all, I know this question is only partially relevant to C#, so sorry for posting it here.
I am trying to implement Facebook single sign on using a desktop application. The one thing I figured out so far is to retrieve an access token.
How I retrieve the access token:
browserFacebook.Navigate(@"https://graph.facebook.com/oauth/authorize?client_id="+ FacebookApplicationID + "&redirect_uri=http://www.facebook.com/connect/login_success.html&type=user_agent&display=popup");
This redirects the user to page where he/she must first authorize the application. Once authorized, I redirect the user to "http://www.facebook.com/connect/login_success.html" as specified in the above address. I then intercept this URL to retrieve the access token like so:
string someString = browserFacebook.Url.ToString();
This returns something like the following:
"http://www.facebook.com/connect/login_success.html#access_token=ACCESS TOKEN.expires_in=0"
I can then easily use this access token with the Graph API to access an users facebook details as in the following code:
Facebook.FacebookGraphAPI g = new FacebookGraphAPI("ACCESS_TOKEN");
var fbUser = g.GetObject("me", null);
Can I also use this token somehow to simply log a user in to the site? My goal is not really to develop a complete new facebook application as my application is simply a prototype.
|
|
|
|
|
Good Morning,
I feel like Dr Frankenstein; I created this monster and now I cannot shut it off! Case in point. My application begins with a Splash screen that retrieves information (Connections Strings, Permissions) and sets a switch in a remote database that defines the users status as active. I hide this page when I advance to the next page (The Main Page). Now, I try to shut it down. I call a method from the Form_Closing event so that I can reset the users status as inactive and I use Application.Exit() as the closing command. BUT....my back trace shows that the script re runs the Splash page and turns the switch in the remote database back to active again before it closes. NOW.... when the user goes to log back on again, the system denies him access with the response that he is already active. In essence, the function of the code is to discourage a hacked application from being able to open if the original application is already active. It's a just in case scenario. SO...what to do? Thanks, Pat
<br />
private void frmMain_FormClosing(object sender, FormClosingEventArgs e)<br />
{<br />
if (alreadyClosing)<br />
{<br />
return;<br />
}<br />
<br />
if (richTextResult.Text != string.Empty)<br />
{<br />
DialogResult answer;<br />
string message1 = "Are you sure you want to exit the program? " +<br />
"\n\nThe information in your Result box will be lost!";<br />
answer = MessageBox.Show(message1, "Exit?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);<br />
if (answer == DialogResult.No)<br />
{<br />
e.Cancel = true; <br />
return;<br />
}<br />
else<br />
{<br />
ResetDatabaseActivity();<br />
alreadyClosing = true;<br />
Application.Exit();<br />
}<br />
}<br />
|
|
|
|
|
private void frmMain_FormClosing(object sender, FormClosingEventArgs e)
{
if (richTextResult.Text != string.Empty)
{
DialogResult answer;
string message1 = "Are you sure you want to exit the program? " +
"\n\nThe information in your Result box will be lost!";
answer = MessageBox.Show(message1, "Exit?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.No)
{
e.Cancel = true;
}
else
{
ResetDatabaseActivity();
Application.Exit();
}
}
}
I know nothing , I know nothing ...
|
|
|
|
|
Hello Stark,
Thank you for your reply. No, unfortunately, the alreadyClosing bool is required. When the application closes, if it is not in place, it trys to run this code twice. This switch is just a stop measure. It's not a big issue, but it takes 2 clicks to close the question box. That is the only reason that it is there. However, I just realized that Application.Exit() call is not required at all, since it is already staring to close before the call. Sometimes (Pat) cannot see the forest through the trees. I removed it and the problem has been solved. Thank you for your thoughts and input. I appreciate it. Best Regards, Pat
|
|
|
|
|
Hi!!
i'm back to disturb u again...
This time i wanna know y cant i use System.windows in a console program..
wheneva i type this it shows error.. that it doesn't exists.. but when i choose window application. i uses it...
help me out..i need to use it...
|
|
|
|
|
You need to add it as a reference. By default, it doesn't get added to console applications. Why would it? They aren't responsible for drawing windows after all.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
