1.我现在的项目,连接数据库的方法已经在webservice中写好了,
//select * from 表 where rownum < 10
[WebMethod(Description = "Oracle数据测试,返回数据集")]
public DataSet GetOracleDataSet(string comstr)
{
string connstr = "Server=10.77.150.105;Data Source=ORCL;user=gxx;password=gxx;";
OracleConnection myconn = new OracleConnection(connstr);
try // 正常运行
{
myconn.Open();
//Console.WriteLine("ServerVersion: " + myconn.ServerVersion
//+ "\nDataSource: " + myconn.DataSource);
OracleDataAdapter myadapter = new OracleDataAdapter(comstr, myconn);
myconn.Close();
DataSet myset = new DataSet();
myadapter.Fill(myset);//将查询的表填充到数据集(DataSet)
return myset;
}