DevStudent

// 1. create a command object identifying

        // the stored procedure

        SqlCommand cmd  = new SqlCommand(

               "CustOrderHist", conn);

        // 2. set the command object so it knows

        // to execute a stored procedure

        cmd.CommandType = CommandType.StoredProcedure;

        // 3. add parameter to command, which

        // will be passed to the stored procedure

        cmd.Parameters.Add(

               new SqlParameter("@CustomerID", custId));

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 with the data retrieved by execution of SQL command.

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 - update

        //Update Category

        private void BtnUpdateCategory_Click(object sender, EventArgs e)

        {

            //SqlCommand to update Category

            SqlCommand cmd = new SqlCommand("exec Usp_UpdateCategory '"+CBExistingCategories.Text+"','"+TxtUpdateCategory.Text+"'", con);

            //Open connection

            con.Open();

            //Execute update command

            int i = cmd.ExecuteNonQuery();

            con.Close();

            if (i > 0)

            {

                //Refresh Category list

                PopulateCategories();

                //Show first Category

                CBExistingCategories.SelectedIndex = 0;

                MessageBox.Show("Category Updated Successfully");

            }

            else { MessageBox.Show("Category Not Updated"); }

           

        }