Xero

Okay heres the dilemna.... I have a Dataset("LineItems") that Stores information about so many records. To source to this DataSet("LineItems") is not its intended ouput. Meaning I pull this info in from one database and output to another. My problem is i have no idea on how to write an insert statement that will insert multiple records into a SQL table. Does anyone have any pointers???? PLEASE HELP ASAP. THANKS!

The problem i am having is understand Databindings fully... What i think databindings does it binds the data to a textbox lets say and if you change the textbox shouldn't that in theory change the data set that its bound to??? If not how can i go about doing this. I have a bunch of textboxes with Databindings to a Dataset thats being read in from a table. What I would like to do is be able to change the textbox and then update the table from there. How is this possible?