我有一個xml檔案，其內容如下。我想將此檔案中的航班資訊添加到datagridview。我將在 datagridview 中創建的列是
flight_id, flight_description, flight_date, instructor_num, instructor_name, student_num, student_name
<?xml version="1.0" encoding="utf-8"?>
<Simulator>
<Flight ID="1" Description="sunny" Date="2022-09-09">
<Instructor Num="6">
<Name>matt</Name>
<Surname>matt</Surname>
<Rank>matt</Rank>
</Instructor>
<Student Num="66">
<Name>matt</Name>
<Surname>matt</Surname>
<Rank>matt</Rank>
</Student>
<Operator Num="666">
<Name>matt</Name>
<Surname>matt</Surname>
<Rank>matt</Rank>
</Operator>
<Technician Num="6666">
<Name>matt</Name>
<Surname>matt</Surname>
<Rank>matt</Rank>
</Technician>
<ErrorLOGS>
<Logs Hour_Date="2022-09-09T09:12:00" ID="1">
<ErrorGUI>checkbox</ErrorGUI>
<ErrorType>high</ErrorType>
<ProgramPage>Failures</ProgramPage>
<ErrorStartTime>PT9H12M23S</ErrorStartTime>
</Logs>
<Logs Hour_Date="2022-09-09T09:12:00" ID="1">
<ErrorGUI>checkbox</ErrorGUI>
<ErrorType>high</ErrorType>
<ProgramPage>Page</ProgramPage>
<ErrorStartTime>PT9H12M23S</ErrorStartTime>
</Logs>
</ErrorLOGS>
</Flight>
<Flight ID="2" Description="test flight">
.................like flight1.........
</Flight>
</Simulator>
我嘗試過這樣的事情但失敗了
string inputpath = Application.StartupPath "\\Data.xml";
XmlDocument doc = new XmlDocument();
doc.LoadXml(inputpath);
IEnumerable<string> names = doc.Root.Descendants("Flight").Select(e => e.Attribute("ID") , e.Attribute("Description"), e.Attribute("Date")).Value);
uj5u.com熱心網友回復：
使用我以前的發布代碼。添加了 MakeDataTable。比你可以使 dgv 的資料源成為資料表：datagridview1.DataSource = dt。
public class Simulator
{
XDocument doc = null;
public Simulator(string filename)
{
doc = XDocument.Load(filename);
}
public Simulator(string id, string description)
{
string ident = "<?xml version=\"1.0\" encoding=\"utf-8\"?><Simulator></Simulator>";
doc = XDocument.Parse(ident);
XElement flight = new XElement("Flight", new object[] {
new XAttribute("ID", id),
new XAttribute("Description", description)
});
doc.Root.Add(flight);
}
public string AddUser(string flightID, string role, string number, string name, string surname, string rank)
{
XElement flight = doc.Descendants("Flight").Where(x => (string)x.Attribute("ID") == flightID).FirstOrDefault();
if (flight != null)
{
XElement user = new XElement(role, new object[] {
new XAttribute("Num", number),
new XElement("Name", name),
new XElement ("Surname", surname),
new XElement("Rank", rank)
});
flight.Add(user);
return "GOOD";
}
else
{
return "Flight ID doesn't exist";
}
}
public string AddFlight(string flightID, string description)
{
XElement flight = doc.Descendants("Flight").Where(x => (string)x.Attribute("ID") == flightID).FirstOrDefault();
if (flight == null)
{
flight = new XElement("Flight", new object[] {
new XAttribute("ID", flightID),
new XAttribute("Description", description)
});
doc.Root.Add(flight);
return "Good";
}
else
{
return "Flight ID already exists";
}
}
public string AddErrors(string flightID, XElement errorLog)
{
XElement flight = doc.Descendants("Flight").Where(x => (string)x.Attribute("ID") == flightID).FirstOrDefault();
if (flight == null)
{
return "Flight ID doesn't exist";
}
else
{
flight.Add(errorLog);
return "GOOD";
}
}
public void WriteXml(string filename)
{
doc.Save(filename);
}
public DataTable MakeDataTable()
{
DataTable dt = new DataTable();
dt.Columns.Add("flight_id", typeof(int));
dt.Columns.Add("flight_description", typeof(string));
dt.Columns.Add("flight_date",typeof(DateTime));
dt.Columns.Add("instructor_num", typeof(int));
dt.Columns.Add("instructor_name", typeof(string));
dt.Columns.Add("student_num", typeof(int));
dt.Columns.Add("student_name", typeof(string));
foreach (XElement flight in doc.Descendants("Flight"))
{
DataRow row = dt.Rows.Add();
int iD = (int)flight.Attribute("ID");
row["flight_id"] = iD;
string description = (string)flight.Attribute("Description");
row["flight_description"] = description;
DateTime date = (DateTime)flight.Attribute("Date");
row["flight_date"] = date;
XElement xStudent = flight.Element("Student");
if (xStudent != null)
{
int studentNum = (int)xStudent.Attribute("Num");
row["student_num"] = studentNum;
string studentName = (string)xStudent.Element("Name");
row["student_name"] = studentName;
}
XElement xInstructor = flight.Element("Instructor");
if (xInstructor != null)
{
int instructorNum = (int)xStudent.Attribute("Num");
row["instructor_num"] = instructorNum;
string instructorName = (string)xStudent.Element("Name");
row["student_name"] = instructorName;
}
}
return dt;
}
}
uj5u.com熱心網友回復：
嘗試為模擬器創建類并像這樣反序列化它
public Simulator FromXml(string value)
{
using (TextReader reader = new StringReader(value))
{
return new XmlSerializer(Simulator).Deserialize(reader);
}
}
public partial class Simulator
{
[JsonProperty("Flight")]
public Flight Flight { get; set; }
}
public partial class Flight
{
[JsonProperty("Instructor")]
public Instructor Instructor { get; set; }
[JsonProperty("Student")]
public Instructor Student { get; set; }
[JsonProperty("Operator")]
public Instructor Operator { get; set; }
[JsonProperty("Technician")]
public Instructor Technician { get; set; }
[JsonProperty("ErrorLOGS")]
public ErrorLogs ErrorLogs { get; set; }
}
public partial class ErrorLogs
{
[JsonProperty("Logs")]
public Log[] Logs { get; set; }
}
public partial class Log
{
[JsonProperty("ErrorGUI")]
public string ErrorGui { get; set; }
[JsonProperty("ErrorType")]
public string ErrorType { get; set; }
[JsonProperty("ProgramPage")]
public string ProgramPage { get; set; }
[JsonProperty("ErrorStartTime")]
public string ErrorStartTime { get; set; }
}
public partial class Instructor
{
[JsonProperty("Name")]
public string Name { get; set; }
[JsonProperty("Surname")]
public string Surname { get; set; }
[JsonProperty("Rank")]
public string Rank { get; set; }
}
uj5u.com熱心網友回復：
private void gridFilter_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1 && e.ColumnIndex > -1)
{
gridFilter.Rows[e.RowIndex].Selected = true;
string selectedValue = gridFilter.Rows[e.RowIndex].Cells[0].FormattedValue.ToString();
XDocument doc = XDocument.Load(inputpath);
List<XElement> flights = doc.Descendants("Flight").ToList();
foreach (XElement flight in flights)
{
string idSelect1 = (string)flight.Attribute("ID");
if (selectedValue == idSelect1) {
XElement xLogs = flight.Element("Logs");
if (xLogs != null)
{
string ErrorGUI = (string)xLogs.Element("ErrorGUI");
string ErrorType = (string)xLogs.Element("ErrorType");
string ProgramPage = (string)xLogs.Element("ProgramPage");
listBox.Items.Add(ErrorGUI);
listBox.Items.Add(ErrorType);
listBox.Items.Add(ProgramPage);
}
}
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/508610.html