ASP.NET

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)<br />
{<br />
    GridViewRow row = GridView1.Rows[(Convert.ToInt32(e.CommandArgument))];<br />
    string productName = Server.HtmlDecode(row.Cells[0].Text);<br />
<br />
/*Various if/else if statements to catch the grid commands left out of here for brevity*/<br />
<br />
else if (e.CommandName == "Update")<br />
{<br />
    if (Session["orderIDandDate"] != null)<br />
    {<br />
        //the quantity value below isn't picking up the value in this row<br />
        //the problem is most likely here--maybe using the wrong method<br />
        quantity = Convert.ToInt32(Server.HtmlDecode(row.Cells[1].Text));<br />
<br />
        if (Convert.ToInt32(quantity) > 0)<br />
        {<br />
            SqlDataSource2.UpdateCommand = String.Format("UPDATE TABLE SET quantity = '{0}' WHERE (product = '{1}') AND (order = '{2}')", quantity, productName, orderID);<br />
            SqlDataSource2.Update();<br />
        }<br />
    }<br />
}