Connecting your Web Application to SQL Server 2005 Express Edition

Is there a way to get the code that is not in the msi? I am not sure why but the MSI does not install or let you see the code on the webpages or the code behind.

I had the same problem with the MSI code.

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?

I have the same the problem as you ("Arithmetic overflow error converting expression to data type smalldatetime. The statement has been terminated.").

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.

There is no code for the project for video 8.There is only a shortcut for project but not project.What is the problem?Is there anyone can help me?

there is no code ın these code section.there ıs only a shortcut for project , but not project.

I couldn’t access the code either. You can write the code yourself since there is not much to write.

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.

I had the same problem. Sure, you can write the code yourself, but you can´t write the "code" for the css. It would be better if you could download all the code.

Yep, same problem downloading the code.

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

Thanks parkerdc your help was very important to me,

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

good video having the code would be nice

bluerainsigma, you can download de code in that link above

www.deanparker.com/DashSkateboards.zip

Thanks for the video. It is very good.

rthanks for the video its realy good

I want to learn a lot but I don't find code for project what I want

Why is it that the data appears in admin, but after debugging, if you click to show table data the database is empty?

I made some changes in the Code to stop dublicating an email and Label in the same page.

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

Unable to download the vedio

very useful for better understanding the subject.

Hi,

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

AWESOME

but the code??????

Thanks a lot, very helpful video :)

Its a good video. But I can't down load the code, I have to use some of the code in my source code... Please do load the code in Zip format.

Thanks

good video

Excellent video and good tips.  I really like your teaching style.

Thanks!

Check out further more video tutorials on SQL Server for free at http://wtv.watchtechvideos.com

Do share the videos you have in above forum since it will help community!

Thank you Diego.Atreyu for showing the link for the code, I only needed the .css but still, great to have it ;)

Just would like to point out that to use ipv6 IP Addresses in a "near" future, the IPAddress field of Table "Email" should be a char(23) and not char(15) type.

I am still new to the world of web development, but it makes it hard when the .msi file doesn't work and you can't get the code. Is this going to be fixed? Thanks

This is a great video. From last two days i am strugling to understand the procedure to insert data to DataBase. You explained very well.

Great video, it helped me a lot!!! Would you be able to convert this insert code into a select code? I need to pull data and assign it to a variable but I'm strugling with the select method of this. I know there are other methods that are much easier, but I think I need to use this. Thank you.

John.

wonderfull!

Thanks so much. I spent too much time searching the web and NOT finding what I needed. This was explained clearly and concisely and it helped me immensely.