Add to database

headworth · September 29th, 2009, 04:42 PM

Can I have some help with this code i am trying to add text to a database?
Error 1 Identifier expected.

Code:

Public Class Form1
    Public Sub
        Public dbConn As New OleDbConnection(ConnectionString)
        Public queryString As String = "select * from Info where FirstName ="
        '123' ;"
        Public ds As New DataSet
        Public da As New OleDbDataAdapter(queryString, dbConn)
        Public cb As New OleDbCommandBuilder(da)




        TextBox1.DataBindings.Clear()
        TextBox1.DataBindings.Add("text" "firstName")

    End Sub
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        TextBox1.Text = TextBox1.Text
        'TextBox2.Text = TextBox2.Text

        'MessageBox.Show(TextBox1.Text & " " & TextBox2.Text)
    End Sub
End Class

planoie · October 2nd, 2009, 12:25 PM

You have the following lines wrong:

Code:

        Public queryString As String = "select * from Info where FirstName ="
        '123' ;"

You've broken a string literal with an extra quote.

Code:

        TextBox1.DataBindings.Add("text" "firstName")

This line won't compile, there are two string values separated by a space. You are missing a comma.

headworth · October 2nd, 2009, 02:32 PM

Thank you for your help with this code

Regards
Headworth