|
when I try to open a office word file with c# in website, everything is working fine on my local machine. However when I upload the files to hosting server I receive an error like:
"Could not load file or assembly 'office, Version=12.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c' or one of its dependencies.
The system cannot find the file specified".
I have learned that hosting server machine hasn't installed office version because of licence an security reasons.
How can I solve this problem ?maybe can I reference a dll file on client machine to open the word document with c# code or .. please help me about it.
|
|
|
|
|
a.ergin wrote: How can I solve this problem ?m
Try to place the assembly 'office, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' on the server. Don't install office, just copy the assembly from your local system on the server and see.
a.ergin wrote: can I reference a dll file on client machine to open the word document with c# code
You need to place the assembly where the code runs. If it's a desktop app, provide assembly on system where it runs.
|
|
|
|
|
actually, at first there had been a problem with the web.config file and web project never starts. Then, I had put the file
Microsoft.Office.Interop.Word.dll
in to the bin folder(inside my project) and my application starts however when I navigate through to the page and hit the button which runs the code to open word file. I had received errorlines could not load file or... I had post in my previous posted massage.
I have tried to put some other dll files in bin folder but it did not work.. please help me about this problem..
|
|
|
|
|
|
Yes button event handler in the codebehind file works on the server side.
the solution that you have sent including the third one usefull for me.
thanks alot
|
|
|
|
|
i am making a browser window application in c# using webcontrol.
is there a way that i can specify the save location, by default it picks the IE's default save location
|
|
|
|
|
Hi,
This is Tushar . I want to develop Expense Management tool as a Mini Project in C# language using ASP.Net Technology(Windows Forms).
So,can anyone help me to find any idea and source code for given Project?
Thanks,
Tushar
|
|
|
|
|
Tushar Urade wrote: in C# language using ASP.Net Technology(Windows Forms).
The first thing you need to do is decide on your platform: do you want to use ASP.NET or Windows Forms? You cannot do it both ways at the same time. As for source code, there are hundreds of samples in the CodeProject articles section[^].
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
To add to what Richard said, there is another problem with your request:
Tushar Urade wrote: I want to develop Expense Management tool
Is incompatible with:
Tushar Urade wrote: find any idea and source code for given Project
If we give you source code, you haven't developed it, have you?
If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.
|
|
|
|
|
Do a search in the articles section on this site - you might find something that is useful to you and might help you get started.
|
|
|
|
|
Hi,
After building my C# solution (using Visual Studio 2010), my debug folder (bin/debug) includes some assembly file (dll files, and .exe file).
Then I tried to use the obfuscator software (such as: Dotfuscator,..) to obfuscate my files successful. Then, I add these assembly file to my setup project, and build it to create setup package.
But, after installed my setup package, I tried to use decompiled softwares to check assembly files (in the installation folder), I still could see and get origin codes.
Do you know why ? How can I obfuscate my assembly file for setup package ?
Thank you for your help !
|
|
|
|
|
Hi,
I use this to change the back color of a cell:
private void dataGridViewData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (!string.IsNullOrEmpty(e.Value.ToString()))
{
e.CellStyle.BackColor = Color.LightGoldenrodYellow;
}
}
This works, but also check box cells are changed if they are checked or not.
How can I make an exception for check boxes, or is there an other way to do this?
The datagridview is set to autogenerateColumns = true.
Groover,
0200 A9 23
0202 8D 01 80
0205 00
|
|
|
|
|
One way to distinguish columns is to check the ColumnIndex property of the DataGridViewCellFormattingEventArgs object.
For example you can access the actual column being formatted using
dataGridViewData.Columns[e.ColumnIndex]
For more info, refer to DataGridViewCellFormattingEventArgs[^]
|
|
|
|
|
Hi,
I've already been there, but I wanted something simple.
Have it working now, this is what I use:
private void dataGridViewData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
int x =e.ColumnIndex;
int y = e.RowIndex;
if (dataGridViewZakdata[x,y].GetType() == typeof(DataGridViewTextBoxCell))
{
if (!string.IsNullOrEmpty(e.Value.ToString()))
{
e.CellStyle.BackColor = Color.LightGoldenrodYellow;
}
}
}
Thank You for your efford,
Groover,
0200 A9 23
0202 8D 01 80
0205 00
|
|
|
|
|
You could test the DataGridViewCellFormattingEventArgs.DesiredType property. It will be typeof(string) for textbox cells and typeof(bool) for checkbox cells.
Alan.
|
|
|
|
|
Thanks Alan,
Now I have it for both types in two lines:
private void dataGridViewData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if(e.DesiredType==typeof(string) && (!string.IsNullOrEmpty(e.Value.ToString())))
e.CellStyle.BackColor = Color.LightGoldenrodYellow;
if(e.DesiredType==typeof(bool)&&((Convert.ToBoolean(e.Value) == true)))
e.CellStyle.BackColor = Color.LightGoldenrodYellow;
}
Edited: I did not test it thorough, if I insert a new row in database I get an exception:
if(e.DesiredType==typeof(bool)&&((Convert.ToBoolean(e.Value) == true)))
Object cannot be cast from DBNull to other types.
Groover,
0200 A9 23
0202 8D 01 80
0205 00
|
|
|
|
|
My goal is to parse out a company name and contact name that is the actual filename of the excel spreadsheet.
I will use this information in a sql server 2008 r2 database to obtain other related information for the company and contact person.
My problem is the file name is manually keyed in my the user who runs the sql server 2008 r2 reports (ssrs) on the standard edition.
Is there away you would suggest that I try to parse out the company and contact name from the file name? There are delimiters between the company and contact names how the delimiters may change.
(Note: I am intending on using this method instead of opening up the excel spreadsheet to
obtain the information I am looking for. I think that there would be alot of C#.net code that is required to open the excel spreadsheet and get the data I am looking for in certain rows and columns. If obtaining the code from an excel spreadsheet is not so bad, can you show me the code on how to accomplish this goal?)
Can you show me in code and/or point me to a reference on how to accomplish my goal?
|
|
|
|
|
You need to provide more detail, such as what the filenames look like, and what the delimiters could be.
|
|
|
|
|
Easiest way will be either to use string.Split on the file name (if the delimiters are sensible) or a Regex:
For example, if the file name was "2012-12-31 Oranges (Jaffa Co, John Smith).xlxs" The I would use a regex:
(\((?<Company>.*?),(?<Contact>.*?)\)) Would match it and extract the company and contact as separate fields.
If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.
|
|
|
|
|
The file name would look like the following:
C:\\app1\12_2012\customer name_contact name.xls.
The part of the file name I listed above is the following:
customer name_contact name.xls.
The customer name can contain all kinds of special characters like (,),'. Thus I need to be able to parse out the customer name with all the special characters.
Note: It is my idea to have an underscore between customer name and contact name for the following reasons:
1. I need some kind of a delimiter,
2. I do not think alot of people's name have an 'underscore' as part of the name.
3. The underscore is a valid character for a filename.
Note: these names may like like the following if it is entered incorrectly by a user:
customer name _ contact name.xls.
Thus can you tell me how you would parse out the names in that case?
|
|
|
|
|
Try:
<pure lang="c#">
string inp = Path.GetFilenameWithoutExtension(path);
string[] parts = inp.Split('_');
parts[0] is the company,
parts[1] is the contact.
If you get an email telling you that you can catch Swine Flu from tinned pork then just delete it. It's Spam.
|
|
|
|
|
|
Hello,
I have a .props(Project Property File), which is currently executed using a bat program(?Windows Batch File).
I want to rewrite this using Asp.Net.
How do you call a props file in ASP.NET, console application?
This is just one part of the program, which is being completely re-written in asp.net from asp.
Thanks!!
|
|
|
|
|
The same way you execute a batch-file, using the Process class.
|
|
|
|
|
Thank you!
Kind of new to asp.net.
Do you know where I could a list of all the classes avaliable in .Net?
Thanks again!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
