private void btnSelectHelper_Click(object sender, EventArgs e) { string sql = "select * from ees_ss_user"; DataSet ds = new DataSet(); ds = SqlServerHelperUtils.ExecuteSQLQuery(sql); if (ds != null) { dgv.DataSource = ds.Tables[0]; } }
private void btnProcHelper_Click(object sender, EventArgs e) { try { //PROC_EES_S_PDLINE_SELECT DataSet ds = new DataSet(); ds = SqlServerHelperUtils.ExecuteProcedureQuery("PROC_EES_S_PDLINE_SELECT"); if (ds != null) { dgv.DataSource = ds.Tables[0]; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }