private void invoiceNoComboBox_SelectedIndexChanged(object sender, EventArgs e) { string query = ""; query = "Select * From TbAfterManufactureStockOut Where EmployeeName = @EmployeeName Order By StockOutDate"; if (query != "") { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand(query, conn); comm.Parameters.Add("@EmployeeName", SqlDbType.VarChar, 50); comm.Parameters["@EmployeeName"].Value = invoiceNoComboBox.Text; SqlDataAdapter adap = new SqlDataAdapter(); StockOutDataSet dataset = new StockOutDataSet(); StockOutCrystalReport crp = new StockOutCrystalReport(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } crp.SetDataSource(dataset); crystalReportViewer1.ReportSource = crp; } }
private void showButton_Click(object sender, EventArgs e) { string query = ""; query = String.Format( "Select * From TbAfterManufactureStockOut Where StockOutDate >='{0}' AND StockOutDate < '{1}'", fromDateTimePicker.Value.Date, toDateTimePicker.Value.Date.AddDays(1)); if (query != "") { SqlConnection conn = new SqlConnection(this.connectionString); SqlCommand comm = new SqlCommand(query, conn); SqlDataAdapter adap = new SqlDataAdapter(); StockOutDataSet dataset = new StockOutDataSet(); DateToDateStockOutCrystalReport crp = new DateToDateStockOutCrystalReport(); try { conn.Open(); adap.SelectCommand = comm; adap.Fill(dataset, "DataTable1"); } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } finally { conn.Close(); } crp.SetDataSource(dataset); crystalReportViewer1.ReportSource = crp; } }