C# Insert Data into Access Database using parameters

Simple User Registration form that show how to add new record from form into Access Database using parameters.
For Beginners.

What I learn.

How to connect to Access 2013 database.
Inserting Date/Time to the database.
Using Parameter insert queries.

TABLE

FORM

CODE

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;

namespace csharpwilsproject
{
    public partial class frmCreateAccount : Form
    {
         OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\csharpwils\database.accdb;");
        
              
        public frmCreateAccount()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            DateTime bday = DateTime.Parse(dtpBirthDate.Text);
              try
            {
                con.Close();
                con.Open();
                OleDbCommand cmd = con.CreateCommand();
                cmd.CommandType = CommandType.Text;
                  cmd.CommandText = "insert into tblUserAccount ([UserName],[Password],[FirstName],[LastName],[BirthDay],[Gender],[emailAdd],[website],[ContactNo]) VALUES(?,?,?,?,?,?,?,?,?)";
                 
                  cmd.Parameters.AddWithValue("UserName",txtUserName.Text);
                  cmd.Parameters.AddWithValue("Password",txtPassword.Text);
                  cmd.Parameters.AddWithValue("FirstName",txtFirstName.Text);
                  cmd.Parameters.AddWithValue("LastName", txtLastName.Text);
                  cmd.Parameters.AddWithValue("BirthDay", bday);
                  cmd.Parameters.AddWithValue("Gender", cboGender.Text);
                  cmd.Parameters.AddWithValue("emailAdd", txtEmail.Text);
                  cmd.Parameters.AddWithValue("website", txtWebsite.Text);
                  cmd.Parameters.AddWithValue("ContactNo", txtContact.Text);

                  cmd.ExecuteNonQuery();

                con.Close();

                MessageBox.Show("New Account has been created");

               
              }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);

            }
             
            

        }
          
    }
}

Mga Pahina

January 24, 2017

C# Insert Data into Access Database using parameters