Click here to Skip to main content
15,921,793 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Thanks, It works fine. But problem with CSS file. Pin
Anurag Gandhi8-Nov-10 0:22
professionalAnurag Gandhi8-Nov-10 0:22 
QuestionSelect query from datetime field [modified] Pin
treuveni7-Nov-10 0:22
treuveni7-Nov-10 0:22 
Hi,

I'm trying to create select query (with LINQ)
that's checking if a row is already exists in a table (SQL SERVER).

this is the query:
var query = from p in dc.OnLineDuties<br />
                       where p.StartDate == start<br />
                       p.EndTime == end<br />
<br />
                       select p;<br />
<br />
           return query.ToList();


the tamplate is - "yyyy-mm-dd hh:mm:ss"
But i'm not getting any result.

Here are the values from the DB:
StartDate<br />
2010-11-01 09:00:00.000<br />
<br />
EndDate<br />
2010-11-01 10:00:00.000<br />



What i'm doing wrong???
Please assist...

modified on Sunday, November 7, 2010 6:28 AM

AnswerRe: Select query from datetime field Pin
Not Active7-Nov-10 5:03
mentorNot Active7-Nov-10 5:03 
GeneralRe: Select query from datetime field Pin
treuveni8-Nov-10 1:13
treuveni8-Nov-10 1:13 
GeneralRe: Select query from datetime field Pin
Not Active8-Nov-10 2:32
mentorNot Active8-Nov-10 2:32 
AnswerRe: Select query from datetime field Pin
Luc Pattyn7-Nov-10 11:06
sitebuilderLuc Pattyn7-Nov-10 11:06 
GeneralRe: Select query from datetime field Pin
treuveni8-Nov-10 1:14
treuveni8-Nov-10 1:14 
GeneralRe: Select query from datetime field Pin
Luc Pattyn8-Nov-10 1:38
sitebuilderLuc Pattyn8-Nov-10 1:38 
GeneralRe: Select query from datetime field Pin
treuveni8-Nov-10 1:47
treuveni8-Nov-10 1:47 
AnswerRe: Select query from datetime field Pin
phil.o8-Nov-10 2:01
professionalphil.o8-Nov-10 2:01 
GeneralRe: Select query from datetime field Pin
treuveni8-Nov-10 3:18
treuveni8-Nov-10 3:18 
GeneralRe: Select query from datetime field Pin
Rhys Gravell8-Nov-10 4:36
professionalRhys Gravell8-Nov-10 4:36 
GeneralRe: Select query from datetime field [modified] Pin
treuveni8-Nov-10 8:56
treuveni8-Nov-10 8:56 
GeneralRe: Select query from datetime field Pin
treuveni8-Nov-10 21:11
treuveni8-Nov-10 21:11 
GeneralRe: Select query from datetime field Pin
Rhys Gravell8-Nov-10 21:18
professionalRhys Gravell8-Nov-10 21:18 
GeneralRe: Select query from datetime field Pin
treuveni9-Nov-10 3:15
treuveni9-Nov-10 3:15 
GeneralRe: Select query from datetime field Pin
Rhys Gravell9-Nov-10 3:34
professionalRhys Gravell9-Nov-10 3:34 
GeneralRe: Select query from datetime field Pin
treuveni9-Nov-10 3:51
treuveni9-Nov-10 3:51 
QuestionView and textbox Pin
future38396-Nov-10 15:40
future38396-Nov-10 15:40 
AnswerRe: View and textbox Pin
Eddy Vluggen8-Nov-10 9:02
professionalEddy Vluggen8-Nov-10 9:02 
QuestionMVC and Dropdownliast Pin
future38396-Nov-10 15:17
future38396-Nov-10 15:17 
AnswerRe: MVC and Dropdownliast Pin
TweakBird9-Nov-10 7:21
TweakBird9-Nov-10 7:21 
QuestionAsp.Net Rendering Option Pin
JayKhatri6-Nov-10 9:36
JayKhatri6-Nov-10 9:36 
AnswerRe: Asp.Net Rendering Option Pin
_Erik_6-Nov-10 10:06
_Erik_6-Nov-10 10:06 
QuestionOnClientClick javascript parameter [modified] Pin
C#Coudou5-Nov-10 21:27
C#Coudou5-Nov-10 21:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.