protected override void Fire(object sender, EventArgs e) { DBC dbc = new DBC(); //dbc.open(); //dbc.select("SELECT UserID FROM Users A, Roles B WHERE A.JobCode = B.JobCode AND B.GroupName in ('Doctors','nurse','administrator')", Param); //Data result = dbc.select("SELECT * FROM Room WHERE RoomID = @roomID", Param); Data data = new Data(); data.add("RoomID", Param.get("RoomID")); RoomBiz doctor = new RoomBiz(); Data result = doctor.view(data); Data owners = doctor.droplist(data); RoomType.Text = result.getString("Type"); Beds.SelectedValue = result.getString("Beds"); RoomOwner.DataSource = owners.Source; RoomOwner.DataBind(); RoomOwner.SelectedValue = result.getString("UserId"); RoomLabel.Text = result.getString("RoomID"); RoomID.Value = result.getString("RoomID"); DeptName.Value = Param.getString("DeptName"); }