Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

datetime format

Status
Not open for further replies.
baran121

baran121

Programmer
Sep 8, 2005
337
TR
hi
i am using C# and sql 2005
i want to learn why this code doesnt work. please help me.


DateTime tarih1 =Convert.ToDateTime(dateTimePicker1.Value.ToString("dd.MM.yyyy"));
DateTime tarih2 = Convert.ToDateTime(dateTimePicker2.Value.ToString("dd.MM.yyyy"));

conn.Open();
try
{
string sorgu = "select mno,tarih,gnedeni,teshis,tedavi,doktor from tbmuayene where tarih between '"+ tarih1+ "' and '" +tarih2+ "' "

 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

glaing
  • Locked
  • Question
Formatting float to no decimals
Replies
4
Views
84
ArkM
ArkM
lupien1
  • Locked
  • Question
exponent output format (%e)
Replies
1
Views
60
xwb
xwb
cheer8923
  • Locked
  • Question
C++ code formatting: indent the brace
Replies
2
Views
65
xwb
xwb
AtomicChip
  • Locked
  • Question
Reading little-endian format numbers 1
Replies
5
Views
86
Salem
Salem
muthuivs
  • Locked
  • Question
Output to RTF, Format is being deleted by C++
Replies
7
Views
98
muthuivs
muthuivs

Part and Inventory Search

Sponsor

Back
Top