 <p>I am not sure whether it is the solution or not,but my value could get and insert each textbox to each particular row without problem, thanks for the help from Peter Campbell and Mairaj Ahmad.</p> <p>hold my transactionNo as following: Dim lblTransactionNo As Label = DirectCast(row.FindControl("lblTransactionNo"), Label) </p> <pre><code>sqlQuery = "Update WebTpay_Trn set RedeemedQuantity = RedeemedQuantity + '" &amp; amtRedeem &amp; "' " sqlQuery = sqlQuery + " WHERE TransactionNo = '" &amp; lblTransactionNo.Text &amp; "' " 'sqlQuery = String.Format("UPDATE WebTpay_Trn set RedeemededQuantity = {0} WHERE webtPay_trn.TransactionNo = {1}", amtRedeem, lbltransactionNo) Dim cmd As SqlCommand = New SqlCommand(sqlQuery, conn) conn.Open() cmd.ExecuteNonQuery() conn.Close() </code></pre>