Problem Inserting Date

Hello

           The date format in SQL Server 2000 is dd-MM-yyyy. I am writing the following code in the buttons click event. I am using a textbox and button.

            Dim conn as SqlConnection=new SqlConnection(connection string)

            Dim ins as string="insert into Sample(dval) values(' " & TextBox1.Text & " ')"

            Dim cmd as SQlCommand=new SqlCommand(sel,conn)

            conn.open()

            cmd.ExecuteNonQuerry()

            conn.close()

             When i am inserting the date 05-03-2007 in the textbox and clicking the button it is inserting date

              03-05-2007 rather than 05-03-2007. What changes should i make in the code?

Rathish