看下这个使用.net c#连接oracle的代码对吗
来源:百度知道 编辑:UC知道 时间:2024/05/18 00:54:35
如果有错帮忙指出,能帮忙写下使用oledb连接oracle的代码吗
using System.Data.OracleClient;
.....
OracleConnection __conn = new OracleConnection(__connectionString)
__conn.Open();
OracleCommand __cmd = __conn.CreateCommand();
__cmd.CommandType = CommandType.Text;
__cmd.CommandText = "SELECT CONTENT FROM TBLs WHERE ID=1"; // content 是从Oracle 8.0升上来的 Long, id 唯一
DataSet __ds = new DataSet();
OracleDataAdapter __oad = new OracleDataAdapter(__cmd);
__oad.Fill(__ds, "XG");
GridView1.DataSource = __ds.Tables[0].DefaultView; // 绑定到 GridView
GridView1.DataBind();
使用了2中方式,抱歉,刚才比较急忘传了
using System.Data.OracleClient;
.....
OracleConnection __conn = new OracleConnection(__connectionString)
__conn.Open();
OracleCommand __cmd = __conn.CreateCommand();
__cmd.CommandType = CommandType.Text;
__cmd.CommandText = "SELECT CONTENT FROM TBLs WHERE ID=1"; // content 是从Oracle 8.0升上来的 Long, id 唯一
DataSet __ds = new DataSet();
OracleDataAdapter __oad = new OracleDataAdapter(__cmd);
__oad.Fill(__ds, "XG");
GridView1.DataSource = __ds.Tables[0].DefaultView; // 绑定到 GridView
GridView1.DataBind();
使用了2中方式,抱歉,刚才比较急忘传了
using System.Data.OracleClient;
string sql = "SELECT CONTENT FROM TBLs WHERE ID=1";
DataSet __ds = new DataSet();
OracleDataAdapter __oad = new OracleDataAdapter(sql,__connectionString);
__oad.Fill(__ds, "XG");
GridView1.DataSource = __ds.Tables[0].DefaultView; // 绑定到 GridView
GridView1.DataBind();
这样就可以了
set adocon=Server.Createobject("adodb.connection")
adocon.open"Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;"