The Data On The Website Cannot Be Input In The Server Database..

hi there..

I have write a code in the submit button using vb code so that when people key in their email.. it will be saved in my created database called test.mdf. but when i debug it, i tried to write an my email address in the textbox in my website but when i click at the submit button, the web page display the email was not enter in my database.

here is the code, can anybody help me. i'm really lost here..

 Protected Sub SubmitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)

Dim TestDataSource As New SqlDataSource()TestDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("TestConnectionString1").ToString()

 

TestDataSource.InsertCommandType = SqlDataSourceCommandType.Text

TestDataSource.InsertCommand = "INSERT INTO Email(EmailAddress, IPAddress, DateTimeStamp) VALUES (@EmailAddress,@IPAddress,@DateTimeStamp)"

 TestDataSource.InsertParameters.Add("EmailAddress", emailAddressTextBox.Text)

TestDataSource.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString())TestDataSource.InsertParameters.Add("DateTimeStamp", DateTime.Now())

 Dim rowsAffected As Integer = 0

 

Try

rowsAffected = TestDataSource.Insert()

 Catch ex As Exception

 Server.Transfer("test_problem.aspx")

 

Finally

 

TestDataSource = Nothing

 

End Try

 

If rowsAffected <> 1 ThenServer.Transfer("test_problem.aspx")

ElseServer.Transfer("Test_Confirm.aspx")

 

End If

 

 

 

End Sub