遍历datatable的几种方法(C# )
转载
- 遍历datatable的方法2009-09-08 10:02方法一:
- DataTable dt = dataSet.Tables[0];
- for(int i = 0 ; i < dt.Rows.Count ; i++)
- {
- string strName = dt.Rows[i]["字段名"].ToString();
- }
- 方法二:
- foreach(DataRow myRow in myDataSet.Tables["temp"].Rows)
- {
- var str = myRow[0].ToString();
- }
- 方法三:
- foeach(DataRow dr in dt.Rows)
- {
- object value = dr["ColumnsName"];
- }
- 方法四:
- DataTable dt=new DataTable();
- foreach(DataRow dr in dt.Rows)
- {
- for(int i=0;i<dt.Columns.Count;i++)
- {
- dr[i];
- }
- }
- 绑定DataTable到Reapter。
- if (dtb_xx.Rows.Count > 0)
- {
- rp_xx.DataSource = dtb_xx;
- rp_xx.DataBind();
- }
- <asp:Repeater ID="rp_xx" runat="server">
- <ItemTemplate>
- <tr>
- <td>
- <div>
- <ul class="ListHorizontally">
- <li>
- <div class="TCell1">
- <%#Eval("ID")%>
- </div>
- </li>
- <li>
- <div class="TCell2">
- <%#Eval("Name")%>
- </div>
- </li>
- </ul>
- </div>
- </td>
- </tr>
- </ItemTemplate>
- </asp:Repeater>
- 方法五
- DataRow[] dataRows = null;
- dataRows = dataTable.Select(fieldParentID + "='" + treeNode.Tag.ToString() + "'", dataTable.DefaultView.Sort);
- foreach (DataRow dataRow in dataRows)
- {
- DataRow dataRow = dataTable.Rows[i];
- ?? = dataRow[fieldParentID].ToString();
- }
缠非缠、禅非禅
枯木龙吟照大千