string strAccessConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\dlanfragen.accdb;Persist Security Info=True";//OutlookAddDLabfragen.Properties.Settings.Default.dlanfragenConnectionString ; string strAccessSelect = "SELECT * FROM dta"; // Create the dataset and add the Categories table to it: dlanfragenDataSet dl = new dlanfragenDataSet(); OleDbConnection myAccessConn = null; myAccessConn = new OleDbConnection(strAccessConn); OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn); OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand); // myAccessConn.Open(); myDataAdapter.Fill(dl); //var p = from c in dl.dta.AsQueryable() // select c; dlanfragenDataSet.dtaRow row = dl.dta.NewdtaRow(); row._Kaufmännische_Software_ = "test1"; row._Kalkulations_Software_ = "test1" row._Datenaustausch_Schnittstelle_ = "test1"; row.ID = dl.dta.Count + 1; dl.dta.AdddtaRow(row); myDataAdapter.Update(dl ); dl.AcceptChanges();
OleDbCommandBuilder myCommandBuilder = new OleDbCommandBuilder(myDataAdapter);