将值添加到数据表的第二列

acrylicfrog 发表于 Dev

丙烯酸蛙

如何将listbox2的值添加到第二个“日期”列中？该代码可以工作，但会将值添加到第一列“名称”。

XmlTextReader reader = new XmlTextReader(cesta);
XmlNodeType type;

DataSet dsload = new DataSet();
dsload.ReadXml(cesta);
DataTable dt = new DataTable("MyTable");
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Date", typeof(DateTime)));

while (reader.Read())
{  
   if (reader.Name == "Name")
    {
        reader.Read();
        listbox1.Items.Add(reader.Value);
    }

    if (reader.Name == "Date")
    {
        reader.Read();
        listbox2.Items.Add(reader.Value);
    }

}

foreach (string value in listbox1.Items)
{
    dr = dt.NewRow();
    dr[0] = value;
    dt.Rows.Add(dr);
}
data.DataSource = dt;

foreach (string value in listbox2.Items)
{
    dr = dt.NewRow();
    dr[0] = value;
    dt.Rows.Add(dr);
}
data.DataSource = dt;

杰里米·汤普森（Jeremy Thompson）

DataTable dt = new DataTable("MyTable");
dt.Columns.Add(new DataColumn("Name", typeof(string)));
dt.Columns.Add(new DataColumn("Date", typeof(DateTime))); 

while (reader.Read())
{
   dr = dt.NewRow();
   //if (reader.Name == "Name")
   //{
        // reader.Read();  <-- this isn't needed, you're already reading...
        listbox1.Items.Add(reader[0].ToString());
        dr["Name"] = reader[0].ToString();
   //}

   //if (reader.Name == "Date")
   //{
        listbox2.Items.Add(reader[1].ToString());
        dr["Date"] = reader[1].ToString();
   //}
    dt.Rows.Add(dr);
}
data.DataSource = dt;