在使用GRIDVIEW控件时,用编辑按钮,编辑后点更新时,出现 非法的变量名/编号 的错误。 在使用GRIDVIEW控件时,用编辑按钮,编辑后点更新时,出现 非法的变量名/编号 的错误。sql语句都是自动生成的。不知道是怎么回事。请高手指点。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 代码如下:<body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"> <Columns> <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="false" /> </Columns> </asp: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.ProviderName %>" SelectCommand='SELECT * FROM SCOTT.LIB' 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'> <DeleteParameters> <asp:Parameter Name="original_NAME" Type="String" /> <asp:Parameter Name="original_SEX" Type="String" /> <asp:Parameter Name="original_GRADE" Type="String" /> <asp:Parameter Name="original_PASSWORD" Type="String" /> <asp:Parameter Name="original_USEID" Type="String" /> <asp:Parameter Name="original_AUTHORITY" Type="String" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="SEX" Type="String" /> <asp:Parameter Name="GRADE" Type="String" /> <asp:Parameter Name="PASSWORD" Type="String" /> <asp:Parameter Name="USEID" Type="String" /> <asp:Parameter Name="AUTHORITY" Type="String" /> <asp:Parameter Name="original_NAME" Type="String" /> <asp:Parameter Name="original_SEX" Type="String" /> <asp:Parameter Name="original_GRADE" Type="String" /> <asp:Parameter Name="original_PASSWORD" Type="String" /> <asp:Parameter Name="original_USEID" Type="String" /> <asp:Parameter Name="original_AUTHORITY" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="NAME" Type="String" /> <asp:Parameter Name="SEX" Type="String" /> <asp:Parameter Name="GRADE" Type="String" /> <asp:Parameter Name="PASSWORD" Type="String" /> <asp:Parameter Name="USEID" Type="String" /> <asp:Parameter Name="AUTHORITY" Type="String" /> </InsertParameters> </asp:SqlDataSource> </div> </form></body> ASP.NET中能否通过填写文件的存储路径来上传文件? 母版页 WebService调用Jmail出错 请问有关水晶报表的问题,谢谢! 怎么在 asp.net页面中显示静态文本 大侠请进来,有急事请教?? 如何用正则表达式匹配汉字? 在ASP.NET中的HTML里,如何获取页面地址的参数? Table表格绑定数据源 紧急求助! 出现下面问题调试不了了怎么办。。急急急急急急急 asp.net地址传参
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="false" />
</Columns>
</asp: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.ProviderName %>"
SelectCommand='SELECT * FROM SCOTT.LIB' 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'>
<DeleteParameters>
<asp:Parameter Name="original_NAME" Type="String" />
<asp:Parameter Name="original_SEX" Type="String" />
<asp:Parameter Name="original_GRADE" Type="String" />
<asp:Parameter Name="original_PASSWORD" Type="String" />
<asp:Parameter Name="original_USEID" Type="String" />
<asp:Parameter Name="original_AUTHORITY" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="SEX" Type="String" />
<asp:Parameter Name="GRADE" Type="String" />
<asp:Parameter Name="PASSWORD" Type="String" />
<asp:Parameter Name="USEID" Type="String" />
<asp:Parameter Name="AUTHORITY" Type="String" />
<asp:Parameter Name="original_NAME" Type="String" />
<asp:Parameter Name="original_SEX" Type="String" />
<asp:Parameter Name="original_GRADE" Type="String" />
<asp:Parameter Name="original_PASSWORD" Type="String" />
<asp:Parameter Name="original_USEID" Type="String" />
<asp:Parameter Name="original_AUTHORITY" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="NAME" Type="String" />
<asp:Parameter Name="SEX" Type="String" />
<asp:Parameter Name="GRADE" Type="String" />
<asp:Parameter Name="PASSWORD" Type="String" />
<asp:Parameter Name="USEID" Type="String" />
<asp:Parameter Name="AUTHORITY" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</div>
</form>
</body>