Problem Updating A Record Based On A Datetime.

Hi People,

hope someone can help me out here with a little problem.

 Basically i've go a asp.net page which has a listbox on. This list box is populated from a SQL database table with the datetime of the a selected field. Thus in the list box you get a list of strings looking like this "24/09/07 12:58"

Also on the page is a submit button, and some other editing textboxes. The main issue here is the when the submit button is used i get the currently selected listbox timedate string and then pass this along with other items to update a record in the database based on the datetime in the listbox control.

 

Below is how i get the string from the listbox control

Dim except_time As DateTime

except_time = DropDownList1.SelectedValue

The expect_time is then passed to store procedure along with some other vars, which looks like this 

-- =============================================
-- Author: Lee Trueman
-- Create date: 1st Sept 2007
-- =============================================
CREATE PROCEDURE [dbo].[spExcept_UpdateData]
 -- Add the parameters for the stored procedure here
 @validated bit,
 @update_time datetime,
 @except_time datetime
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON


     -- Insert statements for procedure here
 UPDATE exceptions
 SET    validated = @validated,
   update_time = @update_time
 WHERE  (except_time = @except_time)
END

So validated and update_time should be updated when except_time is equal to @except_time

 

My problem is that the database never updates. If i debug the asp.net page the watch var shows the datetime in US format (I.e "09/24/07 12:58"), if this is true then this would explain why when it is passed to the stored proc nothing gets updated, as there would not be a date match.

can anyone see any silly mistakes i'm doing here ????