Write a VB.NET program to accept the details of a Supplier (SupId, SupName, Phone No, Address), store it in the database, and display it.
Answer:
Practical Programs
.Net Programs
Write a VB.NET program to create a table Patient (PID, PName, Contact No, Disease). Insert five records into the table and display an appropriate message in a message box.
Answer: Sample Patient Table (PatientDB.accdb): PID (AutoNumber) PName ContactNo Disease 1 John Doe 123-456-7890 Flu 2 Jane Smith 987-654-3210 Cold
.Net Programs
Write an ASP.Net program to create a Login Module which adds Username and Password to the database. The Username in the database should be a primary key.
Answer: Table Name: Users Field Data Type Constraints Username Short Text Primary Key Password Short Text Not Null Default.aspx: Default.aspx.cs:
.Net Programs
Create a Web Application in ASP.Net to display all the EmpName and DeptId of the employees from the database using SQL source control and bind it to a GridView. Database fields are (DeptId, DeptName, EmpName, Salary).
Answer: Table Name: Employees Field Data Type DeptId int DeptName varchar EmpName varchar Salary decimal Sample SQL Query to Create
.Net Programs
Create an ASP.Net application that accepts name, password, age, email ID, and user ID. All the information entries are compulsory. The password should be reconfirmed. Age should be within 21 to 30. Email ID should be valid. User ID should have at least one capital letter, one digit, and its length should be between 7 and 20 characters.
Answer: Default.aspx: Default.aspx.cs:
.Net Programs
Write a VB.NET program to design the following form; it contains three menus: Color (Red, Blue, Green), Window (Maximize, Minimize, Restore), and Exit. On selection of any menu or submenu, the result should affect the form control (for example, if the user selects Red color from the Color menu, the back color of the form should change to Red, and if the user selects Maximize from the Window menu, the form should be maximized)
Answer: