在visual studio 2005里面C#
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
public partial class lgb_try : System.Web.UI.Page
{
DataSet ds;
public OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["lgb_try"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select * from 油井参数区L7-3366";
conn.Open();
OracleDataAdapter da = new OracleDataAdapter(sql, conn);
ds = new DataSet();
da.Fill(ds); GridView2.DataSource = ds; GridView2.DataBind(); conn.Close(); }
}
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
public partial class lgb_try : System.Web.UI.Page
{
DataSet ds;
public OracleConnection conn = new OracleConnection(ConfigurationManager.ConnectionStrings["lgb_try"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select * from 油井参数区L7-3366";
conn.Open();
OracleDataAdapter da = new OracleDataAdapter(sql, conn);
ds = new DataSet();
da.Fill(ds); GridView2.DataSource = ds; GridView2.DataBind(); conn.Close(); }
}
有人说 表 油井参数区L7-3366,需要加双引号。但怎么加呢?
写清楚点好不好
string sql = "select * from
同意。
反正就是传给oracle的sql是 select * from "油井参数区L7-3366"