How to insert data into Ms Access 2007 using Windows C# || Inserting and Binding of data into Ms Access in Windows C#.Net

To implement this concept you need to follow the below steps : 

Step1 :
First you need to design a table in MS Access 2007 Database to insert the records in database.

Step2:
On the File menu, click New Project. Select Windows Forms Application as your project type.
Design the Form using controls from Toolbox.

Step3:
Now open the Form.cs page and write the following source code.

Form.cs Code :

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Visiting_Card

{

    public partial class Form1 : Form

    {

        OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\VisitingCard.accdb");

        public Form1()

        {

            InitializeComponent();

            Bind();

        }

        private void btnSave_Click(object sender, EventArgs e)

        {

            con.Open();

            OleDbCommand cmd = new OleDbCommand("VisitingCard_Insert", con);

            cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.AddWithValue("@Names",txtName.Text);

            cmd.Parameters.AddWithValue("@Organization",txtOrganization.Text);

            cmd.Parameters.AddWithValue("@Location",txtLocation.Text);

            cmd.Parameters.AddWithValue("@PhoneNo",txtPhone.Text);

            cmd.Parameters.AddWithValue("@EmailId",txtEmail.Text);

            int result = cmd.ExecuteNonQuery();

            con.Close();

            if (result > 0)

            {

                MessageBox.Show("Inserted Successfully");

            }

            Bind();

        }

        private void Bind()

        {

            con.Open();

            OleDbCommand cmd1 = new OleDbCommand("VisitingCard_Bind", con);

            cmd1.CommandType = CommandType.StoredProcedure;

            OleDbDataAdapter da = new OleDbDataAdapter(cmd1);

            DataTable dt = new DataTable();

            da.Fill(dt);

            dataGridView1.DataSource = dt;

            con.Close();

        }

    }

}

Step4:
Now build the Solution and Debug it for the output.

OutPut :

 

Ms Access Database: