Hi and TIA! I have a recordset retrieved into a datgrid in my web app, from
an SQL database that I want to save as an excel formatted file. I would
like the user to click a button, get a prompt to save/name the file. Is
this possible and if so where can I find information on accomplishing this
task. Any advice is appreciated. Using (.Net 1.1 / VS2003 / SQL Server
2000 / WinXP Pro). I posted to several groups cause not sure the best place
to ask the question.
Thanks for your time.
--
*************** ***
Reggie
3  1621 
try this code as i used it it worked perfect with c#
string sFilename="myex cel";
Response.Conten tType = "applicatio n/vnd.ms-excel";
Response.Append Header("Content-Disposition", "attachment;fil ename=" +
sFilename);
Response.Charse t = "";
// Turn off the view state.
this.EnableView State = false;
System.IO.Strin gWriter tw=new StringWriter();
HtmlTextWriter hs=new HtmlTextWriter( tw);
this.MyGrid.Ren derControl(hs);
Response.Write( tw.ToString());
Response.End();
"Reggie" wrote:
Hi and TIA! I have a recordset retrieved into a datgrid in my web app, from
an SQL database that I want to save as an excel formatted file. I would
like the user to click a button, get a prompt to save/name the file. Is
this possible and if so where can I find information on accomplishing this
task. Any advice is appreciated. Using (.Net 1.1 / VS2003 / SQL Server
2000 / WinXP Pro). I posted to several groups cause not sure the best place
to ask the question.
Thanks for your time.
--
*************** ***
Reggie
I've detailed a variety of technique for Excel export here: http://SteveOrr.net/articles/ExcelExport.aspx
--
I hope this helps,
Steve C. Orr, MCSD, MVP http://SteveOrr.net
"Reggie" <NoSpam_chief12 3101@NoSpam_yah oo.comwrote in message
news:Gg******** *******@fe07.lg a...
Hi and TIA! I have a recordset retrieved into a datgrid in my web app,
from an SQL database that I want to save as an excel formatted file. I
would like the user to click a button, get a prompt to save/name the file.
Is this possible and if so where can I find information on accomplishing
this task. Any advice is appreciated. Using (.Net 1.1 / VS2003 / SQL
Server 2000 / WinXP Pro). I posted to several groups cause not sure the
best place to ask the question.
Thanks for your time.
--
*************** ***
Reggie
Steve, Exactly what I've been trying to accomplish. I'm a little new at
ASP.Net and the .Net Framework stuff, but I'm getting there. Thanks again
for you time and advice. Take care.
--
*************** ***
Reggie
"Steve C. Orr [MVP, MCSD]" <St***@Orr.netw rote in message
news:%2******** *******@TK2MSFT NGP05.phx.gbl.. .
I've detailed a variety of technique for Excel export here:
http://SteveOrr.net/articles/ExcelExport.aspx
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net
"Reggie" <NoSpam_chief12 3101@NoSpam_yah oo.comwrote in message
news:Gg******** *******@fe07.lg a...
>Hi and TIA! I have a recordset retrieved into a datgrid in my web app,
from an SQL database that I want to save as an excel formatted file. I
would like the user to click a button, get a prompt to save/name the
file. Is this possible and if so where can I find information on
accomplishin g this task. Any advice is appreciated. Using (.Net 1.1 /
VS2003 / SQL Server 2000 / WinXP Pro). I posted to several groups cause
not sure the best place to ask the question.
Thanks for your time.
--
************** ****
Reggie
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Paul |
last post by:
Hi all
Arggghhh...........
The problem.....I want the user to be able to create an excel document and
name particular cells in the document where they want the data to be placed
and then save this out of an XML file or Excel Template file.
Next I need to convert a dataset to xml and try and transform this data into
the users xml...
|
by: Eric |
last post by:
Hi,
I am making a flash card type program for the PocketPC. I am using a dataset
to contain the cards, all of that works great.
I thought I would just import the XML into word or excel, copy/paste the
data from other sources or add new records, and then save it as xml. As i
have Office XP, that does not work.
Is there a freeware XML...
|
by: JacksonYin |
last post by:
1. I can fill data from Excel to DataSet like this:
OleDbConnection connection = new
OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=../../Book1.xls;Extended Properties=Excel 8.0;");
connection.Open();
OleDbCommand command =new OleDbCommand("SELECT * FROM myRange1",
connection);
|
by: Hans [DiaGraphIT] |
last post by:
Hi!
I want to export a dataset to an excel file. I found following code on the
net...
( http://www.codeproject.com/csharp/Export.asp )
Excel.ApplicationClass excel = new ApplicationClass();
excel.Application.Workbooks.Add(true);
DataTable table = DATASETNAME.Tables;
|
by: Schultz |
last post by:
I would like to know if it is possible to import data from MS Excel
2000 to a dataset using asp.net. The excel file would need to be
uploaded to the server from a web page first, before the loaded into a
dataset. After the data is stored in the dataset, i would need to write
the information to an access db. If it is possible to do this, where...
| | |
by: washoetech |
last post by:
Hello,
I am working on a project where I need to be able to grab the data from an
Excel spreadsheet and create a new table in my database based on the columns
in the spreadsheet. After the table is created then I need to fill the table
with the data from that spreadsheet. I am using ASP.NET 2.0 and SQL 2000 for
my database.
What would...
|
by: postings |
last post by:
Hi - can you help please?
Please review the following straightforward code which works fine with
ordinary XML files.
----------------------------------------------------------------
Dim originalxmlsource As New DataSet
Dim xmlfilename As String = Request.PhysicalApplicationPath _ &
"myfilename.xml"
MyDataGrid.DataSource =...
|
by: Phoebe. |
last post by:
Hi, Good Day!
Reading 1 excel file into a dataset is fine.
How can I read multiple excel with the same data structure into 1 dataset?
How can I append those data?
Can someone help?
Thanks in advanced.
rgds,
|
by: Ramakrishnan Nagarajan |
last post by:
Hi,
I am converting Excel data into a Dataset in C#. There are around 24 columns
in the Excel Sheet.
First I tried to insert one row with correct values in the Excel sheet. i.e.
for text columns I entered text values and for numeric columns I entered
numeric values. It works fine and pass through all the validation checks and
gets inserted...
|
by: Sachin Salgarkar |
last post by:
I have a DataSet that I need to export to Excel.
The dataset has multiple tables. I need a way to export the complete dataset
to a single Excel Workbook with sheets for each table in the dataset.
Is that possible ?
I have seen solutions that export a single table to an Excel file.
Opening the XML ( DataSet.getXML() ) in Excel is a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
