如何链接oracle并用执行sql语句从其表中取出数据！

[poors]

代码怎么写？谢谢!

[冷月孤峰]

在web.config文件里：
<appSettings>
<!-- 此处显示用户应用程序和配置的属性设置。-->
<!-- 示例：<add key="settingName" value="settingValue"/> -->
<!--<add key="oracleConnection1.ConnectionString" value="user id=twbltest;data source=qmys;password=twbltest"/>-->
<add key="oracleConnection1.ConnectionString" value="user id=twbl;data source=qmys;password=twbl"/>
<!--<add key="oracleConnection2.ConnectionString" value="user id=qmys;data source=yzdxjck;password=qmys"/>-->
</appSettings>
在页面中：
private string cn=System.Configuration.ConfigurationSettings.AppSettings.Get("oracleConnection1.ConnectionString");
取数据：
string sql;
sql="select a.sheetno,b.providername,a.dating,c.gcname,a.fee,a.contracted,d.lyname,a.clly,a.providerid from twsheet a, " +
" twprovider b,twproject c,twclly d where a.providerid=b.providerid and a.itemid=c.gcid and a.clly=d.cllyid " +
" and a.sheetno in (select distinct sheetno from tworderlist where countnum>arrivedcount) and a.ifs is null " +
" and substr(a.sendaddr,1,2)='"+ ((clsUser)Session["objUser"]).OfficeName.Trim() +"'";
OracleDataAdapter da=new OracleDataAdapter(sql,cn);
DataSet ds=new DataSet();
da.Fill(ds);
DataGrid1.DataSource=ds;
DataGrid1.DataBind();