datagridview saving

[RobcPettit]

Hi, I need some advice on how to proceed with saving gridview
contents. Ive got a 'datagridview control' on a form, so its window
application only not web. I fill this programatically with
'dataGridView1.Rows.Add(whatever array)' so its not bound to a
database. Once the data in I want to save the data in a format that I
can 1,reuse in the datagrid or 2, as an excel file. From what Ive
googled so far, this doesnt seem possible without using a dataset. So
am I correct in thinking that my best course of action is to--Send my
data to a database, create a dataset, bound this to datagridview and
then either stream into excel or possible save as xml file to reuse in
application. Or is there a way to avoid dataset. I dont have a problem
with 'dataset' its creating the database Im not clear on. Even after
googling. Thanks in advance.
Regards Robert

[RobcPettit]

Thankyou for your reply. That makes things clearer then. Create my
dataset and use in datagridview. Am I write that, to save contents of
datagridview, you have to have a dataset?.
Regards Robert

[RobcPettit]

Thanks for making that clear. Working with dataset was easier than I
thought, so Ill stick with it. Thanks for your time.
Regards Robert