Select Query need explanation

Help Activities
,
1

master_dt.Select(“[PriceDate]>= #”+date1.ToString +“# and [PriceDate]<= #”+date2.ToString +“#” ).CopyToDataTable
I use this query and I got required result like between the date but is anyone help me to explain what is means of here # sign and can anyone share some like to learn select query

2

Hi,

“#” symbol using in defining as datetime value when query.

For select query syntax please find more example in
C# DataTable Select Example - Dot Net Perls

Hope this help :slight_smile:

3

@Aleem_Khan For using a DateTime query, we can use the numeric comparison operators. We must surround the date with pound “#” symbols.