最近在做网页的时候发现个问题,整了好久都不能解决!
GridView的Datasource是手动指向SqlDatasource的
<html> 中的SqlDatasource
如下
<asp:SqlDataSource ID= "SqlDataSource1 " runat= "server " ConnectionString= " <%$ ConnectionStrings:123099DBConnectionString %> "
InsertCommand= "INSERT INTO [asUsers] ([asName], [asPhone], [asRole], [asSex]) VALUES (@asName, @asPhone, @asRole, @asSex) "
SelectCommand= "SELECT [asId], [asName], [asPhone], [asRole], [asSex] FROM [asUsers] "
UpdateCommand= "UPDATE [asUsers] SET [asName] = @asName, [asPhone] = @asPhone, [asRole] = @asRole, [asSex] = @asSex WHERE [asId] = @asId "
DeleteCommand= "DELETE FROM [asUsers] WHERE [asId] = @asId "
>
<DeleteParameters>
<asp:Parameter Name= "asId " Type= "Int32 " />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name= "asName " Type= "String " />
<asp:Parameter Name= "asPhone " Type= "Int32 " />
<asp:Parameter Name= "asRole " Type= "Int32 " />
<asp:Parameter Name= "asSex " Type= "Int32 " />
<asp:Parameter Name= "asId " Type= "Int32 " />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name= "asName " Type= "String " />
<asp:Parameter Name= "asPhone " Type= "Int32 " />
<asp:Parameter Name= "asRole " Type= "Int32 " />
<asp:Parameter Name= "asSex " Type= "Int32 " />