void BindCrystal() { string query = "select * from executive.employesallary"; DataTable dt; dt = sampurnit.DataTable(query); SAMARPANN.Admin.CrystalReport1 crypt = new CrystalReport1(); crypt.SetDataSource(dt); ReportDocument cryRpt = new ReportDocument(); cryRpt.Load(@"D:\Samarpann_mannu\SAMARPANN\SAMARPANN\Admin\CrystalReport1.rpt"); crystalReportViewer1.ReportSource = crypt; crystalReportViewer1.Refresh(); }
public static DataTable DataTable(string query) { if (cn.State != ConnectionState.Open) { cn.Open(); } SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(query,cn); DataTable dt = new DataTable(); da.Fill(dt); return dt; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)