Click here to Skip to main content
15,909,822 members
Home / Discussions / C#
   

C#

 
GeneralA simple FileSystemWatcher Question ( How to see if file has copied) Pin
Capriono9-Sep-04 0:29
Capriono9-Sep-04 0:29 
GeneralRe: A simple FileSystemWatcher Question ( How to see if file has copied) Pin
Pradeep Shamarao9-Sep-04 3:11
Pradeep Shamarao9-Sep-04 3:11 
GeneralRe: A simple FileSystemWatcher Question ( How to see if file has copied) Pin
mav.northwind9-Sep-04 5:30
mav.northwind9-Sep-04 5:30 
GeneralDelay Pin
erina5488-Sep-04 22:53
erina5488-Sep-04 22:53 
GeneralRe: Delay Pin
sreejith ss nair8-Sep-04 22:56
sreejith ss nair8-Sep-04 22:56 
GeneralDo User Control Pin
jzb8-Sep-04 21:40
jzb8-Sep-04 21:40 
GeneralRe: Do User Control Pin
sreejith ss nair8-Sep-04 22:53
sreejith ss nair8-Sep-04 22:53 
Generalcomparing date in database Pin
xiaowenjie8-Sep-04 20:32
xiaowenjie8-Sep-04 20:32 
int year = int.Parse(cboYear.Text);
int month = int.Parse(cboMonth.Text);
int day = int.Parse(cboDay.Text);

System.DateTime moment = new System.DateTime( year,month,day);
string dMy = moment.ToShortDateString();

string test_SQL = "Select * From test Where startDay <= " + (dMy) + "And endDay >= " + (dMy);

System.Data.OleDb.OleDbCommand test_cmd = new System.Data.OleDb.OleDbCommand (test_SQL, test_conn);

System.Data.OleDb.OleDbDataAdapter test_adapter = new System.Data.OleDb.OleDbDataAdapter(test_cmd);

System.Data.DataSet test_ds = new DataSet(); test_adapter.Fill(test_ds,"test");

// bind datagrid to dataset
dataGrid2.DataSource = test_ds;
dataGrid2.DataMember = "test";

test - table name
startDay (MM/dd/yyyy)- column name
endDay (MM/dd/yyyy)- column name

when the user select the date, month and year, my program will grab this value and compare it into the database. if found, it will display into the datagrid. i wanna use the date format (MM/dd/yyyy) to compare those in the database. Is not working!!!! help!!!!

Chris
GeneralRe: comparing date in database Pin
sreejith ss nair8-Sep-04 21:15
sreejith ss nair8-Sep-04 21:15 
GeneralRe: comparing date in database Pin
Anonymous8-Sep-04 22:34
Anonymous8-Sep-04 22:34 
GeneralRe: comparing date in database Pin
sreejith ss nair8-Sep-04 22:44
sreejith ss nair8-Sep-04 22:44 
GeneralGood tool for developer! Pin
tianzj8-Sep-04 17:27
tianzj8-Sep-04 17:27 
GeneralRe: Good tool for developer! Pin
sreejith ss nair8-Sep-04 21:21
sreejith ss nair8-Sep-04 21:21 
QuestionListbox ValueMember set to more than one value ? Pin
Christian Graus8-Sep-04 16:42
protectorChristian Graus8-Sep-04 16:42 
GeneralAutoScroll without Scrolling to Focus Pin
McClamm8-Sep-04 13:07
McClamm8-Sep-04 13:07 
Generalhidden column in a checkedListBox control Pin
abhishk2001@yahoo.com8-Sep-04 12:47
abhishk2001@yahoo.com8-Sep-04 12:47 
QuestionEvent Handler hierarchy in WinForms??? Pin
LongRange.Shooter8-Sep-04 10:57
LongRange.Shooter8-Sep-04 10:57 
AnswerRe: Event Handler hierarchy in WinForms??? Pin
Christian Graus8-Sep-04 15:43
protectorChristian Graus8-Sep-04 15:43 
GeneralRe: Event Handler hierarchy in WinForms??? Pin
LongRange.Shooter9-Sep-04 3:14
LongRange.Shooter9-Sep-04 3:14 
GeneralRe: Event Handler hierarchy in WinForms??? Pin
LongRange.Shooter9-Sep-04 3:59
LongRange.Shooter9-Sep-04 3:59 
GeneralDatagrid cloumn to Array Pin
Vodstok8-Sep-04 6:46
Vodstok8-Sep-04 6:46 
GeneralRe: Datagrid cloumn to Array Pin
Nick Parker8-Sep-04 8:49
protectorNick Parker8-Sep-04 8:49 
GeneralRe: Datagrid cloumn to Array Pin
Vodstok9-Sep-04 6:08
Vodstok9-Sep-04 6:08 
GeneralSelecting multiple items in RichTextBox programmatically Pin
Anonymous8-Sep-04 6:02
Anonymous8-Sep-04 6:02 
GeneralRe: Selecting multiple items in RichTextBox programmatically Pin
mav.northwind8-Sep-04 7:49
mav.northwind8-Sep-04 7:49 

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.