Visual Basic

Filename of LastWriteTime

27-Dec-06 13:01

If the code that is executing is loaded from a non-local source (a media that is not physically attached to the local machine) it is not trusted. It doesn't matter what your using the code for.

If the code is run ON the server (not from it) then it gets as much trust as the user who launched it. If it's run FROM the server (the code is loaded from a network share, or other remote source, and is running on a local workstation) it doesn't matter who launched the code, it's running in a restricted sandbox.

Dave Kreskowiak
Microsoft MVP - Visual Basic

VK-Cadec27-Dec-06 3:44

VK-Cadec

27-Dec-06 3:44

Hi - I am trying to get the filename of the last written file in a directory. Any ideas why this code doesn''t work?

        Dim _direct As DirectoryInfo<br />
        Dim _strLastfileName, _strDirectpath As String<br />
<br />
        _strDirectpath = txtExportPath.Text ' path to directory<br />
        _direct = New DirectoryInfo(_strDirectpath)<br />
        _strLastfileName = New FileInfo(_direct.LastWriteTime).Name.ToString

Re: Filename of LastWriteTime

Dave Kreskowiak27-Dec-06 4:53

resize of column width in MSFlex grid

27-Dec-06 4:53

The only way to know which file was written to last is to get the LastAccess time for every file in the folder, sort the list and get the filename off the top of the sorted list.

The LastWriteTime of the Directory is a change in the directory entries for that folder, not the last write to a file in that directory.

Also, The FileInfo class constructor takes a filename as a string as an argument. You're supplying a DateTime object (_direct.LastWriteTime) as the argument, which won't work.

Dave Kreskowiak
Microsoft MVP - Visual Basic

pdeep27-Dec-06 2:39

pdeep

27-Dec-06 2:39

I am doing a VB application,used MSFlex grid control to display the data from the table. column header text and cell values of a column are truncating(not visible fully), user manually needs to be draged everytime when it was loaded. Any idea how to fix the column width of flex grid.

Thanks in Advance
Bye
Pradeep

PradeepG

Re: resize of column width in MSFlex grid

ChandraRam27-Dec-06 2:58

ChandraRam

27-Dec-06 2:58

pdeep wrote:
I am doing a VB application,used MSFlex grid control to display the data from the table. column header text and cell values of a column are truncating(not visible fully),

I do believe that there is a property ColWidth that you can set for each of your columns.

pdeep wrote:
user manually needs to be draged

How to measure two points on a foto?

Zero-G.27-Dec-06 1:56

Zero-G.

27-Dec-06 1:56

Hey NG

I want to mease some points of an foto from a digital camera, like you can see http://www.prisma-computer.de/optik/software/augenoptik/foto-pupillometer.html[^] here.

Does anyone know, how to do things like that? - Is there anywhere a tut? - I do work in VB2005

THX!

Dave Kreskowiak27-Dec-06 5:22

27-Dec-06 5:22

In order to measure the distance between two points on a plane, you need, at a minimum, one of three things:

1) A calibration of a known distance between two points in the photo on the same plane as the subject being measured. An example would be a scaled ruler or some other measurement.

2) The focal length of the lens used to take the photo.

3) The distance between the film plane in the camera and the target objects in the photo.

From there, it's a matter of some trigonometry to get the distance between any two points on the same plane in the photo.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Zero-G.27-Dec-06 21:58

Zero-G.

27-Dec-06 21:58

Hey
Thanks for the fast answer.

1) - This 3 points are no problem.

But

1) How Do I get the two pupils? - So that I I can't take a foto of a bottle or something?
2) How can I take the outermost points of the frame automatic, so that the user only has to insert the value for this points?

Is there any sample, where I can take a look (Written in VB?)

THX

Dave Kreskowiak28-Dec-06 2:59

28-Dec-06 2:59

Now your getting into an area that I don't do. Image recognition is not part of my background at all. This is goign to take some SERIOUS research to find those pupils.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Zero-G.28-Dec-06 3:10

Zero-G.

28-Dec-06 3:10

Hey

OK & when "we" don't control, if there are pupils or not. Do you know, where I can find some tuts?

THX!!

Dave Kreskowiak28-Dec-06 12:42

Protected Overrides Sub RefreshItems

28-Dec-06 12:42

Zero-G. wrote:
OK & when "we" don't control, if there are pupils or not

Zero-G. wrote:
Do you know, where I can find some tuts?

The same place I'd start. Google[^]

Dave Kreskowiak
Microsoft MVP - Visual Basic

DA_Loring27-Dec-06 1:02

DA_Loring

27-Dec-06 1:02

Hi All, I need to refresh a combobox list (in VB .net) when a new item as been added to the SQL database. Protected Overrides Sub RefreshItems seems to be the way to do it but I cannot find any example of how this is used. I am still trying to get to grips with .net!

I have a sub which calls a form so the user can add details of an item, and when it returns from the form (which inserts the item in the database) I need to update the list in the combo box.

I would be most grateful for any assistance

David Loring

Re: Protected Overrides Sub RefreshItems

Navneet Hegde27-Dec-06 2:50

Navneet Hegde

27-Dec-06 2:50

Dear Its Actually refreshing the whole combobox and this snippet sub works as complete redraw of combobox .Better go for regular properties rather than overriding the class properties. For such if you really want to get proptected properties trhen you are welcome for such query till then try regular properties to get work done like clearing combo
Rose | [Rose]

sdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgbashdgfgajs fhgsdhgfjassdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgbashdgfgajs fhgsdhgfjassdfhkjadfhjhjksdhfkjahskjdf hkjahsjkdfhkjashkfakshkhaskghkhagkhadkhgkhgkhaskhsdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgbashdgfgajs fhgsdhgfjassdfu asgdfsgdfhagsdfhgajsdgfgasd hfasvcjbsvjvhgasjd jgsdfjas bdjfasdhfjavbs jvdfhasgdfhgba

System.Runtime.InteropServices.COMException

phonghihi27-Dec-06 0:32

phonghihi

27-Dec-06 0:32

I have an app to generate excel file using excel.dll.
Although after i finished the creating a excel file, i released excel COM.
But in the 10th excel file, it throws System.Runtime.InteropServices.COMException HRESULT exception.

Someone can help me? this is the urgent message.... Cry | :((

i love IT

Dave Kreskowiak27-Dec-06 4:43

27-Dec-06 4:43

What's the complete exception that's thrown? We're looking for the HRESULT number?

Did you call Quit on the Excel object before you released it?

Dave Kreskowiak
Microsoft MVP - Visual Basic

phonghihi27-Dec-06 15:21

phonghihi

27-Dec-06 15:21

Hi Dave Kreskowiak,

Thanks for replied me. I called Quit() before i released it. And i also used

System.Runtime.InteropServices.Marshal.ReleaseComObject(appExcel)<br />
<br />
            Dim proc As System.Diagnostics.Process<br />
            For Each proc In System.Diagnostics.Process.GetProcessesByName("EXCEL")<br />
                proc.Kill()<br />
            Next

to relase it. but it still throws exception: HRESULT:0x800A03EC

Cry | :((

i love IT

Dave Kreskowiak28-Dec-06 2:58

28-Dec-06 2:58

You should NOT be releasing the COM object yourself.

If you're creating multiple sheets in your code in one pass, are you creating multiple Excel application objects? Don't! Create one Excel application object and reuse it to create every sheet and workbook your need.

Another possibility is that your using the Excel Interop Assemblies for one version of Excel, say 2003, and your machine doesn't have Office 2003 installed, maybe you have Office 2000 or XP instead. If you're going to use the Interop Assemblies, you have to match the version of Office that's installed on the machine.

Dave Kreskowiak
Microsoft MVP - Visual Basic