How can I search for the desired data in C# based on the time period (user input start and end time) in asp.net. Thanks for your help. - Loan Platform Complete Network

How can I search for the desired data in C# based on the time period (user input start and end time) in asp.net. Thanks for your help.

sql="select **** from *** where condition ";

sql += string.Format("and Date >='{0}'", dateTimePicker_low.Value.ToShortDateString());

sql += string.Format("and Date <='{0}'", dateTimePicker_high.Value.ToShortDateString());

Execute the sql statement below to return the result.

dateTimePicker_low, dateTimePicker_high are two dateTimePicker controls. It is used to select the time

Related articles

Goodreads recommends The Character of a Child

A few kilometers from Anhui Chizhou Jiangnan Industrial Park to the train station

Headline live big data

90% of AI companies lose money?

Postal Express from Xi'an to Lhasa will take about 4-6 days to arrive.

"If I use the money from raising children to retire, I will have an easy and happy life", what happened to those Dinks?

Government big data application problems

Is Zhengzhou Dengfeng Culture City worth buying?

Portrait ppt template - What is user profile? How to analyze the user profile?

Shennong Wudang Medicine Science and Technology Park Industrial Park project is a national one-four-five project?