1. Build Windows Forms Design for above information using appropriate Controls.
2. Write a function named void RetreivePrograms() to display list of programs from programs Table and display in Control cmbPrograms comoboBox(ADO.NET).
3. Write a function int InsertData() that inserts the values of the controls of above mentioned table into the Student Table and returns 1 if the insertion is success, otherwise returns 0.

d.Show Student name and Program names in Gridview.

1 1 Programs 8 Program_ID Program_Name M Students Roll_No Program_ID Student_Name Gender Birth_Date Table Name: Students Field Name Data Type Constraints Roll No Varchar (12) Primary Key Program ID Int Foreign Key Student Name Varchar(50) mi Gender Varchar (1) Birth Date DateTime Table Name: Programs Field Name Data Type Constraint(s) Program_ID Int Primary Key Program Name Varchar(50) 1 1 Programs 8 Program_ID Program_Name M Students Roll_No Program_ID Student_Name Gender Birth_Date Table Name: Students Field Name Data Type Constraints Roll No Varchar (12) Primary Key Program ID Int Foreign Key Student Name Varchar(50) mi Gender Varchar (1) Birth Date DateTime Table Name: Programs Field Name Data Type Constraint(s) Program_ID Int Primary Key Program Name Varchar(50)