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, 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 zaidi · Answer

//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();

query in ms access

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)