62,046
社区成员
发帖
与我相关
我的任务
分享连接ORACLE出错
在ASP.NET中，我用OleDb方式连接ORACLE，但是在测试查询中出错：
ora-00936 :missing expression
ora-00936 :missing expression
...全文
请发表友善的回复…
发表回复
panzi667 2006-03-21
- 打赏
- 举报
<add name="ConnectionString" connectionString="Provider=MSDAORA;Data Source=xxxxxx;Persist Security Info=True;Password=xxxxx;User ID=xxxxxx"
providerName="System.Data.OleDb" />
providerName="System.Data.OleDb" />
panzi667 2006-03-21
- 打赏
- 举报
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString3 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand="SELECT [SBID], [SBCNAME] FROM [SCM_SUPPLIERBASE]">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString3 %>"
ProviderName="<%$ ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand="SELECT [SBID], [SBCNAME] FROM [SCM_SUPPLIERBASE]">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
wengnet 2006-03-21
- 打赏
- 举报
SQL语句错误，把SQL语句贴出来看看~！
