how to get sorted data wihin the region date from and dateto

Question

i have to text boxes textbox1 in which user enter from date and in textbox2 user enetr to date and after button clickevent the gridview will display the record between fromdate and to date..how to write procedure in sql2005?how to write code  and where i have to write?datatype is datetime,i am not inserting DateFrom and DateTo in table,,jest select using by datetime picker.i have only one column in table that is 'drpdate'.