Developers 42

Hi Jonathan, Thank you for the quick response. I...

2012-04-05T05:55:13.759-07:00

Hi Jonathan,

Thank you for the quick response.

I used your code and _endOfHeaderPosition field gives me 85 for word(".doc") files. I use this 85 to strip OLE header and footer. So it works great with doc files.
----------------------------------------
The _endOfHeaderPosition field gives me 68 for simple Text(".txt") files. But still even after stripping off content from both ends of the file, I get lot of junk characters at the bottom of the file and few junk characters at the beginning like-

LICENSE-ANTLR-2 7 5.txt C:\WINDOWS\system32\SHELL32.dll E \\insidecontent1\ThirdPartyDatabase\THIRDP~1\ANTLR2~1.5\LICENS~1.TXT ®

I have noticed that after "~1.TXT"(6 characters), there is always extra 5 characters before the start of actual file content. So I use this pattern to strip extra OLE content before the file content.

At the bottom of the file content, the Extra OLE content starts with a pattern like-

METAFILEPICT

Even though I am not able to capture other junk characters, I get the index of "METAFILEPICT", and then strip of the extra OLE junk characters from the bottom.

Is there a better way for doing it? Will I get into any problem by stripping of the OLE content as I am doing now?

Hi Sunil, First of all thanks for your extensive ...

2012-04-04T23:35:32.586-07:00

Hi Sunil,

First of all thanks for your extensive comment with some nice additions to the blog post.
In order to find out the length of an ole header, you could simply use the class that is explained and downloadable in the second post of this series. You can find it here.

Once you execute the ReadHeader method in that class, the _endOfHeaderPosition field contains the position after the header was written (which should be the number you're looking for).

HTH.

Jonathan

I am accessing an Ms Access database through C#. I...

2012-04-04T07:38:10.438-07:00

I am accessing an Ms Access database through C#. I am able to read all the fields. The problem that I am getting is, while reading ".txt" and ".doc" files that are stored in OLE Object field of the table, a lot of extra junk characters are also getting read before and after the actual text.

I found the solution for word documents (.doc files). For word documents, "Extra OLE Content Length" that gets added while retrieving through query is 85 bytes. So I strip 85 bytes from both ends of the byte array like I did in below sample code-
------------------
Con.Open();
string _query="select licenseDoc from Products where ID=56";
//Column licenseDoc contains word and text douments as OLE Objects
OleDbCommand Cmd = new OleDbCommand(_query, Con);

const int offset =85;
var oleBytes = (Byte[])Cmd.ExecuteScalar();
MemoryStream ms = new MemoryStream();
ms.Write(oleBytes, offset, oleBytes.Length - offset);

var filePath = Path.GetTempFileName();
using (var fileStream = File.OpenWrite(file))
{
var buffer = ms.GetBuffer();
fileStream.Write(buffer, 0, (int)ms.Length);
}
----------------
The variable "filePath" will contain the path of the .tmp file, which contains the data read from from the word document stored as an OLE object in Ms Access. This file can be directly opened in as a word document or it's extension can be changed .doc.

The "Extra OLE Content Length" for other formats are as follows:

1] JPEG/JPG=224
2] BMP=78
3] PDF=85
4] SNP=74
5] DOC=85

I don't know the "Extra OLE Content Length" of .txt(Simple Text) files stored in Access. Any idea what it could be?

It works. :)

2012-03-27T03:22:58.738-07:00

It works. :)

In fact, due to all kinds of set backs and delays ...

2012-01-25T23:31:36.912-08:00

In fact, due to all kinds of set backs and delays we have only just started this project up again. This also led to a new look at what we actually want and we may very well end up not going ahead with MVC after all.

Hi, My company have also being building a business...

2012-01-22T00:41:38.549-08:00

Hi, My company have also being building a business application in sliverlight 4 since april 2010, we are launching into the healthcare market and with the IPad explosion we are a bit left out in the cold with technology that neither works on ipads or android tablets. How is your transition to MVC currenlty going, i am assessing technology to replace the current UI and keep the backend in place

colin

Hi lg, Thanks for your question. I looked into th...

2011-07-21T00:12:13.592-07:00

Hi lg,

Thanks for your question. I looked into that. Unfortunately you can't get an event for that by default.
You may have some luck with deriving from either the DataGrid class or the DataGridColumn class. That last one seems like a problematic approach as you would end up rendering the standard derived classes from DataGridColumn useless for your application.
Another approach may be to look into using a third party data grid (there is a free one from DevExpress), but I'm not sure if any of them supports this feature.

Greets,
Jonathan

Do you have any suggestion how to get a event when...

2011-07-20T06:39:04.800-07:00

Do you have any suggestion how to get a event when the user changes the Width on a column.
//lg

Hi Dave, You can use the Resources.Add method for...

2011-03-16T00:27:24.047-07:00

Hi Dave,

You can use the Resources.Add method for this. You simply pass in a key and and instance of your value converter. It would look something like this:

Resources.Add("myValueConverter", new SomeValueConverter());

HTH.
Jonathan

Hi Jonathan, You're post really helped me out...

2011-03-15T10:50:51.315-07:00

Hi Jonathan,

You're post really helped me out as I was having the same problem. Thanks so much! Now you mentioned in your post that:

"If you need to load other resources besides the localized strings, you should do so from code, by adding them to the Resources instance."

I actually have Value Converters that need to be used in the DataGrid and they are currently being loaded as a resource in the XAML file. How would I go about loading this resource in the code?

Thanks.

Dave.

Thanks, Myles. That's a very useful addition. ...

2011-03-04T06:18:45.047-08:00

Thanks, Myles. That's a very useful addition.

Greets,
Jonathan

Your code produces some unexpected results. You n...

2011-03-04T01:42:26.847-08:00

Your code produces some unexpected results. You need to sort the List by DisplayIndex before you load the settings e.g:

foreach (ColumnSetting setting in settings.OrderBy(i=>i.DisplayIndex))
{
var column = allRequestsDataGrid.Columns[setting.Index];
column.DisplayIndex = setting.DisplayIndex;
column.Width = new DataGridLength(setting.Width);
}

Hi, As I stated earlier, I don't have this so...

2011-02-27T23:29:49.274-08:00

Hi,

As I stated earlier, I don't have this source available anymore. However, I'm convinced it has to be a TextBlock, declared in the XAML.

HTH.
Greets,
Jonathan

Hi, what's 'innerTextBlock'. This isn&...

2011-02-27T18:57:46.847-08:00

Hi, what's 'innerTextBlock'. This isn't declared anywhere.

Hi Ian, Thanks for your question. It's not so...

2010-11-04T03:28:34.669-07:00

Hi Ian,

Thanks for your question. It's not so much that there would be anyone saying there will not be a Silverlight 5. It's more that I hear a lot of people who interpreted all the chatter as that Microsoft will no longer target the browser with new Silverlight versions.
The point I was trying to make, is that I don't understand why people are so angry, because they can just keep using Silverlight as they were before and Microsoft will keep supporting and investing in Silverlight for the browser.

Greets,
Jonathan

I read a lot of reports and tweets around the PDC ...

2010-11-04T02:43:40.439-07:00

I read a lot of reports and tweets around the PDC Silverlight debacle, but even with all the heat and anger I don't think I read a single one saying that there would not be a Silverlight 5. What makes you think that "people are scared into believing there will not be a Silverlight 5"?

Thanks, Herman. Your comments are always greatly ...

2010-10-19T23:19:55.758-07:00

Thanks, Herman.
Your comments are always greatly appreciated.

Greets,
Jonathan

Hi Jonathan, As an colleague and a daily follower ...

2010-10-19T13:27:25.665-07:00

Hi Jonathan,
As an colleague and a daily follower of your discovery journey in world of Silverlight. I can say you are now an experienced traveler. In know you are followed and your advice (and lessons) are appreciated inside our company. I ‘am sure the readers of your blog will feel the same.
Keep on blogging.

Herman, Product Manager

Hi harsha, Thanks for your comment. Unfortunately...

2010-09-21T06:31:21.244-07:00

Hi harsha,

Thanks for your comment. Unfortunately I do no longer have this source available. Is there any other way I can help you out?

Greets,
Jonathan

hi, this post is very good and i have same requir...

2010-09-13T05:51:28.092-07:00

hi,

this post is very good and i have same requirement.
i have been working on this from past 2 days but i am not able to get.
as i am new to silvrlight can u please upload sample project.

thank you

hey can u please attach source code.

2010-09-09T02:21:08.323-07:00

hey can u please attach source code.

Hi Micheal, Thanks for commenting. I am aware of ...

2010-08-22T23:09:33.172-07:00

Hi Micheal,

Thanks for commenting. I am aware of the extensibility of LightSwitch and I do mention it in the article. However I feel that using a framework like this can become a problem when building complex LOB applications as in the end the application tends to get formed towards the framework instead of the framework being formed towards the application.

I'll be following your blog with interest.

Greets,
Jonathan

LightSwitch comes with a lot of extensibility. It ...

2010-08-21T18:27:46.334-07:00

LightSwitch comes with a lot of extensibility. It is much like DotNetNuke. It has an API that has allowed me to build a lot of massively large sites.

LightSwitch allows you to create Custom Silverlight Controls. This is the big extensibility point that will allow you to "contact the mainframe payroll system and update the LightSwitch application".

I will blog on this and post code to my site at: http://lightswitch.adefwebserver.com

Hi greg-joyal, Thanks for that helpful comment. I...

2010-07-29T23:27:03.866-07:00

Hi greg-joyal,

Thanks for that helpful comment. I realize it would be useful to post the actual resulting connection string. To make sure it is readable I chanegd the post.

Greets,
Jonathan

I think we may have this problem .. would it be po...

2010-07-29T20:40:28.129-07:00

I think we may have this problem .. would it be possible to post what the Metadata part of connection string ended up looking like? Did you use syntax similar to the Adventure Works example? Or did you fully qualify the assembly name? So many questions!