Click here to Skip to main content
15,891,657 members
Home / Discussions / C#
   

C#

 
GeneralRe: Objects to bytes... Pin
turbochimp17-Sep-05 6:25
turbochimp17-Sep-05 6:25 
GeneralRe: Objects to bytes... Pin
Niklas Ulvinge17-Sep-05 6:32
Niklas Ulvinge17-Sep-05 6:32 
GeneralRe: Objects to bytes... Pin
turbochimp17-Sep-05 6:42
turbochimp17-Sep-05 6:42 
GeneralRe: Objects to bytes... Pin
Niklas Ulvinge17-Sep-05 7:00
Niklas Ulvinge17-Sep-05 7:00 
GeneralRe: Objects to bytes... Pin
turbochimp17-Sep-05 6:23
turbochimp17-Sep-05 6:23 
QuestionHow to call ITAddressTranslation method Pin
Fredy16-Sep-05 1:08
Fredy16-Sep-05 1:08 
QuestionC# and voice chat Pin
pakFari16-Sep-05 1:07
pakFari16-Sep-05 1:07 
QuestionDateTime search with Data Tables "Select" Method Pin
16-Sep-05 0:50
suss16-Sep-05 0:50 
Hi,

I want to filter the rows of the DataTable using the DataTables's Select() method.

I have a DataTime column in the DataTable. My Search Criteria should check that
DateTime Column's Hour value with the present System Time's Hour value
and
DateTime Column's Minute value with the present System Time's Minute value.

What functions/methods can i specify to extract the Hour, Minute from the DateTime column of the DataTable?

The following is the code:

string lstr = string.Empty;
lstr = "datename(hh,getdate())= datename(hh,schedule_time) and datename(mi,getdate())= datename(mi,schedule_time)";

DataRow[] dr = mds.Tables[0].Select(lstr);


Thanks in advance.


-- modified at 6:50 Friday 16th September, 2005
Questionimage on toolbarbutton Pin
g00fyman16-Sep-05 0:46
g00fyman16-Sep-05 0:46 
AnswerRe: image on toolbarbutton Pin
Subrahmanyam K16-Sep-05 1:01
Subrahmanyam K16-Sep-05 1:01 
GeneralRe: image on toolbarbutton Pin
g00fyman16-Sep-05 1:07
g00fyman16-Sep-05 1:07 
AnswerRe: image on toolbarbutton Pin
mav.northwind16-Sep-05 5:05
mav.northwind16-Sep-05 5:05 
QuestionThread and timer problem Pin
NicklasRing15-Sep-05 23:41
NicklasRing15-Sep-05 23:41 
AnswerRe: Thread and timer problem Pin
mav.northwind16-Sep-05 21:50
mav.northwind16-Sep-05 21:50 
QuestionCLR Pin
Anonymous15-Sep-05 23:37
Anonymous15-Sep-05 23:37 
AnswerRe: CLR Pin
Guffa15-Sep-05 23:57
Guffa15-Sep-05 23:57 
QuestionJoin video on-the-fly Pin
karnalta15-Sep-05 23:36
karnalta15-Sep-05 23:36 
QuestionHow to use < sign in comments? Pin
Dr Reedo15-Sep-05 23:09
Dr Reedo15-Sep-05 23:09 
AnswerRe: How to use < sign in comments? Pin
g00fyman15-Sep-05 23:17
g00fyman15-Sep-05 23:17 
GeneralRe: How to use &lt; sign in comments? Pin
Dr Reedo16-Sep-05 1:16
Dr Reedo16-Sep-05 1:16 
GeneralRe: How to use &lt; sign in comments? Pin
g00fyman16-Sep-05 1:17
g00fyman16-Sep-05 1:17 
QuestionProblems with Array being readonly (HELP) Pin
Yannielsen15-Sep-05 22:28
Yannielsen15-Sep-05 22:28 
GeneralRe: Problems with Array being readonly (HELP) Pin
Guffa16-Sep-05 0:31
Guffa16-Sep-05 0:31 
GeneralRe: Problems with Array being readonly (HELP) Pin
Yannielsen16-Sep-05 0:56
Yannielsen16-Sep-05 0:56 
GeneralRe: Problems with Array being readonly (HELP) Pin
Guffa16-Sep-05 1:59
Guffa16-Sep-05 1:59 

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.