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();
}
