自定义DataTable_小时_分钟

最新推荐文章于 2019-07-03 18:22:40 发布

breezeforever

最新推荐文章于 2019-07-03 18:22:40 发布

阅读量453

点赞数

文章标签： dataset

本文链接：https://blog.csdn.net/breezeforever/article/details/1815036

版权

#region 将小时返回为DataSet (00 — 23)
    public static DataSet dsHour()
    {
        DataTable dt = new DataTable("tHour");

        //定义字段
        DataColumn column = new DataColumn();
        column.DataType = System.Type.GetType("System.String");
        column.AllowDBNull = true;
        column.Caption = "Hour";
        column.ColumnName = "Hour";
        column.DefaultValue = 25;
        dt.Columns.Add(column);
        //定义主键
        DataColumn[] keys = new DataColumn[1];
        dt.PrimaryKey = keys;

DataSet ds = new DataSet();
ds.Tables.Add(dt);

        DataRow row;
        dt = ds.Tables["tHour"];
        for (int i = 0; i < 24; i++)
        {
            row = dt.NewRow();
            if (i < 10)
            {
                row["Hour"] = "0" + i.ToString();
            }
            else
            {
                row["Hour"] = i.ToString();
            }
            dt.Rows.Add(row);
        }

        return ds;
    }
    #endregion

    #region 将分钟返回为DataSet (00 — 59)
    public static DataSet dsMinute()
    {
        DataTable dt = new DataTable("tMinute");

        //定义字段
        DataColumn column = new DataColumn();
        column.DataType = System.Type.GetType("System.String");
        column.AllowDBNull = true;
        column.Caption = "Minute";
        column.ColumnName = "Minute";
        column.DefaultValue = 25;
        dt.Columns.Add(column);
        //定义主键
        DataColumn[] keys = new DataColumn[1];
        dt.PrimaryKey = keys;

DataSet ds = new DataSet();
ds.Tables.Add(dt);

        DataRow row;
        dt = ds.Tables["tMinute"];
        for (int i = 0; i < 60; i++)
        {
            row = dt.NewRow();
            if (i < 10)
            {
                row["Minute"] = "0" + i.ToString();
            }
            else
            {
                row["Minute"] = i.ToString();
            }
            dt.Rows.Add(row);
        }

        return ds;
    }
    #endregion