Develop a simple web form or .aspx application to load from a SQL server and Oracle databases the orders table and display it on the form/website.
The application should connect to oracle 11g
The application should connect to MS SQL Server database
A form with 2 buttons is needed to load the appropriate database table on click event
Use Visual Studio, [login to view URL], and web forms (or window forms)
this is the order table :
create table tbl_orders
(
order_id VARCHAR2(10) primary key,
order_date TIMESTAMP NOT NULL,
order_total number NOT NULL,
cust_id VARCHAR2(10) NOT NULL,
emp_id VARCHAR2(10) NOT NULL,
order_status VARCHAR2(10),
CONSTRAINT cust_id3 FOREIGN KEY(cust_id) REFERENCES tbl_customers (cust_id),
CONSTRAINT emp_id1 FOREIGN KEY(emp_id) REFERENCES employees (emp_id));
INSERT INTO TBL_ORDERS VALUES ('ORD_01', '01-jan-2014 09:23:34','150','CUS02','EMP01','paid');
INSERT INTO TBL_ORDERS VALUES ('ORD_02', '01-jan-2014 09:23:34','100','CUS01','EMP02','paid');
INSERT INTO TBL_ORDERS VALUES ('ORD_03', '01-jan-2014 09:23:34','200','CUS02','EMP03','pending');
INSERT INTO TBL_ORDERS VALUES ('ORD_04', '01-jan-2014 09:23:34','300','CUS02','EMP04','pending');
INSERT INTO TBL_ORDERS VALUES ('ORD_05', '01-jan-2014 09:23:34','500','CUS02','EMP05','cancelled');
INSERT INTO TBL_ORDERS VALUES ('ORD_06', '01-jan-2014 09:23:34','150','CUS02','EMP05','cancelled');
INSERT INTO TBL_ORDERS VALUES ('ORD_07', '01-jan-2014 09:23:34','600','CUS02','EMP01','cancelled');
INSERT INTO TBL_ORDERS VALUES ('ORD_08', '11-jan-2014 09:23:34','600','CUS02','EMP05','cancelled');
INSERT INTO TBL_ORDERS VALUES ('ORD_09', '01-OCT-2013 09:23:34','1200','CUS04','EMP02','paid');
INSERT INTO TBL_ORDERS VALUES ('ORD_10', '01-JAN-2014 09:23:34','900','CUS01','EMP02','pending');
INSERT INTO TBL_ORDERS VALUES ('ORD_11', '01-JAN-2014 09:23:34','800','CUS01','EMP03','paid');
INSERT INTO TBL_ORDERS VALUES ('ORD_12', '01-JAN-2014 09:23:34','700','CUS01','EMP05','paid');
insert INTO tbl_orders values('ORD_13', '11-jun-2014 09:23:34','600','CUS05','EMP03','paid');
insert INTO tbl_orders values('ORD_14', '11-jun-2014 09:23:34','500','CUS05','EMP05','paid');
insert INTO tbl_orders values('ORD_15', '11-jun-2014 09:23:34','900','CUS06','EMP02','paid');
insert INTO tbl_orders values('ORD_16', '11-may-2014 09:23:34','300','CUS06','EMP02','paid');