/// <summary> /// Handles the Click event of the viewButton control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.Web.UI.ImageClickEventArgs"/> instance containing the event data.</param> protected void ViewButton_Click(object sender, ImageClickEventArgs e) { try { string strSQLQuery = string.Empty; string strColumnName = string.Empty; DropDownList cboOperator = null; TextBox txtCriteria = null; CheckBox chbColumn = null; CheckBox chbSelectAll = chbHeaderColumn; QueryBuilderHelper objQueryBuilder = new QueryBuilderHelper(); #region sql query builder objQueryBuilder.TableName = querySearchTree.SelectedNode.Value; if(chbSelectAll.Checked) { objQueryBuilder.ColumnNames.Add(ALLCOLUMNS); } else { for(int intIndex = 0; intIndex < tblColumnNames.Rows.Count; intIndex++) { chbColumn = (CheckBox)(tblColumnNames.Rows[intIndex].Cells[0].FindControl("chbColumns")); if(chbColumn != null) { if(chbColumn.Checked) { objQueryBuilder.ColumnNames.Add(tblColumnNames.Rows[intIndex].Cells[1].Text.ToString()); } } } } for(int intIndex = 0; intIndex < tblColumnNames.Rows.Count; intIndex++) { strColumnName = tblColumnNames.Rows[intIndex].Cells[1].Text; cboOperator = (DropDownList)tblColumnNames.Rows[intIndex].Cells[2].FindControl("cboOperator"); txtCriteria = (TextBox)tblColumnNames.Rows[intIndex].Cells[3].FindControl("txtCriteria"); if(txtCriteria.Text.ToString().Length > 0 && cboOperator.SelectedIndex != 0) { string strCriteria = txtCriteria.Text; strCriteria = strCriteria.Replace("*", "%"); strCriteria = strCriteria.Replace("?", "_"); strCriteria = strCriteria.Replace("'", "''"); objQueryBuilder.AddSubClause(strColumnName, cboOperator.SelectedItem.Text, strCriteria); } } strSQLQuery = objQueryBuilder.BuildQuery(); #endregion txtSQLQuery.Text = strSQLQuery; tblColumnNames.Enabled = true; txtSQLQuery.ReadOnly = true; if(!string.Equals(btnSaveSearch.Text.ToString(), MODIFYSRCH) && ( !string.Equals(btnSaveSearch.Text.ToString(), MODIFYSQL))) { btnSaveSearch.Text = SAVESRCH; } EnableCriteria(); } catch(WebException webEx) { CommonUtility.HandleException(strCurrSiteUrl, webEx, 1); ShowLableMessage(webEx.Message); } catch(Exception ex) { CommonUtility.HandleException(strCurrSiteUrl, ex); } }