EmployeeDataSet
ReportViewer1.ProcessingMode = ProcessingMode.Local; LocalReport report = ReportViewer1.LocalReport; report.ReportPath = "Report/Report.rdlc"; DataSet dSet = systemBusinessLayer.PLZgetAllEmployeesInfo(); ReportDataSource dsAllEmployees = new ReportDataSource(); dsAllEmployees.Name = "dSet"; dsAllEmployees.Value = "dSet"; report.DataSources.Add(dsAllEmployees);
#region GetALLEmployees() public DataSet PLZgetAllEmployeesInfo() { using (SqlConnection conn = new SqlConnection(ConnString)) { SqlCommand cmd = new SqlCommand("procGetAllEmployees", conn); cmd.CommandType = CommandType.StoredProcedure; DataSet dTable = new DataSet("dSet"); SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dTable, "dSet"); return dTable; } } #endregion
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)