I watched the full video and copied the C# code.

As I was testing, I recieved the following Exception message:

"Arithmetic overflow error converting expression to data type smalldatetime. The statement has been terminated."

My code is exactly the same as in the video. What could be wrong?

One way to work around the problem is to edit the column definiton of your table and then change the "DateTimeStamp" field type from "smalldatetime" to "varchar(50)".

It worked for me. I hope it helps you too.

I wrote the code from scratch by the way since I couldn't access the given code.

You can also learn better this way.

Start a new project and pause during the video and write your code (just type what the instructor types).

You don’t really need source code.It's Straight forward.

These videos were done by learnvisualstudio.net and as a member there, I was able to download the code.

I have the code on my site so you can download it.

htttp://www.deanparker.com/DashSkateboards.zip

1.47 mb

cuz my perfeccionism won't let me go forward before I get to develop an equal project. xD

<a rel="nofollow" target="_new" href="http://www.deanparker.com/DashSkateboards.zip">www.deanparker.com/DashSkateboards.zip</a>

Try it with Ajax its great!

----------Code-------------

Protected Sub Submitbottom_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Submitbottom.Click

       Dim dtbsourceemail As New SqlDataSource()

       dtbsourceemail.ConnectionString = ConfigurationManager.ConnectionStrings("DatabaseConnection" ).ToString()

       Dim con As New System.Data.SqlClient.SqlConnection(System.Configuration.Co nfigurationManager.ConnectionStrings.Item("DatabaseConnecti on").ConnectionString)

       Dim adp As New System.Data.SqlClient.SqlDataAdapter("select * from Email where EmailAddress='" & EmailAddresstextbox.Text & "'", con)

       Dim dt As New System.Data.DataTable

       adp.Fill(dt)

       If dt.Rows.Count = 0 Then

           dtbsourceemail.InsertCommandType = SqlDataSourceCommandType.Text

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

           dtbsourceemail.InsertParameters.Add("EmailAddress", EmailAddresstextbox.Text)

           dtbsourceemail.InsertParameters.Add("IPAddress", Request.UserHostAddress.ToString)

           dtbsourceemail.InsertParameters.Add("DateTimeStamp", DateTime.Now())

           Dim rowsAffected As Integer = 0

           Try

               rowsAffected = dtbsourceemail.Insert()

           Catch ex As Exception

               Label.Text = "Problem with adding"

           Finally

               dtbsourceemail = Nothing

           End Try

           If rowsAffected <> 1 Then

               Label.Text = "Problem with adding"

           Else

               Label.Text = "Thank you for joining our Mailing list"

           End If

       Else

           Label.Text = "Email Already Exist"

       End If

   End Sub

Without any doubt it is a great tutorial.

But i had an exception while executing the code. Please help. It says Null point exception and the details what i am giving doesn't get saved in the data base.

Please help me as the earliest. Much waiting for your reply.

Thanks in advance

Thanks

Thanks!