DataSource Controls :: Query A Nullable System.DateTime Column?
Apr 23, 2010
Am I going to be able to query (using LINQ to SQL) a database field with a type like the following "public System.Nullable<System.DateTime> Spouse_DOB"?
I'm trying to use the following code: [Code]....
and I get the error "'System.Nullable<System.DateTime>' does not contain a definition for 'Month' and no extension method 'Month' accepting a first argument of type 'System.Nullable<System.DateTime>' could be found (are you missing a using directive or an assembly reference?)"
Is it because this DateTime column allows a NULL value (since everyone isn't married in my database)?
Error 1 'System.Nullable<System.DateTime>' does not contain a definition for 'Month' and no extension method 'Month' accepting a first argument of type 'System.Nullable<System.DateTime>' could be found (are you missing a using directive or an assembly reference?)
C:Working WebsitesGrannys Clan Address BookDefault.aspx.cs
38 26
C:Working WebsitesGrannys Clan Addres
View 1 Replies
Similar Messages:
Apr 1, 2011
I have a problem:
I've created usual Controller and View(Edit view) for editing my Entity (EntityFramework)
Here is view example:
<div class="editor-field">
@Html.EditorFor(model => model.BirthDate)
@Html.ValidationMessageFor(model => model.BirthDate)
</div>
BirthDate is Nullable<DateTime>
but during loading my View I get this exception
The model item passed into the dictionary is null, but this dictionary requires a non-null model item of type 'System.DateTime'.
That's because of BirthDate is null in database but it is nullable and I expect that it just leaves the filed empty.
And I have Shared EditorTemplate:
@model System.Nullable<System.DateTime>
@if (Model.HasValue)
View 2 Replies
May 3, 2010
Is there a way to use the OrderBy command in Linq with a DateTime field using the Date portion only (without the Time Stamp portion) that is nullable such as in the following query?
var query1 = from myTable in MyTable
where myTable.EnteredDate != null
group myTable by myTable.EnteredDate into myOutput[code]....
Since myTable.EnteredDate is a DateTime field that can contain nulls, it does not support the .Date conversion call such as
myTable.EnteredDate.Date
Is there a way to convert the myTable.EnteredDate field into a date only string in the group by portion?
View 3 Replies
Dec 22, 2010
I am making a website to store invoices so i can mail them to clients. So i got a table for clients, invoices and one with invoice products/services. When an invoice has no products/services added to them and it returns null i get the error "the null value cannot be assigned to a member with type System.Decimal which is a non-nullable value type."
I just started with linq. Before i always used mysql. Mostly i just had to call data from 1 table so forgive me if my linq query isn't really correct.
Dim invoices = From i In db.invoices _
Group Join p In db.products On i.id Equals p.invoiceId Into invoiceProducts = Group _
Select New With {i.client.naam, i.titel, (From iP In invoiceProducts Select iP.prijs).Sum}
i show the client's name, the title of the invoice and the total amount the clients will need to pay for products and services.
View 1 Replies
Feb 17, 2010
What is syntax for query string for updating an sql datetime field and an sql number field in vb.net ?
View 1 Replies
Jun 29, 2010
I succes with this code
if (InitDateStart.Text != "" && InitDateEnd.Text != "")
{
strWhere += "And ((Convert(DateTime, InitDate, 105) >= Convert(DateTime,'" + InitDateStart.Text + "', 105)) And (Convert(DateTime, InitDate, 105) <= DateAdd(day, 1, Convert(DateTime,'" + InitDateEnd.Text + "', 105))))";
}
How do I do this code as a parameterized query ??I tried this but with no succes.I got some strange result by this
strWhere += "And Convert(varchar(10), ServiceInitDate, 105) >= @InitDate............. ";
GridDatasource.SelectCommand += strWhere; [code]...
View 2 Replies
Jun 14, 2010
How do I select a column with the latest "datetime" data type, in Visual Web Developer 2008, ASP.NET 3.5 ?
In the config data source WHERE option my options are greater than cookie, control, etc... but I would like to select where the datetime is the latest in the table.
View 5 Replies
Jan 9, 2010
I am using the following query to comapare the value of column of datetime type with the server date
select * from Tbl_MyTable where DATEADD(day, DATEDIFF(day,0,[Date]),0)=DATEADD(day, DATEDIFF(day,0,getdate()),0)
but with this I am not getting any out put .
how to compare two dates if the above way is not accurate
View 4 Replies
Nov 8, 2010
Members 'System.DateTime modDate' and 'System.DateTime insertDate' both marked as row version.modDate and insertDate is a SQL Server database field with smalltimedate as data type.
View 2 Replies
Jan 18, 2011
We have a webservice which stores data in sql server 2008R2.I am trying to build a billing system and struggling with the next sql query.
scriberID,X.SubscriberName,X.ProductID,X.ProductDesc,X.NumOfTransactions,X.UnitPrice,SUM(X.NumOfTransactions
* X.UnitPrice)
AS ExtendedPrice
[code]...
View 15 Replies
Nov 17, 2010
I am a c#/asp.net developer and I am having to work on a VB/asp.net. I started out with VB.NET but after years away from it I'm getting confused with the syntax.
I have two variables
Dim originalDate as DateTime?
Dim newDate as DateTime?
Both nullable datetimes, originalDate is a nullable date I am getting from the database and newDate time is set in code, I need to compare them, they can either both have dates, neither have dates or one have and one not.
I have a bit of code as follows:
if origEndDate = origEndDate then
When both origEndDate and origEndDate are "nothing" this statement is false (well when I run it in the watch window it comes back as nothing)!
I don't understand why this is the case because I was under the impression doing an "=" compares the two values and as they are the same surely it should be true?
What syntax should I be using as in C# I can do the above as so:
if (origEndDate == origEndDate) { }
and it will come back as true.
View 4 Replies
May 27, 2010
I am looking to display the value of a column and divite it by 1.175and display only the result do you know how to adjust the value of a column through a select statement in SQL?
View 7 Replies
Jun 14, 2010
I have following tables.
Items
ItemId
ItemName
GroupId
CatId
1
Apple
5
6
2
Banana
5
6
3
Blackberry
5
6
4
Grapes
5
6
5
Guavas
5
6
6
Beans fresh
5
7
7
Bitter Gourd
5
7
8................
View 7 Replies
Dec 23, 2015
I have a textbox that I use to gather a date.  I would like to have the database store a null if this field is left blank by the user when submitting. I am using the following on my aspx page:
<div class="col-md-3">
<strong>Date Submitted to TDI</strong><br />
<asp:TextBox ID="sub_tdi_dt" runat="server" Enabled="true"></asp:TextBox>
<asp:ImageButton ID="sub_tdi_dt_cal_popup" Enabled="false" ImageUrl="Images/calendar.png" ImageAlign="Bottom" runat="server" />
<ajaxToolkit:CalendarExtender runat="server" BehaviorID="sub_tdi_dt_CalendarExtender" PopupButtonID="sub_tdi_dt_cal_popup" TargetControlID="sub_tdi_dt" ID="sub_tdi_dt_CalendarExtender"></ajaxToolkit:CalendarExtender> </div>
I have tried using the following in Page_Load, but it doesn't work - I still get '1/1/1900':
DateTime? sub_tdi_dt = null;
View 1 Replies
Sep 20, 2010
I have the following function signuture:
public JsonResult PopulateGrid(int page, Guid? accountId, Guid? systemUserId, Guid? branchId, DateTime? fromDate, DateTime? toDate, HomeVisitType? homeVisitType)
Every single parameter is bound just fine except toDate which turns out to be always null. When inspecting the Request.QueryString["toDate"] it retrives the right value which is 30/09/2010. It seems that DateTime expects another format when binding.
What is the right format?
View 1 Replies
Mar 19, 2011
Got a nullable datetime member on my viewmodel.the moment it hit my controller action, the viewmodel's modelstate allready are invalid (because the member is null).Forgot...how that works? (using MVC2)Basically my viewmodel have a social security number, passport number and passport expiracy date.If the ssn is entered, I want to ignore the two passport related fields, so I made the expiracy date member nullable.
Like all other viewmodels in this app, each model have it's own validation function that will do validation, and in there I add an error that the date is required or not valid (if using passport number). mvc itself should not care about the date at all.I dont want to give the date a default value, because then the date will show when the form loads, and it must be an empty field (unless I already got a date of course.
View 4 Replies
Jun 24, 2010
I am trying to do a lookup in a table with a value stored in an xml column.
I tried this several ways but I can't get it to work.
Here is some code:
[Code]....
View 1 Replies
May 12, 2010
I am having a problem with the Client Validation not firing when I have marked a nullable DateTime field as [Required] and the value of the field is null. (It is actually stopping ALL client validation on the page working - not just the DateTime field).
Interestingly enough, once a post back has been done and the error picked up on the server, the client validation starts working.
Also if you set the date to a none null value (see commented out line in the controller) it will also work
I have replicated this behaviour in a small test project (this is deliberately very Noddy - just enough to replicate the problem)
Am I doing something fundamentally wrong or am I looking at coding some sort of work around here? (I realise that a Required nullable field sounds like a bit of a oxymoron, but I wanted to present the user with a blank field which they must then fill, not one pre-populated with an arbitrary date value)
Model
[Code]....
View (Auto generated)
[Code]....
[Code]....
View 5 Replies
Jul 9, 2010
i have the following select staement which deosnt work, can anyone advise me whats wrong with it:
string _name = ddl_Name.SelectedValue.ToString();
string cmd =
"SELECT ID, Telephone FROM User_List WHERE Name = '' + _name;
i keep getting an invalid column name error? and i know the syntax next to _name isnt correct. how are the single quotes meant to go?
View 3 Replies
Jun 21, 2010
I have tried to query a table with an xml column by using XQuery and I can't get the Select to work.
All my knowledge/understanding of the subject comes from this MSDN article:
[URL]
so I am probably overlooking something minor:
I tried this query Select col1, Phone.Query('element CellPhone {I am not sure about what goes here} I tried {data('Phone/cellPhone} from aTable Where Phone.Exist('/Phone/cellPhone/text()[contains.,"412-8977"]') = 1 This syntax is definitely not fun.
View 2 Replies
Jun 30, 2010
How do i generate another computed column that will contail the result of GrandTotal/Total,
where GrandTotal is another value comes from computed column and the Total would be the sum of the Total within SchedularID.
And thats what i have done so far: [Code]....
View 3 Replies
Jul 21, 2010
My designer.cs file of all the SQL tables is generated by LINQ-TO-SQL. The class and attribute in question is like this.
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Transfers")]
public
partial
class
Transfer :INotifyPropertyChanging,[code]...
I need to assign a null to the attribute so that the value 0 does not get save to the database.
View 2 Replies
Jun 24, 2010
I spent about 60 minutes sifting through search engine listings trying to figure this out and couldn't find an answer, so I decided to make this post for others.
Situation: Using a Stored Procedure to insert a row and return the new row ID, explained here. In my case, I used the Idenity_Scope to return the new row, like so:
[Code]....
Next, following steps as described in link above, went into the dataset XSD page, configured the table adapter to use this stored procedure. By default, it wanted my return value to be set to some value, but I set to allow Null (makes sense, since I don't want to pass the value in, I want to get it out, so it should be null to begin with).
Problem: Where I ran into an issue was in the method to call this stored procedure. The intellisense displayed the prototype it was expecting, basicly like this:
[Code]....
View 2 Replies
Sep 13, 2010
Can anyone reliably get the EDS to save a nullable column to the databse as a "null" when bound to any of the controls such as "FormView"?I have tried using several different UpdateParameters (Session, ControlParamater, Parameter, etc). I have tried setting "ConvertEmptyStringToNull" to true and leaving the property off entirely. Nothing works. On my "Inserts" it works fine.(I have made sure the column is set to nullable = true in the Entity Designer.....)
View 7 Replies
Dec 26, 2010
When i click on the page that represents a controller the following error was displayed:-
"The null value cannot be assigned to a member with type System.Int32 which is a non-nullable value type"
On this link of code
var articleapproval = articletyperepository.FindAllArticlesRequireMyApproval().ToList();
while the FindAllArticlesRequireMyApproval execute the following LINQ statement :-
var articleapproval= articletyperepository.FindAllArticlesRequireMyApproval().ToList();
where this methods calls the following LINQ statement:-
View 2 Replies
