Using VS2008, c# and ODP.Net(2.111.7.20)
In the following procedure a_end_date may or may not be null.
If the input string is null, I tried to set a_end_date to null.
It is giving error.
The same result if I try to set it to dbNull.
How do I set null to a date field
public string InsertOnlineApplication(
string a_start_date,
string a_end_date,
[code]...
Oracle Date Formating Null date as 00/00/0000
View 3 RepliesI use VS2005 on Oracle 10gR2. Using
(System.ComponentModel.DataObjectMethodType.Update,
True) to update database row that returns null values from date and numeric columns,Whenever i try to update same row with null (or empty) values on both date and numeric columns, it results in sending '01-Jan-0001' for date column and 0 for numeric column. I want the user to have the options of null or corresponding values for the update.
Using MySQL 5.
In my SAP.NEt project, defined a constant:
public static DateTime NullDateTime = DateTime.MinValue;
I have a function:
protected static DateTime GetDateTime(DataRow row, string columnName)
{
return (row[columnName] != DBNull.Value) ?
Convert.ToDateTime(row[columnName]) :
Globals.NullDateTime;
}
In the source code:
public DateTime StationFeedTime{ get; set; }
StationFeedTime = GetDateTime(row, "StationFeedTime");
I ran a SQL to fetch records from MySQL, this field is Time field in MySQL.
Got an exception inside the function:
Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.
I am using mysql and stored date in varchar format, and compare that with current date,i have stored like(dd-mm-yyyy) in database
i need to compare it with date in select query. How to take date from database in dd-mm-yyyy format.
We have a chart on a page that current is hard coded with test data, client likes and we are trying to now link to live data.I have tried different things in the code behind to build the url and keep getting Null Reference Exception even though when i debug the url is there and complete. I can take the value that i get in debug and paste directly to the browser and the chart works. so i know that im building the url correctly, but setting the .Src of the image in the page_load event doesnt seem to be the correct way to populate the image..Here is the complete link that is built in the code behind that is passed to the src of the image control.http://chart.apis.google.com/chart?hs=300x265&chd=s:bD&chdl=DVDs|DVDs+with+Scracthes&chdlp=b&chl=44|5&chma=40,60,0,40&chtt=DVD+Report&cht=p3&chco=751010|FFCC33 In the page load event i have the following:
[Code]....
[Code]....
I place a break point on the line where i set the src and as i step thru everything is correct and the src is being populate with the correct link, but when i step past that line, then i get the null reference.Now why is it that i can paste that link to the browser and it works.. and if i hardcode that link in the image src on my aspx page and comment out the code behind it works there also..
I am trying to insert NULL value in oracle database using asp.net form. and its not inserting null value check my below code and guide me what changes I have make
Dim
cn As
New OracleConnection("Data
Source=ab; User Id=abc;Password=abc")
Dim SQL
As
String
'build the INSERT statement
Dim xy
As
New System.Text.StringBuilder
'Dim strDate As Date...............................
I'm writing a function in "Query Browser" to add some values to a table.
The function should get this value when the stored procedure is called upon, thus te code looks like:
INSERT INTO customer(customer_name, customer_city) VALUES (@customer_name, @customer_city);
But when trying to execute the function, it says "customer_name can't be null"
i thought maybe it just waiting for the values to be sent from .aspx page, but yet again, i get the same error message.
i dont know how to set the field to blank field instead of null
if i insert record, and don't input some field, then the field will display null
how to remove null value by default in mysql db.
(int) faultsGroup is 0 or 1 but i always get this error: Column 'FaultGroup' cannot be null Does anyone tell me why? Syntax looks ok.
[Code]....
I have a query that references many tables, however the main record doesnt necessarily have records in the other tables. In my formview itemtemplate, i bind the values of the query but I'm getting an obvious error when the value is null. This is what I'm trying to do: (the field is a boolean btw). These fields are hidden so I don't really care if it gets assigned a temp value or something.
[Code]....
Error: BC30452: Operator '=' is not defined for types 'Object' and 'System.DBNull'.
Why would i be getting NullReferenceException if im setting the labels with values?In my page_load i have the following:
Label hireMess = (Label)FormView1.FindControl("hireMess");
Label hireEnd = (Label)FormView1.FindControl("hireEnd");
HyperLink hyptry = (HyperLink)FormView1.FindControl("hyptry");
and right below that i have 1 condition to check for and then set the Text value of the 2 labels.hireMess.Text = "It Was Successfully!";hireEnd.Text ="You will be re-directed to your Pool in 10 seconds.";I compared the page to production and eveyrthing is the same and production doesnt have any issues.. not sure why its coming up null.The error comes up for the first label:Object reference not set to an instance of an object. Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Source Error:
[Code]....
In our web.config I am using the following tag to determine the interface language of an ASP.NET website.
<globalization
enableClientBasedCulture="true"
culture="auto:en-GB"
uiCulture="auto:en"/>
This works as expected: Client wo request a specific localisation get it, everybody else is happily looking at the en-GB settings
Requirement:I have 2 tabs in the 2 tab i have a text box in that i have to select date today or before for that i am using ajax calendar control.
Problem: If i select a date below 11 in the calendar control it is not throwing error but if i select a date from 11 and above it is throwing a error.
My Compare validator code is below.
<asp:CompareValidator ID="Compdatefrom" runat="server" ControlToValidate="txtperiodfrom" ValidationGroup="Erradd" valuetocompare="<%#DateTime.Now.ToShortDateString() %>" Operator="LessThanEqual" type="date" ErrorMessage="Invalid Date"></asp:CompareValidator>
I'm trying to create a report (rdl) againt SP list.
I have a Date parameter, just 1.
When a user is selecting a date. It checks against my queried date, a day before and a day after. It works fine.
When a user is NOT selecting the date. I want the my queried date between a MINIMUM date and a MAXIMUM date. Since I couldn't find the Min & Max date in SSRS report filtering, I trying to hard code the date.
I tried DateValue(...with variety of different format...), as well as CDate(...with variety of different format...).
None of them is working. What exactly is the format SSRS accepting?
As for my CDate(Fields!ows_Date.Value)'s result, it is displaying as "yyyy-mm-dd hh:mm:ss", I also tried that format, and still, not working.
<Filter>
<FilterExpression>=CDate(Fields!ows_Date.Value)</FilterExpression>
<Operator>Between</Operator>
<FilterValues>
<FilterValue>=IIf(IsDate(Parameters!DateParameter.Value), DateAdd("d", -1, Parameters!DateParameter.Value),
DateValue("01/01/1900"))</FilterValue>
<FilterValue>=IIf(IsDate(Parameters!DateParameter.Value), DateAdd("d", 1, Parameters!DateParameter.Value), DateValue("01/01/2100"))</FilterValue>
</FilterValues>
</Filter>
I have one popup calandar text box (Ajax,asp.net). When i click the calendar button , it has to show the today's date in text box by default.
View 1 RepliesI have a datepicker and want to set the minimum date like below.
<telerik:RadDatePicker ID="RadDatePicker1" UniqueName="RadDatePicker1"
runat="server" MinDate="<%=System.DateTime.Now.AddDays(-30) %>">
</telerik:RadDatePicker>
But it throws error.
i want it from aspx itself .not from code behind.
Using the client API,I'd like to be able to do this:
picker.set_selectedDate(new Date());
Without the valueChanged event handler firing,is there another way in the API to do this?Again this is all client-side JavaScript.
I am using Oracle 10g im my asp.net project. In my select query, i want to change the format to dd/mm/yyyy hh:mm:ss from mm/dd/yyy hh:mm:ss. The field datatype is date. How can i write a query for this?
View 7 Repliesi have a problem in updating user detail im using mysql db and when retriving the details date:9/8/2009 12:00:00 AM but im inserting date like 2009-09-08
then it shows error like Incorrect date value: '9/8/2009 12:00:00 AM'
is there ny data type of date which can hold the date only.....coz i have a field of date in which i have write date manually... i have taken the datatype as DateTime.... and its showing "incorrect datetime value"..
View 1 RepliesI have around 60 columns in my web form/MySql table .i want impose 2 columns as Auto generate columns.one is quotenumber another one is Date
IS it possible to apply two columns as auto increment,does MySql has provision of imposing date auto increment on a column how can i do this from ASP.net webform and MySql as database.
I would like to set a default date, not the current date ( say 31/11/2011) for the calender control. What date format should I be using for the datetime variable so the calender control accepts the date. I have tried using the following date format but I keep getting the error: String was not recognized as a valid DateTime.
[Code]....
Or is there another way to set a date for the calender control.
i have an administrators page that gets a list of the users that are members of my site and i want to display their profile each time i clikc on the user name.
In order to do so, i use the following code:
[Code]....
This way, the last activity date is updated and the IsUserLogedOn property is set to true, without the user actually enter the application (since it is a calculated value that depends on the last activity date). As a result, each time i click a user name to view his profile, the user seems to be loged in.
I would like to generate an excel sheet aout of a table in asp. The exporting works fine using an in-house developed framework to export the table. The problem that I'm having is that dates are just written in columns as strings and not initialized with the proper cell format. Is there any way to format the date without any 3rd party software by just setting the value of a cell with a string??
sheet[i,j].Value = "{:DateTime}"+dateStringProperlyFormatted