DevStudent

// 1. create a command object identifying         // the stored procedure         SqlCommand cmd  = new SqlCommand(               .

//Disconnected architecture - delete         //Delete product         private void BtnDeleteProduct_Click(object sender, EventArgs e)        .

//Disconnected - update         //Update product name based on the product name under a category         private void BtnUpdateProduct_Click(object sender, EventArgs e)        .

//Disconnected Insert         //Adding product         private void BtnAddProduct_Click(object sender, EventArgs e)         { SqlConnection.

//Disconnected - Select         //Populate the datagridview with registered users information         public void GetData()         { SqlConnection.

DataSet is used in disconnected architecture to store database tables. It can hold multiple tables in it. It is used to store information retrieved by DataAdapter in disconnected architecture. Data adapter will execute the command and fill the dataset.

DataAdapter is used to disconnected architecture to execute all the commands. It is capable of opening the connection to the database server, executing the command, Storing data in DataSet and closing the connection. .

//Connected architecture - delete         //Delete Category         private void BtnDeleteCategory_Click(object sender, EventArgs e)        .

//Connected Architecture - update         //Update Category         private void BtnUpdateCategory_Click(object sender, EventArgs e)        .

SQL Command to create SQL table CREATE TABLE [dbo].[Tbl_Data](        [Id] [int] IDENTITY(1,1) NOT NULL,        [UserName] [varchar](50) NULL,       .