Loading

need help with OleDbData

supersonic_skymaster

I want to insert and delete records in a MS Access database using OleDb, but I can't find the right class and codes. I think I have to use OleDbCommand but I don't know the codes for inserting and deleting records with that class.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

kovan22y ago
Happy Coding public bool SQLExecute(string SQL) { try { OleDbConnection conn = new OleDbConnection(strDSN); conn.Open(); OleDbCommand myCmd = new OleDbCommand( SQL, conn); myCmd.ExecuteNonQuery(); return true; } catch(Exception) { return false; } finally { conn.Close(); } }
+1