Adding Data to Access DB using OleDb

[paulquinlan100]

Hi

Could someone point me in the right direction. Im trying to update an
Access DB using the code below, it seems to all run correctly and I
dont get any error messages, however it doesnt actually add the data
to the table. Any ideas where im going wrong.

private void button1_Click(o bject sender, EventArgs e)
{

OleDbDataAdapte r da = new OleDbDataAdapte r("SELECT
[Investment Type],ProjectName,[Extension Size],FinancialYear FROM
InvestmentHisto ry where [Store ID] = 225",
"Provider=Micro soft.JET.OLEDB. 4.0;data source=C:\\Prog ramme DB\
\Investment Programme_be.md b");
DataSet ds = new DataSet();
da.Fill(ds, "InvestmentHist ory");

OleDbConnection connection =
(OleDbConnectio n)da.SelectComm and.Connection;

DataTable dt = new DataTable("Inve stmentHistory") ;
da.InsertComman d = connection.Crea teCommand();
da.InsertComman d.CommandText = "Insert into
InvestmentHisto ry ([Investment Type],[ProjectName],[Extension Size],
[FinancialYear]) values ('Extension','C NF',2000,0)";

da.InsertComman d.Parameters.Ad d("Investment Type",
OleDbType.Char, 0, "Store ID");
da.InsertComman d.Parameters.Ad d("ProjectName" ,
OleDbType.Char, 0, "ProjectNam e");
da.InsertComman d.Parameters.Ad d("Extension Size",
OleDbType.Integ er, 0, "Extension Size");
da.InsertComman d.Parameters.Ad d("FinancialYea r",
OleDbType.Integ er, 0, "FinancialYear" );

da.Update(ds, "InvestmentHist ory");
ds.AcceptChange s();
MessageBox.Show ("Updated.") ;
}

There are actually more fields in the table than are being inserted
here, do i need to add default values for them?

Thanks for any suggestions.
Paul