Select Query need explanation

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

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:

@Aleem_Khan For using a DateTime query, we can use the numeric comparison operators. We must surround the date with pound “#” symbols.
https://www.dotnetperls.com/datatable-select-vbnet