Advanced Data Access ADO VB 6 MCSD DORON

Advanced Data Access ADO VB 6 דורון אמיר : מרצה MCSD DORON AMIR www. doronamir. com

Advanced Data Access stored procedure 1. 2. 3. 4. Overview of Microsoft SQL Server™ security Using cursors Enforcing data integrity Executing statements on a database Written by: MCSD Doron Amir

Cursor Type You can implement four types : : cursors: • Dynamic • keyset. • Static • forward-only Dim rs. Publishers As Recordset Set rs. Publishers = New Recordset With rs. Publishers . Open "SELECT emp_id FROM pubs", cn. Pubs, ad. Open. Dynamic End With

Lock Type – מסד הנתונים נועל את ad. Lock. Optimistic n. Update הרשומה רק בקריאה ל – זהה ל ad. Lock. Batch. Optimistic n ומאפשר עדכון של הרבה , ad. Lock. Optimistic (Update. Batch רשומות בו זמנית )ע"י קריאה ל Written by: MCSD Doron Amir

Cursor Type+ Lock Type Set rs. Students = New Recordset rs. Students. Open "SELECT emp_id FROM employee", cn. Pubs, _ ad. Open. Keyset, ad. Lock. Pessimistic Written by: MCSD Doron Amir

INSERT INTO… VALUES… Written by: MCSD Doron Amir

בניית שאילתה להזנת נתונים למסד INSERT INTO… VALUES… Dim sql As String _ & " , sql = "INSERT INTO Publishers(pub_id, pub_name _ & " (“city, state, country _ & "' , '" & “VALUES('" & txt. Pub. ID. Text _ & "' , '" & txt. Pub. Name. Text _ & "' , '" & txt. Pub. City. Text _ & "' , '" & txt. Pub. State. Text "('" & txt. Pub. Country. Text Written by: MCSD Doron Amir

ביצוע השאילתה cn. Pubs. Execute sql להצגת הרשומות record. Set בניית rs. Publishers. Open "Select * from Publishers“_ cn. Pubs, ad. Open. Keyset, ad. Lock. Pessimistic , Written by: MCSD Doron Amir

Binding The Record. Set txt. Pub. ID. Data. Source = rs. Publishers txt. Pub. ID. Data. Field = "pub_id" Set txt. Pub. Name. Data. Source = rs. Publishers txt. Pub. Name. Data. Field = "pub_name" Set txt. Pub. City. Data. Source = rs. Publishers txt. Pub. City. Data. Field = "city" Set txt. Pub. State. Data. Source = rs. Publishers txt. Pub. State. Data. Field = "state" Set txt. Pub. Country. Data. Source = rs. Publishers txt. Pub. Country. Data. Field = "country" Written by: MCSD Doron Amir

Executing statements on a database stored procedure Written by: MCSD Doron Amir

Byroyalty Procedure Written by: MCSD Doron Amir

Title Authors Written by: MCSD Doron Amir

Command Object Written by: MCSD Doron Amir

Use ! Mark Set rs. Pubs = comand. Pubs. Execute Do Until rs. Pubs. EOF lst. Results. Add. Item rs. Pubs!pub_id & " " & rs. Pubs!Type & " - " & rs. Pubs!title_id & " " & rs. Pubs!price rs. Pubs. Move. Next Loop

Advanced Data Access ADO VB 6 דורון אמיר : מרצה MCSD DORON AMIR www. doronamir. com