i use ar-SA culture in my app and the date appeared correctly then i save this date to db and i look at the db i found it in English format how to save in the format like it was appeared in my form ?
View 1 RepliesThe issue is in a windows based client-server application.In the GUI, the system date value is converted to string and is stored in a text box, which is displayed while the dialog gets loaded.How to change the format of date so that when the form loads the date is displayed in en-US culture irrespective of the regional setting of the system(for eg: regional setting of the system is "fr-FR").
View 1 RepliesHow can i check the system date format? Tried with the code below, but when i change my system's date format to another date format to test the code, it's still showing the date format before changed!
System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern()
I am trying to convert the current date to the following format YYYY-MM-DD but everytime I do so the month comes up as 00 (ie 2011-00-19).
When I check with the debugger, "today" comes up with #7/19/2011#. Could the # be causing the issue?
Code I am using
format(today(),"yyyy-mm-dd")
My current program is reading a XML doc and using it then moving it to a different directory to be archived once it is finished using the xml.
I want to be able (upon completion) move and rename the file to a new folder, I want the folder to be the current date/time as well.
So basically have 4/4/2011 9:56AM.xml in the folder 4/4/2011 9:56AM.
getting the function DateTime.Now in a format that can be saved. Folders and files cannot contain the " / " or " : "
A more Sql server type of date would be fine like 24-Jun-89 13:32:22 but I don't know how to get something like that.
I'm learning about the cultureinfo and doing ok but there is one thing I can't work out.I'd like to know how to find out the display settings of the date for the user pc.For example, I have an American bought laptop using the us culture so the date will be MM/dd/YY but I have changed the date setting to read dd/MM7YY. So that means I haven't actually changed the inbuilt cultureinfo, I've just "altered" a setting and it's that setting I want to access. When my project starts I have a label that I want to read as dd/MM/YY.With another pc it might be different - the culture might be uk but the date setting might be changed MM/dd/YY so I want the label to read MM/dd/YY etc etc etc.If the cultureinfo hasn't been changed then I want the label to read whatever the date is set to etc.
View 1 Repliesexample: inside regional date format setting i set "Short date format dd/MMM/yyyy" and inside vb.net program i set "strSQL = strSQL & ",'" & Date(Date.Now.ToString("dd/MM/yyyy")) & "'" ----> working fine. if user changed the regional date format setting to other format like "mm/dd/yy" facing problem during saving record into sql table. error date conversion. It's possible to avoid using computer regional date format from vb.net? or have any other way...
View 2 Repliesi am trying to insert date in dd/mm/yy format in sql table from a textbox but everytime the default date 01/01/00 goes in table.
View 19 RepliesI am working on a project inwhich I want same date format in all project forms. I want to use a form for setting/resetting date format for whole project. whenever I will change date format in this settings form, there should be this new date format available in all forms. how can I implement this?
View 8 RepliesHow do I calculate relative time?How do I calculate someone's age in C#? Anyone know how of a function in VB.NET or C# that will take two dates, calculate the difference and output that difference in an english string? For example if I pass the dates '3/10/2009' and '3/25/2009', the function would return the string "15 Days" or if I pass the dates '3/10/2005' and '3/15/2007', the function would return "2 Years, 5 days"
View 3 Replieschange "Date" from English to another languages in Vb 2008 or 2010.
Before i have used...
Private Sub Form1_Load(Byval......
Timer1.Interval = 500
Timer1.Start()
Private Sub Timer1_Tick(Byval....
[Code]....
I want give a date from user to string Such as "2011-10-11" and for example my system date format is : dd/mm/YYYY
How can i convert 2011-10-11 To Default System Date Format ( In My Example : 11/10/2011 )
40469.55139
40469.63333
40471.49792
[code].....
these are dates. They have been given to me by data dump into and xls. I am reading in the values into my app and need to run date calculations on them.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('50a20615dc044866b18b3cab643fdc42')
I'm facing a major problem with a Deployment Project I created to install one of my applications.I am using the ENGLISH IDE of the Visual Studio 2008 - even though my end users will have German environments. This is why I set the
Localization = German
Property in the Deployment Project's Properties. The UI of the generated setup is German, so all's fine there. However, the setup installs the ENGLISH .Net Framework. I have not found any way around this.The problem are at least twofold:
1. An English Framework on a German PC might cause instabilities.
2. It's a big flaw to see UI inconsistencies (i.e. the UI and Setup of the application is German while the NET Framework shows certain elements in English, e.g. the DisplayName property of cultures)how can I get the project to install the localized .NET Framework?
I have multi language application where i am using "en-US" and "ar-KW" languages.I also have WinForm where I am using the DateTimePicker control.When the user logs in, if his default language is "en-US" it saves the record but when he has default language "ar-KW" then this date format is not saving in database, and produces an error. Why?
The datatype of the Employee DateOfBirth field is smallDateTime in SQL Server.I am using the following code in VB to save the record. There is a normal INSERT stored procedure in the backend.
[Code]...
I'm fairly new to ASP.NET & VB.I've been asked to take an existing textbox that is automatically filled with the current date and allow the user to either add a "+" or "-" and a number or a spcific number and convert that into a date.I underdstand the basic concept on how to do this, but I'm running into some problems using the proper commands in order for this to work.The Textbox is called txtDate.What I've tried to do is this:
If txtDate = '+' Or '-' Then
DateAdd("d", txtDate, today)
End If
Here is what the whole thing looks like:
Protected
Sub
DateEnter_Click(ByVal
sender As[code].....
I'm trying the fetch only the date within the current and return how many rows Dim dc as new dataclassesdatacontext dim q=from p in dc.worktime where p.name.equals(session("name") and p.date ).count what I should I put after "p.date" ? And if I want to search for the record which there are record that are insert five days earlier, how to do that ? use (datetime.now - 5) ?
View 3 RepliesI'm trying to access a database which is presently saved in .cds format (which I believe is a TClientDataSet) from within my programme written in VB.Net. The reason being, is that the programme I am writing uses the same database as another programme. Both programmes will never being running at the same time, and it is a read-only operation so I could potentially duplicate the database and convert the database to an SQL-compatible format, but obviously this isn't a tidy solution.Is there anyway that I can directly read data from the .cds file with VB.Net? It seems like this would be something that is not too complex and wouldn't be too different from just reading a .csv file.
View 3 Repliesi'm writing a simple program that outputs a report to a text file with code similar to below PrintLine(1, "Hello", "World") my question is how to format the text so it can be saved as courier new or bold? frustrated visual basic user
View 2 RepliesI'm trying to compare the modify date of a file vs the current system date. I've found an MSDN article describing how to get the modify time of a file:
Dim infoReader As System.IO.FileInfo
infoReader = My.Computer.FileSystem.GetFileInfo("C: estfile.txt")
MsgBox("File was last modified on " & infoReader.LastWriteTime)
This gest the Date and Time, but I want just the Date not the time.
how can I create following thing with Visual basic?I would like my excel to check the date value in a cell and compare it to current date and if the value in the cell is older than 2 months compared to current date it would change the cell's colour.
View 1 RepliesI want to simulate a way to "force" the ASC function to use the english codepage, even on a system having the "language for non-unicode" different than English.[code]On a system having "language for non-unicode" set as English, currently the result is 140..On a system having "language for non-unicode" set as Slovakian, currently the result is 79..The twist is I CANNOT user AscW (for reasons I cannot disclose)In the particular example above I would need for the code to always return 140.If there's a way to force the whole program to use the english code page I could work with that as well.[code]
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 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 RepliesI 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"
How can I printscreen my screen that can be saved in gif or jpeg format locally in VB.net
View 1 RepliesMy problem is probably ignorance as to how the DGV works, anyway, the problem.I have a bound datagridview which is used to collect user input. Data for 3 of the 7 fields is entered by looping through the rows and progmatically entering common data anfter a 'Save' Button is pressed:
For I = 0 To DG1.RowCount - 2
DG1.Rows(I).Cells(4).Value = TextBox1.Text 'Operator
DG1.Rows(I).Cells(5).Value = TextBox2.Text 'Date
DG1.Rows(I).Cells(6).Value = TextBox3.Text 'Time[code]....
At this point the DGV looks the way it should...All fields completed correctly and no un used ro except for the new row.After saving :
Me.ItemTableTableAdapter.Update(Me.StockMoveDataSet.ItemTable)
The 'Operator', 'Date', and 'Time' are not saved to the database for the first row only
I am attempting to import data in a batch from an Excel Worksheet to a Sql Server database. Everything works except for the one date field in the spreadsheet. The date returned is off by four years from the value in the spreadsheet. Example: The Excel sheet has a date 10/24/2010 14:18, but when I look at the column in my query, the date is 10/23/2006 2:18. This pattern, 4 years and 1 day earlier, is repeated for every row in the worksheet.
The Excel column comes to me as a custom type, formatted m/d/yyyy h:mm. I receive this from an outside vendor and having them change the column is not going to be my simplest solution.
For what it's worth, the relevent part of the query is:
Select [Date Created] From MyWorksheet
When I looked at the database record, the datetime saves like this: 4/6/2012 04:42:28 PM
because I've save it using dbtype.string
Now, I'm getting the date only, not including time, this is my code:
Private Sub getpapererror(ByVal ddate As String)
Dim sqlstr As String = "select * from perror where date(ddate) = $xddate"
Dim sqlcmd As New SQLiteCommand(sqlstr, mycon)
[Code].....