//
this .AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this .ClientSize = new System.Drawing.Size(576, 317);
this .Controls.AddRange( new System.Windows.Forms.Control[] {
this .BtnExit,
this .BtnDelete,
this .BtnEdit,
this .BtnSave,
this .BtnAddNew,
this .TxtDeptNo,
this .TxtESal,
this .TxtEName,
this .TxtEmpNo,
this .label4,
this .label3,
this .label2,
this .label1});
this .Font = new System.Drawing.Font("Microsoft Sans Serif", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
this .Name = "FrmEmp";
this .Text = "Employee Data Form";
this .Load += new System.EventHandler( this .FrmEmp_Load);
this .ResumeLayout( false );
}
#endregion
///
1<summary>
2
3/// The main entry point for the application.
4
5/// </summary>
[STAThread]
static void Main ()
{
Application.Run( new FrmEmp());
}
private void FrmEmp_Load( object sender, System.EventArgs e)
{
}
private void BtnExit_Click( object sender, System.EventArgs e)
{
Conn.Close();
this .Close();
}
private void BtnAddNew_Click( object sender, System.EventArgs e)
{
TxtEmpNo.Text = "";
TxtEName.Text = "";
TxtESal.Text = "";
TxtDeptNo.Text = "";
TxtEmpNo.Focus();
}
private void BtnSave_Click( object sender, System.EventArgs e)
{
try
{
if (blnEdit == false )
{
DataRow1 = DataSet1.Tables["Emp"].NewRow();
DataRow1["EmpNo"] = Int16.Parse(TxtEmpNo.Text);
DataRow1["EName"] = TxtEName.Text;
DataRow1["Sal"] = Double.Parse(TxtESal.Text);
DataRow1["DeptNo"] = Int32.Parse(TxtDeptNo.Text);
DataSet1.Tables["Emp"].Rows.Add(DataRow1);
DataAdpt.Update(DataSet1,"Emp");
MessageBox.Show("record saved!");
}
else
{
string Str1;
Str1 = "Update Emp set EName='" + TxtEName.Text + "',Sal=" + double .Parse(TxtESal.Text) + ",";
Str1 = Str1 + "DeptNo=" + Int16.Parse(TxtDeptNo.Text) + " Where EmpNo=" + Int16.Parse(TxtEmpNo.Text);
Comm = new OleDbCommand(Str1, Conn );
Comm.ExecuteNonQuery();
/*drEdit.BeginEdit();
drEdit["EName"] = TxtEName.Text;
drEdit["Sal"] = double.Parse(TxtESal.Text);
drEdit["DeptNo"] = Int16.Parse(TxtDeptNo.Text);
drEdit.EndEdit();
DataAdpt.Update(DataSet1,"Emp");*/
MessageBox.Show("Record Modified!");
}
}
catch (Exception e1)
{
MessageBox.Show(e1.ToString());
}
}
private void BtnEdit_Click( object sender, System.EventArgs e)
{
string Str1;
try
{
Str1 = "Select * from Emp Where EmpNo=" + Int16.Parse(TxtEmpNo.Text);
Comm = new OleDbCommand(Str1, Conn );
DtRead = Comm.ExecuteReader();
if (DtRead.Read())
{
blnEdit = true ;
//drEdit = DataSet1.Tables["Emp"].Rows.Find(Int16.Parse(TxtEmpNo.Text));
TxtEName.Text = DtRead["EName"].ToString();
TxtESal.Text = DtRead["Sal"].ToString();
TxtDeptNo.Text = DtRead["DeptNo"].ToString();
TxtEName.Focus();
}
else
{
TxtEName.Text = "";
TxtESal.Text = "";
TxtDeptNo.Text = "";
MessageBox.Show("Record Not found!");
TxtEmpNo.Focus();
}
DtRead.Close();
}
catch (Exception e1)
{
MessageBox.Show(e1.ToString());
}
}
private void BtnDelete_Click( object sender, System.EventArgs e)
{
try
{
object Str1;
string Str2;
Str1 = MessageBox.Show("Do you want to delete the record","Delete Box", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Warning);
//==DialogResult.Yes)
if (Str1.ToString() == "Yes")
{
Str2 = "Delete from Emp Where EmpNo=" + Int16.Parse(TxtEmpNo.Text);
Comm = new OleDbCommand(Str2, Conn );
Comm.ExecuteNonQuery();
MessageBox.Show("Record has been deleted!");
TxtEmpNo.Text = "";
TxtEName.Text = "";
TxtESal.Text = "";
TxtDeptNo.Text = "";
TxtEmpNo.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
namespace Employee
{
///
1<summary>
2
3/// Summary description for Form1.
4
5/// </summary>
public class FrmEmp : System.Windows.Forms.Form
{
private System.Windows.Forms.Label label1;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.TextBox TxtEmpNo;
private System.Windows.Forms.TextBox TxtEName;
private System.Windows.Forms.TextBox TxtESal;
private System.Windows.Forms.TextBox TxtDeptNo;
private System.Windows.Forms.Button BtnAddNew;
private System.Windows.Forms.Button BtnSave;
private System.Windows.Forms.Button BtnDelete;
private System.Windows.Forms.Button BtnExit;
private System.Data.OleDb.OleDbConnection Conn ;
private System.Data.OleDb.OleDbCommand Comm;
private System.Data.OleDb.OleDbDataAdapter DataAdpt;
private System.Data.OleDb.OleDbCommandBuilder CBuild;
private System.Data.OleDb.OleDbDataReader DtRead;
private System.Data.DataSet DataSet1;
private System.Data.DataRow DataRow1;
private System.Data.DataTable DataTable1;
<SPAN lang=EN-US style="FONT-SIZE: 10pt; COLOR: blue;