dataset

 #region  获取一个DataTable
    /// <summary>
    /// 获取一个DataTable
    /// </summary>
    /// <param name="DifferetDay"></param>
    /// <param name="DateValue"></param>
    /// <param name="dt1"></param>
    /// <param name="date_From"></param>
    /// <returns></returns>
    private DataTable GetDataTable(string Market_Name, DateTime date_From, DateTime date_To, int DifferetDay, ArrayList XDateValue)
    {
        ArrayList DateValue = new ArrayList();
        string sql1 = @"SQL语句";
        DataSet ds = new DataSet();
        ds = DataProviders.ExecuteDataset(sql1);
        DataTable dt1 = ds.Tables[0];
        DataTable dt = new DataTable();
        DataColumn dc = null;
        dc = dt.Columns.Add("ID", Type.GetType("System.Int32"));
        dc.AutoIncrement = true;
        dc.AutoIncrementSeed = 1;
        dc.AutoIncrementStep = 1;
        dc.AllowDBNull = false;

        DataRow newRow;
        dc = dt.Columns.Add("Report_Date", Type.GetType("System.DateTime"));
        dc = dt.Columns.Add("BigMeatChicken_Price", Type.GetType("System.String"));
        dc = dt.Columns.Add("HybridChicken_Price", Type.GetType("System.String"));

        foreach (DataRow drow in dt1.Rows)
        {
            DateValue.Add(drow["Report_Date"]);
        }

        for (int j = 0; j < XDateValue.Count; j++)
        {
            newRow = dt.NewRow();
            dt.Rows.Add(newRow);
            dt.Rows[j]["Report_Date"] = date_From;
            dt.Rows[j]["BigMeatChicken_Price"] = 0;
            dt.Rows[j]["HybridChicken_Price"] = 0;

            for (int h = 0; h < DateValue.Count; h++)
            {
                if (Convert.ToDateTime(XDateValue[j]) == Convert.ToDateTime(DateValue[h]))
                {
                    dt.Rows[j]["BigMeatChicken_Price"] = Convert.ToDouble(dt1.Rows[h]["BigMeatChicken_Price"]);
                    dt.Rows[j]["HybridChicken_Price"] = Convert.ToDouble(dt1.Rows[h]["HybridChicken_Price"]);
                }
            }
        }
        return dt;
    }

    #endregion

 

 

foreach(datarow da in dataset.tables[0].rows)

{

da["列名"]；

}