连接的是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