Click here to Skip to main content
15,905,419 members
Home / Discussions / C#
   

C#

 
GeneralRe: struct and null Pin
DaveyM697-Aug-08 1:03
professionalDaveyM697-Aug-08 1:03 
QuestionMonitoring system useage preformance Pin
Scalee5-Aug-08 9:49
Scalee5-Aug-08 9:49 
QuestionRe: Monitoring system useage preformance Pin
led mike5-Aug-08 10:28
led mike5-Aug-08 10:28 
AnswerRe: Monitoring system useage preformance Pin
Dan Neely5-Aug-08 10:39
Dan Neely5-Aug-08 10:39 
GeneralRe: Monitoring system useage preformance Pin
Scalee5-Aug-08 10:51
Scalee5-Aug-08 10:51 
GeneralRe: Monitoring system useage preformance Pin
Mark Churchill5-Aug-08 14:44
Mark Churchill5-Aug-08 14:44 
AnswerRe: Monitoring system useage preformance Pin
MarkB7775-Aug-08 14:33
MarkB7775-Aug-08 14:33 
QuestionHow to use "SELECT" statement on DataTables [modified] Pin
Verghese5-Aug-08 9:24
Verghese5-Aug-08 9:24 
I want to use the "SELECT " statement on DataTable, which fetches records between these 2 date ranges:

StartDate : 01-01-2007 and,
EndDate : 01-01-2008

The code is as follows:

if (newPDS.Tables[0].Columns["ADM_DATE"]== null) 
{					
	DataColumn dCol = new DataColumn(newPDS.Tables[0].Columns.Add("ADM_DATE", typeof(DateTime), "").ToString());
}				
 
for(Int32 i = 0; i < newPDS.Tables[0].Rows.Count; i++)
{
	row = newPDS.Tables[0].Rows[i];
	row["ADM_DATE"] = row["CADMMM"] + "/" + row["CADMDD"] + "/" + row["CADMHH"] + row["CADMYY"];
	DateTime newDT = new DateTime();
	newDT = Convert.ToDateTime(row["ADM_DATE"]).Date;
         row["ADM_DATE"] = newDT.ToShortDateString();
	string newQuery = "ADM_DATE between StartDate and EndDate";
	newDR = myTable.Select(newQuery);
}

myReport.SetDataSource(newDR);
crystalReportViewer1.ReportSource = myReport;

Thanking you in anticipation.

modified on Tuesday, August 5, 2008 3:33 PM

AnswerRe: How to use "SELECT" statement on DataTables Pin
Wendelius5-Aug-08 9:36
mentorWendelius5-Aug-08 9:36 
GeneralRe: How to use "SELECT" statement on DataTables Pin
Verghese5-Aug-08 10:02
Verghese5-Aug-08 10:02 
GeneralRe: How to use "SELECT" statement on DataTables Pin
Wendelius5-Aug-08 10:13
mentorWendelius5-Aug-08 10:13 
Questionpicturebox resources options Pin
Tamimi - Code5-Aug-08 9:23
Tamimi - Code5-Aug-08 9:23 
AnswerRe: picturebox resources options Pin
Wendelius5-Aug-08 9:43
mentorWendelius5-Aug-08 9:43 
GeneralRe: picturebox resources options Pin
Tamimi - Code5-Aug-08 9:53
Tamimi - Code5-Aug-08 9:53 
GeneralRe: picturebox resources options Pin
Wendelius5-Aug-08 10:00
mentorWendelius5-Aug-08 10:00 
GeneralRe: picturebox resources options Pin
Tamimi - Code5-Aug-08 10:13
Tamimi - Code5-Aug-08 10:13 
GeneralRe: picturebox resources options Pin
Wendelius5-Aug-08 10:18
mentorWendelius5-Aug-08 10:18 
QuestionVersioning a file. Pin
udaykatakam5-Aug-08 9:01
udaykatakam5-Aug-08 9:01 
AnswerRe: Versioning a file. Pin
Wendelius5-Aug-08 9:49
mentorWendelius5-Aug-08 9:49 
GeneralRe: Versioning a file. Pin
udaykatakam6-Aug-08 6:23
udaykatakam6-Aug-08 6:23 
QuestionRe: Versioning a file. Pin
Wendelius6-Aug-08 7:12
mentorWendelius6-Aug-08 7:12 
QuestionThead synchronization(MUTEX) on windows Service-C#.net Pin
balu123455-Aug-08 8:11
balu123455-Aug-08 8:11 
AnswerRe: Thead synchronization(MUTEX) on windows Service-C#.net Pin
N a v a n e e t h5-Aug-08 8:16
N a v a n e e t h5-Aug-08 8:16 
GeneralRe: Thead synchronization(MUTEX) on windows Service-C#.net Pin
balu123455-Aug-08 8:26
balu123455-Aug-08 8:26 
QuestionHow to remember font size changed by ctrl+mouse wheel Pin
AndrusM5-Aug-08 7:35
AndrusM5-Aug-08 7:35 

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.