C# and saving data in access database!

[sharper]

Hi to all ! I have problem with C# and access databasses!

I can't to insert new record in database , ( I mean I made grid view and connect him with a access database and made all things to insert data in column in datagridview and it showing that row is filed with new data but when I restart form in database there is no new record)..

I use for exmpl: same code but with OLEDB;

 
string connectionString = "Data Source=SERV\\SQLEXP;Initial Catalog=tempdb;Integrated Security=True";
string command = "UPDATE  telefon 
SET prezime="+textBox2.Text+",telefon="+textBox3.Text+" 
WHERE ime ="+textBox1.Text+"";
 
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(command, con);
 
con.Open();
cmd.ExecuteNonQuery();
con.Close();
this.telefonTableAdapter.Fill(this.tempdbDataSet.telefon);
 

and this work in SQL but when I use this same code EXCEPT USING SYSTEM.DATA.OLEDB;

it all works well on form it show adding a data to gridview but it not store in database, I was use :

 this.telefonTableAdapter.Update();

 this.telefonTableAdapter.Insert();
AcceptChanges();     

but it NOT SAVE DATA TO ACCESS DATABASSES

PLEASE HELP!!!

[MMcCarthy]

Try changing this code ...

 
string command = "UPDATE  telefon 
SET prezime="+textBox2.Text+",telefon="+textBox3.Text+" 
WHERE ime ="+textBox1.Text+"";

to this ...

 
string command = "UPDATE  telefon 
SET prezime='" & textBox2.Text & "', telefon='" & textBox3.Text & "'
WHERE ime ='" & textBox1.Text & "'";
 

The single quotes are because Access requires single quotes for text inserts. The ampersand becuase that is what would normally be used but if you feel C# syntax requires the + sign instead then put it back.

[sharper]

thanx! for help I will tray it !

[sharper]

Tnx mmccarthy that is fine now , but ????????


I have this code and it's work on gridview it showing inserted values but it do not save changes in database !!!!

countRow++;
string str;
con.Open();
str = "insert into tele(ime,broj) values('"+textBox1.Text+ "','"+textBox2.Text+ "')";

DataRow dRow;
DataTable dTable = db1DataSet.tele;
dRow = dTable.NewRow();
dRow[1] = textBox1.Text;

if(textBox2.Text!="")
dRow[2] = textBox2.Text;
dTable.Rows.Add(dRow);

DataTable tab1 = db1DataSet.tele.GetChanges();

ole.Update(tab1);
db1DataSet.tele.AcceptChanges();



PLEASE HELP I WAS TRYING A LOT OF THINGS AND EVEN NOW I CAN' T TO SAVE DATA IN ACCESS DATABASE!!

[MMcCarthy]

string str;
con.Open();
str = "insert into tele(ime,broj) values('"+textBox1.Text+ "','"+textBox2.Text+ "')";

I can only help with the Access side of things. However, one this seems clear. You have put the INSERT statement into a string but you never execute it. Depending on how you connected to the database this would require something like.

con.execute str

Mayr