01.protected void Button1_Click(object sender, EventArgs e)
02. {
03.
04. SqlConnection objConn = new SqlConnection();
05. SqlCommand objCmd = new SqlCommand();
06. SqlDataAdapter dtAdapter = new SqlDataAdapter();
07.
08. DataSet ds = new DataSet();
09. DataTable dt = null;
10. string strConnString = null;
11. string strSQL = null;
12.
13. strConnString = "Data Source = WAKDATABASE; Initial Catalog = OT; Persist Security Info=True;user ID = sa; password=P@ssw0rd;";
14.
15.
16. strSQL = @"SELECT Empid, Name, Lastname, Section, SUM(Getmoney) AS Expr1 FROM Cometowork WHERE Date between
17. " + Convert.ToDateTime(TextBox1.Text).ToString("yyyy-MM-dd") + " and " + Convert.ToDateTime(TextBox2.Text).ToString("yyyy-MM-dd")
18. + " GROUP BY Empid, Name, Lastname, Section ORDER BY Section";
19.
20. objConn.ConnectionString = strConnString;
21. var _with1 = objCmd;
22. _with1.Connection = objConn;
23. _with1.CommandText = strSQL;
24. _with1.CommandType = CommandType.Text;
25. dtAdapter.SelectCommand = objCmd;
26.
27. dtAdapter.Fill(ds);
28. dt = ds.Tables[0];
29.
30. dtAdapter = null;
31. objConn.Close();
32. objConn = null;
33.
34. ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", dt));
35. ReportViewer1.LocalReport.ReportPath = "ReportHR.rdlc";
36. ReportViewer1.LocalReport.Refresh();
37.
38. }
