62,046
社区成员
发帖
与我相关
我的任务
分享
List<Hashtable> list1 = new List<Hashtable>();
Hashtable hTable;
hTable = new Hashtable();
hTable.Add("ID", "1");
hTable.Add("COMPANY_NAME", "Acme1");
hTable.Add("WEB_ADDRESS", "www.AcmeTech1.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
hTable = new Hashtable();
hTable.Add("ID", "2");
hTable.Add("COMPANY_NAME", "Acme2");
hTable.Add("WEB_ADDRESS", "www.AcmeTech2.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
hTable = new Hashtable();
hTable.Add("ID", "3");
hTable.Add("COMPANY_NAME", "Acme3");
hTable.Add("WEB_ADDRESS", "www.AcmeTech3.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
hTable = new Hashtable();
hTable.Add("ID", "4");
hTable.Add("COMPANY_NAME", "Acme4");
hTable.Add("WEB_ADDRESS", "www.AcmeTech4.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
hTable = new Hashtable();
hTable.Add("ID", "5");
hTable.Add("COMPANY_NAME", "Acme5");
hTable.Add("WEB_ADDRESS", "www.AcmeTech5.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
hTable = new Hashtable();
hTable.Add("ID", "6");
hTable.Add("COMPANY_NAME", "Acme6");
hTable.Add("WEB_ADDRESS", "www.AcmeTech6.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
hTable = new Hashtable();
hTable.Add("ID", "7");
hTable.Add("COMPANY_NAME", "Acme7");
hTable.Add("WEB_ADDRESS", "www.AcmeTech7.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
hTable = new Hashtable();
hTable.Add("ID", "8");
hTable.Add("COMPANY_NAME", "Acme8");
hTable.Add("WEB_ADDRESS", "www.AcmeTech8.com");
hTable.Add("PRIMARY_SIC_DESCRIPTION", "technology");
hTable.Add("METRO_AREA", "USA");
hTable.Add("YEAR_1ST_APPEARED", "1980");
hTable.Add("CONTACT_TITLE", "President");
list1.Add(hTable);
public class Util
{
public static DataTable Convert2DataTable(List<Hashtable> list)
{
DataTable dt = new DataTable();
if (list.Count == 0)
return dt;
foreach (string name in list[0].Keys)
dt.Columns.Add(name);
foreach (Hashtable item in list)
dt.Rows.Add(new ArrayList(item.Values).ToArray());
return dt;
}
}
this.GridView1.DataSource = Util.Convert2DataTable(list1);
this.GridView1.DataBind();
DataTable dt = new DataTable();
foreach (string name in hTable.Keys)
dt.Columns.Add(name);
foreach (Hashtable item in list1)
dt.Rows.Add(new ArrayList(item.Values).ToArray());
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
<asp:GridView ID="gvData" runat="server" CssClass="tb" AutoGenerateColumns="false"
DataKeyNames="ID" OnRowCommand="gvData_RowCommand">
<EmptyDataTemplate>
无数据
</EmptyDataTemplate>
<Columns>
<asp:TemplateField HeaderText="公司名称">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("[COMPANY_NAME]")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="网址">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("[WEB_ADDRESS]")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="描述">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("[PRIMARY_SIC_DESCRIPTION]")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="区域">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("[METRO_AREA]")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="年">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("[YEAR_1ST_APPEARED]")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="标题">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("[CONTACT_TITLE]")) %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:GridView ID="gvData" runat="server" CssClass="tb" AutoGenerateColumns="false"
DataKeyNames="ID" OnRowCommand="gvData_RowCommand">
<EmptyDataTemplate>
无数据
</EmptyDataTemplate>
<Columns>
<asp:TemplateField HeaderText="公司名称">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("COMPANY_NAME")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="网址">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("WEB_ADDRESS")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="描述">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("PRIMARY_SIC_DESCRIPTION")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="区域">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("METRO_AREA")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="年">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("YEAR_1ST_APPEARED")) %>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="标题">
<ItemTemplate>
<%# WZW.Utils.StringUtils.OutputHtml(Eval("CONTACT_TITLE")) %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>