query in ms access

Question

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.

Hrvoje · Answer

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 nullnull) ; OleDbConnection myConn = new OleDbConnection (sConn); OleDbCommand oleCommand = new OleDbCommand (sqlProcmyConn); 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 zaidi · Answer

//con.open(); Lcmd = new OleDbCommand ( Insert into SMSLog(LogDateDescriptionValid_NoCostToSMSBalanceDebitCurBalance)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();