- 关键词:
SqlDataReader
Sqlconnection
DataSet
SqlDataAdapter
- 数据库读取:
//打开类别数据库 public DataSet Getleibie() { SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MYCONNECTIONSTRING"].ConnectionString); string cmdText = "SELECT SupplyID,ParrentID,Title,Showorder,Folder FROM Supply ORDER BY Showorder DESC"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmdText, myConnection); try { myConnection.Open(); da.Fill(ds, "aa"); } catch (SqlException ex) { throw new Exception(ex.Message, ex); } finally { myConnection.Close(); } return ds; }