01.protected void Button1_Click(object sender, EventArgs e)
02. {
03. SqlConnection objConn = new SqlConnection();
04. SqlCommand objCmd = new SqlCommand();
05. SqlDataAdapter dtAdapter = new SqlDataAdapter();
06.
07. DataSet ds = new DataSet();
08. DataTable dt = null;
09. string strConnString = null;
10. string strSQL = null;
11.
12. strConnString = "Data Source=(local)\\SQLExpress05;Initial Catalog=KRIS;Integrated Security=SSPI";
13. strSQL = "SELECT * FROM reportProduct_V";
14.
15. objConn.ConnectionString = strConnString;
16. var _with1 = objCmd;
17. _with1.Connection = objConn;
18. _with1.CommandText = strSQL;
19. _with1.CommandType = CommandType.Text;
20. dtAdapter.SelectCommand = objCmd;
21.
22. dtAdapter.Fill(ds);
23. dt = ds.Tables[0];
24.
25. dtAdapter = null;
26. objConn.Close();
27. objConn = null;
28.
29. ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("ReportDataSet_GoodsByDept", dt));
30. ReportViewer1.LocalReport.ReportPath = "RepGoodsByDept.rdlc";
31. ReportViewer1.LocalReport.Refresh();
32.
33. }
จัดไปครับ
