storing array list in database.

Satyapriy Chindak

Hello,

I have a college project to do on billing system.

I have displayed dynamic data from texboxes in datagridview using arraylist.

All i wanted is to store datagridview values as a list in database or entire invoice details as one file in xml file as database.

if, i am working with xml file then i wanted to store invoice items dynamically with single id which will be easy to fetch and manupulate.

So can you help with any demo sample?.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
you can save as xml file in database and while retriving save that file in local folder and bind grid from that xml file
Nigel Fernandes9y ago
1) If you want to store list in database , store it comma seperated .

2) Why do you want to store in xml format? Store the data as columns and when you fetch the data convert it to xml, its easy.
FileStream fs = new FileStream("c:\\test.xml", FileMode.OpenOrCreate); System.Xml.Serialization.XmlSerializer s = new System.Xml.Serialization.XmlSerializer(typeof(ClassName)); s.Serialize(fs, f);