I want to know how to handle null values....
for eg i hav a datetime field called Completion date which temporarily has a null value and when i display the records using a gridview it displays a default date...how do i get rid of this default date.the completion Date gets entered at a later stage in the application following which the gridview should show this date....but initially it shouldn't show anything
I am using this stored procedure with pivot.If i dont have data i am getting null with this stored procedure.Can u tell me how to handle null.below query is pivot.
[Code]....
I have a class with properties for stuff like FileNumber, OpenedDate, ClosedDate etc.When I Initialise the class I set the datetime variables to Date.MinValue.Then when I populate my textboxes I check if the value of the date variables are Date.Minvalue and I set the textbox text to an empty string.
Code:
If(File.OpenedDate = Date.MinValue, String.Empty, File.OpenedDate.ToString("yyyy/MM/dd"))
However whe I try to save the data to my sql server db I get a datetime out of range error. What is the correct way to handle these null values in my date columns?
i am unable to handle null values in while .even i tried to handle condition is breaking and coming null value comming inside loop.
[code]....
I've got a detailsview control on a page. The table that it interacts with has a DateTime column in it. This column is nullable, and a lot of the records have null for that value. In the EditItemTemplate I've got a calendar control. When I try to put the DetailsView into edit mode, I get the following error message:
System.InvalidCastException was unhandled by user code
Message=Specified cast is not valid.
Source=App_Web_srpmlyjd
StackTrace:
at ASP.entries_aspx.__DataBinding__control44(Object sender, EventArgs e) in c:inetpubwwwrootMediaLibraryEntries.aspx:line 103
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBindChildren()
I am convinced that the problem is the null values in the DateTime column of the table. I've done some web searches on this, and some have suggested placing some dummy values into that column, but that seems more like a kludge, rather than a solution. How do I keep nulls in the table, and yet not have that preceeding error come up when a user tries to edit the selected record?
How to allow null value on my program?
for below statement, "WARNING_TYPE" IS NULL..
but when I run, it promp me error..what are the correct statement should i write. tq all
l_Connection.ConnectionString = constr
l_Command.Connection = l_Connection
l_Command.CommandType = CommandType.Text
l_Command.CommandText = " SELECT UNP.EMPLOYEE_ID, UNP.UNPAID_DAYS, ABST.ABSENT_DAYS, WARN.WARNING_TYPE " +
[code].....
[URL]
how do you handle null data on gridview? and also the white spaces, it seems that the white spaces are converting to " "
Note: i can't replace the because i have 1 column thats in html form.
What if a user hits my site with [URL]t rather than [URL] In other words, they do not specify a value for {id}. If they do not, I want to display a nice "Not Found" page, since they did not give an ID.Is there a more standard MVC framework way of handling this, rather than the code I presently use (see below), where I test accept a nullable int? and then for null? Surely there is a smoother way to handle this.
[Code]....
I have a problem while checking a hashtable value. In the code below I am storing 60 values in the hashtable "hash". One of the values is (or can be) Null. I am checking each entry against its corresponding entry in hashtable "hash1", to see if they match each other. If they don't match I want to check if the value in "hash" is Null, but I can't catch it - it's falling through the 'else' part). How can I overcome this problem?
[code]....
I have asp.net form with C#, where is I am taking user information to insert in the database as usual by using Linq. well. Where as I am taking Date of birth also from the user, but if user skip to fill date text box from ui, then I am getting date like '01/01/0001' something like this, which certainly database security would not allow to store it.
So I need to check somewhere in my code that it is null or in this (above given) format. If it is null or in format '01/01/0001' then what exactly I have to do? I don't have any default
value for dates.
So what is the standard way to handle if date is null (but not mandatory). So many times I found myself in trap while handling null for various types.
[code]....
I need to retrive a value from a column of a table per stored proc. This is usually an integer, but also can be null. I get this value and store it in a session variable.
Later, I need to pass this same session variable to another stored proc.
Session["myVariable"] = ds.tables[0].rows[0][1]; // this can be null or an integer
somewhere else in the project, I need to pass it to another stored proc exactly as received.
[code]....
Given the following simplified code block in ASP.NET
<% foreach( item in Model) { %>
<%=item.OriginalText.OriginalText1 %>
<%} %>
OriginalText is a class which may be null. I am looking for a simple (clean) way to check for this null and return an empty string ("") instead.
I get a recordset returned from DB and try to load it. However sometimes field "LastRun" may be empty (NULL). when i have this it compiles fine but errors out when value is null m_LastRun = Convert.ToDateTime(r["LastRun"]); when I take out Convert.ToDateTime it doesn't even compile.
View 3 RepliesI'm using a custom ashx HttpHandler to retrieve gif images from a database and show it on a website - when the image exists, it works great.
However, there are cases when the image will not exist, and I'd like to have the html table holding the image to become invisible so the "image not found" icon is not shown.
[code]...
I am converting my datatable to LISt using LINQ how do I handle nulls coming from database
List<Port> portDetails = new List<Port>();
DataTable dt = ds.Tables[0];
portDetails = (from q in dt.AsEnumerable()
select new Port
{
PortCode = q.Field<string>("Code"),
ExtCode = q.Field<string>("Nb"),
Name = q.Field<string>("Name"))
}).ToList();
In the above query if Code is null I do not want property portcode to be set to the value it should only set if it is not null or not blank
PortCode = q.Field<string>("Code"),
What should be syntax
I was trying somethign like this which doesnt work
Portcode = q.Field<bool>("Code") == null ? null : q.Field<bool>("Code")
I have a query that averages data in 15 minute increments that I display in a chart using Microsoft Chart Controls. Everything works fine except when there is no data for a 15 minute increment. How do I get the chart to show just the empty time slot?
Query:
[Code]....
I am using the DetailsView Control to read a LastUpdatedDate field (which can be null until an update is performed) from the database. The LastUpdatedDate is of type DateTime saved in UTC. With the DetailsView control, I can use the NullDisplayText property of the boundfield to safely display an custom message. However, once converted to a template field, that property is lost. Now, how would I display that message if the field is null as I am also formatting the date for display to show in local time.
[Code]....
i am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
Almost all the applications I worked on involve some look-up values. For example, a lot of times a list of languages ( English, French, etc...) need to be displayed on the WebForm for user to choose.
The common data structure for such look up values include an integer Id and a string as name. Since these look-up values are used so frequently, and they are unlikely to be changed. Most of time, instead of grabbing them from database, I just define a global enum in C# like this
enum Language : int { English = 1, French = 2}
I've been handling look-up values like this for years now. I knew it may not be the best way to handle them. For example, every time a new language is added to the system, somebody needs to remember to update that enum.
I have a typical gridview/formview master control setup. When I try to update or insert I don't get any errors but it also doesn't work. When I try to insert data all I get are null values and when I update, none of the values are updated. The formview looks like its working, but just doesn't. The primary key is an identity and it auto-increments by one.
[Code]....
I've inherited an SQL table with a column named "product_codes." It contains 1 or more 4-digit numerals separated by commas (for example, the first record in the table has this in the "product_codes" column:0010,0810
There's a second table containing those product_codes and their corresponding names in a column called "product_name"
I'm trying to set up a FormView that will display an individual record and allow the user to update the record. But when attempting to display a record that has multiple values in the "product_codes" column I get an error, presumably because it can't map the product code to the product name.
[Code]....
[code]....
this code give that solution.but if any one of the field have null(example:r.urrQuickLinkRights contain the NULL) then only it will throw error like Object reference not set to an instance of an object.
In the detailsview, I set a edit item template (a bounded dropdownlist control). But in database there are some data not set to a value (null). After clicking edit button in detailsview control I get the error about the value problem (Because after populating the dropdownlist, there is no item as null in it. )How to set dropdownlist selected index when the data is "null"?
View 6 Repliesprotected void rptNavigation_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e){
if (!((e.Item.ItemType == ListItemType.AlternatingItem) || (e.Item.ItemType == ListItemType.Item)))
{return;
}string Name = string.Empty;
if (IsDBNull(e.Item.DataItem["FullName"])) {
Name = String.Empty;}
else {Name = (string)(e.Item.DataItem["FullName"]);}
Literal ltlLiteral = (Literal)(e.Item.FindControl("ltlLiteral"));
ltlLiteral.Text = Name.ToString();
I get error for IsDbNull - Error 1 The name 'IsDBNull' does not exist in the current context. What's the best way to check for null values returned from db? also I get errors on both lines where (e.Item.FindControl(ltlLiteral")); is present ERror: Cannot apply indexing with [] to an expression of type 'object'
Using Combobox in my webpage, in a combobox i want to display a null values first, then it should display all values..
Combobox.item = null values
combobox.item = 1
Combobox.item = 2
cmd = new OdbcCommand("Select vehicleno as vehicleno from tb_car", con);
ada = new OdbcDataAdapter(cmd);
ada.Fill(data1);
cmbvnoview.DataValueField = "vehicleno";
cmbvnoview.DataSource = data1;
cmbvnoview.DataBind();
Above code is working, but is displaying all the values, first it should display a null value, then it should display all the values.
