I want a simple textbox that automatically formats itself for money with this format 0.00..first digit: i can put on it any number of digits like this: 1324654879.00...second and third digits after the decimal put on them only 2 digit like this: 2136459874.12
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'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.
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.
I have the following: MakeCmd$ = "SY" & 0 & (size% + 1) & Data$ & chk%. This creates SY0387142, this relates to, SY,0,3,87,142.
I want put this in a textbox in hex format. I have tried various methods, such as 'CmdData1.Text = CmdData1.Text + Format(Hex$(Asc(Mid$(CmdStr$, Count%, 1))), "0#") + " " But this does not work correctly.
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".
i see that i can use defaultcellstyle.format to format a column but what if i have an number stored as a string "0511" and i want to display it as a integer "511"
I have a textbox in my form where the individual will enter the date (not necessarily todays date). How can I set a format so if the individual enters 040912, it will change to 04/09/12?
After experimenting around with DevExpress controls and adding them to my form, Custom mask do not seem to work on the MaskedTextBox. If I place a custom mask and debug, I get a null reference exception.
It seems to be the maskedTextBox's mask property that is doing this. I have tried setting the mask through design and by code. However, neither way works.
My question is, is it possible to use a TextBox as a maskedTextbox? To be able to format it? I need the user to enter in hours, minutes, seconds like hh:mm:ss or 00:00:00.
Here's the error I get:
"NullReferenceException was unhandled. Object reference not set to an instance of an object."
I have a form in VS 2008 where I have some textboxes to display som calculations. Is there a way to format the textboxes to display det numbers with 2 dec. like 2.34???
I'm trying to create a textbox that'll only accept a value in the 24 hour format (i.e. "18:00" or "1800"). I've been reading up on the FormatDateTime Function but I don't know whether thats appropiate...
Also, how do I set a textbox to be fixed with two decimal places? On VB6 I could do this in properties, but I can't find an option ni Visual Basic Express 2008.