|
No offense, but your master ( boss, I assume ) is an idiot. But you have been at this for some time and PIA (aka Office Interop Library) is best way to get the job done.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
But his only advice on how to do it, is to ask here ? Brilliant.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Christian Graus wrote: his only advice on how to do it, is to ask here ? Brilliant.
Yeah, what a brilliant "master" the OP has.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
hi
am not Genie!!!!!!! am just student from iraq want to learning and to be
and no way from ole structured storage to hiding data in microsoft word document 2003 file format
that's my story
|
|
|
|
|
Hello miss hacker would u b my friend we share our c# programs.
I'm a good programmer as well as a hacker.
BY
SAM
|
|
|
|
|
hi
yes we can. can u help me ?becouse am realy late in my project 
am now searching on the detalies of structure storage API like (StgsStorageFile) (StgOpenStorage)what the value of its parameters and how can i use it? i fnde just small things
THANks
Amani![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I am wondering if we can paste an image while a webbrowser control is set on a designMode='On'. like copy image from word and paste directly on webbrower. I know we can insert an image through execommand(Paste,false,false). The problem is that when i paste an image directly, i don't see an image it just shows an empty box on the browser. I Couldn't find much on this topic.
Any input is highly appreciated.
|
|
|
|
|
I read excel file using following code. This code properly work when columnName variable is not numeric value. If columnName varibale is numeric for example columnName = "1"; so I get IndexOutOfRangeException. Under the while loop, in this line myList.Add(dr[columnName].ToString());
//columnName is string parameter
string connectionString = "....."
List<string> myList = new List<string>();
DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
using (DbConnection connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString;
using (DbCommand command = connection.CreateCommand())
{
string sql = "SELECT " + columnName + " FROM [Test$]";
command.CommandText = sql;
connection.Open();
using (DbDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
myList.Add(dr[columnName].ToString());
}
dr.Close();
}
}
}
What can I do.
Best Regards...
|
|
|
|
|
If the name consists of digits, the SQL query that you create would look like this: "SELECT 1 FROM [Test$]". That would not get the data from the column "1", it would get the literal value 1.
Put brackets around the column name to specify that it's a name, not a value:
string sql = "SELECT [" + columnName + "] FROM [Test$]";
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Yeappp, now its work. Thanks a lot...
|
|
|
|
|
Hi,
Iam using WMI and Win32_printjob to all the printer queue jobs...Iam using file watcher to run my service when a new file is copied from a specified location.
If I keep some thread.sleep then all the size and page no. iam to note them.
But without using thread.sleep Iam unable to read the file size and no. of page..but the file is copied from printer spooler to my specified location.
Now I want to my filewatcher service to invoke my service after a file is fully copied...How to accomplish this?
Kindly help me
|
|
|
|
|
Hi,
I developed a windows service which will copy some files in to the local system folder and then to another system. Right now my system and another system are connected in LAN and have shared along with Read/write access. It Is working for me.....
Requirement:-
but now I need to copy the files from one system to another system which are not connected in the LAN and not have shared permissions...
Assumption:-
On my search I came to know this can be done by FTP.
If I have to use FTP the what I have to do..?
1.Is that I need a FTP client application seperately?
2.Is that I need a FTP server application seperately?
3.Only one app can cater all these requirements?
All these I have to in the Windows service
Kindly help me
Thanks for all advise and help
|
|
|
|
|
If your application needs to send a file to another PC , that seems similar to a Client uploading to a FTP Server . So you need to make your application client and the need to have FTP Sever on the Other PC.
You can also create a WebServcie for the PC you need to put the file.
just pass the file in the service parameter.
Vikas Amin
UNITED STATES STEEL CORPORATION
My First Article on CP" Virtual Serial Port "[^]
modified on Thursday, July 24, 2008 5:33 PM
|
|
|
|
|
hi vikas,
thanks for your help....
I have taken previously your help to solve my problem with printers and using WMI....
I need to guidence to do the FTP work
Iam very much thnakfull to you..
|
|
|
|
|
Hi guys, I want to write to a file but i am getting this weird error message. Only my application is using the path1. It Seems like file is being used by other process. I couldn't figure it out who is using which of my function is using the file.
using (StreamWriter sw = new StreamWriter(path1,false,Encoding.UTF8 ))
{
sw.WriteLine(""+doc.body.innerHTML+"");
sw.Flush();
sw.Close();
}
at System.IO._Error.WinIOError(Int32 errorCode,string maybeFullPath)
at System.IO.FileStream.Init(String path,FileMode mode,FileAccess access,Int32 rights,Boolean useRights,FileShare Share,Int32BufferSize,fileOptions options, SeCURITY_ATTRIBUTES secAttrs,String msgPath,Boolean bFromProxy)
|
|
|
|
|
netJP12L,
I don't think you need to call sw.Close() since it is in a using block. Though, i might be wrong!
Regards,
Gareth.
(FKA gareth111)
|
|
|
|
|
Are you allowed to write to the path? Do you have permissions, where are you trying to write to?
And, sw doesn't need to be closed, a using block will automatically call the Dipose method on an object that implements IDispose, StreamWriter does.
|
|
|
|
|
Yes, I do have permissions. I am creating folders, subfolders and file dynimacally and writing to the file. Even removing of sw.close or using statments doesn't help. Is there anyway i can find out which thread is using the file.
|
|
|
|
|
|
|
Thanks for answering guys, So far no lucky but what a funny thing i just noticed is that when i run the function to write to the file it throws exception related to file is being used by other process but when i run it again it actually writes ....what's going on I got no idea. Are my codes running faster than CPU ...;)
|
|
|
|
|
Hmm,
there may be several reasons.
Do you still have call to the Close-method in the end of using block. I suggest that you keep it.
Another thing. Check from your project properties / debug tab, is "Enable the Visual Studio hosting process" checked? If it is, what happens if you uncheck it and run the application again?
Mika
|
|
|
|
|
Exactly, you got the cure for my app problem.....before when i used to run my app in debug mode i was noticing this myapp.vshost.exe started...since i uncheck it works like charm.... Feel like i am on the safe planet....gonna giving u 5 
|
|
|
|
|
You're welcome 
Mika
|
|
|
|
|
I want to set the attrib of any file and folder using C#.NET button click event.
(As like in DOS: "attrib C:\test +S")
I want to run above DOS command with my C#.NET button click.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
