private void generate_purchase_report_Load(object sender, EventArgs e) { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); DataSet3 ds = new DataSet3(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = j; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds.DataTable1); da.Fill(dt); tot = 0; foreach (DataRow dr in dt.Rows) { tot += Convert.ToInt32(dr["product_total"].ToString()); } CrystalReport3 myreport = new CrystalReport3(); myreport.SetDataSource(ds); myreport.SetParameterValue("total", tot.ToString()); crystalReportViewer1.ReportSource = myreport; }
private void button3_Click(object sender, EventArgs e) { CrystalReport3 cr = new CrystalReport3(); SqlConnection con = new SqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDb1"].ConnectionString; string sql = "select * from QR WHERE ID =" + 3; DataSet ds = new DataSet(); SqlDataAdapter ad = new SqlDataAdapter(sql, con); ad.Fill(ds, "Table1"); cr.SetDataSource(ds.Tables["Table1"]); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); }
private void button9_Click(object sender, EventArgs e) { string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=Kyrsovaya.mdb"; OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = ConnectionString; OleDbCommand myCommand; string sq1; sq1 = "SELECT * FROM Клиенты"; myCommand = new OleDbCommand(sq1, connection); connection.Open(); OleDbDataAdapter da = new OleDbDataAdapter(myCommand); DataSet ds = new DataSet(); da.Fill(ds, "Результат"); ds.WriteXmlSchema("schema3.xml"); CrystalReport3 rpt = new CrystalReport3(); rpt.SetDataSource(ds); crystalReportViewer3.ReportSource = rpt; connection.Close(); }
private void button1_Click(object sender, EventArgs e) { try { if (radioButton1.Checked) { cmd = new SqlCommand("Fiche", c.cnx); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter("@dated", SqlDbType.DateTime, 10, "@dated"); SqlParameter p2 = new SqlParameter("@datef", SqlDbType.DateTime, 10, "@datef"); p1.Value = dateTimePicker1.Value; p2.Value = dateTimePicker2.Value; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); adapt.SelectCommand = cmd; adapt.Fill(data, "Examain"); ex.SetDataSource(data.Tables["Examain"]); crystalReportViewer1.ReportSource = ex; crystalReportViewer1.Refresh(); btnsave.Enabled = true; btnprint.Enabled = true; data.Clear(); } if (radioButton2.Checked) { if (comboBox1.Text.Trim() != "") { string num = comboBox1.Text.Substring(0, 7); cmd = new SqlCommand("Fiche2", c.cnx); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter("@idclii", SqlDbType.VarChar, 15, "@idclii"); SqlParameter p2 = new SqlParameter("@dated", SqlDbType.DateTime, 10, "@dated"); SqlParameter p3 = new SqlParameter("@datef", SqlDbType.DateTime, 10, "@datef"); p1.Value = num; p2.Value = dateTimePicker4.Value; p3.Value = dateTimePicker3.Value;; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); adapt.SelectCommand = cmd; adapt.Fill(data, "Examain1"); ex1.SetDataSource(data.Tables["Examain1"]); crystalReportViewer1.ReportSource = ex1; crystalReportViewer1.Refresh(); btnsave.Enabled = true; btnprint.Enabled = true; data.Clear(); } else { MessageBox.Show("saisir client"); } } if (radioButton3.Checked) { if (comboBox1.Text.Trim() != "") { string num = comboBox1.Text.Substring(0, 7); cmd = new SqlCommand("Fiche1", c.cnx); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter("@idcli", SqlDbType.VarChar, 15, "@idcli"); p1.Value = num; cmd.Parameters.Add(p1); adapt.SelectCommand = cmd; adapt.Fill(data, "Examain2"); ex2.SetDataSource(data.Tables["Examain2"]); crystalReportViewer1.ReportSource = ex2; crystalReportViewer1.Refresh(); btnsave.Enabled = true; btnprint.Enabled = true; data.Clear(); } else { MessageBox.Show("saisir client"); } } } catch (Exception ee) { MessageBox.Show("erreur : " + ee.ToString()); } }