C#中DataTable的使用,新手求助
本人是学习VC/MFC的,最近工作需要紧急修改一个C#程序,遇到各种不明白的地方,请大家指教。
先上代码:
for (int i = 0; i < count; i++)
{
DataRow dr;
dr = dt.NewRow();
dr[0] = true;//false
dr[1] = "0";
dr[2] = testfilelist.result[i].releaseDate;
dr[3] = testfilelist.result[i].latestVersion;
dr[4] = testfilelist.result[i].language;
dr[5] = "0";//FILESIZE
dr[6] = testfilelist.result[i].filename; //文件名称
dr[7] = testfilelist.result[i].ftpPath; //将文件名存这
dr[8] = testfilelist.result[i].downloadPath;
dt.Rows.Add(dr);
dt.AcceptChanges();
}
dtdistinct.Clear();
dtdistinct = dt.DefaultView.ToTable(true, new string[] { "Item", "SoftWare", "Date", "Index", "Filesize" });
DataColumn dataColumn1 = new DataColumn("Version", typeof(String));
dtdistinct.Columns.Add(dataColumn1);
dataColumn1 = new DataColumn("Language", typeof(String));
dtdistinct.Columns.Add(dataColumn1);
dataColumn1 = new DataColumn("filepath", typeof(String));
dtdistinct.Columns.Add(dataColumn1);
dataColumn1 = new DataColumn("downloadPath", typeof(String));
dtdistinct.Columns.Add(dataColumn1);
gridControl1.DataSource = dtdistinct;
//datarefreshgrid();
DataRow drOperate = dt.Rows[3];
drOperate.BeginEdit();
drOperate[0] = false;
drOperate.EndEdit();
<table cellpadding="0" cellspacing="0" border="1" class="pagerlist" width="100%"
id="MasterDataList">
<tr class="header">
<td style="width: 30px;">
<input type="checkbox" id="selectAll" name="selectAll" onclick="SelectAllList();" />
</td>
<td style="width: 90px;">
捐款編號
</td>
<td style="width: 100px;">
捐款日期
</td>
</tr>
<asp:Repeater ID="rep_Donation" runat="server">
<AlternatingItemTemplate>
<tr class="altrow">
<td style="text-align: center">
<input type="checkbox" id="CheckBox_<%#Container.ItemIndex %>" name="SelectItemValue"
value='<%#Eval("ID") %>' onclick="selectItem();" />
</td>
<td style="text-align: center;">
<%#Eval("DonationNo")%>
</td>
<td style="text-align: center;">
<%#((DateTime)Eval("DonationDate")).ToDateString() %>
</td>
</tr>
</AlternatingItemTemplate>
<ItemTemplate>
<tr class="row">
<td style="text-align: center">
<input type="checkbox" id="CheckBox_<%# Container.ItemIndex %>" name="SelectItemValue"
value='<%#Eval("ID") %>' onclick="selectItem();" />
</td>
<td style="text-align: center;">
<%#Eval("DonationNo")%>
</td>
<td style="text-align: center;">
<%#((DateTime)Eval("DonationDate")).ToDateString() %>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>
<div style="display: none;">
<asp:TextBox runat="server" ID="txt_ActiveHiddenID"></asp:TextBox>
<asp:HiddenField ID="txt_SelectHiddenID" runat="server" />
</div>
<script language="javascript" type="text/javascript">
function SelectAllList() {
var selectAll = document.getElementById("selectAll");
var activeItemID = "";
for (var i = 0; i < document.getElementById("MasterDataList").rows.length - 1; i++) {
var chk = document.getElementById("CheckBox_" + i);
chk.checked = selectAll.checked;
if (chk.checked) {
if (activeItemID.length > 0) {
activeItemID += ",";
}
activeItemID += document.getElementById("CheckBox_" + i).value;
}
}
document.getElementById("<%=txt_SelectHiddenID.ClientID %>").value = activeItemID;
}
function selectItem() {
var activeItemID = "";
for (var i = 0; i < document.getElementById("MasterDataList").rows.length - 1; i++) {
var chk = document.getElementById("CheckBox_" + i);
if (chk.checked) {
if (activeItemID.length > 0) {
activeItemID += ",";
}
activeItemID += document.getElementById("CheckBox_" + i).value;
}
}
document.getElementById("<%=txt_SelectHiddenID.ClientID %>").value = activeItemID;
}
</script>