使用asp.net c#从代码中添加、更新和删除数据库数据

我的连接字符串是:

<connectionStrings>
<add name="NorthwindConnectionString" 
connectionString="Data Source=.'SQLEXPRESS;AttachDbFilename=|DataDirectory|'SecurityTutorials.mdf;Integrated Security=True;User Instance=True" 
providerName="System.Data.SqlClient"/>
</connectionStrings>

connection = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString)

目前我正在使用下面的代码在我的。aspx页面添加，更新和删除数据库中的数据。

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" 
        SelectCommand="SELECT [ProductID], [ProductName], [Discontinued] FROM [Alphabetical list of products]"
        InsertCommand = "INSERT INTO [Alphabetical list of products] (ProductID, ProductName, Discontinued)VALUES(@ProductID,@ProductName,@Discontinued)"
        UpdateCommand = "UPDATE [Alphabetical list of products] SET [ProductName] = @ProductName WHERE [ProductID] = @ProductID"
        DeleteCommand = "DELETE FROM [Alphabetical list of products] WHERE [ProductID]=@ProductID">
        <InsertParameters>
            <asp:Parameter Name="ProductID" Type="String" />
            <asp:Parameter Name="ProductName" Type="String" />
            <asp:Parameter Name="Discontinued" Type="String" />
        </InsertParameters>           
        <UpdateParameters>
            <asp:Parameter Name="ProductName" Type="String" />             
            <asp:Parameter Name="ProductID" Type="Int32" />
        </UpdateParameters>
        <DeleteParameters>
            <asp:Parameter Name="ProductID" Type="Int32" />
        </DeleteParameters>
    </asp:SqlDataSource>

我正在使用ListView，并通过下面的代码，我可以访问所有和编辑数据库的所有数据后面的代码:

 using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString))
    {
        var selectCommand = new SqlCommand("SELECT [ProductID], [ProductName], [Discontinued] FROM [Alphabetical list of products]");
        var dataAdapter = new SqlDataAdapter();
        var dataSet = new DataSet();
        selectCommand.CommandType = CommandType.Text;
        selectCommand.Connection = connection;
        dataAdapter.SelectCommand = selectCommand;
        connection.Open();
        dataAdapter.Fill(dataSet, "myDataSet");
        connection.Close();
        foreach (DataRow dr in dataSet.Tables["myDataSet"].Rows)
        {
            dr["ProductID"] = dr["ProductID"]+"00";
        }   
        ListView1.DataSource = dataSet;
        ListView1.DataBind();
    }

我的问题是如何从后面的代码中添加，编辑，更新和删除，并从.aspx页面中删除。因为我正在开发一个模板，我想做的一切从后面的代码。