dataset
来源:互联网 发布:购物车源码 编辑:程序博客网 时间:2024/06/03 16:00
#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["列名"];
}
- DataSet
- DataSet
- DataSet
- DataSet
- DataSet
- dataset
- DataSet
- DataSet
- DataSet
- dataSet
- DataSet
- DataSet
- dataset
- DataSet
- DataSet
- dataset
- DataSet
- DataSet
- Struts2中实现自动发送action请求后到初始化网站首页的学习
- 回车符和换行符的故事
- 如何设计和实现游戏的试玩功能
- Swing和AWT的功能区别
- VARIANT 结构
- dataset
- 数据对齐详解——面试经典问题
- Ural 1002 AC
- java基礎入門知识(数据类型)
- 变换主题
- 9针串行口的针脚功能
- Calculator
- ASP.NET常用路径获取方法与格式对照表
- MyEclipse设置JVM突破内存限制