C# - INSERT u Access bazuProbao sam sa sledećim kodom, koji sam pronašao na ovom forumu:
Code:
string accessPath = Application.StartupPath.ToString() + "/dbService.mdb";
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source" + accessPath;
OleDbConnection dbConnection = new OleDbConnection(connectionString);
string commandSqlString = "INSERT INTO Client VALUES ('" + clientName + "');";
OleDbCommand dbCommand = new OleDbCommand(commandSqlString, dbConnection);
dbConnection.Open();
dbCommand.ExecuteNonQuery();
dbConnection.Close();
string accessPath = Application.StartupPath.ToString() + "/dbService.mdb";
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source" + accessPath;
OleDbConnection dbConnection = new OleDbConnection(connectionString);
string commandSqlString = "INSERT INTO Client VALUES ('" + clientName + "');";
OleDbCommand dbCommand = new OleDbCommand(commandSqlString, dbConnection);
dbConnection.Open();
dbCommand.ExecuteNonQuery();
dbConnection.Close();
ali dobijam sledeću grešku: Format of the initialization string does not conform to specification starting at index 33
Gde grešim?
