Hi,

When debugging the page i am getting error("argumentexception was unhandled by user code"). Can any one help me on this.

in .aspx page:
<asp:DropDownList ID="ddlCategoryID" runat="server" CssClass="input"> </asp:DropDownList>

in .aspx.cs page:

pageload :
Bindmasterdata();

----

        DataTable dt = new DataTable();
        using (OracleConnection Con = new OracleConnection("SConnectionString"))
        {
            Con.Open();
            OracleCommand cmd = new OracleCommand("Select * from nts_advertisements", Con);
            OracleDataAdapter da = new OracleDataAdapter(cmd);
            da.Fill(dt);
        }
        ddlCategoryID.DataSource = dt;
        ddlCategoryID.DataTextField = "Category";
        ddlCategoryID.DataValueField = "Category";
        ddlCategoryID.DataBind();

Thanks in advance.

Regards,
Kavitha Kesav

Recommended Answers

All 4 Replies

new OracleConnection("SConnectionString")

I think you need to pass an actual connection string.

using (OracleConnection Con = new OracleConnection("SConnectionString"))

you either need to supply the connection string there, or add the connection string to your web.config file and then reference the web.config when setting up your connections.

in web.config...

 <connectionStrings>
    <add name="connName" connectionString=" .. you fill this in ..."/>
 </connectionStrings>

in your code behind..

new OracleConnection(ConfigurationManager.ConnectionStrings["connName"].ConnectionString

are you getting value in DataTable (dt) ?

Can you post the full Inner Exception text?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.