private void btn_xembaocaox_Click_1(object sender, EventArgs e) { Frm_BaoCaoX_F.TenKho = cbx_khox.Text; Frm_BaoCaoX_F.TenNcc_Kh = cbx_khachhangx.Text; Frm_BaoCaoX_F.TenNv = cbx_nvx.Text; Frm_BaoCaoX_F.TenSp = cbx_spx.Text; Frm_BaoCaoX_F.TuNgay = tbx_tungayx.Text; Frm_BaoCaoX_F.NgayNh_Xu = tbx_ngayxuatx.Text; Frm_BaoCaoX_F.DenNgay = tbx_denngayx.Text; Frm_BaoCaoX_F.Gia = cbx_giax.Text; Frm_BaoCaoX_F m = new Frm_BaoCaoX_F(); m.ShowDialog(); }
private void BaoCaoX_F_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); string sql = @"Data Source=DESKTOP-3SFFPGN\HAUMTA;Initial Catalog=QuanLyKhoHang;Integrated Security=True"; con.ConnectionString = sql; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "BCX"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@TENNV", TenNv)); cmd.Parameters.Add(new SqlParameter("@TENSP", TenSp)); cmd.Parameters.Add(new SqlParameter("@TENKH", TenNcc_Kh)); cmd.Parameters.Add(new SqlParameter("@TENKHO", TenKho)); cmd.Parameters.Add(new SqlParameter("@NGAYXUAT", NgayNh_Xu)); cmd.Parameters.Add(new SqlParameter("@GIA", Gia)); cmd.Parameters.Add(new SqlParameter("@TUNGAY", TuNgay)); cmd.Parameters.Add(new SqlParameter("@DENNGAY", DenNgay)); cmd.Connection = con; cmd.ExecuteNonQuery(); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(ds); reportViewer1.ProcessingMode = ProcessingMode.Local; reportViewer1.LocalReport.ReportPath = "BaoCaoXuat.rdlc"; if (ds.Tables[0].Rows.Count > 0) { ReportDataSource rds = new ReportDataSource(); rds.Name = "BaoCaoXuat"; rds.Value = ds.Tables[0]; reportViewer1.LocalReport.DataSources.Clear(); reportViewer1.LocalReport.DataSources.Add(rds); reportViewer1.RefreshReport(); } else { MessageBox.Show("Không Có Dữ Liệu!"); Frm_BaoCaoX_F bcf = new Frm_BaoCaoX_F(); bcf.Hide(); } }