//Alt + 1 View Data by No public void GetViewDataByNo(Window frmParent) { PromptForm._frmParent = frmParent; string tableName = ""; MessageBoxResult result = PromptForm.ShowCombobox("ViewDataByNo", "Table Name", ref tableName); if (result == MessageBoxResult.Cancel) { return; } string colName = ""; result = PromptForm.ShowText("ViewDataByNo", "Column Name", ref colName); if (result == MessageBoxResult.Cancel) { return; } if (string.IsNullOrEmpty(colName)) { colName = "*"; } string strWhere = string.Empty; if (SQLDBUtil.ColumnIsExistInTable(tableName, "AAStatus")) { strWhere = "AAStatus = 'Alive'"; } string strQuery = SQLDBUtil.GenerateQuery(tableName, strWhere, colName); //DataTable dtData = SQLDBUtil.GetDataByTable(tableName, strWhere, colName); //if (dtData == null) return; //dtData.TableName = tableName; ShowResultData(frmParent, null, strQuery); }