Re: invoke batch file from server - Visual Basic Discussion Boards

Re: File Searching

Eytukan14-Apr-09 7:17

Eytukan

14-Apr-09 7:17

anandbpsri wrote:
VB 6.0

Actually, it would end in tears.No matter where.

Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy.

Re: File Searching [moved]

0x3c014-Apr-09 10:26

0x3c0

14-Apr-09 10:26

Look into System.IO.Directory.GetFiles. You'll need to look into the various file extensions, but this information is easily available elsewhere on the internet

Create new insatance of Visual Basic Class

Deepak the Cool14-Apr-09 1:33

Deepak the Cool

14-Apr-09 1:33

How to create the visual basic 6.0 class instance from c#?

Actually I add the one OCX file into my C#,Asp.Net application.

But when we create the instance of the visual basic class then it gives the error Class has no constructor defined.

Please help me about that.

Deepak

Smile a Lots,Its Costs Nothing

Re: Create new insatance of Visual Basic Class

Dave Kreskowiak14-Apr-09 5:32

Dave Kreskowiak

14-Apr-09 5:32

Is the .OCX registered on the machine?? You really can't have a COM component without at least an empty constructor, so I question the error you got.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

invoke batch file from server

p_196014-Apr-09 1:04

p_1960

14-Apr-09 1:04

Hi,
i have a batch file kept in webserver(IIS 6.0) under a virtualdirectory and when im trying to invoke batch file from client thru URL it"s not accessible..and it"s working fine when i place the bat file in IIS 5.0 server...

Please help me out...

Re: invoke batch file from server

Dave Kreskowiak14-Apr-09 5:24

Dave Kreskowiak

14-Apr-09 5:24

Are you saying that you want the batch file to run on the server and execute commands there or do you want the batch to be downloaded and executed on the client??

BTW, this question has nothing to do with VB.NET and should be asked in the ASP.NET Forum, where they normally handle Web Server based questions.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: invoke batch file from server

p_196014-Apr-09 6:23

p_1960

14-Apr-09 6:23

Thanks for ur reply.....ya i want the batch file to be downloaded and executed on the client from the server......

Re: invoke batch file from server

Dave Kreskowiak14-Apr-09 15:16

Dave Kreskowiak

14-Apr-09 15:16

The web server doesn't dictate how and if that will work. The web browser's security settings do. Without relaxing the default security settings, that won't work. Yo ucan download the file, you just can't launch it from code running in the browser.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: invoke batch file from server

nlarson1114-Apr-09 5:33

nlarson11

14-Apr-09 5:33

sounds dangerous but...your server Smile | :)

look for aspexec.dll this will allow you to execute exe's/batches/etc from an asp page.

'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous

'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous

Excel file does not close in task manager

Anoop Brijmohun13-Apr-09 23:11

Anoop Brijmohun

13-Apr-09 23:11

hi guys,

The code below works fine except when i open the windows task manager, i can still see EXCEL.EXE Running.
how do i close or exit it, should not objFso.Quit() Close Excel?

thanks

 Dim objFSO, ObjWb, ObjWs As New Object
 
 objFSO = CreateObject("Excel.Application")
 ObjWb = objFSO.Workbooks.Open("c:\myapp.xls")

 For Each ObjWs In ObjWb.Worksheets
   MsgBox(ObjWs.Name)
   Application.DoEvents()
 Next


objFso.Quit()

Re: Excel file does not close in task manager

ChandraRam13-Apr-09 23:26

ChandraRam

13-Apr-09 23:26

Since you have work books open, it would probably prevent Excel from closing.

Re: Excel file does not close in task manager

Anoop Brijmohun13-Apr-09 23:31

Anoop Brijmohun

13-Apr-09 23:31

well this seems to work....
i have added this after the worksheets loop...

ObjWb.close()
            releaseObject(ObjWs)
            ObjWs = Nothing
            releaseObject(ObjWb)
            ObjWb = Nothing
            releaseObject(objFSO)

            objFSO = Nothing

        Catch ex As Exception
            MsgBox(ex.Message, MsgBoxStyle.Critical)
        End Try
    End Sub
    Private Sub releaseObject(ByVal obj As Object)
        Try
            System.Runtime.InteropServices.Marshal.ReleaseComObject(obj)
            obj = Nothing
        Catch ex As Exception
            obj = Nothing
        Finally
            GC.Collect()
        End Try
    End Sub

Re: Excel file does not close in task manager

Ravi Kumar Tyagi13-Apr-09 23:31

Ravi Kumar Tyagi

13-Apr-09 23:31

You also have to dispose the object

Re: Excel file does not close in task manager

Pankaj-codeproject14-Apr-09 2:40

Pankaj-codeproject

14-Apr-09 2:40

close the workbook also,
excel.workbook.close

Report Footer:Line Size(CR)

C#Coudou13-Apr-09 22:29

C#Coudou

13-Apr-09 22:29

mates,

i don't know where to post this, its about crystal report in visual basic.net.

I have a problem of the line size on report footer.
It will not follow the size(10) when page is more than 1.

heres the image: page 1 should the same line with page 2.

http://i40.tinypic.com/6enlmq.jpg

thanks in advance.

C# コードMicrosoft End User
2000-2008

「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Re: Report Footer:Line Size(CR)

Anoop Brijmohun13-Apr-09 23:22

Anoop Brijmohun

13-Apr-09 23:22

Hi,

if i am not mistaken, i would say that you have a drop shadow on your grid.

the last line is the bottom of the grid.
that bottom line will only display once .i.e at the end of the report/data.

so when you have data for only one sheet, you actually see the bottom of the grid on the same page.
when there is more data than one page then the bottom line will be on the last page.

notice on your grid that when 2 pages then the last line on first page is same size as all the other lines.

thanks

Re: Report Footer:Line Size(CR)

C#Coudou14-Apr-09 13:59

C#Coudou

14-Apr-09 13:59

exactly. i have a line at the end of the report. that is why i put a line in a report footer. the page 2 is correct but page 1 the line doesnt show.
any suggestion, how will i add a line in every end of a report?

thanks mate.

Re: Report Footer:Line Size(CR)

Tom Deketelaere14-Apr-09 5:28

Tom Deketelaere

14-Apr-09 5:28

Print the report and check if its still there

I'v noticed that sometimes it will do this in preview but when printed it is the actual size.

Re: Report Footer:Line Size(CR)

C#Coudou14-Apr-09 14:02

C#Coudou

14-Apr-09 14:02

Tom Deketelaere wrote:
Print the report and check if its still there

yes i print that report but the same problem because i thought its only in preview. anyway, the problem is how will i add a line in every end of a report, any suggestion?

Re: Report Footer:Line Size(CR)

Tom Deketelaere14-Apr-09 20:56

Tom Deketelaere

14-Apr-09 20:56

Do you want a line on the end of every page or just at the end off the report.

At the end of every page: add a line to the section 'page footer'
At the end of the report: add a line to the section 'report footer'

Re: Report Footer:Line Size(CR)

C#Coudou15-Apr-09 13:37

C#Coudou

15-Apr-09 13:37

thank you for immediate reply.

Tom Deketelaere wrote:
At the end of every page: add a line to the section 'page footer'

I used this one but the problem is how can I show a line at the bottom of my detail section after the last record of the page? Depending on how many records, the line will need to appear at the end on each page to form a box around the detail output.

Re: Report Footer:Line Size(CR)

Tom Deketelaere15-Apr-09 20:55

Tom Deketelaere

15-Apr-09 20:55

You could try adding a new section

Or add the line to the page footer (on top)

I'm not that used to CR so can't really be specific.

Problem of Combobox

nazimghori13-Apr-09 21:09

nazimghori

13-Apr-09 21:09

hello every one

i am having problem of combobox my code is..
this code works in VB6 but in Vb.net how can i pass itemdata to particular text

cmbmonth.add("January")
cmbmonth.itemdata(0)=1

i m beginner..
so please help...

Re: Problem of Combobox

Dalek Dave13-Apr-09 23:41

Dalek Dave

13-Apr-09 23:41

I can see nothing particularly wrong with that, so long as you are using the correct capitals.

cmbmonth.ItemData (0) = 1

However we need to see more code, are you setting it up correctly? If nothing is set it will default the ItemData to -1.

------------------------------------

"I am always serious about what I do, not necessarily about how I do it."
Tom Baker

Re: Problem of Combobox

nazimghori14-Apr-09 0:54

nazimghori

14-Apr-09 0:54

I tried the same code u wrote it shows the error message like

'ItemData' is not member of 'System.windows.forms.combobox'

please suggest what to do with this error....

thank u in advance...
Smile | :)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.