廣度與深度

方法一: DataSet

PO:

internal RewardsDataSet setRewardsItem()
{
string strCmd = "SELECT [RP_ITEM_ID],[RP_ITEM_NAME] FROM [TB_ISS_REWARDS_ITEM]";
RewardsDataSet ds = new RewardsDataSet();
ds.Load(this.m_db.ExecuteReader(strCmd), LoadOption.OverwriteChanges, ds.TB_ISS_REWARDS_ITEM);
return ds;
}

CS:

public void setDDLRewardItem()
{
RewardsUCO rewardsUCO = new RewardsUCO();
RewardsDataSet rewardsDataSet = rewardsUCO.setRewardsItem();
ddlRewardItem.Items.Add(new ListItem("請選擇","0"));

//塞資料，寫法一: foreach =>強型別
foreach (RewardsDataSet.TB_ISS_REWARDS_ITEMRow dr in rewardsDataSet.TB_ISS_REWARDS_ITEM.Rows)
{
ddlRewardItem.Items.Add(new ListItem(dr.RP_ITEM_NAME, dr.RP_ITEM_ID));
}
ddlRewardItem.SelectedValue ="0";
}

----------

方法二: DataTable

PO:

internal DataTable setRewardsItemTable()
{
string strCmd = "SELECT [RP_ITEM_ID],[RP_ITEM_NAME] FROM [TB_ISS_REWARDS_ITEM]";
DataTable dt = new DataTable();
dt.Load(this.m_db.ExecuteReader(strCmd));
return dt;
}

CS:

public void setDDLRewardItemTable()
{
RewardsUCO rewardsUCO = new RewardsUCO();
DataTable dt = rewardsUCO.setRewardsItemTable();
ddlRewardItem.Items.Add(new ListItem("請選擇", "0"));

//塞資料，寫法一: for
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlRewardItem.Items.Add(new ListItem(dt.Rows[i]["RP_ITEM_NAME"].ToString(), dt.Rows[i]["RP_ITEM_ID"].ToString()));
}

//塞資料，寫法一: foreach
foreach (DataRow dr in dt.Rows)
{
ddlRewardItem.Items.Add(new ListItem(dr["RP_ITEM_NAME"].ToString(), dr["RP_ITEM_ID"].ToString()));
}
ddlRewardItem.SelectedValue = "0";
}