Convert DataSet To Excel

[kscdavefl]

I am running the following code to retrieve a DataSet:

public DataView CreateGroupSour ce()
{
string groupConnect = Session["connect"].ToString();
string groupSelect = "Select grpname from Maxusergroups where usrname = "
+ "'" + userText.Text + "'";
oda = new OleDbDataAdapte r(groupSelect, groupConnect);
DataSet ds = new DataSet();
oda.Fill(ds, "group");
DataView group = ds.Tables["group"].DefaultView;
return group;
}

When I click on a button on a web form I want to convert the information
toan excel spreadsheet.

How do I accomplish this task?

Thanks,

Dave

[Nicholas Paldino [.NET/C# MVP]]

Dave,

You would create a dataadapter, and then you would set the
InsertCommand, DeleteCommand and UpdateCommand to the commands that will
perform those operations. Then, feed the dataset to the Update method on
the DataAdapter, and it should work.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"kscdavefl" <ks*******@disc ussions.microso ft.com> wrote in message
news:B4******** *************** ***********@mic rosoft.com...

I am running the following code to retrieve a DataSet:

public DataView CreateGroupSour ce()
{
string groupConnect = Session["connect"].ToString();
string groupSelect = "Select grpname from Maxusergroups where usrname = "
+ "'" + userText.Text + "'";
oda = new OleDbDataAdapte r(groupSelect, groupConnect);
DataSet ds = new DataSet();
oda.Fill(ds, "group");
DataView group = ds.Tables["group"].DefaultView;
return group;
}

When I click on a button on a web form I want to convert the information
toan excel spreadsheet.

How do I accomplish this task?

Thanks,

Dave

[Chad Z. Hower aka Kudzu]

=?Utf-8?B?a3NjZGF2ZWZ s?= <ks*******@disc ussions.microso ft.com> wrote in
news:B4******** *************** ***********@mic rosoft.com:

When I click on a button on a web form I want to convert the information
toan excel spreadsheet.

The easiest way is to export as a CSV, and then load that with Excel.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programmin g is an art form that fights back"

Empower ASP.NET with IntraWeb
http://www.atozed.com/IntraWeb/

[Fredrik Wahlgren]

"Chad Z. Hower aka Kudzu" <cp**@hower.org > wrote in message
news:Xn******** **********@127. 0.0.1...

=?Utf-8?B?a3NjZGF2ZWZ s?= <ks*******@disc ussions.microso ft.com> wrote in
news:B4******** *************** ***********@mic rosoft.com:

When I click on a button on a web form I want to convert the information
toan excel spreadsheet.

The easiest way is to export as a CSV, and then load that with Excel.

Excel can read xml files.

/Fredrik

[Chad Z. Hower aka Kudzu]

"Fredrik Wahlgren" <fr************ ****@mailbox.sw ipnet.se> wrote in
news:Om******** *****@TK2MSFTNG P12.phx.gbl:

The easiest way is to export as a CSV, and then load that with Excel.

Excel can read xml files.

Even easier - if it can read the same format that the dataset produces.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programmin g is an art form that fights back"

Make your ASP.NET applications run faster
http://www.atozed.com/IntraWeb/

[Nicholas Paldino [.NET/C# MVP]]

Chad,

Since Excel can read XML, and the XML produced by the DataSet is valid,
it can read them. However, you have to handle all the mappings yourself.

One catch though, you have to be using Excel XP, or 2003 and up (I'm not
sure which version support was added).

If that is not a problem for you, then I would use that.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Chad Z. Hower aka Kudzu" <cp**@hower.org > wrote in message
news:Xn******** **********@127. 0.0.1...

"Fredrik Wahlgren" <fr************ ****@mailbox.sw ipnet.se> wrote in
news:Om******** *****@TK2MSFTNG P12.phx.gbl:

The easiest way is to export as a CSV, and then load that with Excel.

Excel can read xml files.

Even easier - if it can read the same format that the dataset produces.
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programmin g is an art form that fights back"

Make your ASP.NET applications run faster
http://www.atozed.com/IntraWeb/

[Fredrik Wahlgren]

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote in
message news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

Chad,

Since Excel can read XML, and the XML produced by the DataSet is valid, it can read them. However, you have to handle all the mappings yourself.

One catch though, you have to be using Excel XP, or 2003 and up (I'm not sure which version support was added).

If that is not a problem for you, then I would use that.

Another option is to use automation from within your C# application. Start a
new instance of Excel, make it visible, loop thru your values and pass them
one by one. You should be able to find several examples of this on the
Internet.

/Fredrik

[Chad Z. Hower aka Kudzu]

"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard .caspershouse.c om> wrote
in news:#j******** ******@TK2MSFTN GP10.phx.gbl:

Since Excel can read XML, and the XML produced by the DataSet is
it can read them. However, you have to handle all the mappings
yourself.

Thats what I thought. Unless he wants to go through ODBC or Automation, the
simplest solution might be best. A CSV. :)
--
Chad Z. Hower (a.k.a. Kudzu) - http://www.hower.org/Kudzu/
"Programmin g is an art form that fights back"

Get your ASP.NET in gear with IntraWeb!
http://www.atozed.com/IntraWeb/