+ "'+" + The least you can do is check your update statement.
On Aug 25, 7:17 pm, A M Swaminathan <[email protected]> wrote: > hello everybody, > > i am swami. i had developed a c#.net windows application with access > database.. > in update operation i got error.. pls help me.. > > The code is: > > OleDbConnection con = new OleDbConnection > ("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\\cictapp.mdb" > OleDbDataAdapter od; > DataSet ds; > string str = "update samp set name= '" + textBox2.Text + "', " + > "place= '" + textBox3.Text + "'+" + "where id='" + textBox1.Text + > "'"; > od = new OleDbDataAdapter(str, con); > ds = new DataSet(); > od.Fill(ds, "samp"); > label4.Text = "Record Updated"; > > thanks in advance.. > > regards > swaminathan.
