Click here to Skip to main content
15,921,959 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: DLLs, Global Variables, and Scope Pin
Jesse Squire16-Aug-06 3:06
Jesse Squire16-Aug-06 3:06 
GeneralRe: DLLs, Global Variables, and Scope Pin
Suresh Pirsquare17-Aug-06 3:45
Suresh Pirsquare17-Aug-06 3:45 
AnswerRe: DLLs, Global Variables, and Scope [modified] Pin
ToddHileHoffer16-Aug-06 3:14
ToddHileHoffer16-Aug-06 3:14 
AnswerRe: DLLs, Global Variables, and Scope Pin
Paddy Boyd16-Aug-06 5:09
Paddy Boyd16-Aug-06 5:09 
Questionasp 2003->2005 Pin
locaas16-Aug-06 2:02
locaas16-Aug-06 2:02 
AnswerRe: asp 2003->2005 [modified] Pin
Alvin George16-Aug-06 2:34
Alvin George16-Aug-06 2:34 
Questioninsert data from excel sheet into sql server [modified] Pin
playout16-Aug-06 2:00
playout16-Aug-06 2:00 
AnswerRe: insert data from excel sheet into sql server Pin
Jesse Squire16-Aug-06 2:40
Jesse Squire16-Aug-06 2:40 
There are a few ways that you can go about this, depending on how complex the spreadsheet is that you wish to read. In a simple case, you may want to consider using ADO to tap Excel as a data source. You can find a nice article on doing so here[^].

If that doesn't work for you, you may wish to consider purchasing one of the commercial components that allow you to work with the Excel native format without Office being present on the machine, such as this[^] one.

As a last resort, it is possible to install Office on the server and use the Office interop assemblies to automate Excel. Please note that I label this the last resort, because it is slower, consumes more resources, and requires client software to be installed on a server (potentially increasing the attack surface.)

Hope that helps. Smile | :)

--Jesse

QuestionCan ASP.NET script and HTML server controls be placed in an XSL file? Pin
Red_Wizard_Shot_The_Food15-Aug-06 23:44
Red_Wizard_Shot_The_Food15-Aug-06 23:44 
QuestionMaster Page Pin
Kamal.Afridi15-Aug-06 23:43
Kamal.Afridi15-Aug-06 23:43 
AnswerRe: Master Page Pin
Guffa16-Aug-06 1:40
Guffa16-Aug-06 1:40 
QuestionIFRAME Pin
-Yoyosh-15-Aug-06 22:49
-Yoyosh-15-Aug-06 22:49 
AnswerRe: IFRAME Pin
_AK_15-Aug-06 23:10
_AK_15-Aug-06 23:10 
AnswerRe: IFRAME Pin
-Yoyosh-15-Aug-06 23:46
-Yoyosh-15-Aug-06 23:46 
GeneralRe: IFRAME Pin
_AK_16-Aug-06 0:01
_AK_16-Aug-06 0:01 
QuestionPaging in Pin
Prabs frm PGP15-Aug-06 22:47
Prabs frm PGP15-Aug-06 22:47 
Questionpaging in DataGrid: Pin
Prabs frm PGP15-Aug-06 22:45
Prabs frm PGP15-Aug-06 22:45 
AnswerRe: paging in DataGrid: Pin
postmaster@programmingknowledge.com16-Aug-06 1:20
postmaster@programmingknowledge.com16-Aug-06 1:20 
AnswerRe: paging in DataGrid: Pin
Sathesh Sakthivel16-Aug-06 1:47
Sathesh Sakthivel16-Aug-06 1:47 
GeneralRe: paging in DataGrid: Pin
Prabs frm PGP16-Aug-06 2:09
Prabs frm PGP16-Aug-06 2:09 
GeneralRe: paging in DataGrid: Pin
Sathesh Sakthivel16-Aug-06 2:47
Sathesh Sakthivel16-Aug-06 2:47 
GeneralRe: paging in DataGrid: Pin
Prabs frm PGP16-Aug-06 3:01
Prabs frm PGP16-Aug-06 3:01 
QuestionSorting for dynamically created column in a datagrid using C# Pin
sudheerkonda15-Aug-06 22:32
sudheerkonda15-Aug-06 22:32 
AnswerRe: Sorting for dynamically created column in a datagrid using C# Pin
blurMember16-Aug-06 16:00
blurMember16-Aug-06 16:00 
GeneralRe: Sorting for dynamically created column in a datagrid using C# Pin
sudheerkonda17-Aug-06 2:12
sudheerkonda17-Aug-06 2:12 

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.