public void searchutesubmit_click(Object sender, EventArgs e) { StringBuilder sqlString = new StringBuilder("SELECT ACCOUNT.UID, (ISNULL(ACCOUNT.SURNAME,'')+' '+ISNULL(ACCOUNT.NAME,'')+' ('+ISNULL(OFFICES.OFFICE,'')+')') AS DESCRIZIONE "); sqlString.AppendFormat("FROM ACCOUNT LEFT OUTER JOIN OFFICES ON ACCOUNT.OFFICEID=OFFICES.ID WHERE (ACCOUNT.NAME LIKE '%{0}%' ", SearchUser.Text); sqlString.AppendFormat("OR ACCOUNT.SURNAME LIKE '%{0}%') ORDER BY SURNAME,NAME ASC", SearchUser.Text); OfficeUsers.DataTextField = "descrizione"; OfficeUsers.DataValueField = "uid"; OfficeUsers.DataSource = DatabaseConnection.CreateDataset(sqlString.ToString()); OfficeUsers.DataBind(); SetAccount(GroupValue.Value); }
public void Offices_SelectedIndexChanged(Object sender, EventArgs e) { if (((DropDownList)sender).SelectedIndex != 0) { OfficeUsers.DataTextField = "descrizione"; OfficeUsers.DataValueField = "uid"; string sqlString = "SELECT ACCOUNT.UID, (ACCOUNT.SURNAME+' '+ACCOUNT.NAME+' ('+OFFICES.OFFICE+')') AS DESCRIZIONE "; sqlString += "FROM ACCOUNT INNER JOIN OFFICES ON ACCOUNT.OFFICEID=OFFICES.ID WHERE ACCOUNT.OFFICEID=" + int.Parse(Offices.SelectedItem.Value) + " ORDER BY SURNAME,NAME ASC"; OfficeUsers.DataSource = DatabaseConnection.CreateDataset(sqlString); OfficeUsers.DataBind(); } else { OfficeUsers.Items.Clear(); } }