student ID, student Name, student Address and in a single data table we can store data for specific topic.Like to store student's records you can have students data table, For school accounts you can have accounts data table, For school results you can have results data table.Delete statement helps to delete one or more records from the database table depending on condition. Example "Where student ID = 1 " - It is a condition, means delete student record whose ID number is = 1.When we have a website or an application associated with database (Sql, Oracle, Mysql and so on) then to do manipulation (i.e.There are commonly used databases in our IT Zone SQL - Microsoft SQL Server Oracle - Oracle RDBMS or simply as Oracle MYSQL - Open Source Freeware MSACESS - Microsoft Access Postgre SQL - ORDBMS SAP - To manage customer relationship and other business operations Fox Pro - Database IBM DB2 - IBM Database by IBM Now in further we will try to understand about data manipulation statements i.e. Select statement let you to retrieve the data from the database table.For ex : In simple words if you want to pick up single student record, multiple student records or all students records from the table database you just need to use "Select" statement.
Insert, Select, Update and Delete altogether also known as DML (Data Manipulation Language) statements which helps in managing the data with the database within schema objects.
You can add your custom name column names along with data type.
(Data Type : For string data choose - varchar(50) or above, for integer data choose - int) Step 3 Adding connection string to web.config file.
We will not get into more detailed explanation about the database but just a breif for undertsanding.
Database is a collection of data stored in a computer disc space or server space.