Generic Code - Insert a record into the database using C# code

    private const string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data source =";
    private string dbName;
    private string constring;
 
 public int InsertDatatoDB(string sqlCommandString)
    {
        int flag = 1;
        OleDbConnection myDBObj = new OleDbConnection();
        OleDbCommand command;

        constring = constring + dbName;

        try
        {
            myDBObj.ConnectionString = constring;       
            myDBObj.Open();                                   
            command = new OleDbCommand(sqlCommandString, myDBObj);  
            command.ExecuteNonQuery();                 
        }
        catch (Exception ex)
        {
            flag = 0;
        }
        finally
        {
            myDBObj.Close();                                   // Close it
        }
        return flag;
    }