Write a console program (ADO.net) to create a table tbl_registration that have fields:
id int primary key,
username varchar,
password varchar,
repassword varchar,
gender varchar,
course varchar,
country varcharAfter this perform the following operation:
- Insert any 5 data into tbl_registration. All the required input should be taken from user
- Display all the record of database table
- Update the name and course of a person to data given by user according to id given by user
- Delete the record of person whose id is given by user
- Display all the record of person who are male and also from country Nepal
- First, create a database named
UserRegistrationPracticalor anything you want in SQL Server. - Change the connectionString in
Registration.csfile according to your SQL Server. - Run the program.