I am retrieving some data from the db and using an sqldatareader to read the data. I have a date column in the table which i am retrieving in the following mannervb Dim d as DateIf Not reader.IsDBNull(10) Then d = reader.GetDateTime(10) Else d = ???
View 5 RepliesI was wondering what is the best way to make sure a date is 'empty' so that, if it hasn't been set by the user, that situation is testable.
I've checked and found one way of approaching the issue:
[Code]....
Is the second one more of a stop-gap measure? Is the first way the sanctioned way (which hopefully doesn't entail a lot of complication with testing/setting the values of the date)?
I've got a new instance of an object in a Linq DBML, but don't know of the test if the a date field is empty.I have tried:
If d Is Nothing OrElse IsDBNull(d) OrElse d <= Date.MinValue Then
TextValue = "nada"
Else
TextValue = FormatDateTime(d)
End If
But the result is "12:00:00 am"
edit: Changed variable name the d
edit: note that the SQL field is nullable
i have a date control on form (vb.net) and by default its value is current date. i want to make its value to null or empty so that no date is shown and user choose from the drop down date calendar.
View 9 RepliesI'm trying to do some validation testing in VB.NET. If Entity.WeekEndDate.ToString = String.Empty Then ErrorList.Add(New cValidationError("id", "Incorrect Week End Date"))
Where WeekEndDate is of type Date. When I originally build the object, how can I insert a value into WeekEndDate that will generate an empty string(ie. "") when converted from a Date to a String?
I have a report parameter which looks like this: 01.01.2009 00:00:00.Its a date (as string), as you might have guessed :). The problem is, this param can be an empty string as well. So I tried those expressions:
=IIf(IsDate(Parameters!DateTo.Value), CDate(Parameters!DateTo.Value), "")
=IIf(Len(Parameters!DateTo.Value) > 0, CDate(Parameters!DateTo.Value), "")
Both dont work and the value for the textfield where I print the expressions result is always #Error. As soon as I remove the CDate stuff, it works, but I have to use it. IS there another way to achieve that? What I want is to display nothing if its not a date or the date (format dd.mm.yyyy) if its a date.
I am trying to deserialize an Xml file content into a specific object. Everything runs fine but when I include empty tag of type date or time in my xml(having xsd that describes my xml structure) the deserialization fails. What can I do to make deserialization working when empty date tags are appear?
View 1 RepliesI have an Sql server 2005 table called Emploeefl with 2 fields, EmployeeCode and Date of Birth. The data type for the date of birth is Datetime. I have a Date time picker on a vb.net 2005 form called dtDateOfbirth. When I click on the save button I get the error message "Conversion from string 'yyyy/MM/dd' is not valid. Below is the code
Dim newQE_Date As Date
newQE_Date = Format(Me.dtDateOfBirth.ToString, "yyyy/MM/dd")
'newQE_Date = String.Format("2008/09/10", "yyyy/MM/dd")
[Code]....
there, im doing a leave management system with vb 2005..and here's my problem -how do i 'find' the expiry date?? eg: from the datetimepicker in my form, if the date i select is 1st january 2009.....how do i type the code to find the expiry date 1 year later (which is 1st january 2010) and display the date in a textbox in my form???
View 1 Repliesi have 10 of empty row which doesnt not have any data, this is happen because i click to many insert button insert data. Please show me the coding should i use to delete my empty row. For you info i have table name is Bundle and 2 column which is name and type .
connection.ConnectionString = " Data Source=Danawa;Initial Catalog=Store;Integrated Security=True"
Try
connection.Open()
[code]....
In my application I load a CheckedListBox from text file apart from looking at the form, how can I trap the error of not completing the action?
View 1 RepliesMay I define an empty node in a XML file then do something?
Dim ReasonNodeList As Xml.XmlNodeList = SomeNode.SelectNodes("./REASON_CODE/REASON")
Dim CReasonNode As Xml.XmlNode = ReasonNodeList(ReasonNodeList.Count - 1)
But maybe this node doesn't exist, I am not sure is there any error occurring during the running.Except the error of length of NodeList.
I am using TextFieldParser to Read a Tab Delimited Text DataFile. The problem I have is that some times the data file (3rd party provided) contains an extra Tab which therefore creates an extra column. I need to remove this unnecessary column. Some columns will have rows that are empty so I cant just delete the column if it has a blank row, So I think I need to loop through each column and if if every row is blacnk then delete that column.
Here is the code that reads the file, I was going to remove the column from the table called table before I populate the table called dtAll , which is what my program uses
Dim safeFileName As String = IO.Path.GetFileName(Me.OpenFileDialog1.FileName)
Using myReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(safeFileName)
myReader.SetDelimiters(vbTab)
Dim currentRow As String()
[Code] .....
what is code i should use if i want to prevent user not to leave empty word in text box after user click save button.Oh ya, i am using visual studio 2005, databse sql 2005 .Here is my code
Private Sub btnregister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnregister.Click
If MsgBox(" Are You Confirm", MsgBoxStyle.YesNo) = vbYes Then
[code].....
I have a date in the future e.g. 13/10/2008 I need to subtract the current date (today is the 28/09/2010) minus 7 days, so thats 21/09/2010 minus 13/10/2008, which would equal erm, 720 something ? But the current date won't always be 28/09/2010, obviously. I need the code for this. EDIT: When i said future I mean past :)
View 3 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 RepliesThis is my database: Here is my
[Code]...
i want to format a datetime column like4-mar-10 9:15 pm
View 1 RepliesI Want To Insert Date Into Sql 2005 But Without Using Datetimepicker In Vb Net 2005 forms every time i do it by using textbox got an erro converting iwant to use textbox like we use it in access with input mask is that avilable
View 1 RepliesHow to validate the Date format "MM-yyyy" irrespective of the culture datetimeformat
View 2 RepliesI have a Login.aspx page where if the user has the 'Remember Me' checked then it stores their username in a cookie for a year so whenever they hit the login page (session timed out, or they clicked logout at some point) the username is pre-filled. The pre-filling is working fine, in fact it works every time. The flip side is if they login and the 'Remember Me' isn't checked, then that cookie (whether it exists or not) needs to go away. The going away part never happens, even though I'm expiring the cookie. here's the cookie name, at the top of the form:
[Code]....
I have the following function that checks if a date is on a holiday or weekend and returns the first non-holiday or weekend date.
vb.net
Private Function CheckDate(ByVal D As Date) As Date
TempDate = D
[code]....
The function does return a date. But when I try to assign it to variable, it assigns a time instead. Both tempdate and newdate are declared as date also.
vb.net
TempDate = CheckDate(NewDate).Date
I have one hour format datetimepicker and other short format datetimepicker. When I select an hour from 1:00 AM to 5:00 AM want to change the current day to the day before. I tryed to - 1 day but doesn't work or maybe isn't the correct way to do it.my error says operator '-' is not defined for types 'Date' and integer
here's my
Dim hora As Date
Dim fecha As Date
hora = Me.dtpHora.Value
fecha = CStr(Me.dtpFecha.Value)
[code]....
I am developing one web application using VB.net. This applicaton this site is actually meant to fetch the details of the active directory users. When i enter the user id in the text box and press enter it should give the complete properties of the user account. This includes : Account Creation date, modification date, password last set, user cannot change password, user account expiry,user must change password at next logon etc. I have done almost all the things. but still i am not able to read the following properties : Account Expiration date, User cannot change password,user must change password at next logon.
View 1 RepliesI have tried to use a masked edit box for this but the highlight does not seem to work. Is there a better way for entering dates. I want the user to enter the date without entering the / symbol and enter it as dd/mm/yy then format it to dd/mm/yyyy. I also want it to be highlighted when they give the control focus.
View 5 RepliesI am encountering an error in the following statement:For i As Integer = 0 To dtAccess.Rows.Count - 1 If dtAccess.Rows(i).Item("YMD") = dateval then dtAccess is a datatable where the column YMD is of type string.dateval is a variable of type date. Now here is the anomaly. The first ten rows works fine during the loop execution. However when the 11th row is encounter I get the following error:"Conversion from type string to date is not valid." My question is that if it is not valid then why it worked for the first ten rows? My second question is what can I do to overcome the error?
View 2 Repliesi have the following setup What i am trying to do is, when the user clicks on the 'calculate age ' button it must calculate the age and display the result based upon the selection in the combobox i.e if 'Days' are selected then it must display in days, if weeks are selected then it must display in weeks..etc
Similarly when the user clicks on the 'convert to date' button , it must subtract the given days(or weeks or months or years) from Todays date and set it to the maskedbox
I have trouble with my vb application.I create query in dataset like this :Select * from Trans where year(dateTrans)=2009 and month(dateTrans)=5But is not work and error message : year and month function not identified, what is the problem ? what a sql date function ?If i create databound from dataset and drag n drop date field in form with datetimepicker control, if i had update dataset, date field is empty.Whats wrong with datetimepicket databound.
View 5 RepliesI am trying to format a date to ShortDate and having some problems doing it. The date is not changing, regardless of the format option I use. [code]
View 2 Replies