Code:
private void button1_Click(object sender, System.EventArgs e){
string accessPath = Application.StartupPath.ToString() + "/test.mdb";
string connectionString = "provider=Microsoft.JET.OLEDB.4.0; " + "data source ="
+ accessPath + "; Integrated Security=SSPI;";
string commandString = "INSERT INTO tabelaTest VALUES ('" + txtBoxBla.Text + "')";
OleDbConnection AccessDbConnection = new OleDbConnection(connectionString);
OleDbCommand AccessOleCommand = new OleDbCommand(commandString);
AccessDbConnection.Open();
AccessOleCommand.ExecuteNonQuery();
AccessDbConnection.Close();
}
private void button1_Click(object sender, System.EventArgs e){
string accessPath = Application.StartupPath.ToString() + "/test.mdb";
string connectionString = "provider=Microsoft.JET.OLEDB.4.0; " + "data source ="
+ accessPath + "; Integrated Security=SSPI;";
string commandString = "INSERT INTO tabelaTest VALUES ('" + txtBoxBla.Text + "')";
OleDbConnection AccessDbConnection = new OleDbConnection(connectionString);
OleDbCommand AccessOleCommand = new OleDbCommand(commandString);
AccessDbConnection.Open();
AccessOleCommand.ExecuteNonQuery();
AccessDbConnection.Close();
}
kada stisnem button1_Click dobilem dijalog:
Multiple-setup OLE DB operation generated erros. Check Each OLE DB Stats value, if available. No eork was done.
ako is connectionString izvrisem Integrated Security=SSPI; onda dobijem ovo:
ExecuteNonQuery: Connection property has not been initialized.
Gde gresim?