上网查了下··说表明大小写的问题,所以··建了2个表,一个大写的,一个小写的,都已经插入了一条记录
create table userinfo
(
username char(20),
sex char(2),
age int ,
address char(100)
);create table "userinfo"
(
username char(20),
sex char(2),
age int ,
address char(100)
);用PL/SQL用用户commonuser登录可以Select * from userinfo/Select * from "userinfo" 都可以查询到一条记录
commonuser 已经获得了connect 和resources的权限了但以下NET里面,按下按钮不报错···就是没结果显示···请问是为什么呢···急啊·· protected void Button1_Click(object sender, EventArgs e)
{
string sql = "Select * from userinfo";
DataSet ds = oraGetDataSet(sql, "table1"); for (int i = 0; i < ds.Tables["table1"].Rows.Count;i++ )
{
Response.Write(ds.Tables["table1"].Rows[i][0].ToString());
}
}
public OracleConnection getconnoracle()
{
string oraStr = "Data Source=GIPCDB;Persist Security Info=True;User ID=commonuser;Password=gdcmain;Unicode=True";
OracleConnection oraConn = new OracleConnection(oraStr);
return oraConn;
}
public System.Data.DataSet oraGetDataSet(string sqlStr, string TableName)
{
OracleConnection myConn = getconnoracle();
myConn.Open();
OracleDataAdapter adapt = new OracleDataAdapter(sqlStr, myConn);
DataSet ds = new DataSet();
adapt.Fill(ds, TableName);
myConn.Close();
return ds;
}
create table userinfo
(
username char(20),
sex char(2),
age int ,
address char(100)
);create table "userinfo"
(
username char(20),
sex char(2),
age int ,
address char(100)
);用PL/SQL用用户commonuser登录可以Select * from userinfo/Select * from "userinfo" 都可以查询到一条记录
commonuser 已经获得了connect 和resources的权限了但以下NET里面,按下按钮不报错···就是没结果显示···请问是为什么呢···急啊·· protected void Button1_Click(object sender, EventArgs e)
{
string sql = "Select * from userinfo";
DataSet ds = oraGetDataSet(sql, "table1"); for (int i = 0; i < ds.Tables["table1"].Rows.Count;i++ )
{
Response.Write(ds.Tables["table1"].Rows[i][0].ToString());
}
}
public OracleConnection getconnoracle()
{
string oraStr = "Data Source=GIPCDB;Persist Security Info=True;User ID=commonuser;Password=gdcmain;Unicode=True";
OracleConnection oraConn = new OracleConnection(oraStr);
return oraConn;
}
public System.Data.DataSet oraGetDataSet(string sqlStr, string TableName)
{
OracleConnection myConn = getconnoracle();
myConn.Open();
OracleDataAdapter adapt = new OracleDataAdapter(sqlStr, myConn);
DataSet ds = new DataSet();
adapt.Fill(ds, TableName);
myConn.Close();
return ds;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货