private void button2_Click(object sender, EventArgs e) { var db = new TestDBEntities(); var tbl = db.products.Where(a => a.productId == 1); CrystalReport2 rpt = new CrystalReport2(); rpt.SetDataSource(tbl); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.RefreshReport(); }
private void Form1_Load(object sender, EventArgs e) { var db = new TestDBEntities(); var tbl = db.products; BindingSource bs = new BindingSource(); bs.DataSource = tbl.ToList(); CrystalReport2 rpt = new CrystalReport2(); rpt.SetDataSource(tbl); crystalReportViewer1.ReportSource = rpt; crystalReportViewer1.RefreshReport(); }
private void generate_bill1_Load(object sender, EventArgs e) { if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); DataSet2 ds = new DataSet2(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select * from order_user where id=" + j + ""; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds.DataTable1); SqlCommand cmd2 = con.CreateCommand(); cmd2.CommandType = CommandType.Text; cmd2.CommandText = "select * from order_item where order_id=" + j + ""; cmd2.ExecuteNonQuery(); DataTable dt2 = new DataTable(); SqlDataAdapter da2 = new SqlDataAdapter(cmd2); da2.Fill(ds.DataTable2); da2.Fill(dt2); tot = 0; foreach (DataRow dr2 in dt2.Rows) { tot += Convert.ToInt32(dr2["total"].ToString()); } CrystalReport2 myreport = new CrystalReport2(); myreport.SetDataSource(ds); myreport.SetParameterValue("total", tot.ToString()); crystalReportViewer1.ReportSource = myreport; }
private void btn_affiche_Click(object sender, EventArgs e) { if (comboBox1.Text.Trim() != "") { cmd = new SqlCommand("chammpes", c.cnx); cmd.CommandType = CommandType.StoredProcedure; SqlParameter p = new SqlParameter("@id", SqlDbType.VarChar, 15, "@id"); p.Value = comboBox1.Text; cmd.Parameters.Add(p); adapt.SelectCommand = cmd; adapt.Fill(data, "Examain"); if (data.Tables["Examain"].Rows[0][18].ToString() == "Termine") { data.Tables["Examain"].Rows[0][18] = "- Matériel testé certifié en état de marche"; } if (data.Tables["Examain"].Rows[0][18].ToString() == "En Cours") { data.Tables["Examain"].Rows[0][18] = "- Matériel envoyé pour suite de maintenance"; } if (data.Tables["Examain"].Rows[0][18].ToString() == "Reforme") { data.Tables["Examain"].Rows[0][18] = "- Matériel reforme"; } if (data.Tables["Examain"].Rows[0][18].ToString() == "Reforme") { data.Tables["Examain"].Rows[0][18] = "- Maintenance Annule"; } //dataGridView1.DataSource = data.Tables["Examain"]; ex.SetDataSource(data.Tables["Examain"]); crystalReportViewer1.ReportSource = ex; crystalReportViewer1.Refresh(); btnprint.Enabled = true; btnsave.Enabled = true; data.Clear(); } else { MessageBox.Show("saisir N° "); } }
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("schema2.xml"); CrystalReport2 rpt = new CrystalReport2(); rpt.SetDataSource(ds); crystalReportViewer2.ReportSource = rpt; connection.Close(); }