Visual Basic

26-Mar-09 0:58

I have a text file that has similar lines.
there are 3 fields by which the similar lines can be identified.

modified 28-Nov-12 8:45am.

JernejR26-Mar-09 1:02

JernejR

26-Mar-09 1:02

you have to define rules for "similar"

Is "jerry" similar to "jery" ??

is ABCD similar to ABBC or ACDC (BTW ACDC is very good band) ??

vijay248226-Mar-09 1:13

26-Mar-09 1:13

how to do the loop???

Eddy Vluggen26-Mar-09 2:14

Eddy Vluggen

26-Mar-09 2:14

Read all strings in an array, and do a foreach.

I are troll Smile | :)

how to change provider in crystal report runtime

Anubhava Dimri31-Mar-09 0:16

Anubhava Dimri

31-Mar-09 0:16

Read your Text file to Line wise. You should need of Two string Arrays.
First one you put your File's Unique Data.
Second You use it for Counter.

Then check one by one your data to array.

Best Regard
Anubhava Dimri

mailto: anubhava.prodata@gmail.com

JernejR26-Mar-09 0:02

JernejR

26-Mar-09 0:02

Hay developers

In Visual studio 2005 in Crystal Report Editor you can find "Set datasource location...". There you can change everything (mapping, datasource, even dataprovider). So far so good, but if you want to change DATAPROVIDER runtime (in code) you have big problem. You can change datasource to other database on the same platform, but you cannot change ORACLE to SQL database ??

It seems that changing DATABASENAME doesn't do anything. This is understandable because ORACLE (i design report originaly for ORACLE) does't have database name, you just specified SERVERNAME, USERID and PASSWORD.

So I think the problem lies in fact that you cannot change PROVIDER runtime??

So basicaly I'm able to change provider from ORACLE to SQL in IDE with no problem but not on runtime

I try allmost everything and nothing works form me (see example below).

BTW I'm IT pro and I know what I'm doing, so don't answer to my question like "do you have SQL started" or "is your password writen correct"
no ofense Roll eyes | :rolleyes:

If you have hundrets of report you cannot do this thru IDE.

Please help

Best regards Jerry

<br />
   Public Sub sub_ApplyInfo1(ByRef _oRpt As CrystalDecisions.CrystalReports.Engine.ReportDocument, _<br />
                   ByVal _dbName As String, _<br />
                   ByVal _serverName As String, _<br />
                   ByVal _userID As String, _<br />
                   ByVal _passWord As String, Optional ByVal _IntegratedSecurity As Boolean = False)<br />
<br />
<br />
        Dim oCRDb As CrystalDecisions.CrystalReports.Engine.Database = _oRpt.Database<br />
        Dim oCRTables As CrystalDecisions.CrystalReports.Engine.Tables = oCRDb.Tables<br />
<br />
        Dim oCRTableLogonInfo As CrystalDecisions.Shared.TableLogOnInfo<br />
        Dim oCRConnectionInfo As CrystalDecisions.Shared.ConnectionInfo = New CrystalDecisions.Shared.ConnectionInfo<br />
<br />
<br />
        oCRConnectionInfo.IntegratedSecurity = _IntegratedSecurity<br />
        oCRConnectionInfo.Type = ConnectionInfoType.CRQE<br />
        oCRConnectionInfo.ServerName = _serverName<br />
<br />
        If _dbName <> "" Then<br />
            oCRConnectionInfo.DatabaseName = _dbName<br />
        End If<br />
        If _userID <> "" Then<br />
            oCRConnectionInfo.UserID = _userID<br />
        End If<br />
        If _passWord <> "" Then<br />
            oCRConnectionInfo.Password = _passWord<br />
        End If<br />
<br />
        For Each oCRTable As CrystalDecisions.CrystalReports.Engine.Table In oCRTables<br />
            oCRTableLogonInfo = oCRTable.LogOnInfo<br />
            oCRTableLogonInfo.ConnectionInfo = oCRConnectionInfo<br />
            oCRTable.ApplyLogOnInfo(oCRTableLogonInfo)<br />
            'Dim lcLocation As String = oCRConnectionInfo.DatabaseName & ".dbo." & oCRTable.Location<br />
        Next<br />
<br />
        'Dim cry_logOnInfo As New CrystalDecisions.Shared.TableLogOnInfo<br />
        ''Me.sub_ApplyInfo(oRpt, "FIN", "MYPC\SQLEXPRESS", "", "", True)<br />
<br />
        'cry_logOnInfo.ConnectionInfo.ServerName = "MYPC\SQLEXPRESS"<br />
        'cry_logOnInfo.ConnectionInfo.DatabaseName = "FIN"<br />
        'cry_logOnInfo.ConnectionInfo.UserID = ""<br />
        'cry_logOnInfo.ConnectionInfo.Password = ""<br />
        'cry_logOnInfo.ConnectionInfo.IntegratedSecurity = True<br />
<br />
        'Dim oTable As CrystalDecisions.CrystalReports.Engine.Table<br />
        'For Each oTable In _oRpt.Database.Tables<br />
        '    oTable.ApplyLogOnInfo(cry_logOnInfo)<br />
        'Next<br />
    End Sub<br />
<br />

Re: how to change provider in crystal report runtime

Skymir27-Mar-09 8:51

Skymir

27-Mar-09 8:51

It's been a LONG time since I've had to do this, but if I remember right there are two things you have to watch, the difference in table names between sql/oracle and I believe you have to refresh the object after you change the provider via .refresh .verifydatabase. That should force it to load the right dlls for the currently assigned provider rather than the one saved with the report.

The true man wants two things: danger and play. For that reason he wants woman, as the most dangerous plaything.

Re: how to change provider in crystal report runtime

Anubhava Dimri31-Mar-09 0:26

Anubhava Dimri

31-Mar-09 0:26

For changing your datasource at run time in case of Crystal Report You can crete your Report connection through DSN.then create DSN as per your requirement.

Best Regard
Anubhava Dimri

mailto: anubhava.prodata@gmail.com

Output Differs

vijay248225-Mar-09 23:33

25-Mar-09 23:33

modified 28-Nov-12 8:51am.

Tom Deketelaere25-Mar-09 23:40

Tom Deketelaere

25-Mar-09 23:40

I didn't read the whole code but check the following

The cases that your code doesn't work are the names different in case (upper / lower case)
String comparison in .net is case sensitive so that might be the problem.
(use string.tolower or string.toupper on both strings that you are comparing to make it case insensitive)

vijay248226-Mar-09 0:54

26-Mar-09 0:54

thanks for that ...

will try it out

JernejR26-Mar-09 0:58

JernejR

26-Mar-09 0:58

try this

If String.Equals("AAA", "BBB") Then

End If

BR
Jerry

Luc Pattyn26-Mar-09 0:58

Using SMTP, the email is sent only when the Form is closed

26-Mar-09 0:58

Hi,

I did not like your post for several reasons:

1. it is not clear what you attempt to achieve. Why couldn't you explain what this is for, and give an example of some data, showing parts that work and parts that don't.
Applying some bold and italic is not the way to explain things.

2. your code looks terrible, I am not going to analyze it. Why can't you apply object-oriented principles to it? you have lines describing some kind of object, hence make that a class, and give it a method to create itself from a text line, and another method to output itself in a format of your choice.
Also try to limit the nesting of conditionals and loops, you have around 10 leading to long code lines requiring lots of horizontal scrolling. When properly coded, the main method would fit on a single screen and it would be much easier to spot the problem.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

paulogomes25-Mar-09 16:30

Re: Using SMTP, the email is sent only when the Form is closed

25-Mar-09 16:30

Hi everyone,

I have a form with only one button, "Send", to test the code to send SMTP emails.

It fires the click event when I hit the "Send" button, but the email is never sent if I leave the form running. When I close the form, the email is sent.

This is not the needed behavior because the User may never close the Application or the Form to send emails (this is a Client/Server application, not Web).

Does anyone have an idea why is this happening or what should I change in the code?

Below is the code behind the "Send" button's click event:

Dim message As New MailMessage()
Dim client As New SmtpClient()

'Set the sender's address
message.From = New MailAddress("paulog@corpdev09.com")

message.To.Add(New MailAddress("recipient-test@corpdev09.com"))
message.CC.Add(New MailAddress("paulo-second@corpdev09.com"))

'Set the subject and message body text
message.Subject = "This is the email subject"
message.Body = "This is the body of the email"

'Set the SMTP server to be used to send the message
'client.Host = "DEV-EXCP09-CORPDEV.COM"

'Send the e-mail message
Try
client.Send(message)
Catch exMessage As Exception
MessageBox.show("Error: " + exMessage.Message)
End Try

Thanks,

Paulo

Henry Minute26-Mar-09 1:48

Henry Minute

26-Mar-09 1:48

Have you tried using SendAsync(message) instead of Send(message)?

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Using SMTP, the email is sent only when the Form is closed

paulogomes26-Mar-09 7:36

Re: Using SMTP, the email is sent only when the Form is closed

26-Mar-09 7:36

Hi Henry,

Thanks for your answer. Yes, I changed the code and tried SendAsync with the same result in VB. I also got the below code snipe in C#:
private static void SendAynchronousEmail(SmtpClient client)
{
MailMessage message = new MailMessage();
message.To.Add(RecipientEmail);
message.From = new MailAddress(SenderEmail);
message.Subject = "Asynchronous Email Test";
message.Body = "This is a test email, sent asynchronously.";
client.SendCompleted += new SendCompletedEventHandler
(mailDeliveryComplete);
client.SendAsync(message, "Test");

Console.WriteLine("Sending finished, press Enter.");
Console.ReadLine();
}
It sends the email only after you hit Enter. If you remove the Console.ReadLine()the email is never sent!
The code in the mailDeliveryComplete just write in the console "Message Sent".

I'm lost.
All code snipes I see in books and Internet are straight forward like above but none works, only after you close the application.

Any idea what is missing?

Thanks,

Paulo

Luc Pattyn26-Mar-09 9:02

Re: Using SMTP, the email is sent only when the Form is closed

26-Mar-09 9:02

My guess is the Console is behaving in a logical way and you are fooling yourself. Whenever you execute Console.ReadLine() the console awaits your input and delays all its output. So "Message Sent" can not be shown as long as you don't hit ENTER.

To prove this, add the following right after Console.ReadLine():

Console.WriteLine("please hit ENTER once more");
Console.ReadLine();

Luc Pattyn [Forum Guidelines] [My Articles]

paulogomes26-Mar-09 9:14

Re: Using SMTP, the email is sent only when the Form is closed

26-Mar-09 9:14

Hi Luc,
Yes, you are right. But the point is not the command console.readline() but the fact that if I remove it the email is not sent.

In MSDN I found that if you use the synchronous Send method your code does not goes until the request is completed. This is why I'm using SendAsync that is asynchronous and it should not wait and send the email, not matter what the code does after.

I put the console.readline() only to be able to see the messages, I never tought that if I remove it the email is never sent.

Must be a reason for that...

Thanks for you reply. I'm still trying to find a way to send SMTP emails without having to finish the thread.

Thanks,

Paulo

Henry Minute26-Mar-09 9:12

Henry Minute

26-Mar-09 9:12

See what happens if you follow Lucs' suggestion.
I'll watch the thread, in case you come back.

Re: Using SMTP, the email is sent only when the Form is closed

Luc Pattyn26-Mar-09 9:50

Re: Using SMTP, the email is sent only when the Form is closed

26-Mar-09 9:50

Hi Paulo,

I have a C# program that, amongst a lot of other stuff, contains mail code, basically identical to yours (the synchronous version, that is):

MailMessage msg=new MailMessage();
... // set msg.properties
SmtpClient client = new SmtpClient(server);
client.Send(msg);

The only difference is my client is constructed with the server's name as a parameter.
My program successfully sends three mails without exiting at all.
My best guess is your observation somehow is wrong.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

modified on Thursday, March 26, 2009 4:23 PM

paulogomes26-Mar-09 10:49

Re: Using SMTP, the email is sent only when the Form is closed

26-Mar-09 10:49

Hi Luc/Henry,
I tried to build the SMTP client as Luc suggested but did not work either.

However, I found what the problem was: follow me.

when I started this project I did not know if I'll be using MAPI or SMTP, so I wrote 2 methods. Testing the MAPI time ago (with MAPI we use here Exchange Server), when the email is sent ExchangeServer pops a dialog box telling me that a program (my application) "is trying to send an email on your behalf" and give me an OK and CANCEL buttons. Once I hit OK, the email is sent.

That is the key: I'm testing the code using my own equipment, sending emails to me to see if it works or not. Did you see what happened?

SMTP does not have all Exchange Server features and does not issue a dialog asking for authorization, but it keeps waiting because I'm sending emails from my equipment to myself, but the user is not me, is my application, using my credencials!

As a proof of concept for this theory, I installed the application in another computer in the network and it worked fine, no more need to close the sending thread!

Nothing is wrong with those VB and C# codes, just the way I'm testing.

So, Luc/Henry, I really appreciate your effords and time spent to help me and it was a good felling having someone in the other side to discuss with my tech problems.

Thank you!

Paulo

Luc Pattyn26-Mar-09 10:59

Re: Using SMTP, the email is sent only when the Form is closed

26-Mar-09 10:59

Hi Paulo,

glad you got it working.

However I'm not familiar with Exchange Server, and I do not quite follow your reasoning.

Are you saying:
1. Exchange Server does not want to accept your app sending something until the app exits?
2. Exchange Server does not deliver the newly received message as long as the app is running, because the app is impersonating you and "you" (the app) are not asking for incoming mail until the app exits and your regular mail client becomes active again?

Furthermore: would your app succeed in sending without exiting, if you did close your mail client beforehand?

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

paulogomes26-Mar-09 11:38