How can i remove this in my crystal report . this value is showing if my date field in null . "1/1/1900 12:00:00 AM". I don't want to show thin is my report.I have two dates , case open date and case close date . if the case is not closed its showing this value so i want to remove this.I am using sqlsever.
View 3 RepliesI'm making a data application and using the data adapters, I created a query in the designer:
EmpActivities_TableAdapter.InsertQuery(IdTextBox.Text, ActivityComboBox.Text, DescriptionTextBox.Text, Cdate(adddate.text))
The question is how can I set the adddate to null or nothing and save it? I'm using SQL server for the data.
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
I 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]....
This video shows how to add validation for a textbox:[URL]..what about date ? I can't make it work for date.
View 2 RepliesI am working with calendar inside GridView using VB. I have some NULL date on the DDBB. I can fix the problem using EVAL, but when I try to save the date from the calendar, I got an error telling me that their is no @variable declared.[code]Everything is fine but I got: Must declare the scalar variable "@tDate" trying to save.This is beacuse I'm not using Bind, but with BIND I cannot run checkDate.
View 1 Repliesi have a datetimepicker with showcheckbox properties set to true..
when there is date in database, the checkbox is checked..
but when the database is null, the checkbox is unchecked..
here's the code:
Sub checkeddate() 'to set DateTimePicker.check (compare from database)
'if db is not null, then CheckBox is checked
If IsDBNull(DataSet.Tables("AssetMaster").Rows.Item(curPosition).Item(19)) = False Then
[Code]....
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 RepliesFix my code I am trying to put null in sql server through a function that is excepting _dtSWO.
If I set _dtSWO = Nothing it returns #12:00:00 AM# which throws an exception. The field is nullable in sql server I just want it to return a blank[code]...
I am using visual studio 2010. I have a text box bound to a sql datetime field.I have to be able to either set or clear the text box. I can set it to any date fine, but when I try to clear it I am unable to save the record.i am using the binding navigator to save.
View 5 RepliesI have some date fields that I want to not have any dates during a record creation. I figured the way to go would be to insert NULL. The way I'm going about it now gives me a Type mismatch error.[code]...
View 2 RepliesI have an ASP.NET application that crashes when a null date value is returned.
The code line is:
excelWorksheet.Cells("A" & xlRowCounter).Value = IIf(IsDBNull(dRow("sysdate")), "", Format(dRow("sysdate"), "MM/dd/yyyy"))
Error message:
ERROR: System.ArgumentException: Argument 'Expression' is not a valid value.
How would I check for a null date, and replace it with "" in my app ?
The user will select an entry in a gridview, which then redirects them to a form that is populated with the data from the selected row (thus making the gridview editable in a more user friendly way). Null values are accepted by the DB and I would like to show null date values as blank (or " ") in the corresponding text boxes. Instead I get the error:
Conversion from type 'DBNull' to type 'Date' is not valid.
Here is my code:
'preceded by connection code
Dim sqlcmd As String = "SELECT * from Master WHERE RecNum = @recnum"
'Dim sqlCmd As New OleDb.OleDbCommand("SELECT * from Master WHERE RecNum = @recnum", connection)
Dim FileCommand3 As New OleDb.OleDbCommand(sqlcmd, connection)
[code]....
In my table date value exist in the date filed. I want to remove the date value based on some condition. How it is possible? I used delete command but the entire row was deleted. I tried to update the date as null but it showing conversion errors.
View 12 Repliesi get the date value from other field then need to insert it into other database. but the problem is when the column is null the n it cannot insert it.
View 1 Repliesi have a maskedtextbox which will accept only date in the format of "DD-MM-yyyy" no i want to insert this date in my db. i have done this successfully.
Now i want to insert null value in through that maskedtextbox .
i need to pass null value but error dim drf as date
[Code]....
Dim Upd As String ="UPDATE sakit set tanggalsakit'" & drf & "' WHERE orang= '" & id& "'
I have a DataSet where I need to filter the collection where one of the date columns is not null.
How do you term this in LINQ?
This is what I have so far but there is a compiler error on the w.CompletedDate field in the Where clause.
Dim completed = From ins In InspectionDataset.Inspection.AsEnumerable _
Where (Function(w) w.CompletedDate IsNot Nothing) _
Order By ins.Field(Of DateTime)("UpdatedDate")
I have also tried it the below way but the compiler will not allow the DBNull comparison.
Dim completed = From ins In Inspection.AsEnumerable _
Where ins.Field(Of DateTime)("CompletedDate") <> DBNull.Value _
Order By ins.Field(Of DateTime)("UpdatedDate")
Attempting to convert a possible null value into date/time field. Any easy way ?
[Code]...
I have a FormView where I pull data from one table (MS Access), and then insert it (plus more data) into another table. I'm having issues with the dates.The first table has two date fields: date_submitted and date_updated. In some records, date_updated is blank. This causes me to get a data mismatch error when attempting to insert into the second table.It might be because I'm databinding the date_updated field from the first table into a HiddenField on the FormView. It then takes the value from the HiddenField and attempts to insert it into the second table:
Dim hfDateRequestUpdated As HiddenField = FormView1.FindControl("hfDateRequestUpdated")
myDateRequestUpdated = hfDateRequestUpdated.Value
'... It then attempts to insert myDateRequestUpdated into the database.
[code].....
My application is asp.net with vb. In my page I have a textbox for passing date. If I didn't enter date and on clicking submit, I have to pass null value to the stored procedure. I tried following codes such as DBNull.Value and DateTime.MinValue. In that case instead of null ,"#12:00:00#" is passing. I have to pass Null.
View 3 RepliesIm writing an app which connects to a SQL Server database, via datasources / datatable.When Im looking at my .xsd I can see DataTables containing DataColumns. Each DataColumn has a 'NullValue' property which defaults to '(Throw exception)'.Because I have nulls in my tables I have gone through the fields and set all System.String fields to NullValue = 'Empty', System.int32 field to NullValue = 0.
View 1 RepliesWith a Decimal, I use:
document.Air1 = CDec(IIf(Decimal.TryParse(Air1TextBox.Text, Nothing), Air1TextBox.Text, "0")) to fill the column with there is no value.
I would like to do something similar when the date is blank (preferably with NULL or just plain blank):
document.TestDate1 = CDate(IIf(Date.TryParse(TestDate1TextBox.Text, Nothing), TestDate1TextBox.Text, " - - ")) - of course, this throws an exception.
The table Data Type is date.
I need to check if a value from a date column is equal to null. I can't find how to do it.
Wat I got now is:
if ds.tblBooking(row).CancelledOn.compareTo(dbnull.value) = true then
But this doesn't seem to work, I think it's because I'm using a strongly typed database.
I want to create a custom date type. I want to allow null values, and return a string to the user if no date if specified.
View 13 RepliesA stored procedure returns data about a user record including a nullable datetime column for their last login date. Which one is the better choice in dealing with the possibility for NULL values when trying to assign a .Net date variable?
Try
_LastLogin = CDate(DT.Rows(0)("LastLogin"))
Catch ex As InvalidCastException
[Code]....
Which is the preferred method of handling possible NULL values from the database? Is there a better way than the three listed?
Edit #2: I have noticed that the TryParse method does not play nice when trying to assign to a Nullable type.
I have the following code to bind data to my form controls:
dateFromDate.DataBindings.Add("Value", dvUpdateCME, "From Date")
dateToDate.DataBindings.Add("Value", dvUpdateCME, "To Date")
[code].....
In every date field I have, I cannot update it if it is null. For instance, I have the following query and it will throw an error if the date fields are Null or zero lengths. Any ideas? I try and parse and get the following error: String was not recognized as a valid DateTime. if i don't, it throws a null error.[code]
View 7 Repliesi'm not 100% sure about sql server but i think it doesn't accept null value for date type columns but in oracle, a date column can accept a null value. and since i'm using oracle, this is causing some problems because in my form, a textbox item bound to a date column will not accept a null value. reading thru some threads, it would seem that it is not possible to pass a null value to a date type in .Net.
[Code]...
I have the following
If Trim(txtConfirmationDate.Text) <> "" Then
sqlinsert2.Parameters.AddWithValue("@CONFIRMDATE", CDate(txtConfirmationDate.Text))
Else
sqlinsert2.Parameters.AddWithValue("@CONFIRMDATE", VB.vbNull)
End If
Unfortunately, it writes "01/01/1900" to the database. How do I get it to just leave the field as NULL?