How to export data from DB to excel?

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

0	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

0	Hi, http://www.ljzsoft.com/excelreport/database-to-excel.htm Regards, Susan Seenuvasan, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts