private void frmReport_DT_Load(object sender, EventArgs e) { SqlConnection connect; connect = new SqlConnection(@"server=.\SQLEXPRESS; Database=QuanLiCaPhe;integrated security=true"); connect.Open(); SqlDataAdapter da = new SqlDataAdapter(); string query = "SELECT * FROM tblDoanhThu"; SqlDataAdapter dscm = new SqlDataAdapter(query, connect); DSDoanhThu ds = new DSDoanhThu(); dscm.Fill(ds, "tblDoanhThu"); connect.Close(); Report_DT objRpt = new Report_DT(); objRpt.SetDataSource(ds.Tables[1]); crystalReportViewer_DT.ReportSource = objRpt; crystalReportViewer_DT.Refresh(); }
private void button1_Click(object sender, EventArgs e) { if (txtSoLuong.Text == "") { MessageBox.Show("Vui lòng nhập số lượng bàn bạn muốn xem"); } else { int i = int.Parse(txtSoLuong.Text); SqlConnection connect; connect = new SqlConnection(@"server=.\SQLEXPRESS; Database=QuanLiCaPhe;integrated security=true"); connect.Open(); SqlDataAdapter da = new SqlDataAdapter(); string query = "SELECT top " + i + " * FROM tblBanSDNhieu ORDER BY LuotSD DESC"; SqlDataAdapter dscm = new SqlDataAdapter(query, connect); DSDoanhThu ds = new DSDoanhThu(); dscm.Fill(ds, "tblBanSDNhieu"); connect.Close(); Report_BanSDNhieu objRpt = new Report_BanSDNhieu(); objRpt.SetDataSource(ds.Tables[1]); crystalReportViewer_BanSDNhieu.ReportSource = objRpt; crystalReportViewer_BanSDNhieu.Refresh(); } }