• I would also suggest you review the C# code slightly; it would be better to create the parameters explicitly with the datatypes used by the stored procedure, eg.

    SqlParameter parm00 = new SqlParameter("@ordrdQnty", SqlDbType.Int);

    parm00.Value = (int)dgvSelectedItem.Rows.Cells[2].Value;

    comm.Parameters.Add(parm00);

    and, if you haven't already done so, put the SQL access in a try/catch/finally structure.