I have a date field (OrderTimeStamp) in Database which allow nulls.When I try to return this field in my LINQ Query I get this following error.Cannot Convert expression type System.Nullable<System.DateTime> to return type System.DateTime
I do not get this error when I try to return other fileds which also allow nulls. Like FirstName and LastName. Then Why I get error when I try to return a date field?
[code]....
I am filtering dataview using my Date Column but the result is not proper because the Field value also stores time, so I want to convert this Date Field to only Date during Filter. How can I achieve this? Here is my code. And the actual value I am getting in the Dataset Field "CreationDate" is a DateTime field which is like
2010-01-21 14:35:25.203
2010-01-22 12:55:18.033
2010-01-26 12:10:06.990
But I only want to neglet time value and want to compare Date only.
[Code]....
I'm trying to update a date field to the system date but it's not working. Could someone please help with the syntax?
[Code]....
Assume that a model has a datetime datatype.
So in view there will be a blank field ask you to input datetime.
Is there a way to fill this HTML field with today's date/datetime as default value?
how can i return 401 error from a method return ActionResult?
View 1 RepliesI have a page with a FormView on it. The page is strictly for adding records to a Table. I have the FormView bound to an EntityDataSource and everything works greate except for one thing.
I want to initialize a date field in the FormView to today's date. So, in my page_load event I have:
if (!Page.IsPostBack)
{
//Initialize SetupDate to today.
TextBox setupdate = (TextBox)fvJob.FindControl("txtSetupDate");
setupdate.Text = DateTime.Now.ToShortDateString();
}
The first time this page loads, the txtSetupDate field is initialized.
Although, and subsequent loads of the page doesn't initialize the Text Box. I step through the code in the debugger and I can see that the code is executig, but something (the FormView bind?) is "clearing" the Text Box.
I have a databound gridview that displays basic customer information. I have added a template field to the gridview, but I am having trouble with the coding for the RowDataBound event. I need to take the sum of all payments made by the customer in each row and store it in a variable for further calculation. Also, I need to take an integer value (say 30, representing 30 days) and add it to a date, and return a date.
View 14 RepliesI have a low level quiz. this is a mvc project
in PostRepository.cs, it has some code :
[Code]....
and then , in PostController.cs , I wanna a field in database call postStatus, the code is:
[Code]....
When I edit the post ,I hold the selectlist can show the option what is in database. But the code not work will.
then I use the Response.Write(postStatus); to test what happen. And the Browser show some code on top side :
[Code]....
I wanna what's up with the code and I want to know the suitable method.
In my database MYDB i have a table called MYTABLE and inside it I have a column called NAME. I want to only return the first 100 characters of the column NAME. (NAME can be up to 2000 characters).How can this be done in SQL as I want to set the first 100 characters to a ASP.NET label.
View 8 RepliesCode like this....
[Code]....
Using SQL Server 2005.
I need to return the year only from a datetime field and then group by that field, does anyone know the syntax for this?
using sql server 2005. I have table setup as follows
Table: Orders
Col: CustomerID
Col: OrderID
Col: OrderDate
so a given Customer can have many orders in this table however I only want to return the last order (using OrderDate) for each customer. how do you do this? I assume that I need to group by customerID and then use max on the OrderDate but not sure of the exact syntax.
I have a little problem with a query. I'm selecting data using the between command, But when I select the initial date equal to the final date the query doesn't show data.I know that the problem is the format. In my database I got something like this:2009-05-22 15:32:52.000. But when I send the date parameter from ASP.NET Page I sent only the Date (2009-05-22).So, I want to fix this thing. I cannot change the Datetime inside the database.I was thinking adding 1 day to the final date, So when the user select the same date I change the range behind the scene and then show the data. What do you think?
View 8 Replieshow to use database return many field and insert in a object(like any Collection ,Array,Hashtable etc)
[code]....
i want my query to return results where the field address is not empty or null
however, the query i have is still returning results where address is empty i.e. ' ' .
I am having an issue trying to return the date of a selected date in a calendar popup back to a textbox. (I am using a master page).
On a page called ManagerDrivers.aspx, I have a textbox called TextBoxFollowUpDate and an image button called ImageButtonCalendar.
My VB Codebehind is:
[Code]....
This brings up a popup Calendar.aspx page in a popup. When a date is selected, I need it to post the selected date back to the TextBoxFollowUpdate on the ManageDrivers.aspx page. My code is as follows:
[Code]....
In doing some searching, I found that you need to reference the Content Place Holder of your master page which in my case is
ctl00_ContentPlaceHolderFormationShaw
Followed by the control which is my TextBoxFollowUpDate, but for some reason I am not getting the selected date back into my textbox.
I want to return single field to a different webpage using hyperlink.
View 12 RepliesSay I have a table Comments with these columns: Id, Comment, Category, CreatedDate, CommenterIdI want to get the top 5 categories from the Comments table (based on the count of each category in that table). How can I do this in linq, to return either List or IQueryable?
View 2 RepliesI must be doing something wrong, but this makes sense to me. I have a Listbox loaded with tons of items from a datasource. A user clicks one of these items it grabs the selectedindex (an integer) and stores it in a HiddenField (works fine).
Now when the page does a complete a refresh (after postback) I want the ListBox to go back to that selectedindex that is in the HiddenField. Problem is, it seems that after postback the HiddenField is empty? Then I thought about storing the value in an Integer variable in code, but that is simply coming up as a zero at all times.
Question 1: What is the best/simplest way to do this?
Question 2: How?
I am currently grabbing it on selectedindex change
[Code]....
i'm trying to creat a form which contain textboxs, and i want to use one to fill in date by clicking in that zone.i use asp.net/vb
View 1 RepliesHow Can I use JQuery to Add And Edit in Date Field in ASP MVC Page
View 4 RepliesI want to fetch date from a datetime field, when i select this field in database i get the result as 'yyyy-mm-dd hh:mm:ss' i want the result to be like dd/mm/yyyy
I am developing website using ASP.net C# using Mysql.query i have made is:
//***to get next date
string nextdatequery = "SELECT next_dt
FROM testcase.heardt where fil_no=?
and next_dt>?;";
I have 2 date fields - From and To Date.Both are using required field validators, regular expression validtors and compare validators. When the user enters an invalid date range, e.g. 02-29-2010 to 02-29-2010 (non-leap year), the comparevalidator throws an 'from cannot be greater than to date range' error.Why am I seeing this error when From is not > To.Here's the code snippet
[Code]....
In the below code when I remove the optional end date and click save it should just take the value as blank, but it doesn't
when I remove the date and click save it saves but still shows the same date as before...when I make it to null it should remain null...how do i do that
#region Save Package
protected void btnBack_Click(object sender, EventArgs e)
{
this.Response.Redirect("/?id=Promotion.PackageList");
}
[Code]....
I have in model:
[Code]....
And in view:
[Code]....
But when I write in this field date: 30/11/2009 I see validation error: The value '30/11/2009' is not valid for publication_date.