C# (CSharp) System.Data.Common DbDataRecord.GetInt32示例

GetInt32() public abstract method

public abstract GetInt32 ( int i ) : int
i	int
return	int

示例#1

//-------------------------------------------------------------------------------------------
    void ByDay_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item ||
            e.Item.ItemType == ListItemType.AlternatingItem)
        {
            System.Data.Common.DbDataRecord rd = (System.Data.Common.DbDataRecord)e.Item.DataItem;
            DateTime date = new DateTime(rd.GetInt32(0), rd.GetInt32(1), rd.GetInt32(2));
            e.Item.Cells[0].Text = date.ToString("MM/dd/yy");
            if (date > DateTime.Now)
            {
                e.Item.Cells[0].Font.Italic = true;
                e.Item.Cells[0].ForeColor   = System.Drawing.Color.Gray;
            }
        }
    }

示例#2

//-------------------------------------------------------------------------------------------
    void ByWeek_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item ||
            e.Item.ItemType == ListItemType.AlternatingItem)
        {
            System.Data.Common.DbDataRecord rd = (System.Data.Common.DbDataRecord)e.Item.DataItem;
            DateTime weekStart = GetDatesForWeek(rd.GetInt32(0), Int32.Parse(YearFilter.Text));
            e.Item.Cells[0].Text    = weekStart.ToString("MM/dd/yy") + "-" + weekStart.AddDays(7).ToString("MM/dd/yy");
            e.Item.Cells[0].ToolTip = rd.GetInt32(0).ToString();
            if (weekStart > DateTime.Now)
            {
                e.Item.Cells[0].Font.Italic = true;
                e.Item.Cells[0].ForeColor   = System.Drawing.Color.Gray;
            }
        }
    }

示例#3

//-------------------------------------------------------------------------------------------
    void ByMonth_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item ||
            e.Item.ItemType == ListItemType.AlternatingItem)
        {
            System.Data.Common.DbDataRecord rd = (System.Data.Common.DbDataRecord)e.Item.DataItem;
            DateTime monthCalc = new DateTime(Int32.Parse(YearFilter.Text), rd.GetInt32(0), 1);
            e.Item.Cells[0].Text = monthCalc.ToString("MMMM");
            if (monthCalc > DateTime.Now)
            {
                e.Item.Cells[0].Font.Italic = true;
                e.Item.Cells[0].ForeColor   = System.Drawing.Color.Gray;
            }
        }
    }