We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

c# ExecuteNonQuery not inseting a row into a access database

delta_v
delta_v asked
on
Medium Priority
382 Views
Last Modified: 2013-12-17
Hi

i am trying to insert a row into a database using the   OleDbConnection and   OleDbCommand

the sql command works fine when i run it in ms access

when i run the cod enothing happens

no data inserted, no error

HELP PLEASE
public void WriteRegisterRecords(ArrayList Scouts, int MeetingID)
    {
        
        // Loop through all scouts in the array
        foreach (Scout ScoutRec in Scouts)
        {
            string sqlQuery = "";
 
            // Build the sql query
            sqlQuery += "INSERT INTO tblRegister (MeetingID, ";
            sqlQuery += "                         ScoutID, ";
            sqlQuery += "                         Attendence) ";
            sqlQuery += "VALUES (1, 1, 0);";
 
            OleDbConnection Connection = CreateAndOpenConnection();
            // Write the data
            //ExecuteDatabaseWrite(ref Connection, sqlQuery);
 
            // Create the command linking the connection and the SQL to be run
            OleDbCommand command = new OleDbCommand(sqlQuery, Connection);
 
            // Execute the query
            command.ExecuteNonQuery();
 
            // Close the database connection
            CloseConnection(ref Connection);
        }
        
    }

Open in new window

Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
i am running select querys off the db with info i am putting in to the db i am checking
Nate FeinbergFinancial Center Operations Manager

Commented:
Access can sometimes be very picky with its queries. Try removing the spaces you've shoved into your string. Also, if any of those fields you're inserting are of type Autonumber, it usually won't work, though I've found this rather inconsistent. If any of the data types for the fields are Text, you'll need to surround the values in single quotes, too.
Hope this helps,
Nate

Author

Commented:
Unfortunately the real problem occurred between the computer and the chair.

When a C# program is compiled it moves the database into the debug/bin directory and does not copy it back.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.