Real Life Example for ASP.Net

How TO Insert Data In MSsql DataBase with ASP.NET (C#). So let's Start Now...  You must do 5 steps for insert, update, and delete (DML)Operations. Step 1: Add " using System.Data.SqlClient ; ". Step 2: Create Object of SqlConnection...  like this..  ( SqlConnection Objname = new SqlConnection(); ) Step 3: Crate Object of SqlCommand.... like this... ( SqlCommand  cmd = new SqlCommannd(); ). Step 4: After create Objects of sqlconnection and sqlcommand You Open the Connection. Like this (Objname.Open() ;) Step 5: Execute your Query... Here Example::::...... -------------------------------------------------------------------------------------------                                                                   Code Start ------------------------------------------------------------------...

This is for beginner...      How to create DATABASE in MSSQL ? CREATE DATABASE databasename      How to use DATABASE in MSSQL ? USE databasename     How to create table in MS-SQL ? CREATE TABLE tablename              (                                                                                    columb_ID INT,                                  column_Name VARCHAR (100),  )                                           ...