private void Inhoadon_Load(object sender, EventArgs e) { Hamchung hc = new Hamchung(); SqlConnection cnn = new SqlConnection(hc.sqlCon); cnn.Open(); SqlDataAdapter da = new SqlDataAdapter("rpHoadon '"+MainForm.frmHoadon.Madangchon+"'", cnn); DataTable dt = new DataTable(); da.Fill(dt); SqlCommand cmd = new SqlCommand("Tongtien", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaHD", MainForm.frmHoadon.Madangchon); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); string Tongtien = reader[0].ToString(); ReportHoadon cr = new ReportHoadon(); cr.SetDataSource(dt); cr.SetParameterValue("MaHD", MainForm.frmHoadon.Madangchon); cr.SetParameterValue("Tenkhachhang", MainForm.frmHoadon.tenkh); cr.SetParameterValue("Tennhanvien", MainForm.frmHoadon.tennv); cr.SetParameterValue("Makhachhang", MainForm.frmHoadon.makh); cr.SetParameterValue("Ngaylap", MainForm.frmHoadon.nl); try { cr.SetParameterValue("Tongtien", Tongtien); } catch { MessageBox.Show("Hóa đơn này rỗng"); return; } rptvHoadon.ReportSource = cr; cnn.Close(); }
private void DanhsachKH_Load(object sender, EventArgs e) { Hamchung hc = new Hamchung(); SqlConnection cnn = new SqlConnection(hc.sqlCon); cnn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from Khachhang", cnn); DataTable dt = new DataTable(); da.Fill(dt); ReportKhachhang kh = new ReportKhachhang(); kh.SetDataSource(dt); rptvKhachhang.ReportSource = kh; cnn.Close(); }
private void DanhsachNXB_Load(object sender, EventArgs e) { Hamchung hc = new Hamchung(); SqlConnection cnn = new SqlConnection(hc.sqlCon); cnn.Open(); SqlDataAdapter da = new SqlDataAdapter("select * from NXB", cnn); DataTable dt = new DataTable(); da.Fill(dt); reportNXB nxb = new reportNXB(); nxb.SetDataSource(dt); rptvNXB.ReportSource = nxb; cnn.Close(); }