|
|
How to create an excel sheet in asp.net
kavitha
|
|
|
|
|
Use the office web components.
It's the COM version for Office.
Eran Aharonovich (eran.aharonovich@gmail.com )
Noviway
|
|
|
|
|
Hello,
Thanks for u r reply.
Im using office 2003 on win2000
and owc11,but i get the error
"QueryInterface for interface owc11.ISpreadsheetclass failed"
it works fine on xp machine,i have tried reinstalling owc11,office 2003,
but im getting the same error.
can u pls help
kavitha
|
|
|
|
|
There are a couple of ways to create the excel document, and one of the simple options is to generate the excel sheet in the XML format. Using the automation is also an option but it's not recommended to run at the server side due to some issues which you can find in MSDN. Also, if you want to create the excel sheet in the native format, you might consider using a third party component like Aspose.Cell.
|
|
|
|
|
Thanks for u r reply
i'll try them
kavitha
|
|
|
|
|
Can some body tell me how many types of datasets are there. And what are they.
Thanks & Regards
Mishra
|
|
|
|
|
there are 2 types of dataset available.
1. Strongly typed Dataset
2. Dataset
|
|
|
|
|
There is 1 type of dataset, in the System.Data namespace.
There is also a feature of .NET that will generate a "strongly typed dataset" from an XML schema (xsd), which is simply some auto generated classes which inherit from Dataset, DataTable, DataRow and DataColumn to make a dataset that is slightly easier to use, and enforces type safety in the data.
---
How to get answers to your questions[^]
-- modified at 4:17 Monday 17th July, 2006
|
|
|
|
|
I want to add multiple URLs for the datagrid control in Visual Studio. I looked in the collections column and it only has space for a URL. I want to create multiple URLs for their respective names. For example, for Sydney it will go to Sydney's home page....for Melbourne it will go to the Melbourne's home page etc. Can this be done in the asp.net environment or will i have to create some C# coding to get this working?
If anyone can help, i would be grateful.
Thanks
nkhan23
|
|
|
|
|
You can pass it to a single page(ex: A.aspx)and pass the values sydney or Melbourne through query string . and in the page load of A.aspx you can check the query string and pass it to sydney's home page or Melbourne's home page.
Thanks & Regards
Mishra
|
|
|
|
|
You can use itemdatabound event to generate your url in the datagridon the fly.
<br />
string CellText = e.item.cell[2].Text<br />
<br />
string url = "MyPages.aspx?username=" + CellText<br />
<br />
e.Item.cell[2].Text = url<br />
<br />
Code is sudo code and not tested.
Look where you want to go not where you don't want to crash.
Bikers Bible
|
|
|
|
|
Hi,
Help me out with this
I developed webservice and am using in my application
ie i am consuming web service from the local machine
it worked fine for a while but now it gives an error "unable to connect to remote server"
is it something to do with proxy setting of my application.though i tried changing the proxy settings of my machine, it dint help though
help please
Thanks jiny
|
|
|
|
|
browse on your web service with browser on your asmx file and check for no error...?
Human knowlege belongs to the world
|
|
|
|
|
is it possible to execute crystal reports from aspx page
if yes can u plz provide the details
|
|
|
|
|
is there any one who can help me out
i want yes or no for the above quest
|
|
|
|
|
How to upload the file form client to server without Browse button.
I want to upload the file from client's C:\abc.txt file to server on click of
normal ASP BUTTON.
|
|
|
|
|
Considering this would be a substantial security risk so I doubt there is a way to do it with just ASP.net/html/javascript. Although, you may be able stick together a java applet that does it... I'm not sure.
|
|
|
|
|
When I Debug any ASP.NET Applicaion 1.1, It is unable to Debug with the message below:
"Error while trying to run project: Unable to start debugging on the web server"
I have checked all of guides below however all of it not solve my problem, However I can Debug any ASP.NET Application 2.0, I found that When I have installed Visual Studio 2005, I unable to Debug any ASP.NET Application 1.1
Are there any conflict?
How can I do to Debug ASP.NET 1.1 ???
Please help me!!!
Thanks Alot
Things to Check
If you get an "Unable to start debugging on the Web server" error, try checking the following things:
* Are you running a version of Windows that allows the Visual Studio debugger to automatically attach to a Web application? If not, you need to launch the application without debugging and manually attach to it. (For more information, see Manually Attaching and ASP.NET Debugging: System Requirements.)
* Does your Web application have a Web.config file?
o Does the Web.config file enable debug mode) by setting the debug attribute to true? For more information, see Debug Mode in ASP.NET Applications.
o Does the Web.config file contain any syntax errors? You can check for syntax errors by running the Web application without debugging. (From the Debug menu, choose Start Without Debugging.) If there are syntax errors in Web.config, detailed information will be displayed.
* You need to be a member of the Debugger Users group or an administrator if the ASP.NET worker process runs under your own user account.
* You need to be a member of the Administrators group if the ASP.NET worker process runs under any other user account besides your own.
* Did you create the project by specifying a specific IP address (100.20.300.400, for example)? Debugging a Web server requires NTLM authentication. By default, IP addresses are assumed to be part of the Internet, and NTLM authentication is not done over the Internet. To correct this problem:
o When creating the project, specify the name of the machine on your intranet.
-or-
o Add the IP address (http://100.20.300.400) to the list of trusted sites on your computer. (From the Internet Explorer Tools menu, choose Internet Options, and then select the Security tab).
* Does the machine running IIS server have Visual Studio .NET Remote Components installed?
* Was IIS installed on the local machine (the machine running Visual Studio .NET) after Visual Studio .NET was installed? IIS should be installed before Visual Studio .NET. If it was installed afterwards, you may need to repair the .NET Framework.
To repair the .NET Framework
o Insert the Visual Studio .NET disc and enter as one line at the command line:
<dvd drive="">:\wcu\dotNetFramework\dotnetfx.exe /t:c:\temp
/c:"msiexec.exe /fvecms c:\temp\netfx.msi"
—or—
Insert the Visual Studio .NET Requirements disc and enter as one line at the command line:
<cd drive="">:\dotNetFramework\dotnetfx.exe /t:c:\temp
/c:"msiexec.exe /fvecms c:\temp\netfx.msi"
* Is the URL for the project start page properly specified? Are the extension and project directory correct?
* Are the IIS security settings set up properly? To verify this, check the Default Web Site settings.
To check IIS security settings for the Default Web Site
1. From the Start menu, choose Programs, then Administrative Tools, and click Internet Services Manager (Windows 2000) or Internet Information Services (Windows XP).
2. In the Internet Services Manager or Internet Information Services dialog box, click the tree control for your machine. In the Web Sites folder, find Default Web Site.
3. Right-click Default Web Site and choose Properties.
4. In the Default Web Site Properties window, select the Directory Security tab and click Edit.
5. In the Authentication Methods dialog box, select Anonymous Access and Integrated Windows Authentication (if not already selected).
6. Click OK to close the Internet Services Manager or Internet Information Services dialog box.
|
|
|
|
|
Hi
mesage indicates that the issue is with the IIS.
Try Reseting the IIS by typing "iisreset" in the command prompt.... Even if the issue continues, u may reiinstall the IIS and check if it helps...
regds
rijesh
|
|
|
|
|
I am going back to school and find myself constantly searching for information. Currently ASP.NET development, if you know of some good links to the information, I would appretiate it.
Some that I have found userful so far:
Event Handling in ASP.NET[^]
Build Your Own ASP.NET Website...[^]
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
|
Thanks, I was hoping for sights that are harder to find, like the ones I listed. I tend to start with CodeProject and then go from there. MSDN is always an excellent source of information on Windows related programming issues. I should have placed a ‘*’ next to the second link, because that was the one that helped the most with figuring out some problems.
My main goal is to save time in finding research materials, and people keep referencing good sights that I did not find during my searches.
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
John R. Shaw wrote: My main goal is to save time in finding research materials
For the first two sites, I'd normally use the search functionality of the site to look for what I want to know. For the online MSDN, I'd better use the king Google to search on this site as the search of MSDN is not as good as the site. Also, as I'm familiar with the structure of the MSDN (both local and online), I can quickly narrow the scope of my searching, for example with the ASP.NET[^] from the left pane. As you already know that, with VS 2005 you have more options to do your search quickly with the Community menu item.
|
|
|
|
|
Ya, I use Google a lot. The MSDN has tons of good information, but finding it is the trick. I have already recorded the location of the ASP.NET information sections I will probably need.
I just discovered that one of the CodeProject partners is ASPAlliance, which looks like a good jumping off point for my research.
Thanks again!
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
