Solved

DropDownList conecttion to Oracle DB

Posted on 2008-10-31
3
253 Views
Last Modified: 2013-12-17
Not able to get data from Oracle DB to populate a DropDownList. I've successfully established a connection in my web.config with the same connection string:

<asp:SqlDataSource ID="RegionData" runat="server" ConnectionString = "Data Source=tnsServiceName;User Id=myID;Password=myPass;" SelectCommand = "select primarykey, field_name from myTable order by field_name"></asp:SqlDataSource>                        
<asp:DropDownList ID="ddRegion" runat="server" AppendDataBoundItems = "true" DataSourceID = "RegionData" DataTextField = "field_name" DataValueField = "primarykey">
<asp:listitem selected="True"></asp:listitem>                                              
</asp:DropDownList>
0
Comment
Question by:kevbob650
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Priest04 earned 250 total points
ID: 22853634
You should use Oracle data provider to conennect to Oracle server, not Sql provider.

Goran
0
 

Author Closing Comment

by:kevbob650
ID: 31512120
Thanks Priest04, that was the missing link!  Can I code it where the sql is done in the code behind? Would that be cleaner?
0
 
LVL 18

Expert Comment

by:Priest04
ID: 22854902
Of course,so you are free to alter the code manually.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IP addresses can be stored in a database in any of several ways.  These ways may vary based on the volume of the data.  I was dealing with quite a large amount of data for user authentication purpose, and needed a way to minimize the storage.   …
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question