Re: How to open a word document from C# application - C# Discussion Boards

Re: How to open a word document from C# application

20-Jul-10 0:27

Hi,
I am not getting any error.I just want to open a file in the same application and now my problem is solved using this
String new_FileName = Path.ChangeExtension(Path.GetTempFileName(), "txt");
File.WriteAllBytes(new_FileName, result);
System.Diagnostics.Process.Start(new_FileName);

But now i getting junk values for doc data. Frown | :(

Luc Pattyn20-Jul-10 0:43

Re: How to open a word document from C# application

20-Jul-10 0:43

why would you change the extension? if it is a Word document, NotePad will not be able to open it properly.

The normal thing to do is to use two database fields: one for the filename (including extension!), one for the binary data (the actual file content).

Confused | :confused:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

seeism20-Jul-10 0:49

Re: How to open a word document from C# application

20-Jul-10 0:49

Soory i pasted the code for txt here.I put it as doc while opening the doc file.For doc file it is coming junk data.For txt first char is printing
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable());
dt.Load(dr);
result = (Byte[])dt.Rows[0]["File_Doc"];

when i check this result array it is contiaing the first byte value and all others r zero
Why so

Luc Pattyn20-Jul-10 1:12

Re: How to open a word document from C# application

20-Jul-10 1:12

use your database management tool to check the content of the field, and determine whether the problem is in storing or in retrieving the data.

BTW: you don't need a DataReader, a simple ExecuteScalar could suffice, see here e.g.: Save An Image Into SQL Server 2000 Database[^]

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

seeism20-Jul-10 1:25

Re: How to open a word document from C# application

20-Jul-10 1:25

I am not much familiar with sql server.How to view the binary data in sql server.
??

seeism20-Jul-10 19:00

Error Getting Processor Id

20-Jul-10 19:00

Hey
my probs was solved.oops that was a mistake in the stored proc where i didn mentioned the size of binary data.SO only one data was storing Smile | :)

thanks a lot for ur help.

PDTUM19-Jul-10 13:44

PDTUM

19-Jul-10 13:44

Gentleman,

I wrote an application that needs to get the Processor ID from the OS. I have been using it exactly as designed below for the last several years on Win XP and Vista. A recent user of this app reported to me that he is getting an error that would indicate that the Processor Id is not being returned as designed. Now, the only difference that I know of is that he is using Windows 7. Question: is there any reason why the Management Class call that I have here will not work on Win 7?...or should I look for a different problem elsewhere? Thank you in advance...Pat

public string GetProcId()
        {
            ManagementClass mc = new ManagementClass("Win32_Processor");
            ManagementObjectCollection moc = mc.GetInstances();
            foreach (ManagementObject mo in moc)
            {
                if (cpuSerial == string.Empty || cpuSerial == null)
                {
                    // only return cpuSerial from first CPU
                    cpuSerial = mo.Properties["ProcessorId"].Value.ToString();
                    cpuSerial = cpuSerial.ToUpper().Trim();
                }
            }
            return cpuSerial;
        }

Re: Error Getting Processor Id

Luc Pattyn19-Jul-10 14:20

Re: Error Getting Processor Id

19-Jul-10 14:20

I've never seen code like that; the normal way to interact with Win32_Processor seems to be like this one[^], which works fine for me on XP and Vista.

Probably your Win7 is 64-bit and your code somehow isn't compatible with that, whereas the alternative probably is (can't test right now).

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

PDTUM19-Jul-10 16:50

PDTUM

19-Jul-10 16:50

Thank you for your reply, Luc. As is often the case, there is more than one way to get from here to there. I have been using this exact snippet since at least 2004 and with series 2.0, 3.0, and 3.5 framework...it has always worked in the past and I can find similar examples on the net as well. I have personally tested it on XP, Vista, and 2003 Server and it works fine. This is the first time this has happened, but I until I know why, I have to stop distribution of the program. You have a nice idea re: the Bit version, so I checked it out and this guy is using XP Pro 32 bit, so that lets that idea out. I appreciate your input though, and if you come up with another idea, I'm certainly listening...
Best Regards, Pat

node hottracking

xilefxilef19-Jul-10 12:39

xilefxilef

19-Jul-10 12:39

I have a treeview with ownerdrawn nodes. I also set an invividual indent value for each node, so each node has new bounds. The problem occurs on mouseover, hottracking is not triggered when mousing over the the last portion of the node - portion that equals to the length of the indent. Is there a way to set the mouseover bounds or maybe catch the event that triggers hottracking and force hottracking when mousing over the new bounds?

pass resource name as variable

Jassim Rahma19-Jul-10 12:21

Jassim Rahma

19-Jul-10 12:21

I usually read the resource using Properties.Resource.my_resource_name

But I want to pass the name from a variable, something like this:

String var_name = "my_resource_name"

How can I do that?

Thx

Re: pass resource name as variable

Luc Pattyn19-Jul-10 12:40

Creating a function using Dictionary and Datetime help??

19-Jul-10 12:40

I don't know the full answer, here are some bits and pieces though:

	string[] sa=assembly.GetManifestResourceNames();
	foreach (string s in sa) log(s);
...
	Bitmap bitmap=new Bitmap(type, resourceName);
...
	Icon icon=new Icon(type, resourceName);
...
	public static void PlaySound(Type type, string resourceName) {
		try {
			// inspired by http://www.bobpowell.net/playsnd.htm
			resourceName=type.Namespace+".resources."+resourceName;
			Stream stream=type.Assembly.GetManifestResourceStream(resourceName);
			int len=(int)stream.Length;
			byte[] buf=new byte[len];
			stream.Read(buf, 0, len);
			GCHandle handle=GCHandle.Alloc(buf);
			IntPtr ptr=Marshal.UnsafeAddrOfPinnedArrayElement(buf, 0);
			int res=sndPlaySound(ptr, 4);	// SND_MEMORY
			handle.Free();
			env.log(env.TRACE, "Played sound "+resourceName);
		} catch (Exception e) {
			env.error(resourceName+" failed: "+e.Message);
		}
	}

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

roman_s19-Jul-10 9:25

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 9:25

I am first getting a list of strings from files that have dates in them ex. fileabc_20100612_1020.txt in a certain directory(expression S.ImportFolder)

my objective is to get a list of these dates in from a folder. My problem is that there will be some files with same dates in this case I want to select the newest one for that date like closest to 23:59 of that Date.

for example in c:\Temp there is

fileabc_20100612_1020.txt
fileabc_20100613_1020.txt
fileabc_20100614_1020.txt
fileabc_20100614_2320.txt

I would want to only import

fileabc_20100612_1020.txt
fileabc_20100613_1020.txt
fileabc_20100614_2320.txt

or exclude
fileabc_20100614_1020.txt

            string[] fileEntries = Directory.GetFiles(S.ImportFolder);
            foreach (string fileNameWithRoot in fileEntries)
            {
                string fileName = System.IO.Path.GetFileName(fileNameWithRoot);
....String manipulation.....
                DateTime dtFileName = new DateTime();
            try
                {
                    DateTime dtFileName = Convert.ToDateTime(fileName); 
                }
                catch (Exception e)
                {
                }

                dicFiles.Add(dtFileName, fileName);

Luc Pattyn19-Jul-10 9:36

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 9:36

I don't see a problem, except for choosing one of many possible ways to get there. Here are some ideas:

1.
your filename convention is such that sorting them alphabetically also sorts them chronologically, that makes things easy. Start by sorting them alphabetically; if you think they already are, that is only true sometimes, it depends on the file system (NTFS versus FAT).

2.
you can convert a datetime string to a DateTime using DateTime.ParseExact() or DateTime.TryParseExact(). Works much better than any Convert method. But you don't have to. See below.

3.
when scanning the files chronologically, you're only interested in the last one of each date, so compare the date (or the first 16 characters, or all but the last 8 characters) of two consecutive names, when equal do nothing, when different, keep the oldest one. Make sure to also keep the very last file.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

roman_s19-Jul-10 9:47

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 9:47

I am importing another system's files therefor I do cannot change the file naming convention

so Im thinking of parsing the file into: datetime, full name

How can I compare the each record against each other with the first 8 digits for example 20100719 and if it finds another string node with 20100719 to then look at the substring/node which would be the next 6 digits after the date.
then delete the record that is not the most current for that date.

Thanks in advance

Luc Pattyn19-Jul-10 9:58

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 9:58

o0romeo0o wrote:
I do cannot change the file naming convention

I never suggested you change it; I said to take advantage of it.

I suggest you reread by earlier reply. it is all in there.

o0romeo0o wrote:
How can I compare the each record against each other

There is no need to do that; just sort the array as I said before.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

roman_s19-Jul-10 10:52

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 10:52

Thank you for your reply

I don't need the for example the last 4 latest records in the array... as I can have several days and the oldest date has 3 times it was altered creating 3 different files for that day... I would need the newest one.

Luc Pattyn19-Jul-10 11:22

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 11:22

I did read and understand your original post.
I'm not so sure you did read and understand any of my replies so far.
Anyway I have added yet another reply with the full code, albeit untested.
For me the subject is closed.

Hmmm | :|

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

DaveyM6919-Jul-10 10:02

DaveyM69

19-Jul-10 10:02

If the filename will always be in the format

name_yyyyMMdd_HHmm.extension

then you could use something like this (needs some [alot of] optimization but works). You can now implement a custom comparer to compare by name and if eqaul, compare by date.

// string wrapper for filename format 'name_yyyyMMdd_HHmm.ext'
public class MyFileData
{
    private string fullname;

    public MyFileData(string fullname)
    {
        this.fullname = fullname;
    }

    public string Fullname
    {
        get { return fullname; }
    }
    public string Name
    {
        get { return fullname.Substring(0, fullname.IndexOf('_')); }
    }
    public DateTime DateTime
    {
        get { return DateTime.ParseExact(fullname.Substring(fullname.IndexOf('_') + 1, 13), "yyyyMMdd_HHmm", CultureInfo.InvariantCulture); }
    }
    public string Extension
    {
        get { return fullname.Substring(fullname.IndexOf(".") + 1); }
    }
}

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Creating a function using Dictionary and Datetime help??

roman_s19-Jul-10 10:46

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 10:46

So I created a dictionary DICTIONARY1

dicFilesDT.Add(dateParts[1], (dateParts[1] + dateParts[2] ));

so that I would have just the:

KEY as the Date and
VALUE as the Date+Time

I need help in making another dictionary (DICTIONARY2) that would

1. If there are no Duplicates from checking DICTIONARY2 using foreach keyvaluepair in DICTIONARY1 add Key Pair to DICTIONARY2

2. Check for duplicates of the Key (Date) (thinking ex. dictionary.ContainsKey)

if the dictionary has the KEY then
Compare the KEY VALUE from DICTIONARY 1 to DICTIONARY 2 to see which one is larger

ex. 230132 compared to 100425

if DICTIONARY1 KEY VALUE is larger Delete KeyValuePair from DICTIONARY 2 and add DICTIONARY 1 KEY VALUE

else do nothing and continue the loop

Thank you folks for helping me wiht this.

Luc Pattyn19-Jul-10 11:15

Re: Creating a function using Dictionary and Datetime help??

19-Jul-10 11:15

You're making it all way too complex. Here is what I would do (untested!):

string[] files = Directory.GetFiles(S.ImportFolder);
Array.Sort(files);
int count=files.Length;
for(int i=1; i<=count; i++) {
    string curr=files[i-1];
    string next="_the_end_";
    if (i<count) next=files[i];
    if (strcmp(curr.Substring(0,curr.LastIndexOf('_')), next.Substring(0,next.LastIndexOf('_'))!=0) {
        // process or store curr as it is the last one of this date
    }
}

Some nasty trick was used to make sure the last file is also included.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

roman_s20-Jul-10 3:35

Re: Creating a function using Dictionary and Datetime help??

20-Jul-10 3:35

Hi Luc,

I tried the above code, just trying to debug the last line
if (strcmp(curr.Substring(0,curr.LastIndexOf('_')), next.Substring(0,next.LastIndexOf('_'))!=0) {

strcmp is a c++ concept, is that similiar to StringComparer?

also my ide complains !=0 that it cannot be applied to an int and a string. Tried playing around with the brackets and to no function.

let me know what I can do.

Luc Pattyn20-Jul-10 4:22