i want to connect plsql server with asp.net using C# and want to show data of server in grid view.
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
OracleCommand cmd = new OracleCommand("SELECT wllpackagecode,wllpackagename,wllpackagedesc,sdate,edate,status,brandid FROM wllpackage ", new OracleConnection("Server=ip;Database=fg;User Id=dgfh; Password=hgh;Trusted_Connection=True;"));
try
{
cmd.Connection.Open();
gvwdata.DataSource = cmd.ExecuteReader();
gvwdata.DataBind();
cmd.Connection.Close();
cmd.Connection.Dispose();
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
finally
{
connection.Close();
}
}
}
error
Compiler Error Message: CS0234: The type or namespace name 'OracleClient' does not exist in the namespace 'System.Data' (are you missing an assembly reference?)