Parse DateTime Without Allowing Default Values?
Apr 20, 2010
I currently receive spreadsheets from clients which include several date fields. Since these are coming from many different sources, the date formats can vary widely (although they will all be US format). It could be "April 19, 2010", "4/19/2010", "2010-04-19", etc. I would very much like to use the DateTime.Parse function rather than having to write my own parsing function--I don't want to have to write out every possible combination of date strings.
The problem is, the DateTime.Parse function includes default values if all values are not supplied. So if the field comes in as "03/2009", since no day was specified, the function will return a datetime equivalent to "3/19/2009" (today's day along with the values given). I cannot use this. If a client provides a date that is incomplete, my program must produce an error, not fill in default values for them. Is there a way to tell DateTime.Parse not to use default values? Or perhaps there's another function that can parse multiple string formats into DateTime type without using defaults?
View 8 Replies
ADVERTISEMENT
Aug 25, 2011
I am very surprised to see the output of the function with the given value ,DateTime.Parse("08/19/2011 11:32"). I am using VS2008. Always it returns 08/19/2011 11:32 AM. and if the pass value would be 08/19/2011 14:23 then the output value would be 08/19/2011 02:23 PM. But sometimes it is returning 08/19/2011 11:32 PM for DateTime.Parse("08/19/2011 11:32"). Why?
View 3 Replies
Nov 18, 2011
Is the default format of ToString dependent on anything server related? Here's the issue: I'm testing and have tested an application on my local machine and ToString(), by default, is returning in a format of "MM/dd/yyyy hh:mm:ss tt", however on our server it appears to be returning as "dd/MM/yyyy hh:mm:ss tt" which the consuming application is not expecting and causing errors.
Dim uvExpireDate = DateTime.Now.AddMinutes(1)
Dim token = String.Format(fmtString, uvExpireDate.ToUniversalTime().ToString(), [various other params])
View 3 Replies
Jun 22, 2011
I have two textboxes on the screen. They are used for startdate and enddate. If the user does not enter anything in the textboxes I pass nothing (VB.NET) to the webservice. When the webservice receive it on the other end it shows the value "#12:00:00 AM" which I think is the default for the datetime field. Anyway, now I do not want to pass this value to Stored procedure since it will not work. How can I check before sending values to sproc that the value is not the default datetime.
View 3 Replies
Aug 13, 2009
I have a a few checkboxes that I want to be checked based on a value of columns in a table.So I have a table that has a date column and I run a search based on a particular date. Then I want to be able to go through the rest of the columns based on the selected date. But I need to be able to check individual values. Not sure if this is making sense. It is for a checklist. I want to click on a date, and it will auto populate checkboxes based on what was pulled from the db.
View 9 Replies
Jan 15, 2011
I am editing BINary file and i need to parse some values from it without corruption of file, unfortunately I was try everything, but I dont know how to parse it on the byte level. I know how to read, write, search bytes from files but not how to parse it.
View 1 Replies
Feb 23, 2009
I coded a class that scans an object and maps data from a data table into each one of the corresponding properties, it works very well, however I am not able to set the property of one of the child (coplex objects)
Public Class CntrConfHdr
Private m_CntrConfHdrID As Double
Private m_HeaderCode As String
[Code]...
I want to set the value for the child object TypeCurrency.TypeCurrencyID thus I set the value of the variable sTargetPropertyName to TypeCurrency.TypeCurrencyID but the application willnot work stating that the property can not be found.
View 1 Replies
Aug 16, 2010
I am fetching DataTime value of a SQL Database, LockDate. Dim diffDate As TimeSpan diffDate = DateTime.Now - LockDate minutes = Convert.ToInt32(diffDate.Minutes) hours = Convert.ToInt32(diffDate.Hours) Minutes value is showing incorrect values.
View 1 Replies
May 24, 2012
I'm tried creating an analog clock and I realized I was terrible at trig and gave up. So instead I'm just creating a digital clock. I'm having problems getting the alarm to go off. Lemme explain my layout, I have 3 comboboxes. 1 is for the hour, 1 is for the minute and 1 is for am/pm.
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
'The commented out variables are global
[Code]....
View 1 Replies
Sep 14, 2009
I have a string I want to parse. I could write the code to do so, but I figured that VS.NET has a parser that should do this for me.however, I can't find it. All the searches I do return info on how to parse numeric values in string form into real numbers. It would be nice if the MSDN search had some ways to allow users to enter more details than just search text and 3 ways to filter out irrelevant stuff. In any case, I also tried things like string.parse (nope - although I kinda figured this would be it.) I also looked at Enum.parse, but the code indicates that it works with arrasy of items, not strings.
View 5 Replies
Jul 26, 2011
I'm working on a project that's going to be deployed via .NET on Windows and via Mono on Linux; the same data needs to be exchangeable between the platforms, including where platform A is Little-Endian and platform B is Big-Endian.Where text is concerned, I know ASCII/Unicode is natively Big-Endian, so there's no problem with that.Where numbers are concerned, I know that byte arrays have to be reversed on Big-Endian platforms to store the data in Little-Endian format.But what exactly is the 64 bit value output from System. Date Time.ToBinary?Is this a number representing the number of seconds elapsed since Jan 1 1970, is this some kind of serialized attribute that outputs some DotNET-recognizable value, or what?Does this byte array need to be handled differently in Big and Little Endian environments?It never hurts to try. In a worst case scenario, you'll learn from it.
View 7 Replies
Mar 28, 2011
I have a problem when i am passing negative value to "AddMinutes" function.The problem occurring when i subtract a value from the "00:xx:xx".[code]When it is trying to subtract, it is throwing the "Un-representable DateTime" error.How do I do the subtraction of minutes in this scanerio?
View 3 Replies
Feb 24, 2009
I am using VB.net 2003 application program. I am trying to do a select statement whereby I'm searching between 2 datetime values that are being stored as datetime. records are stored inside Access. For example, I am searching between 2 datetime:
StartTime = 2/23/2009 9:00:00 AM
EndTime = 2/23/2009 11:30:00 AM
So I need to find all the records in between 9:00 AM and 11:30 AM on 2/23/2009.
strSQL = "select OrderID from Orders Where OrderDate >= ('" & StartTime & "') AND OrderDate <= ('" & EndTime & "') "
but i got the error showing below:
An unhandled exception of type 'System.Data.OleDb.OleDBException' occurred in system.data.dll
strSQL = "select OrderID from Orders Where OrderDate >= DATEVALUE('" & StartTime & "') AND OrderDate <= DATEVALUE('" & EndTime & "') "
But when I use DATEVALUE, it takes the date from the string and set time as midnight (00:00:00). So it returns no records between 9:00 AM and 11:30 AM on 2/23/2009, but I can see there are records. [Code]
strSQL = "select OrderID from Orders Where OrderDate >= TimeValue('" & StartTime & "') AND OrderDate <= TimeValue('" & EndTime & "') "
And when I use TimeValue, it returns the time from the string and set date as jan 1st. so it returns no records between 9:00 AM and 11:30 AM on 2/23/2009, but I can see there are records. [Code]
but none of the codes above is returning records between 9:00 AM and 11:30 AM on 2/23/2009, but I can see there are records. i searched and found all those examples. but that didn't work. Is there anyway i can search between 2 datetime values. i need to find all the records that lies between that time period (for example: between 9:00 AM and 11:30 AM on 2/23/2009).
View 16 Replies
May 23, 2011
I would like to be able to display null values in a datetime picker control. I am using one datetime picker control for both datadisplay and data entry. when I load the data from the database and if there is no date then the datetime picker control must be blank.
View 3 Replies
Aug 22, 2010
I have been dabbling in VB before and i played around wiht linq to sql back then but im wondering what i should go with here.I need to have a list of people.. They should all have their own id nr.
The people in the list are supposed to keep a record of values changing over time with a datetime stamp. (In my case its numbers from a test outcome of blood)You have to be able to add people and delete people. All records will be deleted too.A Chart will read information from the records and display changes over time in chart.I was thinking of doing it with linq to sql and i was kinda aiming at Creating datatables with id names from the script
Havent found a way of creating datatables from a script though..I was hoping for a solution like that.. And i was hoping id be able to search databasetable names.
View 6 Replies
May 28, 2010
I'm trying to create a Windows form application which uses a few data grid views to pull data back from a SQL Server database. I've managed to get the data back okay from the tables but what I want to do is filter that data dynamically based on values input by the user from a combo box and a date time picker. Each of the data grids display production data for a machine but the combo box and date time picker will allow the data to be filtered by shift and date respectively - how to I pass the values of these to the SQL query returning the data?
View 4 Replies
Nov 30, 2011
I am trying the following to select a long date, but becase the value is stored in SQL database as DateTime I am unable to return any results unless minutes and seconds match perfectly...I then tried to use 2 calendars and have the same issue with the DateTime format..
CODE:
View 1 Replies
Jan 13, 2011
I have a DataTable with two DateTime columns: "start_time" and "end_time".Now, I want to add a third column that calculates the difference between the two DateTimes. But I can't seem to figure out how. I've tried to set the .Expression-value to "start_time - end_time", but it says that "-"-operator is not allowed on DateTime.
View 4 Replies
Jan 5, 2009
i would like to know whether is there any ways of setting a masked value of "0.00" to a textbox? So when user input a value, let's say "200". The textbox will interpret it as "2.00". Similarly, if user enters "1000" it will display as "10.00".
View 4 Replies
May 29, 2010
i am developing vb.net windows application. i have a combobox. In that i added items in its properties as follows
<- - - select- - - >
school
hospital
office
others
when i run my application i need to display the selected item as "<- - - select- - - >" but it display empty.....
View 1 Replies
May 18, 2010
I've been getting "Connection forcibly closed" errors and in researching a resolution, I have seen suggestions to money with the following web.config options, which currently are not set in my web app. Before I change them, I'd like to know what they are currently set to. Can someone tell me how to read these values from .NET code, preferably VB.NET, though C# is fine.
[Code]...
View 3 Replies
Nov 23, 2010
A Windows service written in VB.NET is using the My.Settings namespace for simplicity. There are only three settings to read, and these are read within the constructor of the ServiceLauncher.
I am attempting to install the service as such:
installutil GID.ServiceLauncher.exe
And this is successful, however the config settings it is using are not the ones within the GID.ServiceLauncher.exe.config file, instead it is using the ones baked into the app as Default Settings within Settings.Designer.vb (marked with DefaultSettingValueAttribute). [The questionable wisdom of Microsoft not allowing a developer to ignore default settings is another question entirely].
How can I further diagnose this issue, and maybe force a reload of settings? I tried calling My.Settings.Default.Reload, however this did nothing. All settings are application settings, and only differ by "value" from those in the auto generated file.
I have successfully attached the debugger using System.Diagnostics.Debugger.Launch() and true enough, the settings are still the default settings.
In anticipation of the question, the background: The reason for requiring configuration settings is because this is a very straightforward service that simply executes an exe; and this exe is in configurable location. There are other reasons also, such as I wish to have the service name configurable without recompiling.
View 3 Replies
Jan 12, 2010
What is the difference between these two methods for defining property value defaults? [code] Is there a reason to use one method over the other for defining the default property values in a class?
View 24 Replies
Jan 9, 2010
I create a class "Planet" that can be inherited. One of the purposes of inheriting is to create a template with different default property values. Eg:
Public Sub New
MyBase.New
MyBase.ForeColor = Red
[code]....
Now, to stop the defaults serializing in the InitializeComponent method, there are 2 ways:If I've implemented the properties using the 'DefaultValue' attribute, and made them overridable, the attribute can be overriden with the new value.The problem with this is, there's no way to just make just the attributes overridable, as opposed to the whole property.I could implement every property with protected Reset'PropertyName' and ShouldSerialize'PropertyName' methods. However, this is a bit of a pain in the arse.Is it, generally, an important consideration to ensure that someone who overrides your base class has the ability to change the default values of a property?
View 1 Replies
Mar 15, 2012
How do you read the default values from the appName.exe.config file? My application only reads these values on first installation. Subsequently, it reads the updated values sitting in the user.config file.
View 2 Replies
Sep 1, 2011
I need some help with coding that is attached to a reset button. I need it to reset the form's controls (textbox,combobox,etc.. to it's default values, but I can find what to use. I've found information on clearing the values which I don't want to do. I just want to reset them as if the form just loaded.
[Code]...
View 8 Replies
Jul 28, 2009
I have in my database a table for Products with one field as Price. For each invoice i want to be able to change this default price, so in my table for Invoice Details I have made another field called Price1. When I am entering invoice details and i enter a product number i want my program to select the relevent default 'Price' and insert it into 'Price1' so that it will be editable and so it can be saved to my database.
View 2 Replies
Apr 13, 2010
Looking at the new VB 2010 features, I stumbled upon support for Auto-Implemented Properties.Since I'm working with C#, this seemed quite familiar, but I noticed that VB did add a feature I would love to have in C#: setting a arbitrary default value for the auto-implemented property:I really like the clean usage of auto-properties in C#. This would save us the effort of introducing a backing field and hooking it up to the property everytime we simply need a default value, thereby cluttering up the code unnecessarily.I was wondering why this wasn't introduced in C# as well? What could be the rationale for not doing this? Is a syntax discussion going on, or are there technical limitations to implementing this?
View 4 Replies
Jul 12, 2009
How do I reset My.Settings at run time to the initial default values. I want to do this after the app has been running and the user may have save changed settings. The intention is to reset evering to 'factory defaults' as opposed to the last saved value as done by 'settings.reload'.For example in the property below , I want to restore to the value to '90' as given in the default value. I want to do this for all settings.[code]...
View 4 Replies
Aug 5, 2011
If I delete the top row of my datagrid, or load a page without any data in the datagrid, I get a NullRefrenceException error. "Object reference not set to an instance of an object."suggest a way for it to only run the default values needed sub if a row exists in my datagrid, else ignore it?
View 6 Replies