public void searchLawyer(searchuser su)
{
SqlCommand myCommand = new SqlCommand("SELECT * FROM Employee WHERE baro_no=@searching_baro_no", con);
myCommand.Parameters.AddWithValue("@searching_baro_no", su.searching_baro_no);
con.Open();
SqlDataReader dr = myCommand.ExecuteReader();
if (dr.Read())
{
su.name = dr[1].ToString();
su.surname = dr[2].ToString();
su.address = dr[3].ToString();
su.phone = dr[4].ToString();
}
con.Close();
/*
* da = new SqlDataAdapter("SELECT * FROM Employee WHERE baro_no=@searching_baro_no", con);
* cmd.Parameters.AddWithValue("@searching_baro_no", uu.updating_baro_no);
* ds = new DataSet();
* con.Open();
* da.Fill(ds, "employee");
*
*
* con.Open();
* cmd.ExecuteNonQuery();
* con.Close();
*/
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
searchuser su = new searchuser();
DataConnection dct = new DataConnection();
su.searching_baro_no = Convert.ToInt32(TextBox1.Text);
su.baro_no = Convert.ToInt32(TextBox1.Text);
su.searchLawyer();
Label1.Text = su.name + " " + su.surname + " " + su.address + " " + su.phone + " ";
Label1.Visible = true;
}
