private void btnSearch_Click(object sender, EventArgs e) { if (searchtext.Text == "") { MessageBox.Show("Plese Inter Employee's ID you are searching for"); searchtext.Focus(); } else { OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Employees.mdb"); OleDbDataAdapter ad = new OleDbDataAdapter("select * from Employee where EmpID=@EmpID", con); ad.SelectCommand.Parameters.Add("@EmpID", OleDbType.Integer); ad.SelectCommand.Parameters["@EmpID"].Value = int.Parse(searchtext.Text); DataSet ds = new DataSet(); ad.Fill(ds, "Emp"); DGV1.DataSource = ds.Tables["Emp"]; if (ds == null) { MessageBox.Show("not found!!"); } else { MessageBox.Show("The Employee you are searching for is listed down, if you want to update the data click the arrow sign on the lift side of the record"); } }
if(ds.Tables["Emp"].Rows.Count>0) { MessageBox.Show("Found !!"); } else { MessageBox.Show("not found!!"); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)