C# - INSERT u Access bazu

Odgovori Nova tema

2 odgovora
3.261 pregleda

C# - INSERT u Access bazu 20.01.2005. u 02:34 · pre 265 meseci #1

Pokušavam da podatke iz forme ubacim u Access bazu.
Probao 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();

ali dobijam sledeću grešku: Format of the initialization string does not conform to specification starting at index 33

Gde grešim?

Re: C# - INSERT u Access bazu 20.01.2005. u 02:48 · pre 265 meseci #2

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + accessPath;

Potpis

If it's a girl then they're gonna call it Sigourney, after an actress. If it's a boy, then they're gonna call it Rodney, after Dave!

Re: C# - INSERT u Access bazu 20.01.2005. u 03:04 · pre 265 meseci #3

Hvala! Ovo ne bih primetio ni da sam gledao još sat vremena...

Pozdrav

Prijavite se da biste odgovorili u ovoj temi.Prijava Registracija

Forum kao aplikacija na telefonu

Srodne teme