I am trying to generate an XML file from a datagridview that looks like this:
A0001,Horse on Wheels,5,No
A0002,Elephant on Wheels,2,No
A0003,Dog on Wheels,0,Yes
A0004,Seal on Wheels,3,No
It has 4 elements i.e an Order Number, Item description, Current count and On order.
When the XML file is generated however, only the top row is used. How can I make it so that a different row is used for different items?
What I have tried:
my code is as follows
string source = Clipboard.GetText(TextDataFormat.CommaSeparatedValue);
XElement cust = new XElement("Root",
from str in source
let fields = source.Split(',', '\n')
select new XElement("Item",
new XElement("OrderId", fields[0]),
new XElement("ItemDescription", fields[1]),
new XElement("CurrentCount", fields[2]),
new XElement("OnOrder", fields[3])
)
);
I have a button that copies all the data in the grid to the clipboard, code is as follows:
IDataObject objectSave = Clipboard.GetDataObject();
dataGridView1.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableWithoutHeaderText;
dataGridView1.SelectAll();
Clipboard.SetDataObject(dataGridView1.GetClipboardContent());
Any help would be greatly appreciated. I am very new to coding and have been trying to teach myself for only a few weeks.