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; }