OleDB using MS-Access

[s4_sabahatf]

i m unable to insert record in table using OLeDb follwoing command.it is drawing unhandled expection,please do tell me the easiest way /////////////////////////////////////////////////////////// OleDbConnection m_Connection = new OleDbConnection(Connection); m_Connection.ConnectionString=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:use.mdb"; m_Connection.Open(); Connection ="DELETE FROM user WHERE username = @s";

[Muhammad Shahid Farooq]

using System.Data.OleDb; public class Database { OleDbConnection connection = new OleDbConnection(); OleDbCommand command = new OleDbCommand(); public void openConnection() { connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\use.mdb"; connection.Open(); } public void closeConnection() { if (connection.State != 0) { connection.Close(); } } public void executeNonQuery(string query) { command.Connection = connection; command.CommandText = query; openConnection(); command.ExecuteNonQuery(); closeConnection(); } } public class Test { Database ObjDatabase = new Database(); string strQuery; objDatabase.openConnection(); strQuery = "DELETE FROM User"; objDatabase.executeNonQuery(strQuery): objDatabase.closeConnection(); }