private void Submit_btn_Click(object sender, EventArgs e)
{
SqlConnection cnn;
string connectionString = null;
string sql = null;
connectionString = ConfigurationManager.ConnectionStrings["coonstring"].ConnectionString;
cnn = new SqlConnection(connectionString);
cnn.Open();
sql = "SELECT BillNo,Date,Grandtotal,BrannchName,Location,PhoneNo FROM Tbl_Sales inner join Tbl_BranchMaster on Tbl_BranchMaster.BranchId=1 where Tbl_Sales.Date between'" + From_dateTimePicker.Text + "'and '" + To_dateTimePicker.Text + "'";
SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn);
SalesReportDataSet ds = new SalesReportDataSet();
dscmd.Fill(ds);
// MessageBox.Show(ds.Tables[1].Rows.Count.ToString());
cnn.Close();
SalesCrystalReport objRpt = new SalesCrystalReport();
objRpt.SetDataSource(ds.Tables[1]);
SalesReportViewer.ReportSource = objRpt;
SalesReportViewer.Refresh();
}
private void button_ViewSalesReport_Click(object sender, EventArgs e)
{
conn.Open();
// cmd = new SqlCommand("select stud_id, stud_gradelevel, stud_section, stud_firstname,stud_age, stud_middlename, stud_lastname, stud_gender, stud_datetime from table_student where convert (datetime,stud_datetime) >= '" + dateTimePicker1.Value.ToShortDateString() + "' and convert (datetime,stud_datetime) <= '" + dateTimePicker2.Value.ToShortDateString() + "';", conn);
cmd = new SqlCommand("select transactionid, total, discount, subtotal, vatable, totaldue, cashtender, change, dateandtime from postotalsalepertransaction where (dateandtime) >='" + dtp_SalesFrom.Text + "' and dateandtime <= '" + dtp_SalesTo.Text + "';", conn);
cmd.CommandType = CommandType.Text;
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
SalesReport salesreport = new SalesReport();
salesreport.SetDataSource(dt);
SalesReportViewer.ReportSource = salesreport;
SalesReportViewer.Refresh();
conn.Close();
}
