Required Namespaces:

1. using umbraco;
2. using umbraco.BusinessLogic;
3. using umbraco.DataLayer;

C# Code:

1. public bool InsertData(string FirstName, string LastName, string Email, string Phone)
2. {
3. bool IsSuccessful = false;
4. try
5. {
6. string InsertQuery = "INSERT INTO tblPerson(FirstName, LastName, Email, Phone, CreatedDate) values ";
7. InsertQuery = InsertQuery + "(@FirstName, @LastName, @Email, @Phone, @CreatedDate)";
8. Application.SqlHelper.ExecuteNonQuery(InsertQuery,
9. Application.SqlHelper.CreateParameter("@FirstName", FirstName),
10. Application.SqlHelper.CreateParameter("@LastName", LastName),
11. Application.SqlHelper.CreateParameter("@Email", Email),
12. Application.SqlHelper.CreateParameter("@Phone", Phone),
13. Application.SqlHelper.CreateParameter("@CreatedDate", DateTime.Now));
14. IsSuccessful = true;
15. }
16. catch
17. {
18. IsSuccessful = false;
19. }
20. return IsSuccessful;
21. }