Click here to Skip to main content
15,913,239 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to add rows into Datatable? Pin
zeeShan anSari16-Sep-08 4:06
zeeShan anSari16-Sep-08 4:06 
GeneralRe: How to add rows into Datatable? Pin
zeeShan anSari16-Sep-08 4:06
zeeShan anSari16-Sep-08 4:06 
GeneralRe: How to add rows into Datatable? Pin
Harvey Saayman16-Sep-08 4:11
Harvey Saayman16-Sep-08 4:11 
GeneralRe: How to add rows into Datatable? Pin
zeeShan anSari16-Sep-08 4:16
zeeShan anSari16-Sep-08 4:16 
QuestionCombobox SelectedIndexchanged -ASP Pin
omlac16-Sep-08 3:18
omlac16-Sep-08 3:18 
AnswerRe: Combobox SelectedIndexchanged -ASP Pin
MeContra16-Sep-08 3:35
MeContra16-Sep-08 3:35 
GeneralRe: Combobox SelectedIndexchanged -ASP Pin
omlac16-Sep-08 3:46
omlac16-Sep-08 3:46 
QuestionDate time Sql and query Pin
Bongiwe16-Sep-08 3:10
Bongiwe16-Sep-08 3:10 
I want to calculate the difference between the timein and the current time.Now I want to know how to extract the date only and time only from the database using the DATETIME datatype.

this is what i tried
SELECT Kid.kidName, Kid.kidGender, Kid.kidsAddress, Parents.parentName, Parents.parentContactNumber, VisitLog.TimeIn
FROM Kid INNER JOIN
KidParent ON Kid.kidUniqueID = KidParent.kidUniqueID INNER JOIN
Parents ON KidParent.parentID = Parents.parentID INNER JOIN
VisitLog ON KidParent.kidUniqueID = VisitLog.kidUniqueID AND KidParent.parentID = VisitLog.parentID INNER JOIN
ImagesStore ON VisitLog.kidUniqueID = ImagesStore.kidUniqueID AND VisitLog.TimeIn = ImagesStore.TimeIn
WHERE (VisitLog.TimeIn BETWEEN DATEADD(d, - 1, GETDATE()) AND GETDATE())
AnswerRe: Date time Sql and query Pin
omlac16-Sep-08 3:20
omlac16-Sep-08 3:20 
AnswerRe: Date time Sql and query Pin
Harvey Saayman16-Sep-08 3:46
Harvey Saayman16-Sep-08 3:46 
AnswerRe: Date time Sql and query Pin
nelsonpaixao16-Sep-08 14:00
nelsonpaixao16-Sep-08 14:00 
Questionhow to make control moveable from mouse in windows application. Pin
AtulRane16-Sep-08 3:10
AtulRane16-Sep-08 3:10 
AnswerRe: how to make control moveable from mouse in windows application. Pin
stancrm16-Sep-08 3:30
stancrm16-Sep-08 3:30 
QuestionProblem with recording voice from multiple microphones [modified] Pin
MeContra16-Sep-08 3:07
MeContra16-Sep-08 3:07 
AnswerRe: Problem with recording voice from multiple microphones Pin
leppie16-Sep-08 3:09
leppie16-Sep-08 3:09 
GeneralRe: Problem with recording voice from multiple microphones Pin
MeContra16-Sep-08 3:21
MeContra16-Sep-08 3:21 
AnswerRe: Problem with recording voice from multiple microphones Pin
DaveyM6916-Sep-08 3:22
professionalDaveyM6916-Sep-08 3:22 
GeneralRe: Problem with recording voice from multiple microphones Pin
MeContra16-Sep-08 3:47
MeContra16-Sep-08 3:47 
GeneralRe: Problem with recording voice from multiple microphones Pin
DaveyM6916-Sep-08 4:05
professionalDaveyM6916-Sep-08 4:05 
GeneralRe: Problem with recording voice from multiple microphones Pin
MeContra16-Sep-08 4:15
MeContra16-Sep-08 4:15 
GeneralRe: Problem with recording voice from multiple microphones Pin
DaveyM6916-Sep-08 9:50
professionalDaveyM6916-Sep-08 9:50 
GeneralRe: Problem with recording voice from multiple microphones Pin
MeContra16-Sep-08 20:34
MeContra16-Sep-08 20:34 
GeneralRe: Problem with recording voice from multiple microphones Pin
DaveyM6916-Sep-08 23:49
professionalDaveyM6916-Sep-08 23:49 
Questionwindows service Pin
arkiboys16-Sep-08 2:56
arkiboys16-Sep-08 2:56 
AnswerRe: windows service Pin
leppie16-Sep-08 3:08
leppie16-Sep-08 3:08 

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.