在vs winform 中用datagridview显示oracle中数据有问题 求助?????
public void init(){
dop.goToConnect();
String strSql = "select * from system.管理员表";
DataSet ds = new DataSet();
ds = dop.query(strSql);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
class DataOper
{
private static string StrConn;
private static OracleConnection conn = new OracleConnection();
private static DataSet ds;
private static OracleDataAdapter sda;
private static OracleCommand SC;
public void goToConnect()
{
StrConn = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PC-20121118GGSZ)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl))) ; Persist Security Info=True; User =SYSTEM;Password=wu__xing;Unicode=True";
try
{
conn = new OracleConnection(StrConn);
}
catch (System.Data.OracleClient.OracleException ex)
{
throw new Exception(ex.Message);
}
}
public DataSet query(string strSql)
{
ds = new DataSet();
conn.Open();
sda = new OracleDataAdapter(strSql, conn);
sda.Fill(ds, "ds");
conn.Close();
return ds;
}
public int DataProcessor(string StrSql)
{
int Row = 0;
conn.Open();
SC = conn.CreateCommand();
SC.CommandText = StrSql;
Row = SC.ExecuteNonQuery();
conn.Close();
return Row;
}
}
}
为什么不显示呢????????
补充:.NET技术 , C#