.net - LINQ Null Date Comparison In Dataset?

Aug 26, 2011

I have a DataSet where I need to filter the collection where one of the date columns is not null.

How do you term this in LINQ?

This is what I have so far but there is a compiler error on the w.CompletedDate field in the Where clause.

Dim completed = From ins In InspectionDataset.Inspection.AsEnumerable _
Where (Function(w) w.CompletedDate IsNot Nothing) _
Order By ins.Field(Of DateTime)("UpdatedDate")

I have also tried it the below way but the compiler will not allow the DBNull comparison.

Dim completed = From ins In Inspection.AsEnumerable _
Where ins.Field(Of DateTime)("CompletedDate") <> DBNull.Value _
Order By ins.Field(Of DateTime)("UpdatedDate")

View 1 Replies


ADVERTISEMENT

VS 2008 Dataset - Checking If Date = Null?

Sep 7, 2009

I need to check if a value from a date column is equal to null. I can't find how to do it.

Wat I got now is:

if ds.tblBooking(row).CancelledOn.compareTo(dbnull.value) = true then

But this doesn't seem to work, I think it's because I'm using a strongly typed database.

View 6 Replies

C# - Date Comparison To Check If Last Date Has Passed?

Dec 16, 2011

I have a DB table with the following columns

PolicyNumber
NextPremiumDate
PremiumNumber

Example For each PolicyNumber i have 5 NextPremiumDates.I want to display the 1st NextPremiumDate which is easy ...but i want to show the next NextPremiumDate only after the last NextPremiumDate has passed...How do i check if the last date has passed?I mean if i have 5 dates in the table given above...how do i check if the 1st date has passed then show 2nd date ...if 2nd has passed show 3rd and so on.

View 1 Replies

Convert Vb Date Comparison To C#

Aug 24, 2011

I have a code in vb, and I'm trying convert it to c#.

_nextContactDate.ToShortDateString > New Date(1900, 1, 1)

This is _nexContractDate declaration:

Private _nextContactDate As DateTime

Comapre datetime to string?

View 4 Replies

Date Comparison Not Returning Correct Results?

Mar 5, 2011

I am pulling a date value from my database:
Dim qfresho = From p In dbConfig.Configs _
Where p.Description = "FROD" _
Select p.dateValue
Dim qfreshc = From p In dbConfig.Configs _
Where p.Description = "FRCD" _
Select p.dateValue

Then comparing these date values to the current date:
[Code] .....
But for some reason its always returning the Else condition - even though the values in the database should make the query true. I'm guessing for some reason its not pulling the results as a date?

View 3 Replies

SQL Statement In Tableadapter VS2008 (date Comparison)

Jul 17, 2011

I am trying to create a statement with my dataset that uses an underlying access table. There is a date column in one of the tables in the dataset/access db. Originally the date column within the datarow was set to 'nothing'.

[Code]...

View 1 Replies

Linq To Sql Null - Check Whether A Column Is Null

Jul 15, 2011

How to check whether a column is null i use the following code but I got this error "Input string was not in a correct format."

[Code]....

View 2 Replies

Value Of Type 'System.Linq.IQueryable(Of Date?)' Cannot Be Converted To 'Date'

Dec 6, 2011

I'm trying to get datetime value but here is issue with nullable datetype.

Public Function GetDate(ByVal kodg As Integer) As DateTime
Dim g = From dt In db.xDates _
Join f In db.xGrafiks On dt.КодД Equals f.DateKod _

[Code]....

View 1 Replies

C# - LINQ To SQL Sum Null Value?

Aug 20, 2010

I have the following query, I'd like to sum the NULL value also. Some TimeSheet don't records in TimeRecord and some tr.TimeIn and tr.TimeOut are NULL.The query select only TimeSheet that has reords in TimeRecord. How I can have it select everything, and sum up the NULL value as well. So, the SUM of NULL will be just zero.

[Code]...

View 1 Replies

Dataset Returning Null Value?

Jan 11, 2012

Public Sub checkemail()
sqlcheckemail = "select Email from WEBUSER where Email='" + TBEmail.Text + "'"
Dim dscheckemail As New DataSet

[Code]....

if u see the one that i've commented is the one i already googled at tested...so now if the email address exist in the db..everything works wonderful..but if it doesn't exist the code should process the one that does not satisfy the first if statement...but now i'm getting the result as "There is something" eventhough the email does not exist in the db...

View 2 Replies

Dataset Returns Null Value

Mar 1, 2010

I have the following code in my application. When it is executed it brings out a null value at times, where i am sure there should be a value returned. I have checked by running the sql statement in the database and it returns the correct value. What could be wrong with my code? [Code]

View 6 Replies

Null Result In LINQ?

Apr 11, 2012

I'm having trouble with a null result, when I compare the query it said I cant it give the following error "sequence contains no elements"

Dim existe = (
p In abc.Ventadetalles
Where p.idarticulo = txtArticulo.Text

[code].....

View 3 Replies

Checking DataSet For Null Before Referencing?

Oct 15, 2010

I keep getting the error "Object reference not set to an instance of an Object" on the below highlighted line of code and I understand why. It's because I'm checking for something that hasn't even been initialized yet. My question is, what's the best way to check a DataTables row count without getting that error before refilling it?

If Not ds.Tables("tblNotes").Rows(0).IsNull(0) Then
ds.Tables("tblNotes").Rows.Clear()
End If
adp.Fill(ds, "tblNotes")

View 6 Replies

Handle Null In LINQ Subquery?

May 24, 2009

I've got a subquery that returns the most recent value from a child table. In some cases the subquery returns nothing. The query below fails at runtime because the inferred type of MemberPrice is decimal and is not nullable. [code]...

View 4 Replies

Linq To XML Remove Element Where Value Is Null?

Apr 19, 2011

I have a XML xElement like[code]...

In order to get rid of Trick nodes where value is null, I wrote:

myXmlElement.<Play>.<Trick>.Where(Function(m) m.<Trick>.Value = "").Remove()

View 4 Replies

VS 2010 LINQ Null Return?

Dec 2, 2011

I'm having trouble figuring out what to do with the bolded part, when there are no nodes to return.If there are no image tags inside the <images> tag, i get an "Object reference is not set to an instance of an object".I have been searching and searching for an answer but can't find one.

Dim orders = From o In xmlLinq.Descendants("order")
Select New With { _
.orderID = o.Attribute("id").Value, _

[code].....

View 2 Replies

IDE :: Handle Null Values When Updating Dataset?

Jun 11, 2009

In a WinForms app (VS2008 / .Net Framework 3.5) I bind data from SQL Server to controls. If there's a null value e.g. an employee has no middle name (allowed by business rules), when I browse that record at runtime an exception is thrown. So I code: If Not (row("middle_name") Is DbNull.Value then txtMiddleName.DataBindings.Add(New Binding("Text", row, "middle_name)). Say someone adds a middle name to this record, because the control had no databindings the dataset.HasChanges property is false and update stored proc doesn't run. I guess I could handle this like this: If txtMiddleName.Databindings.Count = 0 AndAlso txtMiddleName.Text <> "" Then row("middle_name") = txtMiddleName.Text. I guess I would have to do something similar to handle a value changing from not null to null.

View 8 Replies

LINQ + Find Count Of Non-null Values

Apr 2, 2010

I have a table with the below structure.

ID VALUE
1 3.2
2 NULL
4 NULL
5 NULL
7 NULL
10 1.8
11 NULL
12 3.2
15 4.7
17 NULL
22 NULL
24 NULL
25 NULL
27 NULL
28 7

I would like to get the max count of consecutive null values in the table.

View 3 Replies

Linq Expression Returning Null Rather Than Empty Set

Nov 18, 2010

I am finding this weird issue. When I do this > activities.Where(Function(a) (Not a.IsDeleted And a.ParentId = 100) It returns an in-memory query & when I try opening it up, it throws a object not set exception. This only happens when there were no items which satisfied the condition. Shouldn't it be returning an empty set? When there are items satisfying the condition, then it returns a list & works all good.

View 1 Replies

Linq Left Outer Join Null

Sep 27, 2010

I've got what I think is a working left outer join linq query but I'm having problems with the select because of null values in the right hand side of the join.[code]I want to return all of e and one column from c called tClassCode. I was wondering what the syntax would be. As you can see I'm using vb.net.[code]If i remove the c.tClassCode from the select the query runs without error. So i though perhaps i needed to do a select new but i don't think i was doing that correctly either.

View 2 Replies

Linq Query Handling Null Values?

Nov 12, 2011

From r In ReceiptLines
Where
r.RECEIPT.RECEIPTDATE >= _reportStartDate
And r.RECEIPT.RECEIPTDATE <= _reportEndDate

[Code].....

I am fetching all departments and their sales, average, count from the ReceiptLine, Receipt, ReceiptDiscount tables. The problem i am facing is, if i remove where discount > 0, I am getting null exception. But if I include that, then I only get sales that has discount. How would I write query that bring all sales less discount (if it has one).

View 2 Replies

Linq To Datasets Null Values On Integers?

Feb 21, 2010

If I have a datatble column set as int16 but rows can contain null values for this column. How do i write the linq query. I keep getting an error null value exception. Dim query = From n In resultstable.AsEnumerable Where n.value is dbnull.value does n't work.

View 6 Replies

Select All Records Where A Field Is Null Using LINQ?

Jan 25, 2012

I've got a table that caches calculated values for certain dates. I want to use LINQ to select all rows where the calculated value fields are null.But when I use isNothing I get an error that LINQ can't translate this into T-SQL. Is there a way to select null values with link, like this...?

Dim var = From rec As Record In myDataContext.Records Where IsNothing(rec.calculatedValue) Select rec

Other posts on stackoverflow mostly discuss how to avoid or check for null values with LINQ.

Note: I can't just set cacluatedValue's default to -1 to flag records whose calculated value has not been set (and then select those records) because I run queries that sum/average the calculated values. Selecting nulls seems cleaner and less bug-prone.

View 1 Replies

How To Set Value For Date To Null Or Nothing

Aug 30, 2009

I'm making a data application and using the data adapters, I created a query in the designer:
EmpActivities_TableAdapter.InsertQuery(IdTextBox.Text, ActivityComboBox.Text, DescriptionTextBox.Text, Cdate(adddate.text))
The question is how can I set the adddate to null or nothing and save it? I'm using SQL server for the data.

View 4 Replies

LINQ To Entities .Any() Results In Null Reference Exception?

Nov 16, 2011

I have a simple query as below:

Dim sizings = From a In db.Sizings
Where a.Customer.ID = customer.ID
Select a
If sizings.Any Then
.....

The sizings.Any line is throwing a null reference exception. I thought I was meant to use .Any to determine if there were any rows returned?isnothing(sizings) returns false.

Edit - Resolution:Don't use null objects in the LINQ Query!

View 2 Replies

.net - SQL Server NULL DATE?

Jan 12, 2012

How can i remove this in my crystal report . this value is showing if my date field in null . "1/1/1900 12:00:00 AM". I don't want to show thin is my report.I have two dates , case open date and case close date . if the case is not closed its showing this value so i want to remove this.I am using sqlsever.

View 3 Replies

Add Date Not Null Validation In .NET?

Oct 24, 2009

This video shows how to add validation for a textbox:[URL]..what about date ? I can't make it work for date.

View 2 Replies

Calendar And NULL Date

Jun 23, 2012

I am working with calendar inside GridView using VB. I have some NULL date on the DDBB. I can fix the problem using EVAL, but when I try to save the date from the calendar, I got an error telling me that their is no @variable declared.[code]Everything is fine but I got: Must declare the scalar variable "@tDate" trying to save.This is beacuse I'm not using Bind, but with BIND I cannot run checkDate.

View 1 Replies

Change Date From Dd/mm/yy To Null?

Sep 15, 2011

i have a datetimepicker with showcheckbox properties set to true..

when there is date in database, the checkbox is checked..

but when the database is null, the checkbox is unchecked..

here's the code:

Sub checkeddate() 'to set DateTimePicker.check (compare from database)
'if db is not null, then CheckBox is checked
If IsDBNull(DataSet.Tables("AssetMaster").Rows.Item(curPosition).Item(19)) = False Then

[Code]....

View 9 Replies

Date With Empty/null Value?

Jun 23, 2009

i have a date control on form (vb.net) and by default its value is current date. i want to make its value to null or empty so that no date is shown and user choose from the drop down date calendar.

View 9 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved