private void crystalReportViewer1_Load(object sender, EventArgs e)
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
DataSet1 ds = new DataSet1();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from orderUser 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 items 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 = tot + Convert.ToInt32(dr2["total"].ToString());
}
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(ds);
myreport.SetParameterValue("total", tot.ToString());
crystalReportViewer1.ReportSource = myreport;
}
private void button1_Click(object sender, EventArgs e)
{
try
{
DataSet1 ds = new DataSet1();
SqlCommand cmd = con.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from issue_books where books_return_date=''";
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds.DataTable1);
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(ds);
crystalReportViewer1.ReportSource = myreport;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void loadPrint()
{
if (salescommit == "1")
{
string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'";
string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'";
try
{
aa.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(q1, aa);
DataSet1 mydataset = new DataSet1();
da.Fill(mydataset, "Sales");
da.Dispose();
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = new SqlCommand(q2, aa);
da2.Fill(mydataset, "SalesSummary");
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(mydataset);
PrintMemo pm = new PrintMemo();
pm.crystalReportViewer1.ReportSource = myreport;
pm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
aa.Close();
}
}
else
{
MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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("schema.xml");
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(ds);
crystalReportViewer1.ReportSource = rpt;
connection.Close();
}
private void loadPrint()
{
if(commit == "1")
{
string q1 = "select itemCode,itemName,quantity,unitPrice,Amount,sReturn from Sales where salesNo='" + sl + "'";
string q2 = "select salesNo,sDate,total,salesType,creditCardPer,discountPer,vatAmount,grandTotal,receive,change from SalesSummary where salesNo='" + sl + "'";
try
{
aa.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand(q1, aa);
DataSet1 mydataset = new DataSet1();
da.Fill(mydataset, "Sales");
da.Dispose();
SqlDataAdapter da2 = new SqlDataAdapter();
da2.SelectCommand = new SqlCommand(q2, aa);
da2.Fill(mydataset, "SalesSummary");
CrystalReport1 myreport = new CrystalReport1();
myreport.SetDataSource(mydataset);
PrintMemo pm = new PrintMemo();
pm.crystalReportViewer1.ReportSource = myreport;
pm.Show();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
aa.Close();
}
}
else
{
MessageBox.Show("First commit sales by Clicking Save Button!", "error!!!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}