数据库连接与读取

  • 关键词:

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

 

posted @ 2016-08-16 10:21  jacketlin  阅读(186)  评论(0编辑  收藏  举报