void BindPrinyal(SqlConnection conn) { SqlCommand cmd = new SqlCommand("select ui.Family, ui.[IO], ui.UserId from UserInfo ui " + "join Zayavky z on ui.UserId=z.Prinyal " + "group by ui.Family, ui.[IO], ui.UserId", conn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (!(reader[0] is DBNull)) { prinyalData.Add(new PersonData() { Title = reader[0].ToString() + " " + reader[1].ToString(), Id = reader[1].ToString() }); } } reader.Close(); if (!IsPostBack) { Prinyal.DataSource = prinyalData; Prinyal.DataBind(); } }
protected void Button10_Click(object sender, EventArgs e) { PlaceHolder10.Visible = !PlaceHolder10.Visible; if (PlaceHolder10.Visible) { Prinyal.FindControl("SelectAll").Focus(); } }