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