How to export data from DB to excel?

Posted by Seenuvasan under Regular Expressions on 6/23/2011 | Points: 10 | Views : 3080 | Status : [Member] | Replies : 5
Hi,

i have data in DB as folowing columns
->Sno
->name
->task
->date

i need to export these data to Excel as following format
        
12/03/2011 13/03/2011 14/03/2011 ----->dates

name1 list of tasks (same like) (same like)
done on this date

name2


please guide me

Thanks,
Seen



Responses

Posted by: SheoNarayan on: 6/23/2011 [Administrator] HonoraryPlatinum | Points: 25

Up
0
Down
Please read this article, it should guide you how to export data into MS Excel file http://www.dotnetfunda.com/articles/article920-export-text-along-with-image-into-ms-excel-file-.aspx.

or you can read this as well http://www.dotnetfunda.com/articles/article429-simplest-method-export-gridviewdata-to-excelsheet-using-aspnet-.aspx

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Seenuvasan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Seenuvasan on: 6/24/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Sheo,

Thanks for your responce.

i need to align tasks based on date and name of the user automatically because we don't know how many columns and rows it will take.etc.
How can i do this?

Pls guide me

Thanks,
Seen

Seenuvasan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakn2 on: 6/24/2011 [Member] Starter | Points: 25

Up
0
Down
try this

http://www.mssqltips.com/tip.asp?tip=1202

Thanks&Regards
LakshmiNarayana Nalluri.

Seenuvasan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Seenuvasan on: 6/24/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,,

i need to export data using c# in asp.net , not sql server and others methods

Thanks

Thanks,
Seen

Seenuvasan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 6/24/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi,

http://www.ljzsoft.com/excelreport/database-to-excel.htm

Regards,
Susan

Seenuvasan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response