public void Read(string s) { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand("SELECT *FROM Vw_EmployeeDatebaseWIthPhoto WHERE CompanyName = @CompanyName ORDER BY EmployeeID", conn); //comm.CommandType = CommandType.StoredProcedure; comm.Parameters.Add("@CompanyName", SqlDbType.VarChar, 30); comm.Parameters["@CompanyName"].Value = comboBox5.Text; SqlDataAdapter adap = new SqlDataAdapter(); DatabaseDataSet dataset = new DatabaseDataSet(); DatabaseCrystalReport1 crp = new DatabaseCrystalReport1(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); crp.SetDataSource(dataset); crystalReportViewer1.ReportSource = crp; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } }
public void Read() { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand("SELECT *FROM Vw_EmployeeDatebaseWIthPhoto ORDER BY EmployeeID", conn); //comm.CommandType = CommandType.StoredProcedure; SqlDataAdapter adap = new SqlDataAdapter(); DatabaseDataSet dataset = new DatabaseDataSet(); DatabaseCrystalReport1 crp = new DatabaseCrystalReport1(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); crp.SetDataSource(dataset); crystalReportViewer2.ReportSource = crp; } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } }