Select All Records Between 2 Dates

I am trying to select all records added between 2 dates that the user inputs into a form and am having problems. I had this working no problems with asp but can't seem to get it working with .net. BTW I am using SQL Server and Visual Studio.





The asp.net code I am trying to use is:








Me.SqlSelectCommand1.CommandText = "SELECT news_title, news_date, news_type, news_link FROM news WHERE (news_type = 'news') AND (news_date BETWEEN CONVERT(DATETIME, '"" & startdate & ""', 102) AND CONVERT(DATETIME, '"" & enddate & ""', 102))"





....





Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click





Dim startdate As DateTime


startdate = Request.Form("date_from")





Dim enddate As DateTime


enddate = Request.Form("date_to")





SqlDataAdapter1.Fill(DataSet1)


Repeater1.DataSource = DataSet1


Repeater1.DataBind()





End Sub








With this I am getting the following error:





"Syntax error converting datetime from character string. "





So I am assuming it is something to do with the way I am getting the date from the form as when I hardcode the dates in it works???





Any help would be greatly appreciated, thanx