how to take date from database between two textbox"dd/mm/yy"

Compare Two Textbox Dates

Fully Explain With Screen Shots Below Links


http://dotnetdrizzles.blogspot.com/2015/05/compare-two-dates-in-between-sql-query.html

http://screenshotdrizzles.blogspot.in/2015/05/compare-two-dates-in-between-sql-query.html

Hi,

You can use below SQL Query to Select Data From Database for specific date range.

Select * From TableName Where DateColumnName BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD'

// Assumes that connection is a valid SqlConnection object.
string queryString =  "SELECT Column1, Column2 FROM TableName";
SqlDataAdapter adapter = new SqlDataAdapter(queryString, connection);
DataSet data = new DataSet();
adapter.Fill(data);