Date: October 2nd, 2008 08:59 PM - lewy - Untitled Post: Welcome to the forums :) When working with dates, you need to enclose them in ## like this string str2 = "select * from patient where dateofregistration=#" +DropDownList1.SelectedValue.ToString +"# ";... ...