数据库连接与读取

• 关键词：

　　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;
    }