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);
}
}
