I export some data from a MSSQL Database (2005) to a simple Textfile. The Problem I have is, that if the Field contains a Date it is converted to a different Format, but I definitly don't want this. How do I prevent from formatting to another Format.
[Code]...
My user wants to have textbox fields that don't have any masks but wants those text fields to reformat any text that is entered as mm/dd if it is a real date entered
View 5 RepliesI have this sql server query that I am running in my .net app.[code]...
Any date that has e in the middle such as 20120731*e*0000001 turns into scientific data.
I have a column in a datagridview which is populated with a string. Can I format it to financial type format? Here is what I am trying, but not getting it.[code]This is not working so how should I go about doing this? All I am getting is right justified values.
View 3 RepliesMy user wants to have textbox fields that don't have any masks but wants those text fields to reformat any text that is entered as mm/dd if it is a real date entered. They won't be using the year.
View 10 RepliesI am throwing some data out into Excel and am having some formatting troubles. I have 5 columns (date, time, a long number I don't want displayed in scientific notation - text is fine, text, text). I can get it all working with numberformat, however I have to do them different ways.
Date works this way cell.numberformat = "m/d/yy" and it formats it to say 3/1/11
Time works this way cell.numberformat = "h:mm AM/PM" and it formats it to say 8:07 AM
For the long number cell.numberformat = "@" and it doesn't change the format and it gets displayed in scientific notation
BUT if I use cell.style.numberformat = "@" it works as it should, but it messes up all of the date and time cells. Apparently when you use style.numberformat, it doesn't just apply to the cell you're working with. If I try using style.numberformat with the date and time formats, they don't change and are entered as if I didn't change the format at all.
I have some VB .NET software that interfaces to a load of old (but sound) COM objects. The VB provides a GUI for the COM objects, part of which consists of setting various options on the COM objects - several of which relate to string formatting.I have a simple pair of VB .NET functions that convert basic %f, %d, %g formats to/from .NET equivalents using a large select case covering specific common strings, but they don't cover all formats.[code]Before I start diving in and making it more versatile with some parsing, does anyone know of a class (eg VB or C# .NET) that provides a decent ready-made implementation? Or perhaps some regexp wizadry could be used?
View 2 RepliesWhile I understand there are properties of MailItem that would allow one to programmatically create a formatted email, I would prefer the ability to copy the body of an email that is already formatted to my liking (bolding, italicizing, embedded pictures/tables, set margins, etc.) copy and paste it to a newly composed email such that this formatting is preserved.
View 4 RepliesI'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.
[code].....
Im looking for a class or code in VB.NET that can convert a black and white image in JPEG format to a grayscale TIFF format.
View 2 RepliesI'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.
View 5 RepliesWhen 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.
View 1 Repliesformat Gridview's unbound column in 12hr format? i tried the following code, it didnt work.
[Code]...
I have a DGV that is getting data from a sql db. The dates in this db are stored as doubles ie 40025.708681
How do I format this column as Date/Time?
I tried but this doesn't seem to work.
how to do this? DGV1.Columns("HostDate").DefaultCellStyle.Format = "d"
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.
View 5 Repliesi just started usign Vb two days ago, as it was required for work and i just wondered how to change the format of the total into a money format
View 3 RepliesHow to convert jpg format into binary format using VB code ?
View 3 RepliesI want to format the Timespan to have format like this 49 hr 34 mn 20 sec
I used the String format below :
String.Format("{0:00}:{1:00}:{2:00}", theTimeSpan.TotalHours, theTimeSpan.Minutes, theTimeSpan.Seconds)
It formats the Timespan to this format 49:34:20. How can I add hr mn sec to the String.Format above? or there's another easy way?
How would I format txtLabel.Text to a currency format?
The text would be 15000000
I would like the text to show $15,000,000
How to format drive in FAT 16 format using VB.NET without user interaction?
View 1 RepliesI am using String.Format("{0:C2}", -1234)to format numbers.is always formats the amount to a positive number, while I want it to become $*-*1234
View 4 RepliesIn 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);
gives the output 254,255.12
but the output required is 2,54,255.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?
How to convert eps format to jpg images in VB.NET?
View 3 RepliesI 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".
View 2 Repliesi 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"
View 6 RepliesMyRow = MyDT.NewRow()
MyRow(1) = rs2.Fields("Field29").Value.ToString
rs2.Fields("Field29").Value has values like "YYYYMMDD" in a string.how can i convert a "YYYYMMDD" string to a needed date format like 'dd mmm yy' (or any format)
This the test example.
Dim dt As DataTable = New DataTabledt.Columns.Add("StartTime")dt.Columns(0).DataType = System.Type.GetType("System.TimeSpan")
[code]....