Database

using System;<br />
using System.Collections.Generic;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Linq;<br />
using System.Text;<br />
using System.Windows.Forms;<br />
using System.Data.OleDb ;<br />
<br />
namespace studentManagementSystem1<br />
{<br />
    public partial class StudentDetails : Form<br />
    {<br />
         public OleDbCommand cmd;<br />
         public OleDbConnection con;<br />
        <br />
        string connectionString, query;<br />
               public StudentDetails()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
<br />
        <br />
        private void StudentDetails_Load(object sender, EventArgs e)<br />
        {<br />
            <br />
            // TODO: This line of code loads data into the 'studmanageDataSet.master' table. You can move, or remove it, as needed.<br />
            this.masterTableAdapter.Fill(this.studmanageDataSet.master);<br />
<br />
                       connectionString =@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\studentManagementSystem1\studmanage.mdb";<br />
            <br />
          }<br />
        <br />
        private void btnAdd_Click(object sender, EventArgs e)<br />
        {<br />
             <br />
           <br />
            int rows;<br />
<br />
            <br />
            query = "INSERT INTO master(RegNo,Name)VALUES(@RegNo,@Name)";<br />
            <br />
            cmd = new OleDbCommand(query, con);<br />
            <br />
           cmd.Parameters.AddWithValue("@RegNo", txtRegNo.Text );<br />
            cmd.Parameters.AddWithValue("@Name", txtName.Text );<br />
<br />
<br />
           <br />
            try<br />
            {<br />
               <big>con.Open(); </big>                <br />
                rows = cmd.ExecuteNonQuery();<br />
                if (rows > 0)<br />
               {<br />
                   MessageBox.Show("records inserted successfully");<br />
                }<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                MessageBox.Show(ex.Message);<br />
            }<br />
            finally<br />
            {<br />
                con.Close();<br />
            }<br />
        }<br />
<br />
        private void btnEdit_Click(object sender, EventArgs e)<br />
        {<br />
<br />
        }<br />
<br />
       <br />
<br />
<br />
    }<br />
}