internal frmParameterNew(mdlReportParameters obj_mdlReportPara) { obj_mdlReportParaa = obj_mdlReportPara; InitializeComponent(); }
public DataTable GetReportListParameters(mdlReportParameters reportPara) { DataTable dt = new DataTable(); dt = obj_ReportPara.GetReportParametersDetail(reportPara); return dt; }
public DataTable GetReportParametersDetail(mdlReportParameters reportPara) { DataTable dt = new DataTable(); try { SqlCommand cmd = new SqlCommand("stp_ERP_ReportParameters", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ReportID", SqlDbType.VarChar, 50).Value = reportPara.ReportID; SqlDataAdapter ad = new SqlDataAdapter(cmd); conn.Open(); ad.Fill(dt); if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception) { MessageBox.Show(" Please contact system administrator!", "Babar Medicine Company Lahore - ERP ", MessageBoxButtons.OK, MessageBoxIcon.Error); } return dt; }