private void QRS010_QueryLunch_Load(object sender, EventArgs e) { this.tsbNew.Visible = false; this.tsSeperator1.Visible = false; this.tsbRefresh.Text = "Query"; this.shtQueryList.ActiveSkin = Common.ACTIVE_SKIN; this.shtView.ActiveSkin = Common.ACTIVE_SKIN; CtrlUtil.MappingDataFieldWithEnum(shtQueryList, typeof(eColQueryList)); QueryLunchBiz biz = new QueryLunchBiz(); DataTable dt = biz.GetQueryList(); m_dtQueryList = dt; this.shtQueryList.DataSource = dt; }
private void LoadData() { try { QueryLunchDTO dto = new QueryLunchDTO(); dto.SQLCommand = this.txtSearch.Text.ToNZString(); QueryLunchBiz biz = new QueryLunchBiz(); DataSet dsResult = biz.ExecuteSQLCommand(dto); this.m_dtAllData = null; this.shtView.DataSource = null; this.shtView.RowCount = 0; this.shtView.ColumnCount = 0; if (dsResult.Tables.Count > 0) { if (dsResult.Tables[0].Rows.Count > 0) { this.m_dtAllData = dsResult.Tables[0]; this.shtView.DataSource = m_dtAllData; } else { MessageBox.Show("หาไม่เจอเว้ยยยยยยยย"); } } else { MessageBox.Show("query ภาษาอะไรวะ"); } } catch (DataAccessException ex) { MessageBox.Show("ไปเรียน Query ใหม่ซะไป๊"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }