当前位置: 代码迷 >> .NET组件控件 >> 急VS2015中使用GridView控件无法编辑和删除的有关问题
  详细解决方案

急VS2015中使用GridView控件无法编辑和删除的有关问题

热度:118   发布时间:2016-05-04 23:18:16.0
急!!VS2015中使用GridView控件无法编辑和删除的问题
连接的是Oracle数据库,编辑或删除的时候总是提示确实表达式,代码如下,求大神帮忙看看
       <asp:GridView ID="GridView1" runat="server" Height="245px" Width="1415px" AutoGenerateColumns="False" DataSourceID="wanggq" OnSelectedIndexChanged="GridView1_SelectedIndexChanged1" 
            BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" AllowSorting="True" CssClass="auto-style1" 
            DataKeyNames="ID" DataMember="DefaultView" EnablePersistedSelection="True" >
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="编号" SortExpression="ID" ReadOnly="True" />
                <asp:BoundField DataField="NAME" HeaderText="姓名" SortExpression="NAME" ReadOnly="True" />
                <asp:BoundField DataField="SEX" HeaderText="性别" SortExpression="SEX" ReadOnly="True" />
                <asp:BoundField DataField="AGE" HeaderText="年龄" SortExpression="AGE" ReadOnly="True" />
                <asp:BoundField DataField="BIRTHDAY" HeaderText="出生日期" SortExpression="BIRTHDAY" ReadOnly="True" /> 
                <asp:BoundField DataField="DEPARTMENT" HeaderText="部门" SortExpression="DEPARTMENT" ReadOnly="True" />
                <asp:BoundField DataField="BEIZHU" HeaderText="备注"  SortExpression="BEIZHU" />
                <asp:CommandField ButtonType="Button" ShowDeleteButton="True" ShowEditButton="True" />
            </Columns>
            <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
            <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
            <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
            <RowStyle BackColor="White" ForeColor="#003399" />
            <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
            <SortedAscendingCellStyle BackColor="#EDF6F6" />
            <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
            <SortedDescendingCellStyle BackColor="#D6DFDF" />
            <SortedDescendingHeaderStyle BackColor="#002876" />

        </asp:GridView>
        
        <asp:SqlDataSource ID="wanggq" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString2 %>" ProviderName="<%$ ConnectionStrings:ConnectionString2.ProviderName %>" 
            SelectCommand="SELECT ID, NAME, SEX, AGE, BIRTHDAY, DEPARTMENT, BEIZHU FROM XDFRYXX"
            DeleteCommand="DELETE FROM XDFRYXX WHERE ID = @ID " 
            UpdateCommand="UPDATE XDFRYXX SET [email protected],[email protected],[email protected],[email protected],[email protected],[email protected] WHERE [email protected]
            InsertCommand="INSERT INTO XDFRYXX(ID,NAME,SEX,AGE,BIRTHDAY,DEPARTMENT,BEIZHU) VALUES (@ID,@NAME,@SEX,@AGE,@BIRTHDAY,@DEPARTMENT,@BEIZHU)" >
            <DeleteParameters>
                <asp:Parameter Name="ID" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="ID" />
                <asp:Parameter Name="NAME" />
                <asp:Parameter Name="SEX" />
                <asp:Parameter Name="AGE" />
                <asp:Parameter Name="BIRTHDAY" />
                <asp:Parameter Name="DEPARTMENT" />
                <asp:Parameter Name="BEIZHU" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="ID" />
                <asp:Parameter Name="NAME" />
                <asp:Parameter Name="SEX" />
                <asp:Parameter Name="AGE" />
                <asp:Parameter Name="BIRTHDAY" />
                <asp:Parameter Name="DEPARTMENT" />
                <asp:Parameter Name="BEIZHU" />
            </UpdateParameters>
        </asp:SqlDataSource>
------解决思路----------------------
SqlDataSource是专门用来连接sqlserver的,连不了oracle。

而且即使有OracleDataSource之类的,也不推荐用(不灵活)。

建议使用封装好的类库,实现Oracle数据库的crud操作。

http://blog.csdn.net/pitt_xiong/article/details/7348904
http://blog.csdn.net/chinacsharper/article/details/18377303