954,517 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Having Issues Updating SQL database via textbox

Hi,

I am having a bit of trouble. Here is what I have.

Main Form - the atari pong game
High Score Form - the grid view of the simple SQL database

PONG database contains: ID (identity auto increment) and FinalTime (string)

Basically I cannot get the stopwatch text box to send its final time it receives to the SQL database. I added the "high score" table and dragged it form "Data Sources" pane on the right into the Main Form, to make sure it was connected. Here is a code snippet.

txtFtime.Text = lblstopwatch.Text

                Try
                    Me.TimeTrialTableTableAdapter.Insert(txtFtime.Text)
                    Me.TimeTrialTableTableAdapter.Fill(Me.PONG_NEW_SQLDataSet.TimeTrialTable)


                Catch ex As Exception

                End Try

                Me.Validate()
                Me.TimeTrialTableBindingSource.EndEdit()
                Me.TableAdapterManager.UpdateAll(Me.PONG_NEW_SQLDataSet


)


Can anyone help. I hosted my file on my personal website, which is my whole project so you can kind of get an idea of what I am trying to do.

Link: http://www.linuxcauldron.com/temporary/final project.zip

THANK YOU,

Mike

mdeguzis
Newbie Poster
1 post since Apr 2009
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You