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 InsertData
{
    public partial class Form1 : Form
    {
     //creating instances of Command and Connection class
        OleDbCommand cmd;
        OleDbConnection con;   
        public Form1()
        {
            InitializeComponent();
        }
      private void btnSave_Click(Object Sender,EventArgs e)
      {
       int c;
       this.con = new OleDbConnection();
       //passing the database path and provider name
       this.con.ConnectionString = "Data Source =   d:\\Student.mdb;Provider = Microsoft.Jet.Oledb4.0";
       this.cmd = new OleDbCommand();
       this.cmd.Connection = this.con;
       this.cmd.CommandType = CommandType.Text;
       //passing insert command to insert values into the database table
       this.cmd.CommandText = "insert into Student  values('" + this.txtName.Text"' + '"this.txtRoll.Text + "')";
       this.con = open();
       //checking whether command successfully executed
       c = this.cmd.ExecuteNonQuery();
       if(c > 0)
       {
        MessageBox.Show("Record inserted");
        this.txtName.Text = " ";
        this.txtRoll.Text = " ";
        this.txtName.Focus();
        }
        else
        MessageBox.Show("Record not saved");
       }
    }
}