01.protected void btnShowReport_Click(object sender, EventArgs e)
02. {
03. SqlConnection con;
04. SqlDataAdapter da ;
05. DataSet ds = new DataSet();
06.
07. con = new SqlConnection(@"Data Source=TONNIVA-NB\;Initial Catalog=DB_EXCEL;Integrated Security=True");
08.
09. da = new SqlDataAdapter("select*from [dbo].[PROJEXT_EXCEL_2-A-1-1]", con);
10. da.Fill(ds);
11. ReportDocument rd = new ReportDocument();
12. rd.Load(Server.MapPath("~/CrystalReport1.rpt"));
13. rd.SetDataSource(ds.Tables[0]);
14. CrystalReportViewer1.ReportSource = rd;
15. CrystalReportViewer1.DataBind();
16. CrystalReportViewer1.RefreshReport();
17. con.Close();
18.
19.
20. }
21.
Load balance : Server 02
ขอบคุณค้าบบ แอสมิน
