Click here to Skip to main content
15,889,116 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Updating a resx file Pin
Sandeep Mewara21-Apr-12 6:32
mveSandeep Mewara21-Apr-12 6:32 
QuestionReporting Pin
Member 387988119-Apr-12 23:24
Member 387988119-Apr-12 23:24 
AnswerRe: Reporting Pin
Sandeep Mewara21-Apr-12 6:37
mveSandeep Mewara21-Apr-12 6:37 
QuestionVisual Basic.net Pin
Hermaine18-Apr-12 21:42
Hermaine18-Apr-12 21:42 
AnswerRe: Visual Basic.net Pin
Pete O'Hanlon18-Apr-12 22:20
mvePete O'Hanlon18-Apr-12 22:20 
GeneralRe: Visual Basic.net Pin
Hermaine18-Apr-12 22:54
Hermaine18-Apr-12 22:54 
GeneralRe: Visual Basic.net Pin
Vipin_Arora19-Apr-12 2:23
Vipin_Arora19-Apr-12 2:23 
QuestionExport to Excel with number of columns unknown in advance Pin
biop.codeproject18-Apr-12 19:52
biop.codeproject18-Apr-12 19:52 
I have a web application to display sales data. My input, transaction_header table, is like this:

...van_idsale_date...
...Van A2012-03-01 17:28:38.000...
...Van A2012-03-01 17:33:54.000...
...Van B2012-03-01 12:33:48.000...
...Van B2012-03-01 12:38:14.000...


I need to export the transaction data to excel and the excel would show as:

Gross Sales
DATEVan AVan BVan C...
1-Mar$3,359...
$49,934$20,657$41,481...
2-Mar$3,633$4,263...
$73,394$38,134$41,083...
3-Mar$2,118...
$40,831$39,838$32,344...
4-Mar
SUNDAY
5-Mar$4,387$3,842...
$84,814$39,242$41,116...
...


My problem is the number of van may change over time. For the transaction_header table, this does not post a problem as there is just one more row. Yet for the output, it is a problem. Thw columns of my table may increase over time. Now how do I approach this problem?

Appreciate any feedback. Thanks.

modified 19-Apr-12 22:57pm.

AnswerRe: Export to Excel with number of columns unknown in advance Pin
Hermaine18-Apr-12 21:09
Hermaine18-Apr-12 21:09 
AnswerRe: Export to Excel with number of columns unknown in advance Pin
ZurdoDev19-Apr-12 6:37
professionalZurdoDev19-Apr-12 6:37 
GeneralRe: Export to Excel with number of columns unknown in advance Pin
biop.codeproject19-Apr-12 16:49
biop.codeproject19-Apr-12 16:49 
AnswerRe: Export to Excel with number of columns unknown in advance Pin
ZurdoDev20-Apr-12 1:53
professionalZurdoDev20-Apr-12 1:53 
AnswerRe: Export to Excel with number of columns unknown in advance Pin
vvashishta24-Apr-12 18:55
vvashishta24-Apr-12 18:55 
Questionborder for the repeater control Pin
indian14318-Apr-12 18:58
indian14318-Apr-12 18:58 
AnswerRe: border for the repeater control Pin
Reza Ahmadi19-Apr-12 2:07
Reza Ahmadi19-Apr-12 2:07 
AnswerRe: border for the repeater control Pin
jkirkerx19-Apr-12 8:49
professionaljkirkerx19-Apr-12 8:49 
QuestionVB.net Pin
Hermaine18-Apr-12 18:48
Hermaine18-Apr-12 18:48 
AnswerRe: VB.net Pin
biop.codeproject18-Apr-12 19:54
biop.codeproject18-Apr-12 19:54 
GeneralRe: VB.net Pin
Hermaine18-Apr-12 20:52
Hermaine18-Apr-12 20:52 
AnswerRe: VB.net Pin
Abhinav S18-Apr-12 20:50
Abhinav S18-Apr-12 20:50 
GeneralRe: VB.net Pin
Hermaine18-Apr-12 20:58
Hermaine18-Apr-12 20:58 
AnswerRe: VB.net Pin
ZurdoDev19-Apr-12 6:39
professionalZurdoDev19-Apr-12 6:39 
AnswerRe: VB.net Pin
Vipin_Arora19-Apr-12 22:30
Vipin_Arora19-Apr-12 22:30 
QuestionWhen opening a SSRS report in visual stusio, gives error unable get IVSDDESIGNER SERVICE Pin
nainakarri18-Apr-12 18:14
nainakarri18-Apr-12 18:14 
QuestionGet and set the value of a literal in the list item in unordered list - jquery Pin
indian14318-Apr-12 13:03
indian14318-Apr-12 13:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.