string mySelectQuery = "SELECT ID, Title FROM myBBS order by id asc"; SqlCommand myCommand = new SqlCommand(mySelectQuery,coreDB); coreDB.Open(); SqlDataReader myReader=myCommand.ExecuteReader();
数据库coreDB中的表myBBS定义如下: if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[myBBS]'''') and OBJECTPROPERTY(id, N''''IsUserTable'''') = 1) drop table [dbo].[myBBS] GO