日期:2014-05-17 浏览次数:20847 次
using System.Data;
using Com.Think.Utility;
public partial class Query_RoadIntersectSelect_test : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindLoadName();
}
public void BindLoadName()
{
try
{
string sql1 = "select distinct 道路名称 from ROADNODE";
//string sql2 = "select distinct 道路名称_1 from roadnode";
DataSet ds1 = new DataSet();
ds1 = OracleHelper.ExDataSet(sql1);
public static DataSet ExDataSet(string sql)
{
DataSet ds = new DataSet();
try
{
OracleDataAdapter Adapter = new OracleDataAdapter(sql, Conn);
Conn.Open();
Adapter.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally { Conn.Close(); }
return ds ;
}