ADO.NET的一段数据库操作代码
int currentIndex = 0;
int pageSize = 10;
//System.Data.OracleClient.OracleConnection connection = new SqlConnection("Data Source=ORCL_100.0.3.10;User Id=btvaudit2;Password=btvaudit2;");
//connection.Open();
DbProviderFactory dbfactory = DbProviderFactories.GetFactory("System.Data.OracleClient");
DbConnection dbconn = dbfactory.CreateConnection();
dbconn.ConnectionString = "Data Source=ORCL_100.0.3.10;User Id=btvaudit2;Password=btvaudit2;";
string orderSQL = "SELECT * FROM a_wsinterfaceinfo order by requesttime desc";
DbCommand dbCommand = dbconn.CreateCommand();
dbCommand.CommandText = orderSQL;
dbCommand.CommandType = CommandType.Text;
DbDataAdapter dbDataAdapter = dbfactory.CreateDataAdapter();
dbDataAdapter.SelectCommand = dbCommand;
if (System.Data.ConnectionState.Open != dbconn.State)
dbconn.Open();
DataSet dataSet = new DataSet();
int count = dbDataAdapter.Fill(dataSet, currentIndex, pageSize, "a_wsinterfaceinfo");
if (System.Data.ConnectionState.Open == dbconn.State)
dbconn.Close();
DataTable table =new DataTable();
dataSet.Merge(table);