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.
I am able to route my urls to an existing page. Here is how our scenario is currently working:
On Default.aspx, we have several links that link to pdf files on the server. The filenames of these files change dynamically which is why we need the url routing. When the user clicks on of the urls, the link is routed to the getFile.aspx page that has logic in it to determine which file to open.
Is there a way to have the getFile.aspx page to open in the same window as the default.aspx page?
Otherwise, I need for the getFile.aspx page to close after the intended processing is complete, and I've not been able to close it without getting the close window dialog box. I figure if it opens in the same browser window, I can redirect back to the default.aspx page when processing is finished.
I'm using a custom route to create the following URL (http://mysite/subscriber/12345) where 12345 is the subscriber number. I want it to run the ShowAll action in the Subscriber controller. My route is firing and using Phil's route debugger, when I pass in the above url, the route debugger shows ID as 12345.
My controller is accepting an int as subscriberID. When it fires, the controller throws the error "The parameters dictionary contains a null entry for parameter 'id' of non-nullable type 'System.Int32". Why does the route debugger show a value and the controller doesn't see it?
Here's my route (first one is the culprit)
routes.MapRoute( "SubscriberAll", "subscriber/{id}", new { controller = "Subscriber", action = "ShowAll", id=0 }, new { id = @"d+" } //confirm numeric ); routes.MapRoute( "Default", // Route name "{controller}/{action}/{id}", // URL with parameters new { controller = "Home", action = "Index", id = UrlParameter.Optional } // Parameter defaults );
I'm getting a null in the ShowAll action? Here is the action method signature:
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 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?
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.
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.
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.
I'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.
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.
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 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?
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.
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?
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"?