Find the web.config file open that web.config file. Then Drag and drop a gridview to the page from the tool box then do the following as shown in below. Add - Edit Delete buttons from the command field and check on the auto generate fields.Replace the above connection string with your copied connection string. Edit link is for to choose which record to edit and delete link is for to delete the selected record.In simple words it is a space where your data is been stored.In a single database we can create any number of data tables.Displaying, Deletion, Updating and Insertion) in the database we have to use only DML Language statements (i.e. Now that you have understoond about data manipulation language, now let's do step by step insert, update, delete and select using c# code with objects.To demonstrate step by step insert update delete and select, we will be using a simple web application, you can choose anything web or windows depending on your requirement the coding part will remain the same.
When we have a website or an application associated with database (Sql, Oracle, Mysql and so on) then to do manipulation (i.e.
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.
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.