ChartAreas(0).AxisX.LabelStyle.Format Is Changing Axis Label Text Instead Of Format?
Feb 1, 2011
I'm returning a database query into a List object and using that list object to fill the X and Y axes of my chart as seen below. (_runData is a "List(of DatabaseTableName)" style Object filled with the results of my query.
Primary_Chart.Series(0).Points.DataBindXY(_runData, "DateTime", _runData, "UPPER_PRESSURE")
My Datetime field is returning as a Serial Number (i.e. 40116.76111) so I want to format the X Axis to display the field more readably. Enter my problem code.
I am using the .NET datavisualization library to create some charts. The data is all time series based (ie, the x-axis is dates). I know that I can use custom date and time format strings to format the x-axis labels (formatting from[URL]..But what if I wanted to format the labels via a custom function that isn't provided in the .NET library?
To be more specific, is it possible to format the x-axis labels using the Quarter of the date? In other words:
I have a P/L chart which has a left scale (Y axis) which starts from a negative value. I want to format the axis labels (the major tick mark labels) so that the negative ones are red. Something like;
If cht.ChartAreas(chtarea).AxisX.MajorTickMark.Value < 0 Then cht.ChartAreas(chtarea).AxisY.LabelStyle.Font = New Font("Verdana", 9.0F, FontStyle.Bold, Color.Red)
[Code]....
Of course that doesn't work since MajorTickMark doesn't have a value property. How does one make this work?
I am currently reading a table from Access database and displaying it a DataGridView. Here is my
Dim ConnString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ....db1.mdb" Dim SQLString As String = "SELECT Cost, Average, FROM expense_summary"
[Code]....
All the files in my access data base are numeric (database cannot be changed) but I need to change the value formats in the table. I want to convert one particular cell in the table to a percent with one decimal and also display the '%' symbol. Similarly, I want to round and display a '$' symbol in another cell. How would I do that? How would I select a specific cell in this table to change?
I have a datagridview populated using a csv file. I have a column named Date. The csv file has mixup of different date formats. So I need the date column in datagridview to be in standard "MM-dd-yyyy" format. I used below code
Me.dataGridView1.Columns("Date").DefaultCellStyle.Format = "d"It didnot have any impact. So I used the below shown code Me.dataGridView1.Columns("Date").DefaultCellStyle.Format = "MM-dd-yyyy"Still no effect.
When I use the code Public Class Form1 Private Declare Function GetAsyncKeyState Lib "user32" (ByVal vKey As Integer) As Integer Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load [Code] ..... I get an error saying that the cursor format may be wrong. It is a .cur which is the standard for cursors. How to rewrite this so when GetAsyncKeyState(1) then the computers cursor will change to the currentcursor.
I need to format a Label to show numbers in a certain way. I had asked this before about textboxes so I looked into that first but it didn't do what I wanted.
I want to convert a military time was is in a textbox and convert it into a label with a standard 12hr time with a.m. and p.m. Ex: textbox -> label 0500 -> 5:00 am
HTML Private Sub btnFormat_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFormat.Click lblStart.Text = Format(txtStart.Text), "hh:nn") lblEnd.Text = Format(txtEnd.Text), "hh:nn") End Sub
Everywhere I look they keep saying to use the format() function but maybe I am missing something.
This code creates the chart, and extracts the formula from the trendline. The problem is that the trendline "DisplayEquation" label is formatted as General. In Excel it's easy, just right click and select format. But I can't make it from VB. I thought that:
I'm creating a VB app that uses the Infragistics UltraGrid to display data from 2 JD Edwards files. Before the data is displayed, first I need to convert 2 date fields that are in JD Edwards Julian date format (i.e., 111158 for 6/07/11....the 158th day of this year) to mmddyy format.
MCTS: Web Apps, MCTS: Windows Apps, MCTS: SQL Server 2005, MCP: Windows XP Professional, A+, Network+, Linux+, Security+, Master CIW Designer, SCJP
I am using VS 2005 pro and VB.NET. How do you format the DataGridView.DefaultCellStyle.format property for zip codes and phone numbers. I have a zip code and phone number column(s) that I want to be formatted. I have tried a lot of different things:
Zip code: "99999-0000" or "Phone Number: "(999)000-0000" or "(000)000-0000" and the like So far nothing has worked. I can get my date columns formatted correctly, but not these. Can any one give me some examples that work?
I need to take a string formatted like '010711' (DDMMYY) and put it into format '01-Jul-11'. Ive thought about doing something like string.toArray and then having some conditionals that format from there but am looking for an easier way.
When retrieving rows from an SQL Server table I use the following code select mydate, Customer, Details from sales where mydatetime >= '" & format (somedate, "MMM d, yyyy h:mm:ss tt") & "'"This works fine unless the clients computers windows Region setting is 'English (New Zealand)'The default time format in windows Region and Language for New Zealand is [code]On computers with this region setting I get an SQL Error 'Conversion failed when converting date and/or time from character string'..If I manually select the other option for AM symbol, PM symbol in Region and Language i.e AM PM the all works fine again..What format string can I use so that above code always works, even if the Region time format is a.m. / p.m.
We are designing the GUI of a microwave where a user can hit the numeric buttons 0-9 and create the time they want their item to cook. I have everything complete and ready to be submitted, but the only thing left is getting the label that displays the entered time to look like it is in a clock format.
Right now you enter the digits and it puts them like this: 95959
I am trying to get it to always enter it like this: 9:59:59
The bottom line on a dropped-down datetimepicker shows the date different then in the text-part.In my case, the text-part format was yyyy/mm/dd, but the bottom part of the dropped down part stated Today: dd/mm/yyyy, what is probably the format set in the regional settings.
In India and other Asian countries money is formatted as following:The first three digits grouped in three then all other digits are grouped in pair of two.eg : 2,54,255.12 5,22,54,255.12 etc string money = String.Format("{0:#,##0.00}", 254255.12);
All of my regional settings in control panel are set to UK but when I retrieve a date from an SQL database (run from my PC) in my program, it appears in the MM-DD-YYYY format rather than the DD-MM-YYYY format that I expect.
After a bit of troubleshooting I found that this is because of the fact that SQL server always stores its dates in that format - so then when my program reads the data from the database it interprets it as being the US format.How can I convert this to UK format bearing in mind I am working with Date objects not strings?
I am trying to do a custom date format in VB.net using Format. The data coming in is "2009-10-03 00:00:00.000" and I want it to be "OCT 03 2009 12:00AM". I am using Format(object, "MON DD YYYY HH:MIAM") and am getting screwy results ... "2006-09-17 00:00:00.000" becomes "9ON DD YYYY 00:9IA9".