private void btnIn_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"SERVER = DESKTOP-5HGTV4A; uid = sa; pwd = 12112014; DATABASE = QuanLyKhachSan"); conn.Open(); SqlCommand command = new SqlCommand("SELECT * FROM PhieuDangKy", conn); SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet ds = new DataSet("tbPhieuDangKy"); adapter.Fill(ds, "tbPhieuDangKy"); conn.Close(); rpPhieuDangKy rp = new rpPhieuDangKy(); rp.DataSource = ds; rp.DataMember = ds.Tables["tbPhieuDangKy"].TableName; rp.ShowPreview(); }
private void btnIn_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"SERVER = DESKTOP-5HGTV4A; uid = sa; pwd = 12112014; DATABASE = QuanLyKhachSan"); conn.Open(); string sql = "select * from PhieuDangKy where MaPhieuDK = '" + txtTuKhoa.Text + "'"; SqlCommand command = new SqlCommand(sql, conn); SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet ds = new DataSet("tbPhieuDangKy"); adapter.Fill(ds, "tbPhieuDangKy"); conn.Close(); rpPhieuDangKy rp = new rpPhieuDangKy(); rp.DataSource = ds; rp.DataMember = ds.Tables["tbPhieuDangKy"].TableName; rp.ShowPreview(); }