myOleDbConnection=new OleDbConnection("Provider=OraOLEDB.Oracle.1;"+"Persist Security Info=False;"+"User ID=peixun;"+"password=peixun05;"+"Data Source=orc1");
OleDbDataAdapter mc5=new OleDbDataAdapter("select * From pxry " , myOleDbConnection);
DataSet ds5=new DataSet();
mc5.Fill(ds5,"pxry");
DataRowView rowview5=ds5.Tables["pxry"].DefaultView[0];
int n=ds5.Tables["pxry"].Rows.Count;
DataGrid1.DataSource=ds5.Tables["pxry"].DefaultView;
DataGrid1.DataBind();
运行时在mc5.Fill(ds5,"pxry");出现错误:ORA-12154:TNS:无法处理服务名
OleDbDataAdapter mc5=new OleDbDataAdapter("select * From pxry " , myOleDbConnection);
DataSet ds5=new DataSet();
mc5.Fill(ds5,"pxry");
DataRowView rowview5=ds5.Tables["pxry"].DefaultView[0];
int n=ds5.Tables["pxry"].Rows.Count;
DataGrid1.DataSource=ds5.Tables["pxry"].DefaultView;
DataGrid1.DataBind();
运行时在mc5.Fill(ds5,"pxry");出现错误:ORA-12154:TNS:无法处理服务名
myOleDbConnection.open();//要把连接打开
OleDbDataAdapter mc5=new OleDbDataAdapter("select * From pxry " , myOleDbConnection);
DataSet ds5=new DataSet();
mc5.Fill(ds5,"pxry");
DataRowView rowview5=ds5.Tables["pxry"].DefaultView[0];
int n=ds5.Tables["pxry"].Rows.Count;
DataGrid1.DataSource=ds5.Tables["pxry"].DefaultView;
DataGrid1.DataBind();
string OracleConnection conn = new OracleConnection(connstr);
conn.Open();
sql = "select * From pxry ";
OracleDataAdapter myAdp = new OracleDataAdapter(sql, conn);
DataSet dt = new DataSet();
myAdp.Fill(dt);