DataGrid does not update mdb file
I'm first trying to use ADO.NET and C#. I try to connect a simple mdb Daba Base to a DataGrid control, and everything works OK, but any change I make to the table I see is not upodated into the DataBase.
I've tried both programatically and draging controls. This is the programatic way: Is there something I'm forgotting?
Thanks!
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=C:\Documents and Settings\Rikardo\Mis documentos\GruposUtopia.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False");
System.Data.OleDb.OleDbCommand selectComm = new System.Data.OleDb.OleDbCommand("SELECT * FROM ADEUDOS");
selectComm.Connection = conn;
System.Data.DataSet ds = new System.Data.DataSet("Tabla de adeudos");
ds.Tables.Add("ADEUDOS");
System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(selectComm);
adapter.Fill(ds.Tables["ADEUDOS"]);
dataGrid1.SetDataBinding(ds.Tables["ADEUDOS"], "");