UC知道在使用GRIDVIEW控件时，用编辑按钮，编辑后点更新时，出现 非法的变量名/编号 的错误。
来源：百度知道 编辑：UC知道 时间：2024/05/12 12:43:44
在使用GRIDVIEW控件时，用编辑按钮，编辑后点更新时，出现 非法的变量名/编号 的错误。
请高手指点。
页面代码如下：
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionoracleString %>" DeleteCommand='DELETE FROM SCOTT.LIB WHERE "NAME" = :original_NAME AND "SEX" = :original_SEX AND "GRADE" = :original_GRADE AND "PASSWORD" = :original_PASSWORD AND "USEID" = :original_USEID AND "AUTHORITY" = :original_AUTHORITY'
InsertCommand='INSERT INTO SCOTT.LIB ("NAME", "SEX", "GRADE", "PASSWORD", "USEID", "AUTHORITY") VALUES (:NAME, :SEX, :GRADE, :PASSWORD, :USEID, :AUTHORITY)'
OldValuesParameterFormatString="original_{0}" ProviderName="<%$ ConnectionStrings:ConnectionoracleString.Provid
请高手指点。
页面代码如下：
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionoracleString %>" DeleteCommand='DELETE FROM SCOTT.LIB WHERE "NAME" = :original_NAME AND "SEX" = :original_SEX AND "GRADE" = :original_GRADE AND "PASSWORD" = :original_PASSWORD AND "USEID" = :original_USEID AND "AUTHORITY" = :original_AUTHORITY'
InsertCommand='INSERT INTO SCOTT.LIB ("NAME", "SEX", "GRADE", "PASSWORD", "USEID", "AUTHORITY") VALUES (:NAME, :SEX, :GRADE, :PASSWORD, :USEID, :AUTHORITY)'
OldValuesParameterFormatString="original_{0}" ProviderName="<%$ ConnectionStrings:ConnectionoracleString.Provid
UpdateCommand='UPDATE SCOTT.LIB SET "SEX" = :SEX, "GRADE" = :GRADE, "PASSWORD" = :PASSWORD, "USEID" = :USEID, "AUTHORITY" = :AUTHORITY WHERE "NAME" = :original_NAME AND "SEX" = :original_SEX AND "GRADE" = :original_GRADE AND "PASSWORD" = :original_PASSWORD AND "USEID" = :original_USEID AND "AUTHORITY" = :original_AUTHORITY'>
1，更新语句，一定有问题，你用VS自带的生成，然后对照检查一下。
2，你的的更新的相关字段值非法。如果字段值正常，一般情况下，页面如果设置，Validation=True，很容易出现这样的问题。先设成False进行调试。
希望回答有助你解决问题。
你自己写的Command？格式很怪。
你用DataSource自动生成的试试。