This C#.net Crud will teach you how to do basic database functions that are CREATE RETIEVE UPDATE and DELETE using Microsoft Server 2012 Database. The INSERT, SELECT, UPDATE and DELETE statements can be used in any database system, because this is support by all relational database systems.
We will learn how to INSERT, SELECT, UPDATE and DELETE in database by writing code to manage the student table in the database named gcbt. student table consist of following columns name,course,fee.
Feature of projects
The system shall be able to record student details : name,course,fee.
The system shall be able to retrieve the student details : name,course,fee.
The system shall be able to Edit and Delete the student details : name,course,fee .
First we have to import the sql namespace.
After that we have to Establish the Database Connection
SqlConnection con = new SqlConnection("Data Source=KOBINATH-PC; Initial Catalog=gcbt; User Id=sa;
bool Mode = true;