C# Discussion Boards - CodeProject

Crystal Reports and Windows Applications

ebonaba25-Aug-06 7:59

25-Aug-06 7:59

Hi, I was wondering if anyone can help me with my problem.

I have created a windows application (service). This service will run every day at 7am and it will generate a PDF (that was created in crystal reports) which will then be emailed to certain users.

My problem is, I want the PDF to only be generated to the output file folder. I do not want the PDF to be generated to the screen.

I know how to do this in a web application. I have tried using the same code in the windows application and it does not work. When in debug mode, when you hit the line reportDoc.Export();, the service will stop itself.

I have tried using the CrystalReportViewer as well but I get a prompt to enter a file name and to save to the hard drive.

Can anyone help me? Thanks.

// Get ReportDocument
ReportDocument reportDoc = new ReportDocument();
reportDoc.Load(rptPath + "rptDailyDriverExceptionReport.rpt");
string outputFile = "";

// Setup the export options
DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
outputFile = outPath + "DailyDriverExceptionReport_" + GetDateTimeString() + ".pdf";
diskOpts.DiskFileName = outputFile;
ExportOptions exportOpts = reportDoc.ExportOptions;
exportOpts.DestinationOptions = diskOpts;
exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;

//Update DB connection settings
TableLogOnInfo dbConn = reportDoc.Database.Tables[0].LogOnInfo;
dbConn.ConnectionInfo.DatabaseName = dbName;
dbConn.ConnectionInfo.ServerName = dbServer;
dbConn.ConnectionInfo.UserID = dbUserID;
dbConn.ConnectionInfo.Password = dbPassword;
reportDoc.Database.Tables[0].ApplyLogOnInfo(dbConn);

reportDoc.Export();

Eva

Printing to an Okidata printer

tigerButterfly25-Aug-06 7:52

tigerButterfly

25-Aug-06 7:52

Hello Everyone,

I need to print form data to an okidata printer. Anyone know how I can go about doing this? It's a track feed printer.

Thanks

"Unadvising" Event Sink in VB6

Ilia Blank25-Aug-06 7:46

Ilia Blank

25-Aug-06 7:46

I have COM object written in C# that exposes connection points and deployed as out of process server.
I wrote VB6 application that supplies handler for the events fired by this COM object.
To do that I added reference in my VB project to type library generated for C# COM.
Next I used WithEvents statement in my VB code to declare variable of the events firing type exported from the COM.

The application works fine. I can consume the events from the C# COM in my VB6 code.

Problem arises when I stop my VB application.
The delegate that implements the event in C# remains assigned and exception is thrown when attempt is made to call it.

When you implement Event Sink say in C++ you use Advise – Unadvise paradigm to assign and clean up your handlers.

What you supposed to do in VB6?

Any help will be appreciated.

Re: "Unadvising" Event Sink in VB6

Guffa25-Aug-06 8:54

Guffa

25-Aug-06 8:54

Please don't cross post.

---
b { font-weight: normal; }

Global DLL for all app components

drdavef25-Aug-06 7:35

drdavef

25-Aug-06 7:35

I would like to use a global DLL that could be called by any program in the app. In VB6, all I had to do is create a code module which inited the DLL variables, some of which come from the database. I am migrating this app with new features to C# and have been unsuccessful in getting my ALLINFO.DLL to be availabe. Can anyone help me with this?
Thanks

David

Re: Global DLL for all app components

Nader Elshehabi25-Aug-06 10:36

Nader Elshehabi

25-Aug-06 10:36

Hello

drdavef wrote:
called by any program in the app

What is a program?? What is an app??!! Unsure | :~

drdavef wrote:
and have been unsuccessful in getting my ALLINFO.DLL to be availabe

Why? What is your problem exactly??

In C# you make a new project for your dll, and in other projects in the solution, you make a reference by project to the dll -look for the project tab in the reference dialog-.

Regards Rose | [Rose]

Re: Global DLL for all app components

drdavef25-Aug-06 11:58

drdavef

25-Aug-06 11:58

What i mean by a program is an executable that will do a variety of tasks. When I say app, I mean the entire application, which consists of 15-25 programs and a number of DLLs.

I want a DLL, that I call AppInfo, which contains general info that all programs need access to, such as SchoolYear. The application is involved with schools and school services. One thing it tracks is the type of student involved in the school year, is the student a Senior, Undergrad, or Postgrad (college). This is a toggle that the user of a given program will select to determine functionality for each type of student. This AppInfo DLL also contains functions specific for client specifications. For example, a rounding function that always rounds to the next nickle (no pennies wanted Smile | :)

).

I am looking for a way to create this DLL such that initialization is very simple. I used to simply call the AppInfo.Init from Main to set it up. I have not found a way to create a DLL that is available to all program functions. A program may consist of many forms and support DLLs.
Thanks for any support

David

Re: Global DLL for all app components

Nader Elshehabi25-Aug-06 12:21

Nader Elshehabi

25-Aug-06 12:21

Hello

I've posted the way that is used to make dlls in C# in my previous post! Is that what you want?

drdavef wrote:
I want a DLL, that I call AppInfo, which contains general info that all programs need access to, such as SchoolYear

I thought SchoolYear should be stored as a variable, and since you are a programmer you know about scope. How would you store a variable in another module?!! Even in VB I don't think that's possible!!

drdavef wrote:
I am looking for a way to create this DLL such that initialization is very simple.

Well, I haven't worked much in VB, but I've spent a lot of time in C# and I've never heard of Dll init!! dlls are referenced, not intitialized, specially that you are writting these dlls. I have a feeling somehow I still don't get you!! Please forgive me for that Smile | :)

Another approach to store shared info in an executable is to make it as a win service. I don't think that's what you want, is it?!!

Anyway. The way I know it, you want dll it's simple. Make a dll project and reference to it in other projects. You want shared info, store them in a file -careful here for read/write operations- or use a database!!

If you managed to store variables in a dll, and share it with other programs, I beg you to write an article about it.I'll be dying to read it Big Grin | :-D

Regards

Crystal reports and SharpDevelop

Evy_Soza25-Aug-06 7:02

Evy_Soza

25-Aug-06 7:02

Hi,

I'm very new in programing, I create a report in Crystal reports and I want to call it from my project in sharp develop.

Somebody could me explain step by step what things I have to do?

I'm using sharp develop 2.0.0 Build 1591.

Thanks

use C# function in VB

VK-Cadec25-Aug-06 3:57

VK-Cadec

25-Aug-06 3:57

Hi,

We have a function which parses csv into datatables written in C#

Want to use this function in my VB.net code. How would we go about doing this? I tried using the function name nd it doesn't seem to work, it comes back with swiggly lines. using VS 2005.

thanks.

Re: use C# function in VB

Not Active25-Aug-06 4:08

Not Active

25-Aug-06 4:08

Your best bet would be to give up the whole VB.NET thing and go with C# Poke tongue | ;-P

If the function is in an assembly that you have included in your project, then you should be able to use it within you VB.NET code by instantiating an instance of the class and calling the function.

only two letters away from being an asset

Re: use C# function in VB

VK-Cadec25-Aug-06 5:49

VK-Cadec

25-Aug-06 5:49

we should be able to use either without issues - .cs and .vb

Re: use C# function in VB

Not Active25-Aug-06 6:04

Not Active

25-Aug-06 6:04

You can, but not the way you are trying.

only two letters away from being an asset

Re: use C# function in VB

Judah Gabriel Himango25-Aug-06 4:43

Judah Gabriel Himango

25-Aug-06 4:43

Just add a reference in your VB.NET project to the dll containing the C# function. In your VB.NET code, you'll can then call the C# function as if it were written in VB.NET.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Dumbest. Movie. Title. Evaaar.
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: use C# function in VB

VK-Cadec25-Aug-06 5:48

VK-Cadec

25-Aug-06 5:48

it is not a separate project. I am adding this .cs file into a vb.net project.

this .cs is reading a csv file and returning a datatable.

Thanks.

Re: use C# function in VB

Judah Gabriel Himango25-Aug-06 5:54

Judah Gabriel Himango

25-Aug-06 5:54

Sorry, that won't work. A project must be entirely in one language. If you need to use multiple languages, use multiple projects in a single solution.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Dumbest. Movie. Title. Evaaar.
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

Re: use C# function in VB

Dave Kreskowiak25-Aug-06 5:58

Dave Kreskowiak

25-Aug-06 5:58

That won't work; you have to create seperate projects. You cannot combine different languages in the same project. You can, however, combine projects of different languages in the same Solution. Your C# code would have to go into it's own Class Library project, then in your VB.NET project, add a reference to the C# project.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Search DLL before P/Invoke?

Dominik Reichl25-Aug-06 3:03

Dominik Reichl

25-Aug-06 3:03

Hello!

I'm trying to do some P/Invoke, but the native DLL is an optional component, i.e. it isn't sure that it is present.

How can I test if P/Invoke will be able to call the DLL?

Best regards
Dominik

_outp(0x64, 0xAD);
and
__asm mov al, 0xAD __asm out 0x64, al
do the same... but what do they do??
(doesn't work on NT)

Re: Search DLL before P/Invoke?

Jun Du25-Aug-06 4:27

Jun Du

25-Aug-06 4:27

Can you test the DLL's existence before calling DllImport()?

Best,
Jun

Re: Search DLL before P/Invoke?

Dominik Reichl25-Aug-06 4:32

Dominik Reichl

25-Aug-06 4:32

Well, I'd need to search in several directories (system directory, application directory, etc.), and even if I find a DLL it's not sure that this DLL is really a valid library (could be a text file for example)...

Isn't there any way to test if a loadable DLL is present?

Best regards
Dominik

_outp(0x64, 0xAD);
and
__asm mov al, 0xAD __asm out 0x64, al
do the same... but what do they do??
(doesn't work on NT)

Re: Search DLL before P/Invoke?

Jun Du25-Aug-06 5:44

Jun Du

25-Aug-06 5:44

As far as I know, there is no way to test if a DLL is loadable, except for catching exceptions when DllImport fails.

Best,
Jun

Re: Search DLL before P/Invoke? [modified]

Dave Kreskowiak25-Aug-06 6:06

Dave Kreskowiak

25-Aug-06 6:06

You might want to look into trying to load the .DLL using the Assembly class. You might also want to look into doing this in a seperate AppDomain so you can unload it.

-- modified at 12:07 Friday 25th August, 2006

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Search DLL before P/Invoke?

Andy Moore25-Aug-06 15:03

Andy Moore

25-Aug-06 15:03

No there is not. You could do interop to DllLoadLibrary to see if you can load the DLL this way. If it fails then the dll is not present.

Deus caritas est

Interesting date time comparison

coolestCoder25-Aug-06 2:48

coolestCoder

25-Aug-06 2:48

Hi,
I have a bit of situtation here..

I have to check whether the current time is between two pre-defined time values. But, if the second time value is less than the first, then the second time value must be assumed of next day and then current value should be compared. Details are as below ---

time t1 = 10.00.00 PM
t2 = 11.00.00 AM

Current time should be between these two. But as shown above t1 > t2, in this case i want to assume that t2 will be time of next day. (current day +1). And after these considerations i want to find out whether current time is between these t1 and t2.

Actually i am trying to replicate the night duty schedule. If the current time is between the night timings then some operation must be performed or if it is not between the office timings then the operation will be discarded.

Hope i am clear with the situation !!
Please reply as soon as possible.

<marquee>"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

Anant Y. Kulkarni

Re: Interesting date time comparison [modified]

Shajeel25-Aug-06 3:08

Shajeel

25-Aug-06 3:08

try this

<br />
DateTime start = DateTime.Parse("10:00:00 PM");<br />
DateTime end = DateTime.Parse("11:00:00 AM");<br />
if(end < start)<br />
{<br />
  if(DateTime.Now < start)<br />
    start = start.AddDays(-1);<br />
  else<br />
    end = end.AddDays(1);<br />
}<br />
<br />
if(start < DateTime.Now && DateTime.Now < end)<br />
{...}

-- modified at 14:48 Friday 25th August, 2006
<edit> Just came to mind that internal if else is also required so added that.

Regards
Shajeel

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