I am developing a solution that has master and addEmployee as a table and a form respectively. The solution has a search button for searching record. The solution uses C# as front-end and sql2008 database as back-end. After compiling the solution, am receiving no response when clicking search button. Can somebody help me?
What I have tried:
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.SqlClient;
using System.Configuration;
using System.IO;
using System.Data.SqlTypes;
namespace FHAMortgageBank
{
public partial class Add_Employee : Form
{
public Add_Employee()
{
InitializeComponent();
double bsal, tranA, hous, lunc, uti, furn, harz, educ, housM, dres, risk, veh, driv, dome, pfs, nhf, nhfs, oded, housU, staffM, thrift, otherP, Nhis, pens, paye, tpay, tded, npay;
ClearData();
FillBank();
FillStatus();
FillPenAdmin();
FillYear();
FillGrade();
FillDpt();
New_Rec();
DisplayData();
New_Rec();
Calculation();
}
public static string constring = "Data Source=AKINTOMIDE-HP\\SQLEXPRESS;Initial Catalog=fham;Integrated Security=True";
SqlConnection con = new SqlConnection("Data Source=AKINTOMIDE-HP\\SQLEXPRESS;Initial Catalog=fham;Integrated Security=True");
SqlCommand cmd;
SqlDataReader dreader;
SqlDataAdapter adapt = new SqlDataAdapter();
private DataViewManager dviewmanager;
int SN = 0;
private void frmMain_Enter(object sender, EventArgs e)
{
}
private void picStafPix_Click(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
open.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
if (open.ShowDialog() == DialogResult.OK)
{
this.picStafPix.Image = new Bitmap(open.FileName);
textBox1.Text = open.FileName;
}
}
private void Calculation()
{
}
private void BntSave_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Please enter valid data...");
}
else
{
Image img = this.picStafPix.Image;
byte[] bt;
ImageConverter converter = new ImageConverter();
bt = (byte[])converter.ConvertTo(img, typeof(byte[]));
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=AKINTOMIDE-HP\\SQLEXPRESS;Initial Catalog=fham;Integrated Security=True";
cmd = new SqlCommand("insert into master (eid,mon,yr,dat,staf,adrs,coy,loc,dpt,grd,datead,datemod,bsal,tranA,hous,lunc,uti,furn,harz,educ,housM,dres,risk,veh,driv,dome,pfs,nhf,nhfs,oded,housU,staffM,thrift,otherP,accno,bank,email,penadmin,pennum,status,Nhis,picstaffpix,photo,[browse]) values(@eid, @mon,@yr,@dat,@staf,@adrs,@coy,@loc,@dpt,@grd,@datead,@datemod,@bsal,@tran,@hous,@lunc,@uti,@furn,@harz,@educ,@housM,@dres,@risk,@veh,@driv,@dome,@pfs,@nhf,@nhfs,@oded,@housU,@staffM,@thrift,@otherP,@accno,@bank,@email,@penadmin,@pennum,@status,@Nhis,@picstaffpix,@photo, @BrowsePic )", con);
con.Open();
cmd.Parameters.AddWithValue("@eid", txteid.Text);
cmd.Parameters.AddWithValue("@yr", cmbYr.Text);
cmd.Parameters.AddWithValue("@dat", datAd.Text);
cmd.Parameters.AddWithValue("@datead", datEmp.Text);
cmd.Parameters.AddWithValue("@datemod", DatMod.Text);
cmd.Parameters.AddWithValue("@staf", txtStaf.Text);
cmd.Parameters.AddWithValue("@adrs", txtAdrs.Text);
cmd.Parameters.AddWithValue("@coy", txtCoy.Text);
cmd.Parameters.AddWithValue("@dpt", cmbDpt.Text);
cmd.Parameters.AddWithValue("@loc", cmbLoc.Text);
cmd.Parameters.AddWithValue("@grd", CmbGrd.Text);
cmd.Parameters.AddWithValue("@accno", TxtAccno.Text);
cmd.Parameters.AddWithValue("@email", txtemail.Text);
cmd.Parameters.AddWithValue("@picstaffpix", bt);
cmd.Parameters.AddWithValue("@bank", cmbBank.Text);
cmd.Parameters.AddWithValue("@penadmin", cmbPenAdmin.Text);
cmd.Parameters.AddWithValue("@status", cmbStatus.Text);
cmd.Parameters.AddWithValue("@pennum", txtPenNum.Text);
cmd.Parameters.AddWithValue("@bsal", txtBSal.Text);
cmd.Parameters.AddWithValue("@dres", txtDres.Text);
cmd.Parameters.AddWithValue("@Nhis", txtNhis.Text);
cmd.Parameters.AddWithValue("@educ", txtEduc.Text);
cmd.Parameters.AddWithValue("@furn", txtFurn.Text);
cmd.Parameters.AddWithValue("@harz", txtHarz.Text);
cmd.Parameters.AddWithValue("@tran", txtTran.Text);
cmd.Parameters.AddWithValue("@hous", txtHous.Text);
cmd.Parameters.AddWithValue("@lunc", txtLunc.Text);
cmd.Parameters.AddWithValue("@uti", txtUti.Text);
cmd.Parameters.AddWithValue("@housM", txtHousM.Text);
cmd.Parameters.AddWithValue("@risk", txtRisk.Text);
cmd.Parameters.AddWithValue("@veh", txtVeh.Text);
cmd.Parameters.AddWithValue("@pfs", txtPfS.Text);
cmd.Parameters.AddWithValue("@nhf", txtNHF.Text);
cmd.Parameters.AddWithValue("@nhfs", txtNHFS.Text);
cmd.Parameters.AddWithValue("@oded", txtOded.Text);
cmd.Parameters.AddWithValue("@driv", txtDriv.Text);
cmd.Parameters.AddWithValue("@dome", txtDome.Text);
cmd.Parameters.AddWithValue("@housU", this.txtHousU.Text);
cmd.Parameters.AddWithValue("@staffM", this.txtStaffM.Text);
cmd.Parameters.AddWithValue("@thrift", this.txtThrift.Text);
cmd.Parameters.AddWithValue("@mon", cmbMon.Text);
cmd.Parameters.AddWithValue("@otherP", this.txtOtherPay.Text);
cmd.Parameters.AddWithValue("@photo", this.textBox1.Text);
cmd.Parameters.AddWithValue("@BrowsePic", SqlDbType.NVarChar).Value = button1.Text;
cmd.Connection = con;
try
{
int k = cmd.ExecuteNonQuery();
MessageBox.Show("Saved...");
ClearData();
}
catch (Exception ex)
{
MessageBox.Show("Not Save:\n" + ex.Message);
}
finally
{
con.Close();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Please enter valid data...");
}
else
{
Image img = this.picStafPix.Image;
byte[] bt;
ImageConverter converter = new ImageConverter();
bt = (byte[])converter.ConvertTo(img, typeof(byte[]));
SqlDataAdapter adapt = new SqlDataAdapter();
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=AKINTOMIDE-HP\\SQLEXPRESS;Initial Catalog=fham;Integrated Security=True";
cmd = new SqlCommand("update master set mon=@Mon , yr=@Yr, dat=@dat,staf=@Staf,adrs=@Adrs,coy=@Coy,loc=@Loc,dpt=@Dpt,grd= @Grd,datead=@datead,datemod=@datemod,bsal=@BSal,tranA=@Tran,hous=@Hous,lunc=@Lunc,uti=@Uti,furn=@Furn,harz=@Harz,educ=@Educ,housM=@HousM,dres=@Dres,risk=@Risk,veh=@Veh,driv=@Driv,dome=@Dome,pfs=@PfS,nhf=@NHF,nhfs=@NHFS,oded=@Oded,housU=@HousU,staffM=@StaffM,thrift=@Thrift,accno=@Accno,bank= @Bank,email=@email,penadmin=@PenAdmin,pennum=@PenNum,status=@Status,Nhis=@Nhis,picstaffpix=@picstaffpix,[browse]=@BrowsePic,photo=@photo WHERE eid= @eid ", con);
con.Open();
cmd.Parameters.AddWithValue("@eid", txteid.Text);
cmd.Parameters.AddWithValue("@yr", cmbYr.Text);
cmd.Parameters.AddWithValue("@dat", datAd.Text);
cmd.Parameters.AddWithValue("@datead", datEmp.Text);
cmd.Parameters.AddWithValue("@datemod", DatMod.Text);
cmd.Parameters.AddWithValue("@staf", txtStaf.Text);
cmd.Parameters.AddWithValue("@adrs", txtAdrs.Text);
cmd.Parameters.AddWithValue("@coy", txtCoy.Text);
cmd.Parameters.AddWithValue("@dpt", cmbDpt.Text);
cmd.Parameters.AddWithValue("@loc", cmbLoc.Text);
cmd.Parameters.AddWithValue("@grd", CmbGrd.Text);
cmd.Parameters.AddWithValue("@accno", TxtAccno.Text);
cmd.Parameters.AddWithValue("@email", txtemail.Text);
cmd.Parameters.AddWithValue("@picstaffpix", bt);
cmd.Parameters.AddWithValue("@bank", cmbBank.Text);
cmd.Parameters.AddWithValue("@penadmin", cmbPenAdmin.Text);
cmd.Parameters.AddWithValue("@status", cmbStatus.Text);
cmd.Parameters.AddWithValue("@pennum", txtPenNum.Text);
cmd.Parameters.AddWithValue("@bsal", txtBSal.Text);
cmd.Parameters.AddWithValue("@dres", txtDres.Text);
cmd.Parameters.AddWithValue("@Nhis", txtNhis.Text);
cmd.Parameters.AddWithValue("@educ", txtEduc.Text);
cmd.Parameters.AddWithValue("@furn", txtFurn.Text);
cmd.Parameters.AddWithValue("@harz", txtHarz.Text);
cmd.Parameters.AddWithValue("@tran", txtTran.Text);
cmd.Parameters.AddWithValue("@hous", txtHous.Text);
cmd.Parameters.AddWithValue("@lunc", txtLunc.Text);
cmd.Parameters.AddWithValue("@uti", txtUti.Text);
cmd.Parameters.AddWithValue("@housM", txtHousM.Text);
cmd.Parameters.AddWithValue("@risk", txtRisk.Text);
cmd.Parameters.AddWithValue("@veh", txtVeh.Text);
cmd.Parameters.AddWithValue("@pfs", txtPfS.Text);
cmd.Parameters.AddWithValue("@nhf", txtNHF.Text);
cmd.Parameters.AddWithValue("@nhfs", txtNHFS.Text);
cmd.Parameters.AddWithValue("@oded", txtOded.Text);
cmd.Parameters.AddWithValue("@driv", txtDriv.Text);
cmd.Parameters.AddWithValue("@dome", txtDome.Text);
cmd.Parameters.AddWithValue("@housU", this.txtHousU.Text);
cmd.Parameters.AddWithValue("@staffM", this.txtStaffM.Text);
cmd.Parameters.AddWithValue("@thrift", this.txtThrift.Text);
cmd.Parameters.AddWithValue("@mon", cmbMon.Text);
cmd.Parameters.AddWithValue("@otherP", this.txtOtherPay.Text);
cmd.Parameters.AddWithValue("@photo", this.textBox1.Text);
cmd.Parameters.AddWithValue("@BrowsePic", SqlDbType.NVarChar).Value = button1.Text;
adapt.UpdateCommand = cmd;
cmd.Connection = con;
try
{
int k = cmd.ExecuteNonQuery();
MessageBox.Show("Updated...");
ClearData();
}
catch (Exception ex)
{
MessageBox.Show("Not Updated:\n" + ex.Message);
}
finally
{
con.Close();
}
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{ }
else
{
Image img = this.picStafPix.Image;
byte[] bt;
ImageConverter converter = new ImageConverter();
bt = (byte[])converter.ConvertTo(img, typeof(byte[]));
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=AKINTOMIDE-HP\\SQLEXPRESS;Initial Catalog=fham;Integrated Security=True";
cmd = new SqlCommand("select * from master where eid =@eid", con);
con.Open();
cmd.Parameters.AddWithValue("@eid", txteid.Text);
cmd.Connection = con;
try
{
dreader = cmd.ExecuteReader();
if (dreader.Read())
{
txteid.Text = dreader[" eid"].ToString();
cmbYr.Text = dreader["Yr"].ToString();
datAd.Text = dreader["Dat"].ToString();
datEmp.Text = dreader["Datead"].ToString();
DatMod.Text = dreader["DateMod"].ToString();
txtStaf.Text = dreader["staf"].ToString();
txtAdrs.Text = dreader["Adrs"].ToString();
txtCoy.Text = dreader["coy"].ToString();
cmbDpt.Text = dreader["dpt"].ToString();
cmbLoc.Text = dreader["loc"].ToString();
CmbGrd.Text = dreader["Grd"].ToString();
TxtAccno.Text = dreader["accno"].ToString();
txtemail.Text = dreader["email"].ToString();
cmbBank.Text = dreader["bank"].ToString();
cmbPenAdmin.Text = dreader["penadmin"].ToString();
cmbStatus.Text = dreader["status"].ToString();
txtPenNum.Text = dreader["pennum"].ToString();
txtBSal.Text = dreader["bsal"].ToString();
txtDres.Text = dreader["dres"].ToString();
txtNhis.Text = dreader["nhis"].ToString();
txtEduc.Text = dreader["educ"].ToString();
txtFurn.Text = dreader["furn"].ToString();
txtHarz.Text = dreader["harz"].ToString();
txtTran.Text = dreader["tranA"].ToString();
txtHous.Text = dreader["hous"].ToString();
txtLunc.Text = dreader["lunc"].ToString();
txtUti.Text = dreader["uti"].ToString();
txtHousM.Text = dreader["housM"].ToString();
txtRisk.Text = dreader["risk"].ToString();
txtVeh.Text = dreader["veh"].ToString();
txtPfS.Text = dreader["pfs"].ToString();
txtNHF.Text = dreader["nhf"].ToString();
txtNHFS.Text = dreader["NHFS"].ToString();
txtOded.Text = dreader["oded"].ToString();
txtDriv.Text = dreader["driv"].ToString();
txtDome.Text = dreader["dome"].ToString();
txtHousU.Text = dreader["housU"].ToString();
txtStaffM.Text = dreader["staffM"].ToString();
txtThrift.Text = dreader["Thrift"].ToString();
cmbMon.Text = dreader["mon"].ToString();
txtOtherPay.Text = dreader["otherpay"].ToString();
textBox1.Text = dreader["photo"].ToString();
button1.Text = dreader["browse"].ToString();
ClearData();
}
else
{
MessageBox.Show(" No Record");
}
dreader.Close();
}
catch (Exception x)
{
MessageBox.Show("No Record:\n" + x.Message);
}
finally
{
con.Close();
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Please enter valid data...");
}
else
{
Image img = this.picStafPix.Image;
byte[] bt;
ImageConverter converter = new ImageConverter();
bt = (byte[])converter.ConvertTo(img, typeof(byte[]));
SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source=AKINTOMIDE-HP\\SQLEXPRESS;Initial Catalog=fham;Integrated Security=True";
cmd = new SqlCommand("delete master where eid =@eid", con);
con.Open();
cmd.Parameters.AddWithValue("@eid", txteid.Text);
cmd.Parameters.AddWithValue("@yr", cmbYr.Text);
cmd.Parameters.AddWithValue("@dat", datAd.Text);
cmd.Parameters.AddWithValue("@datead", datEmp.Text);
cmd.Parameters.AddWithValue("@datemod", DatMod.Text);
cmd.Parameters.AddWithValue("@staf", txtStaf.Text);
cmd.Parameters.AddWithValue("@adrs", txtAdrs.Text);
cmd.Parameters.AddWithValue("@coy", txtCoy.Text);
cmd.Parameters.AddWithValue("@dpt", cmbDpt.Text);
cmd.Parameters.AddWithValue("@loc", cmbLoc.Text);
cmd.Parameters.AddWithValue("@grd", CmbGrd.Text);
cmd.Parameters.AddWithValue("@accno", TxtAccno.Text);
cmd.Parameters.AddWithValue("@email", txtemail.Text);
cmd.Parameters.AddWithValue("@picstaffpix", bt);
cmd.Parameters.AddWithValue("@bank", cmbBank.Text);
cmd.Parameters.AddWithValue("@penadmin", cmbPenAdmin.Text);
cmd.Parameters.AddWithValue("@status", cmbStatus.Text);
cmd.Parameters.AddWithValue("@pennum", txtPenNum.Text);
cmd.Parameters.AddWithValue("@bsal", txtBSal.Text);
cmd.Parameters.AddWithValue("@dres", txtDres.Text);
cmd.Parameters.AddWithValue("@Nhis", txtNhis.Text);
cmd.Parameters.AddWithValue("@educ", txtEduc.Text);
cmd.Parameters.AddWithValue("@furn", txtFurn.Text);
cmd.Parameters.AddWithValue("@harz", txtHarz.Text);
cmd.Parameters.AddWithValue("@tran", txtTran.Text);
cmd.Parameters.AddWithValue("@hous", txtHous.Text);
cmd.Parameters.AddWithValue("@lunc", txtLunc.Text);
cmd.Parameters.AddWithValue("@uti", txtUti.Text);
cmd.Parameters.AddWithValue("@housM", txtHousM.Text);
cmd.Parameters.AddWithValue("@risk", txtRisk.Text);
cmd.Parameters.AddWithValue("@veh", txtVeh.Text);
cmd.Parameters.AddWithValue("@pfs", txtPfS.Text);
cmd.Parameters.AddWithValue("@nhf", txtNHF.Text);
cmd.Parameters.AddWithValue("@nhfs", txtNHFS.Text);
cmd.Parameters.AddWithValue("@oded", txtOded.Text);
cmd.Parameters.AddWithValue("@driv", txtDriv.Text);
cmd.Parameters.AddWithValue("@dome", txtDome.Text);
cmd.Parameters.AddWithValue("@housU", this.txtHousU.Text);
cmd.Parameters.AddWithValue("@staffM", this.txtStaffM.Text);
cmd.Parameters.AddWithValue("@thrift", this.txtThrift.Text);
cmd.Parameters.AddWithValue("@mon", cmbMon.Text);
cmd.Parameters.AddWithValue("@otherP", this.txtOtherPay.Text);
cmd.Parameters.AddWithValue("@photo", this.textBox1.Text);
cmd.Parameters.AddWithValue("@BrowsePic", SqlDbType.NVarChar).Value = button1.Text;
cmd.Connection = con;
try
{
int k = cmd.ExecuteNonQuery();
MessageBox.Show("Deleted...");
textBox1.Text = "";
}
catch (Exception ex)
{
MessageBox.Show("Not Deleted:\n" + ex.Message);
}
finally
{
con.Close();
}
}
}
private void DisplayData()
{
}
private void ClearData()
{
txteid.Text = "FHA136";
cmbYr.Text = DateTime.Now.Year.ToString();
datAd.Text = DateTime.Now.ToString("dd/MM/yyyy");
datEmp.Text = DateTime.Now.ToString("dd/MM/yyyy");
DatMod.Text = DateTime.Now.ToString("dd/MM/yyyy");
txtStaf.Text = "Akintomide Ayodele";
txtAdrs.Text = "39 Durban Street, Wuse II, Abuja";
txtCoy.Text = "FHA Homes Ltd";
cmbDpt.Text = "Operations";
cmbLoc.Text = "Abuja";
CmbGrd.Text = "Banking Officer";
TxtAccno.Text = "11234567";
txtemail.Text = "info@fhamortgage.gov.ng";
cmbBank.Text = "United Bank of Africa";
cmbPenAdmin.Text = "Crusader";
cmbStatus.Text = "staff";
txtPenNum.Text = "pen1234";
txtBSal.Text = "20000";
txtDres.Text = "20000";
txtNhis.Text = "10000";
txtEduc.Text = "10000";
txtFurn.Text = "25000";
txtHarz.Text = "20000";
txtTran.Text = "15000";
txtHous.Text = "30000";
txtLunc.Text = "10000";
txtUti.Text = "10000";
txtHousM.Text = "10000";
txtRisk.Text = "20000";
txtVeh.Text = "10000";
txtPfS.Text = "10000";
txtNHF.Text = "10000";
txtNHFS.Text = "10000";
txtOded.Text = "10000";
txtDriv.Text = "10000";
txtDome.Text = "20000";
txtHousU.Text = "10000";
txtStaffM.Text = "20000";
txtThrift.Text = "20000";
cmbMon.Text = DateTime.Now.ToString("MMMM");
this.txtOtherPay.Text = "15000";
textBox1.Text = "";
button1.Text = "";
SN = 0;
}
private void New_Rec()
{
txteid.Text = "";
cmbYr.Text = DateTime.Now.Year.ToString();
datAd.Text = DateTime.Now.ToString("dd/MM/yyyy");
datEmp.Text = DateTime.Now.ToString("dd/MM/yyyy");
DatMod.Text = DateTime.Now.ToString("dd/MM/yyyy");
txtStaf.Text = "";
txtAdrs.Text = "39 Durban Street, Wuse II, Abuja";
txtCoy.Text = "FHA Homes Ltd";
cmbDpt.Text = "Operations";
cmbLoc.Text = "Abuja";
CmbGrd.Text = "Banking Officer";
TxtAccno.Text = "11234567";
txtemail.Text = "info@fhamortgage.gov.ng";
cmbBank.Text = "United Bank of Africa";
cmbPenAdmin.Text = "Crusader";
cmbStatus.Text = "staff";
txtPenNum.Text = "pen1234";
txtBSal.Text = "0";
txtDres.Text = "0";
txtNhis.Text = "0";
txtEduc.Text = "0";
txtFurn.Text = "0";
txtHarz.Text = "0";
txtTran.Text = "0";
txtHous.Text = "0";
txtLunc.Text = "0";
txtUti.Text = "0";
txtHousM.Text = "0";
txtRisk.Text = "0";
txtVeh.Text = "0";
txtPfS.Text = "0";
txtNHF.Text = "0";
txtNHFS.Text = "0";
txtOded.Text = "0";
txtDriv.Text = "0";
txtDome.Text = "0";
txtHousU.Text = "0";
txtStaffM.Text = "0";
txtThrift.Text = "0";
cmbMon.Text = DateTime.Now.ToString("MMMM");
this.txtOtherPay.Text = "0";
textBox1.Text = "";
button1.Text = "";
SN = 0;
}
private void Add_Employee_Load(object sender, EventArgs e)
{
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlLoc = "SELECT * FROM Location";
var lAdapter = new SqlDataAdapter(sqlLoc, con);
var lset = new DataSet();
lAdapter.TableMappings.Add("Table", "Location");
lAdapter.Fill(lset);
this.dviewmanager = lset.DefaultViewManager;
try
{
for (int i = 0; i <= lset.Tables[0].Rows.Count - 1; i++)
{
this.cmbLoc.Items.Add(lset.Tables[0].Rows[i]["Location"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Not successful:\n" + ex.Message);
}
this.cmbMon.Items.Add("January");
this.cmbMon.Items.Add("February");
this.cmbMon.Items.Add("March");
this.cmbMon.Items.Add("April");
this.cmbMon.Items.Add("May");
this.cmbMon.Items.Add("June");
this.cmbMon.Items.Add("July");
this.cmbMon.Items.Add("August");
this.cmbMon.Items.Add("September");
this.cmbMon.Items.Add("October");
this.cmbMon.Items.Add("November");
this.cmbMon.Items.Add("December");
}
}
protected void FillBank()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlStr = "SELECT * FROM BANK";
var dAdapter = new SqlDataAdapter(sqlStr, con);
var dset = new DataSet();
dAdapter.TableMappings.Add("Table", "Bank");
dAdapter.Fill(dset);
this.dviewmanager = dset.DefaultViewManager;
try
{
for (int i = 0; i <= dset.Tables[0].Rows.Count - 1; i++)
{
this.cmbBank.Items.Add(dset.Tables[0].Rows[i]["Bank"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Not successful:\n" + ex.Message);
}
}
protected void FillDpt()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlStr = "SELECT * FROM Dpt";
var dAdapter = new SqlDataAdapter(sqlStr, con);
var dset = new DataSet();
dAdapter.TableMappings.Add("Table", "Dpt");
dAdapter.Fill(dset);
this.dviewmanager = dset.DefaultViewManager;
try
{
for (int i = 0; i <= dset.Tables[0].Rows.Count - 1; i++)
{
this.cmbDpt.Items.Add(dset.Tables[0].Rows[i]["Dpt"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Not successful:\n" + ex.Message);
}
}
protected void FillYear()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlStr = "SELECT * FROM Year";
var dAdapter = new SqlDataAdapter(sqlStr, con);
var dset = new DataSet();
dAdapter.TableMappings.Add("Table", "Year");
dAdapter.Fill(dset);
this.dviewmanager = dset.DefaultViewManager;
try
{
for (int i = 0; i <= dset.Tables[0].Rows.Count - 1; i++)
{
this.cmbYr.Items.Add(dset.Tables[0].Rows[i]["Year"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Not successful:\n" + ex.Message);
}
}
protected void FillGrade()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlStr = "SELECT * FROM Grade";
var dAdapter = new SqlDataAdapter(sqlStr, con);
var dset = new DataSet();
dAdapter.TableMappings.Add("Table", "Grade");
dAdapter.Fill(dset);
this.dviewmanager = dset.DefaultViewManager;
try
{
for (int i = 0; i <= dset.Tables[0].Rows.Count - 1; i++)
{
this.CmbGrd.Items.Add(dset.Tables[0].Rows[i]["Grade"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Not successful:\n" + ex.Message);
}
}
protected void FillStatus()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlStr = "SELECT * FROM Status";
var dAdapter = new SqlDataAdapter(sqlStr, con);
var dset = new DataSet();
dAdapter.TableMappings.Add("Table", "Status");
dAdapter.Fill(dset);
this.dviewmanager = dset.DefaultViewManager;
try
{
for (int i = 0; i <= dset.Tables[0].Rows.Count - 1; i++)
{
this.cmbStatus.Items.Add(dset.Tables[0].Rows[i]["Status"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Not successful:\n" + ex.Message);
}
}
protected void FillPenAdmin()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlStr = "SELECT * FROM PenAdmin";
var dAdapter = new SqlDataAdapter(sqlStr, con);
var dset = new DataSet();
dAdapter.TableMappings.Add("Table", "PenAdmin");
dAdapter.Fill(dset);
this.dviewmanager = dset.DefaultViewManager;
try
{
for (int i = 0; i <= dset.Tables[0].Rows.Count - 1; i++)
{
this.cmbPenAdmin.Items.Add(dset.Tables[0].Rows[i]["PenAdmin"].ToString());
}
}
catch (Exception ex)
{
}
}
private void groupBox1_Enter(object sender, EventArgs e)
{
}
private void label14_Click(object sender, EventArgs e)
{
}
private void frmTpay_Enter(object sender, EventArgs e)
{
}
private void txtHousU_TextChanged(object sender, EventArgs e)
{
}
private void label33_Click(object sender, EventArgs e)
{
}
private void txtStaffM_TextChanged(object sender, EventArgs e)
{
}
private void txtPAYE_TextChanged(object sender, EventArgs e)
{
}
private void datEmp_ValueChanged(object sender, EventArgs e)
{
}
private void btnClose_Click(object sender, EventArgs e)
{
this.Dispose();
}
private void txtTran_TextChanged(object sender, EventArgs e)
{
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
}
private void btnNew_Click(object sender, EventArgs e)
{
New_Rec();
}
private void groupBox1_Enter_1(object sender, EventArgs e)
{
}
}
}