-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Roopesh_finally_serious
Message 2 in Discussion
Hi Ravi,
use this,
EventDate='" + gDate.ToString("dd-mmm-yyyy") + "'"
On 2/8/07, pravi-pravi <[EMAIL PROTECTED]> wrote:
New Message on BDOTNET
The Date format problem with MS-Access DB
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
pravi-pravi
This is the Select query that i am using while developing ASP.Net app using
VB.Net My EventDate is in General Date format.But gDate is in Short Date
format.So query not produsing any out put.
Dim gDate As DateTime = txtDate.Text.Trim()
SelectQueryText = "SELECT Distinct UserID,EventDate FROM History WHERE Dept='"
+ lstDept.SelectedValue.Trim() + "'AND EventDate=" + gDate + ""
What is the currect query to get the OutPut?
View other groups in this category.
To stop getting this e-mail, or change how often it arrives, go to your
E-mail Settings.
Need help? If you've forgotten your password, please go to
Passport Member Services.
For other questions or feedback, go to our
Contact Us page.
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
Remove my e-mail address from BDOTNET.
--
Thanks and best regards,
~Roopesh Tayaloor
--------------------------------------------------------------------------------------------------------
People seldom do what they believe in. They do what is convenient, then repent
- Bob Dylan
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
