OracleClient namespace name doesnot exist in the namespace 'System.Data' what can i do for this
using System;
using System.Data;
using System.Configur ation;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
using System.Data.Ora cleClient;
public partial class _Default : System.Web.UI.P age
{
OracleConnectio n objcon = new OracleConnectio n("Data Source=fsoft ;user=fcctest; password=fcctes t");
OracleCommand objcmd = new OracleCommand() ;
protected void Page_Load(objec t sender, EventArgs e)
{
}
protected void Button1_Click(o bject sender, EventArgs e)
{
objcon.Open();
DataSet ds = new DataSet();
OracleDataAdapt er da = new OracleDataAdapt er("select * from CAN_PERSONALINF O where REFERANCE_ID=" + TextBox1.Text + " ", objcon);
da.Fill(ds);
GridView1.Datas ource = ds.Tables[0];
GridView1.DataB ind();
objcon.Close();
}
protected void Button2_Click(o bject sender, EventArgs e)
{
objcon.Open();
DataSet ds = new DataSet();
OracleDataAdapt er da1 = new OracleDataAdapt er("select * from CAN_PERSONALINF O where REFERANCE_ID=" + TextBox1.Text + " ", objcon);
OracleDataAdapt er da2 = new OracleDataAdapt er("update CAN_PERSONALINF O SET FIRST_NAME=" + TextBox2.Text + " ", objcon);
da.Fill(ds1);
GridView1.Datas ource = ds1.Tables[0];
GridView1.DataB ind();
objcon.Close();
}
}
using System;
using System.Data;
using System.Configur ation;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
using System.Data.Ora cleClient;
public partial class _Default : System.Web.UI.P age
{
OracleConnectio n objcon = new OracleConnectio n("Data Source=fsoft ;user=fcctest; password=fcctes t");
OracleCommand objcmd = new OracleCommand() ;
protected void Page_Load(objec t sender, EventArgs e)
{
}
protected void Button1_Click(o bject sender, EventArgs e)
{
objcon.Open();
DataSet ds = new DataSet();
OracleDataAdapt er da = new OracleDataAdapt er("select * from CAN_PERSONALINF O where REFERANCE_ID=" + TextBox1.Text + " ", objcon);
da.Fill(ds);
GridView1.Datas ource = ds.Tables[0];
GridView1.DataB ind();
objcon.Close();
}
protected void Button2_Click(o bject sender, EventArgs e)
{
objcon.Open();
DataSet ds = new DataSet();
OracleDataAdapt er da1 = new OracleDataAdapt er("select * from CAN_PERSONALINF O where REFERANCE_ID=" + TextBox1.Text + " ", objcon);
OracleDataAdapt er da2 = new OracleDataAdapt er("update CAN_PERSONALINF O SET FIRST_NAME=" + TextBox2.Text + " ", objcon);
da.Fill(ds1);
GridView1.Datas ource = ds1.Tables[0];
GridView1.DataB ind();
objcon.Close();
}
}
Comment