need help with OleDbData

Question

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.

kovan · Answer

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