ASP.NET Connection with Oracle DB

Question

I do not understand why I have this error message. No code is used for the connection, only an SQLDatasource and a grid view. I am using this code:

protected void Page_Load(object sender, EventArgs e)

{
     try
    {
        using(OracleConnection conn = new OracleConnection("....."))
        using(OracleCommand cmd = new OracleCommand("select * from t1", conn))
        {
            conn.Open();
            using(OracleDataReader reader = cmd.ExecuteReader())
            {
                 DataTable dataTable = new DataTable();
                 dataTable.Load(reader);
                 ListBox1.DataSource = dataTable;
            }
        }
    }
    catch (Exception ex)
    {
        Label1.Text=ex.Message;
    }
}

try this.. ASP.default_aspx' does not contain a definition for 'IssuesGrid_OnItemUpdated' and no extension method 'IssuesGrid_OnItemUpdated' — user990423
I've edited your question to inline the image, but you really should type the text in the error message rather than posting an image. That way, others searching can find the relevant words in your error. — Wai Ha Lee

Khazratbek Khazratbek · Accepted Answer · 2015-12-01T02:47:12

You can't use SqlConnection for the Oracle! First of all, you have to add connectionString into web.config to connection with Oracle. Secondly, Add reference System.Data.OracleClient to your project. Then, replace SqlConnection with OracleConnection. Everything, what you used with Sql, you have to replace with Oracle.

ASP.NET Connection with Oracle DB

2 Answers