<div>
this should explain<br />
<br />
<a href="http://msdn2.microsoft.com/en-us/library/system.data.datatable.select.aspx" rel="ugc">http://msdn2.microsoft.com/en-us/library/system.data.datatable.select.aspx</a>
</div>


this should explain

http://msdn2.microsoft.com/en-us/library/system.data.datatable.select.aspx [http://msdn2.microsoft.com/en-us/library/system.data.datatable.select.aspx]

<div>
Sorry. Allow me to make me clear...<br />
<br />
Actually i want to select date only from date time column.<br />
<br />
For example:<br />
<br />
column [Date]<br />
'03/29/2006 12:00:00A.M'<br />
<br />
and i want to select it date only like<br />
'03/29/2006'<br />
<br />
<br />
is there any way like convert datetime to date only or select date only in datatable.select method..?<br />
<br />
I have tried datatable.select(&quot;Convert(<wbr />date, Varchar)&quot;), but the result is a error message like this :<br />
'Invalid datatype Varchar'<br />
<br />

</div>


Sorry. Allow me to make me clear...

Actually i want to select date only from date time column.

For example:

column [Date]
'03/29/2006 12:00:00A.M'

and i want to select it date only like
'03/29/2006'


is there any way like convert datetime to date only or select date only in datatable.select method..?

I have tried datatable.select("Convert(date, Varchar)"), but the result is a error message like this :
'Invalid datatype Varchar'



<div>
<div class="content wysiwyg-content">
I have a datatable that contain column of data type datetime.<br />
<br />
for example:<br />
i have a column name 'Ndate' that have datavalue '03-29-2006 12:00:00AM'<br />
<br />
i want to select rows that 'Ndate' is '03/29/2006'. <br />
<br />
Could anyone pls tell me how can i select it using datatable.select method..?
</div>
</div>


I have a datatable that contain column of data type datetime.

for example:
i have a column name 'Ndate' that have datavalue '03-29-2006 12:00:00AM'

i want to select rows that 'Ndate' is '03/29/2006'. 

Could anyone pls tell me how can i select it using datatable.select method..?

Datatable select method to select date

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,