1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
OleDbConnection sqlDatabaseConnectionString = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=dbb.accdb;Persist Security Info=True");
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand("Select * from projects", sqlDatabaseConnectionString);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
sqlDatabaseConnectionString.Open();
myDataSet.projectsRow newProject = this.myDataSet.projects.NewprojectsRow();
newProject.pro_consultant_fk = cbxConsultantForNewProject.SelectedValue.ToString();
newProject.pro_name = txtBxNewProjectName.Text;
this.myDataSet.projects.AddprojectsRow(newProject);
builder.GetUpdateCommand();
adapter.Update(this.myDataSet, "projects");
dtGdViewProjects.Refresh(); |
Partager