Microsoft Office Excel cannot access the file - ASP.NET Discussion Boards

Hi code project world!

My Question is that :
I have written a "web application" via ASP.net 2008 and SQL database 2008.
I wanna use this source for multiple websites with different Master pages and CSS.
1) what is the simplest way/Solution to do that ?
2) if i change the main source code (one will be the main that i make changes to that) how can update other websites that uses this code(but with different Master pages and CSS)?

Thanks is advanced!

webpage is published successfully in windoms xp iss.... but page is not redirect another page when it call....... any one solve this problem to me .. i ready to pay for you 1000RS...... contact me if you know solution for this.. dineshk61@gmail.com

Please provide full technical details of your problem, as it stands there is no real way anyone can guess what you may be doing wrong. And do not offer money (answers are provided free here), or put your email in publicly available messages.

One of these days I'm going to think of a really clever signature.

Hello Guys,

I am new to .Net could you please tell me what are the controls used in ASAP.Net ?

Thanks,
Vani

Controls in asp.net consist of several categories such as HTML elements, but can be used directly on a web form or in code behind.

So web designers just starting out can drag and drop a control from the toolbar onto a web form, and experts can just type pure code to build sections of a web page.

If you have a specific question about controls, feel free to ask.

Read this[^]. It's the documentation and it's where you should start.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Hi, you can read the article in msdn:

http://msdn.microsoft.com/en-us/library/bb386451(v=vs.100).aspx[^]

Comm100 - Leading Live Chat Software Provider

modified 28-May-14 1:49am.

I am getting this while import and exporting data to Excel file

Quote:
Microsoft Office Excel cannot access the file 'C:\usr\SVN\ePROM\EffOnePMA\Files\QuestionStructure.xls'.

There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

Here I am Attacheing my code

private void DownLoadStrcture()
        {
            Excel.Application xlApp;
            Excel.Workbook xlWorkBook;
            Excel.Workbook xlTempWorkBook;
            Excel.Worksheet xlWorkSheet;
            Excel.Range range;
            range = null;
            int rCnt = 2;
            int cCnt = 2;
            string str;
            string fname = "QuestionStructure.xls";
            string Filepath = Server.MapPath("~/Files/" + fname);
            string TempFilename = "QuestionStructure_ " + Convert.ToInt32(Session[PageBase.SESSION_USER_ID]) + ".xls";
            string TempFilepath = Server.MapPath("~/Files/Temp/" + TempFilename);
            string dep = ddlDepartment.SelectedItem.Text.ToString();
            string area = ddlArea.SelectedItem.Text.ToString();
            string category = ddlCategory.SelectedValue != "-1" ? ddlCategory.SelectedItem.Text : "";
            string subCategory = ddlSubCategory.SelectedValue != "-1" ? ddlSubCategory.SelectedItem.Text : "";

            xlApp = new Excel.Application();
            xlWorkBook = xlApp.Workbooks.Open(Filepath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
            range = xlWorkSheet.UsedRange;
            File.Copy(Filepath, TempFilepath);

            xlWorkBook.Close();
            xlApp.Quit();
            releaseObject(xlWorkSheet);
            releaseObject(xlWorkBook);
            releaseObject(xlApp);

            xlApp = new Excel.Application();
            xlTempWorkBook = xlApp.Workbooks.Open(TempFilepath, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
            xlWorkSheet = (Excel.Worksheet)xlTempWorkBook.Worksheets.get_Item(1);
            range = xlWorkSheet.UsedRange;

            str = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2;
            string[] stringArray = new string[] { dep, area, category, subCategory };
            for (int i = 0; i < stringArray.Length; i++)
            {
                (range.Cells[rCnt, cCnt] as Excel.Range).Value2 = stringArray[i].ToString();
                str = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2;
                rCnt++;
            }
            xlApp.DisplayAlerts = false;
            xlApp.ScreenUpdating = false;
            xlApp.Visible = false;
            xlApp.UserControl = false;
            xlApp.Interactive = false;
            string Deletefilepath = Server.MapPath("~/Files/Temp/");
            if (File.Exists(Deletefilepath + TempFilename))
                File.Delete(Deletefilepath + TempFilename);

            xlTempWorkBook.Close(SaveChanges: true);
            Marshal.ReleaseComObject(xlTempWorkBook);
            xlApp.Quit();
            GC.Collect();
            GC.WaitForPendingFinalizers();
            Marshal.FinalReleaseComObject(xlTempWorkBook);
            Marshal.FinalReleaseComObject(range);
            Marshal.FinalReleaseComObject(xlApp);
            
        }

Dear All,

After following instruction from the excellent article by Panayotis Matsinopoulos for setting up a multi-language interface -

Allow users to select the user interface language in your ASP.NET Web application

I went to debug it using the built-in debugger in Visual Studio (VS) and received an error that the class module cannot be loaded. I know it is finding the module because if I move it to a different location in my project, it specifies that it cannot find the module.

This got me thinking about the whole subject of httpModules and their deployment on a localhost webserver and also use in VS debugging and I now have the following questions as a new and aspiring .NET programmer -

1. Does using the VS debugger make a difference? Does for example the module need to be registered separately ahead of time somehow on the localhost? Does it make a difference that the web.config file, the class module for the LanguageModule and the page itself (as well as the App_GlobalResources files) are all inside the same VS project?
2. Does the httpModule need to be registered separately on the local IIS for the application? I mean, I'm sure it needs to be so registered if I am running the application in a browser outside of Visual Studio, - but what about from within VS using the debugger? Doesn't the built-in compiler in the Debugger handle this (registration)?
3. If none of the above are issues in using the VS debugger, how can I go about debugging why the module won't load?

Thanks everyone for your assistance. I hope this isn't too much of a newbie question for the esteemed company!

Best Regards,

Ray Fischer, Kibo, Germany

If you have an issue with a CodeProject article then please first post your question in the forum at the end of the article. In this way the author will be notified of your query.

One of these days I'm going to think of a really clever signature.

Thanks Richard for your answer. I can post it there as well, I was just not sure because this is more of a general question relating to VS and the debugger there and not so much having to do with the method shown.

Hi All,

I have a WCF Service (Ex name: MyWCFService) which has all the database access and business logic mechanism, which is hosted in IIS using BasicHttpBinding. This WCF service is created by me. One of my collegue also created a WCF service called JasonProxyService which consumes MyWCFService, converts the result into Jason and gives it to UI, UI is using Ajax. The JasonProxyservice doesnt have configuration (like in web config it doesnt have elements <services>, <service> etc, which is unusual for me), and this JasonProxyservice has only two files .svc and svc.vb added to an asp.net application which has the UI also (the asp.net application has all the UI and ajax etc). There is no interface for contract, the ServiceContract attribute is defined right on top of the class and the methods in the class are defined with OperationContract attribute on top of them. When I tried to add interace and define it as service contract and put the WCF service configuration in the webconfig file, simply the Ajax isnt working. Then I left that option.
The reason for keeping JasonProxyService and UI in the same project is to avoid cross domain, becuase Ajax doesnt allow cross domain and our organization also not interested in cross domain because of security. The developer who wrote JasonProxyservice has left the project. Now it has come to my plate. This is what the problem is. I am really struggling with it for a while.
For solution, as first step I wrote logger to understand what is the problem, I am getting the below exception, and I am new to the json world. Please help me. Below is my exception, any help would be really helpfull.

XML

System.ServiceModel.ProtocolException: The content type text/html of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<title>500 - Internal server error.</title>
<style type="text/css">
<!--
body{margin:0;font-size:.7em;font-family:Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;}
fieldset{padding:0 15px 10px 15px;} 
h1{font-size:2.4em;margin:0;color:#FFF;}
h2{font-size:1.7em;margin:0;color:#CC0000;} 
h3{font-size:1.2em;margin:10px 0 0 0;color:#000000;} 
#header{width:96%;margin:0 0 0 0;padding:6px 2% 6px 2%;font-family:"trebuchet MS", Verdana, sans-serif;color:#FFF;
background-color:#555555;}
#content{margin:0 0 0 2%;position:relative;}
.content-container{background:#FFF;width:96%;margin-top:8px;padding:10px;position:relative;}
-->
</style>
</head>
<body>
<div id="header"><h1>Server Error</h1></div>
<div id="content">
 <div class="content-container"><fieldset>
 '. ---> System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
   at System.Net.HttpWebRequest.GetResponse()
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
   --- End of inner exception stack trace ---

Server stack trace: 
   at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory factory, WebException responseException, ChannelBinding channelBinding)
   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
   at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
   at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
   at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at WA.LNI.StayAtWork.Public.Web.StayAtWorkServiceReference.IStayAtWorkService.SetContactInfo(UserInfo userInfo)
   at WA.LNI.StayAtWork.Public.Web.StayAtWorkServiceReference.StayAtWorkServiceClient.SetContactInfo(UserInfo userInfo) in D:\source\SourceCode\StayatWork-VS2010\WA.LNI.StayAtWork.Public.Web\WA.LNI.StayAtWork.Public.Web\Service References\StayAtWorkServiceReference\Reference.vb:line 2848
   at WA.LNI.StayAtWork.Public.Web.JSONProxyService.SetContactInfoJSON(UserInfo dto) in D:\source\SourceCode\StayatWork-VS2010\WA.LNI.StayAtWork.Public.Web\WA.LNI.StayAtWork.Public.Web\JSONProxyService.svc.vb:line 359

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

That's like finding a needle in the haystack. I would start the debugger up again and F9 the lines below,add some watches and step through the values.

D:\source\SourceCode\StayatWork-VS2010\WA.LNI.StayAtWork.Public.Web\WA.LNI.StayAtWork.Public.Web\Service References\StayAtWorkServiceReference\Reference.vb:line 2848

D:\source\SourceCode\StayatWork-VS2010\WA.LNI.StayAtWork.Public.Web\WA.LNI.StayAtWork.Public.Web\JSONProxyService.svc.vb:line 359

Hi jkirkerx,

I resolved it, actually it was another problem so it was throwing exception because of a field in the database is not matching to what I am sending.
So that exception was unable to be read by the jason application. So this error.

Thanks for your suggestion.

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

That's Great!

I get those to, but you have to start somewhere and check all the values before the exception is thrown. It's always the dumbest little thing.

Enjoy your weekend now

let me first show the code. here is the insert code:

C#

try
{
    sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
    sql_connection.Open();
    sql_command = new MySqlCommand("sp_add_support_ticket", sql_connection);
    sql_command.CommandType = CommandType.StoredProcedure;

    sql_command.Parameters.AddWithValue("param_support_incident_title", txtSubject.Text);
    sql_command.Parameters.AddWithValue("param_email_address", txtEmailAddress.Text);
    sql_command.Parameters.AddWithValue("param_support_ticket_description", txtMessage.XHTML);

    int result_rows = sql_command.ExecuteNonQuery();

    Session["message_title"] = "Thank you";
    Session["message_title_Color"] = Color.Blue.ToArgb();
    Session["message_text"] = "We have recieved your feedback and we will get back to you as soon as possible.";
    Session["message_button_title"] = "Back";
    Session["message_button_url"] = "Home.aspx";

    Response.Redirect("Message.aspx", false);
}
catch (Exception exp)
{
    Session["message_title"] = "Error";
    Session["message_title_Color"] = Color.Red.ToArgb();
    Session["message_text"] = "Unable to send your message. Please try again later.";
    Session["message_button_title"] = "Back";
    Session["message_button_url"] = Request.UrlReferrer.ToString();

    Response.Redirect("Message.aspx", false);
}
finally
{
    if (sql_connection != null)
    {
        if (sql_connection.State == ConnectionState.Open)
            sql_connection.Close();
    }
}

and this is my stored procedure:

SQL

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_add_support_ticket`(IN `param_support_incident_title` varchar(255),IN `param_email_address` varchar(255),IN `param_support_ticket_description` text)
BEGIN
	INSERT INTO support_incidents (support_incident_title, email_address) VALUES (param_support_incident_title, param_email_address);
	INSERT INTO support_tickets (support_incident_id, support_ticket_description) VALUES (LAST_INSERT_ID(), param_support_ticket_description);
END

now.... when I fill the form on help.aspx page i get the data insert properly..

BUT...............

It will also add a new row

in support_incodents table with "Thank you" in support_incident_title field

in support_tickets table with "We have recieved your feedback and we will get back to you as soon as possible." in support_ticket_description field

if you notice, the text added in the new row is taken from the Session variable! but I really don't understand why it's adding new row and how it's taking Session's variable?!!

please help..............

Technology News @ http://www.JassimRahma.com

Hello,

I'm developing as ASP.NET web application and I use Crystal report for visual studio 2010, I installed it on my machine.
the application work correctly on my machine, but not like this on the server.
after I upload it to the server I fond this error

Could not load file or assembly 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

I searched for "log4net" more and I found more releases
I upload it ot my bin folder on the server, but the error changed to:

Could not load file or assembly 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

I didn't found any compatible assembly to my application,

I developed this web application into 32 bit OS, and I upload it to a server machine which use Window server 2008 R2 64 bit OS

is it has relation with the error?
and How can I correct that error?
at last where I can fount the compatible assembly log4net version 1.2.10.0?

thanks?

Sir;
I don't understand. Did you upload a diffident version of the assembly than the one you use it in development?

if so,, then just copy the one from you development machine assembly cache and upload it to the server.

Help people,so poeple can help you.

thanks fro your reply

My Application work on the local host without this assembly, but fire an error on the server, this error say:

Could not load file or assembly 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

I downloaded the assembly from the internet and upload it to the server, then another error say:

Could not load file or assembly 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

how can I solve this error and where I found the compatible assembly log4net version 1.2.10.0?

Man;
On your local machine the assembly 'log4net, Version=1.2.10.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' runs from the Global Assembly Cache[^].

You should copy it and upload it to the server.

Good Luck Smile | :)

Help people,so poeple can help you.

Many thank,

I will try it

I am going to develop application in ASP.NET MVC. I know there are no rich controls.

Could you please recommend me good controls for that (datagrid, calendar, scheduler, numeric textbox, etc.)?

Thanks in advance

Free no good

Free and good controls are the jquery ui controls Big Grin | :-D