Click here to Skip to main content
15,884,353 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
GeneralVisual Studio. Net Help Please !!! Pin
mattymc17-Apr-04 17:32
mattymc17-Apr-04 17:32 
GeneralRe: Visual Studio. Net Help Please !!! Pin
Fade (Amit BS)18-Apr-04 3:31
Fade (Amit BS)18-Apr-04 3:31 
Question.Net Version Problem..???? Pin
Renjith Ramachandran17-Apr-04 9:05
Renjith Ramachandran17-Apr-04 9:05 
AnswerRe: .Net Version Problem..???? Pin
Sarvesvara (BVKS) Dasa17-Apr-04 18:08
Sarvesvara (BVKS) Dasa17-Apr-04 18:08 
GeneralHANDLE in .net Pin
Paolo Ponzano17-Apr-04 1:49
Paolo Ponzano17-Apr-04 1:49 
GeneralRe: HANDLE in .net Pin
Mike Dimmick18-Apr-04 2:13
Mike Dimmick18-Apr-04 2:13 
GeneralChecking for Installed Component Pin
swcrissman16-Apr-04 11:13
swcrissman16-Apr-04 11:13 
GeneralDynamicly creating excel file and sending to client Pin
c++guy16-Apr-04 10:51
c++guy16-Apr-04 10:51 
Hi!

I searched on Google as well as the entire codeproject forum and still can't find answer to my problem. I am desparetely in need of someone's advice!!

I have ASP.NET C# code to dynamicly create excel file on server. User will then click on a link to the created excel file and download/browse the content.

I need to change this so that the dynamcly created excel file will be directly transffered to the client (without saving it on the server disk!)

Is it possible to do such a sthing?

Here is how I create the excel file on server. fileExcel is the filename of the creating excel file.
<br />
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Driver={Microsoft Excel Driver (*.xls)};DBQ=" + @xlsTemplatePath + "\\" + fileExcel + ";ReadOnly=False;Extended Properties=Excel 8.0;";<br />
OdbcConnection conn= new OdbcConnection();<br />
conn.ConnectionString = connectionString;<br />
conn.Open();<br />
OdbcCommand myOdbcCommand = new OdbcCommand();<br />
myOdbcCommand.Connection = conn;      <br />
<br />
myOdbcCommand.CommandText = "CREATE TABLE [Sheet1$] ( " + strColNamesWV + ")";<br />
myOdbcCommand.ExecuteNonQuery();<br />
<br />
...  <br />
<br />


I will hugely appriciate if you could shine some light on my mind.
GeneralRe: Dynamicly creating excel file and sending to client Pin
Steven Campbell16-Apr-04 14:57
Steven Campbell16-Apr-04 14:57 
QuestionIs it possible? Pin
MDem16-Apr-04 8:36
MDem16-Apr-04 8:36 
AnswerRe: Is it possible? Pin
Charlie Williams16-Apr-04 10:54
Charlie Williams16-Apr-04 10:54 
AnswerRe: Is it possible? Pin
Renjith Ramachandran17-Apr-04 16:30
Renjith Ramachandran17-Apr-04 16:30 
GeneralServer GC vs. Workstation GC Pin
jqd200115-Apr-04 9:08
jqd200115-Apr-04 9:08 
GeneralRe: Server GC vs. Workstation GC Pin
Mike Dimmick15-Apr-04 9:24
Mike Dimmick15-Apr-04 9:24 
GeneralRe: Server GC vs. Workstation GC Pin
jqd200115-Apr-04 9:55
jqd200115-Apr-04 9:55 
GeneralSending a custom message to .NET Pin
MarkSPA15-Apr-04 7:41
MarkSPA15-Apr-04 7:41 
Generalsetup project Pin
Dpriya15-Apr-04 3:01
Dpriya15-Apr-04 3:01 
Generalconvert unicode to ascii Pin
eranas14-Apr-04 6:58
eranas14-Apr-04 6:58 
GeneralRe: convert unicode to ascii Pin
Steven Campbell14-Apr-04 14:22
Steven Campbell14-Apr-04 14:22 
Generalascii to unicode Pin
Maverick14-Apr-04 18:43
Maverick14-Apr-04 18:43 
GeneralRe: ascii to unicode Pin
Steven Campbell15-Apr-04 2:44
Steven Campbell15-Apr-04 2:44 
GeneralRe: ascii to unicode Pin
Maverick18-Apr-04 20:25
Maverick18-Apr-04 20:25 
GeneralRe: convert unicode to ascii Pin
eranas14-Apr-04 20:26
eranas14-Apr-04 20:26 
GeneralRe: convert unicode to ascii Pin
Steven Campbell15-Apr-04 2:39
Steven Campbell15-Apr-04 2:39 
GeneralRe: convert unicode to ascii Pin
Mike Dimmick15-Apr-04 2:23
Mike Dimmick15-Apr-04 2:23 

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.