[vbnet]

.....

بعد إذن الأستاذ AbuEhab

بما أن العضو جديد قمت بعمل ما ذكره الأستاذ AbuEhab على شكل دوال (وللإستاذ AbuEhab التعديل أو التعليق)

كود :

public string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|database1.accdb";
public void UserHistory(int userID, string action, string description, string comment)
{
    try {
        using (OleDbConnection cnn = new OleDbConnection(connectionString)) {
            string sql = " INSERT INTO [History] ( [UserID], [Action], [Description], [TheDate], [Comment] ) "
                       + "                VALUES ( @UserID , @Action , @Description,   Now(),    @Comment  ) ";
            using (OleDbCommand save = new OleDbCommand(sql, cnn)) {
                save.Parameters.AddWithValue("@UserID", userID);
                save.Parameters.AddWithValue("@Action", action);
                save.Parameters.AddWithValue("@Description", description);
                save.Parameters.AddWithValue("@Comment", comment);
                cnn.Open();
                save.ExecuteNonQuery();
                cnn.Close();
            }
        }
    } catch (Exception ex) {
    }
}

التعامل مع الدالة

كود :

private void button1_Click(object sender, EventArgs e)
{
    UserHistory(1, "Add", "New Employee", "No comment");
}

.....