VB.Net writing to MS Access

[Force]

I am trying to update a database using VB.net I have been able to read the file just not update any information in it. After searching the net it seems like there are many different ways to read / write to access. I was hoping that someone knew of a way to write to access without using command builder. The command builder has been a giant hassle and I want to avoid it whenever possible.

This is the code that I am using to read information from Access:
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String

Dim intCounter As Integer = 0
Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
con.ConnectionString = "PROVIDER=Microsoft.jet.oledb.4.0;Data Source = F:\Visual Basic Files\Magic\CardList.mdb"
sql = "SELECT * FROM CardName"
con.Open()
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "CardName")
TextBox1.Text = ds.Tables("CardName").Rows(1).Item(1)
con.Close()

[trains58554]

try

da.update(ds,"CardName")

that is the way i go about updating my access database.

i hope this helps

[Force]

To run the command da.update you have to use command builder though dont you?
Thanks in advance

[trains58554]

Try this it works for me

Try

            Dim CmdUpdate As New OleDbCommandBuilder(da)

            da.Fill(ds, "CardName")

            ds.Tables("CardName").Rows(1).Item(1) = Me.TextBox1.Text

            da.Update(ds, "CardName")

        Catch ex As Exception

            MsgBox(ex.ToString)

        End Try

[Hack]

Running an SQL UPDATE query always works for me regardless of what database I'm using.

[Force]

I created a sql query but its posting an error. This is the code that I added:
sql = "UPDATE CardName SET CardName = 'test' WHERE PrimaryKey = '1'"
Dim cmd As New OleDb.OleDbCommand(sql, con)
cmd.ExecuteNonQuery()

I receive this error "Data type mismatch in criteria expression."

[Hack]

Probably because primary key is not a string.

Remove the single quotes.

[Force]

Hack, that worked perfect. I am new to SQL so my syntax is rough.
My thanks again to Hack and Trains for offering ideas / fixes.

[Hack]

No problem and this is something that has a tendency to trip up a lot of folks that are new to SQL (i.e., strings need single quotes - non strings do not)

Just remember to review what you have in these terms if you wind up with type mismatch errors again.

[Force]

Will do
Thanks Again