|
Hi to All,
I am trying to handle excel file in my application. Here I am trying to get a cell value in the text box on the event of button click. but whenever i run it shows exception that Access is denied..... my code is as follows....
private Excel.Application oXL=null;
private void Button1_Click(object sender, System.EventArgs e)
{
InitializeComponent();
oXL = new Excel.ApplicationClass();
oXL.Visible = true;
Excel.Workbook oWB = oXL.Workbooks.Open("D:\\Pravin\\October-07\\xls\\7starcare-October.xls",0,true,5,"","",true,Excel.XlPlatform.xlWindows,"\t",false, false, 0, true);
Excel.Sheets oSheet= oWB.Worksheets;
Excel.Worksheet oWS = (Excel.Worksheet)oSheet.get_Item(1);
TextBox1.Text= Convert.ToString(oWS.Cells.get_Item(1,1));
}
But whenever i run my application it shows exception as follws ....
------------------------------------------------------------------------------------------------
Access is denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true">, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
----------------------------------------------------------------------------------------------------
how can i remove this problem?
Pravin
|
|
|
|
|
You need to grant the ASPNET machine account, which your site is running under in IIS, read permissions to the file. You can do this in Windows Explorer by right-clicking on the file and selecting the 'Security' tab.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Please help.
I am getting the above error.
my code:
SqlConnection conn = new SqlConnection("data source=server;initial catalog=database;persist security info=False;user id=user;password=password");
conn.Open();
DataTable t_table = new DataTable();
SqlDataAdapter adapt;
SqlCommand cmd = new SqlCommand("Select Project_ID From tblProjects",conn);
adapt = new SqlDataAdapter(cmd);
adapt.Fill(t_table);dsProjectId.Tables.Add(t_table);
|
|
|
|
|
Hai iam working with generic list the data from combobox selected items is added to list using first next and last buttons continiously and i need this list items to be write into an excel file when i click on save button plz any one help me in this
In this project there are four classes and the item which is selected in combobox is to be added to list and when we press save it is to saved to excel file using c# plz help me
|
|
|
|
|
Hey there,
I am new to this language and have been looking at the example program at the link below:
http://www.codeproject.com/dotnet/twaindotnet.asp
but what i wanted was when the image is returned from the scanner, is to convert it to a Bitmap. I have tried numerous ways to convert the ImgPtr but get an ExternalException at runtime. The example seems to use another class to save and display the image, but I would prefer to handle a Bitmap.
Any help would be greatly appreciated
Thanks
Pete
|
|
|
|
|
You're probaqbly getting back a HBITMAP, there is a Bitmap.FromHAndle or Bitmap.FromHBITMAP, isn't there ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hey thanks for your reply
yeah there is and thats what i tried. this gives me the external exception. i don't know what that is though, or what causes it.
pete
|
|
|
|
|
hey thanks for your reply
yeah there is and thats what i tried. this gives me the external exception. i don't know what that is though, or what causes it.
pete
|
|
|
|
|
|
Hello All,
I have created an application which will create the word document with table structure wihtin it. but my problem is, it is taking 3 minutes for creating 60 tables on the documnet.I will have to create somewhere arroung 7000 tables to be created on the fly. I wanted to know whethere there are any methods from which i can improve the performance
Bharath.S Ron
|
|
|
|
|
What method are you using to create the tables?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
i am creating tables on word document. the data is comming from xml file.
Bharath.S Ron
|
|
|
|
|
Hey all,
Actually i should say that i have a Decrypting problem  !
I am trying to use a certificate to prove the client/server identity in my application. I was sending a welcome message from the server to the client, encryption/decryption worked smoothly, but this message is just a string like the client number, name of the computer where the server is running and all that...
Now when i am doing this:
Publisher publisher = new Publisher(new Init().Certificate());
byte[] message = Encoding.ASCII.GetBytes(new Encrypting().Encrypt(new Init().GetRawCertData(), password));
....
and sending it over the "Network", i am getting a bad data exception... something about a wrong character in the Base64 String.
I am sending fixed length bytes[] and when i am just sending strings it works. But when i try to change the type of data to send it messes up.
My logic to Encrypt/Decrypt is create an instance of the algorithm to use, i use the login password to encrypt/decrypt and i init the key and IV of the algorithm with them, a memory stream and the crypto stream... and return an array of bytes.
Maybe i am doing something wrong, any idea of how to use the certificate better, I am extremely new to Certificates and Digital Signatures. I tried SSL Stream but i could not make work .
Thanks in advance !
Best regards!!!
Luis E Tineo S
|
|
|
|
|
Are you still having trouble with this?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
HI guys,
I have resize picturebox (say picMain) to the size of form.There are many picturebox inside picMain. Now I am moving child
picturebox ( on mouse_move event) on picMain. I am getting refresh problem while dragging child picturebox.
I had use Invalidate(),Update() and Refresh() method of current movable child picturebox but not getting precise solution. It seems like child picturebox ghost is following it. Child picturebox takes more times to refresh.
Instead of picMain if I work with main form then it work very well. I think picturebox has less ability to refresh faster compare
to form (am I write??).
I want same effect as what we dragged item from visual studio toolbox and move around in the form.(its so smooth)
pls give the solution
thanks in advance.
Regards
Chintan
www.visharadsoft.com
(I am thinking to change humans to computer, but unfortunately GOD will not give me the source code)
|
|
|
|
|
Sounds like you read an article and should have posted your question in the forum below that article.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
How would I tell if a textbox's text is a number or string? Thanks.
- I love D-flat!
|
|
|
|
|
TextBox.Text is always a string; you can get its numeric value if YourNumericType.TryParse()
returns true.
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips:
- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use PRE tags to preserve formatting when showing multi-line code snippets
|
|
|
|
|
Ok; thanks. Could you check out my post below please? I'm getting depressed.. can't even PUBLISH?
- I love D-flat!
|
|
|
|
|
Does anybody know how to find the memory usage for an object instance or instances? Specifically, I'm trying to figure out how much overall memory it takes to retreive data from the database and populate the object instance in two different ways. I attempted to get the memory usage of an object instance by calling System.GC.GetTotalMemory() before and after the object creation and take the difference, but it didn't work in some cases. Below is some example code on what I'm trying to do:
<br />
public int FindMemoryUsage()<br />
{<br />
SqlDataReader reader;<br />
<br />
int memoryBefore = System.GC.GetTotalMemory(false);<br />
reader =
The result of the function should return the memory usage of the reader which is dependent on the results returned from the database. However, I tested this by comparing the memory usages between retreiving just a few records and a whole lot of records from the database and the result was approximately the same. Can anyone explain to me what I'm doing wrong? Any help is greatly appreciated!!
P.S. - Why does using the 'code' tag fail to indent anything?
-- modified at 20:48 Tuesday 27th November, 2007
|
|
|
|
|
The problem is that the GC may not release memory when it's no longer used. So if you run your first test and it causes your application to jump to 100MB, then your next test only needs 50MB, your application will probably still have 100MB allocated. Depending on how much free space you already have, you may not see any differences between running your two tests even if the "large" test is performed second. Basically, the GC memory totals are not a good way to detect memory usage.
You can use performance counters[^] to try to track down which test is better. You can also use Son Of Strike (SOS) to get the data from the raw objects. The blog entries here[^] and here[^] are a good place to start.
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
I'm looking for an C# API, subscription-based service, or database that will allow me to pass a zip or city/state/zip with a distance parameter i.e. ("redmond","wa","98052",20) and get back the surrounding cities within the specified distance, without getting into some kind of gps coding nightmare. Does anyone know of such a thing?
Cliff Robinson
|
|
|
|
|
cliffr wrote: Does anyone know of such a thing?
SQL Server 2008? (The functionality got released last week in CTP5)
|
|
|
|
|
How would I publish and deploy a program that has DirectX references and how to do this in general?
- I love D-flat!
|
|
|
|
|
By shipping the DirectX runtime installer with it and making sure that any interop dlls that get build with your proejct are included.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
