DAO CONNECTIVITY (VB)













Comments

Post a Comment

Popular posts from this blog

DBMS Lab Cycle 6 (client_master, product_master, salesman_master, sales_order, sales_order_details)

Image
CREATE THE FOLLOWING TABLES AND INSERT THE VALUES client_master product_master salesman_master sales_order sales_order_details CREATE TABLE client_master( client_no VARCHAR2(10), name VARCHAR2(50), city VARCHAR2(40), pincode NUMBER(6), state VARCHAR2(40), bal_due NUMBER(9,2), PRIMARY KEY(client_no) ); INSERT INTO client_master VALUES ('C00001','Anup Dalal','Mumbai',400054,'Maharashtra',15000); INSERT INTO client_master  VALUES ('C00002','Vandana Srivastava','Chennai',600018,'Tamil Nadu',0); INSERT INTO client_master  VALUES ('C00003','Kaustubh Khare','Mumbai',400056,'Maharashtra',5000); INSERT INTO client_master  VALUES ('C00004','Ashok Agarwal','Mumbai',400057,'Maharashtra',0); INSERT INTO client_master  VALUES ('C00005','Vivek Misra','Delhi...
Read more

DBMS Lab Cycle 4 (sailor,boat,reserve)

Image
Create the following tables and execute the queries given below sailor boat reserve CREATE TABLE sailors( sid NUMBER(3), sname varchar2(100), rating NUMBER(2), age NUMBER(3), PRIMARY KEY(sid) ); INSERT INTO sailors VALUES(22,'Dustin',7,45); INSERT INTO sailors VALUES(29,'Brutas',1,33); INSERT INTO sailors VALUES(31,'Luber',8,55); INSERT INTO sailors VALUES(32,'Andy',8,25); INSERT INTO sailors VALUES(58,'Rusty',10,35); INSERT INTO sailors VALUES(64,'Horatio',9,35); INSERT INTO sailors VALUES(71,'Zorba',10,16); INSERT INTO sailors VALUES(74,'Horatio',9,35); INSERT INTO sailors VALUES(85,'Art',3,25.5); INSERT INTO sailors VALUES(95,'Bob',3,63.5); CREATE TABLE boats( bid NUMBER(3), bname VARCHAR2(50), color VARCHAR2(25), PRIMARY KEY(bid) ); INSERT INTO boats VALUES(101,'Interlake','Blue'); INSERT INTO boats VALUES(102,'Inter...
Read more

DBMS Lab Cycle 2 (student_info)

Image
1.  Create the table STUDENT_INFO with Columns: Sid, Stud_name & stude_score . create table STUDENT_INFO( sid NUMBER(3) NOT NULL, stud_name VARCHAR2(100) NOT NULL, stud_score NUMBER(3) DEFAULT 20, primary key(sid) ); -->   Insert  values into STUDENT_INFO with the following constraints: Stud name NOT NULL and stude_score DEFAULT value of 20 . INSERT INTO STUDENT_INFO (sid,stud_name) VALUES(9,'Adharsh Sunny'); INSERT INTO STUDENT_INFO VALUES(2'Dimal Mathew',200); INSERT INTO STUDENT_INFO VALUES(3,'Arun Joji',170); INSERT INTO STUDENT_INFO VALUES(4,'MAnuel Cherian',180); INSERT INTO STUDENT_INFO VALUES(5,'Christin Chacko',90); INSERT INTO STUDENT_INFO VALUES(6,'Jithu Sebastian',110); INSERT INTO STUDENT_INFO VALUES(7,'Fazil Habeeb',160); INSERT INTO STUDENT_INFO VALUES(8,'Visakh harikumar',101); -->   Update stude_score by adding a value of 5 to stude_score in the table STUDENT_...
Read more