I created an insert query in ms access.
I want to call that query and send data to query parameters that I specified in it.
I created an insert query in ms access.
I want to call that query and send data to query parameters that I specified in it.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
HrvojePosted Jul 31, 2008, 6:51 AM
I tried to use this code but I get an error: "The ConnectionString property has not been initialized".
string
sConn = System.Configuration.ConfigurationManager.AppSettings["dahStanoviConn"];string
sqlProc = "INSERT INTO Stanovi (SifraStana BrKvadrata VrstaStana Klima Jacuzzi," + "Internet, MultiLock, CijenaUkupno, CijenaKvadrat, SlikaVelika, SlikaMala)"+ "VALUES(@SifraStana, @BrKvadrata, @VrstaStana, @Klima, @Jacuzzi," + "@Internet, @MultiLock, @CijenaUkupno, @CijenaKvadrat, null,null)"; OleDbConnection myConn = new OleDbConnection(sConn); OleDbCommand oleCommand = new OleDbCommand(sqlProc,myConn);myConn.Open();
OleDbDataAdapter oleAdapter = new OleDbDataAdapter();oleCommand.Connection = myConn;
oleCommand.CommandType =
CommandType.StoredProcedure;oleCommand.CommandText = sqlProc;
oleAdapter.InsertCommand = oleCommand;
oleCommand.Parameters.Add(
"@SifraStana", OleDbType.Integer, 0).Value = sifraStana;oleCommand.Parameters.Add(
"@BrKvadrata", OleDbType.Integer, 0).Value = BrKvadrata;oleCommand.Parameters.Add(
"@VrstaStana", OleDbType.VarChar, 50).Value = VrstaStana;oleCommand.Parameters.Add(
"@Klima", OleDbType.Boolean, 0).Value = Klima;oleCommand.Parameters.Add(
"@Jacuzzii", OleDbType.Boolean, 0).Value = Jacuzzi;oleCommand.Parameters.Add(
"@Internet", OleDbType.Boolean, 0).Value = Internet;oleCommand.Parameters.Add(
"@Multilock", OleDbType.Boolean, 0).Value = MultiLock;oleCommand.Parameters.Add(
"@CijenaUkupno", OleDbType.Integer, 0).Value = CijenaUkupno;oleCommand.Parameters.Add(
"@CijenaKvadrat", OleDbType.Integer, 0).Value = CijenaKvadrat; //upCmd.Parameters.Add("@CijenaUkupno", OleDbType. .Integer, 0, SlikaVelika);oleCommand.ExecuteNonQuery();
Ali ZaidiPosted Jul 31, 2008, 5:23 AM
//con.open();
Lcmd =
new OleDbCommand("Insert into SMSLog(LogDate,Description,Valid_No,CostToSMS,Balance,Debit,CurBalance)values(@LogDate,@Description,@Valid_No,@CostToSMS,@Balance,@Debit,@CurBalance)", LCon);Lcmd.CommandType =
CommandType.Text;Lcmd.Parameters.AddWithValue(
"@LogDate", LogDate);Lcmd.Parameters.AddWithValue(
"@Description", Description);Lcmd.Parameters.AddWithValue(
"@Valid_No", Valid_No);Lcmd.Parameters.AddWithValue(
"@CostToSMS", CostToSMS);Lcmd.Parameters.AddWithValue(
"@Balance", Balance);Lcmd.Parameters.AddWithValue(
"@Debit", Debit);Lcmd.Parameters.AddWithValue(
"@CurBalance", CurBalance);Lcmd.ExecuteNonQuery();
//LConClose();