Download the SQL servere date to excel file using ASP.net

Hi EveryOne

I would like to download the SQL server databse to excel file using ASP.Net

I need to download the one table to excel file. If anyone knows please help me.

With Regards

Nibu Abraham

hi

i found this link

http://www.theserverside.net/discussions/thread.tss?thread_id=29385

give a try

|||

Hi Nibu

Create a stored procedure to display the required columns from the give table. Grant execute permission to this stored procedure to the role that your ASP.NET account is assigned to. In your datalayer, run the stored procedure to output a dataset. Add a gridview control (or datagrid if still at ASP.NET 1.1) to an ASPX form.

Set the datasource for the control to the dataset produced by the read function in your data layer, call databind and the data will be displayed.

There is a simple modifier to make the displayed page OLE load Excel - I will find out the how of this at the weekend.

HTH

|||

You need to add the following to your Page_Load

Response.ContentType = "application/vnd.ms-excel";

Response.Charset = "";

You will need to turn off the sort option on the grid and any other hyperlinks on the form.

HTH

sql

doubt in crystal report(help needed Urgently)

hai

I have one doubt in crystal report.I am using crystal report 7 version.I added a databse to report and i connected that report with visual basic and my report is working.Except that i cant refresh my report at runtime and so it displays the same values repeatedly.

I cant use crystal report 8 or 9 or 10.

Help needed urgently

Bye
Ramyafrom file menu of crystal report , uncheck the option of 'Save Data with Report', then save the file and try .|||hai

i have one doubt i am using crystal report from visual basic and not directly from crstal report.

That is i added report at project itself and so where to change that option

Bye
Ramya

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed Visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in Visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?
Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?
|||I've installed Visio for VS2005 Beta? but I can't found where is that command
to do it
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>
|||I mean not to create new diagram but contigious development of a database
(two way connection with a database)
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>
|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed Visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?
|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in Visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.
|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?

Does Yukon have diagramm designer?

I've installed Beta2 and havn't found this feature.
How can I now design my databse sheme?Use VISIO... That feature has been removed from the client tools, at least
for now.
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?|||I've installed visio for VS2005 Beta? but I can't found where is that comman
d
to do it
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>|||I mean not to create new diagram but contigious development of a database
(two way connection with a database)
"Adam Machanic" wrote:

> Use VISIO... That feature has been removed from the client tools, at least
> for now.
>
> "Vadim" <Vadim@.discussions.microsoft.com> wrote in message
> news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
>
>|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:81E14BD3-7F3D-41B3-A6FA-2DF8AACFF056@.microsoft.com...
> I've installed visio for VS2005 Beta? but I can't found where is that
command
> to do it
To do what?|||"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:436C4814-D513-43BA-A68F-B7D34FC357BE@.microsoft.com...
> I mean not to create new diagram but contigious development of a database
> (two way connection with a database)
I don't know about the 2005 version, but in visio for Enterprise
Architects (I believe the version I'm running came with VS.NET 2003), under
the "Database" toolbar, there are options "Update", "Generate", and "Reverse
Engineer" that handle that functionality.|||It's in, it's out... most recently someone told me it was going to be put
back in.. but I do not remember who I was talking to...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vadim" <Vadim@.discussions.microsoft.com> wrote in message
news:B178B37A-6B45-4585-96E9-82653560A788@.microsoft.com...
> I've installed Beta2 and havn't found this feature.
> How can I now design my databse sheme?