DataTable row column lookup possiblity? - C# Discussion Boards

3-Jun-10 1:36

Excel is native code, not managed code, so it should always run fine, even without .NET present.
Excel automation through PIA (Primary Interop Assembly) may be different, and different versions of Office may require different PIA versions, I don't know any details.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

Re: exe not executed

prithaa3-Jun-10 1:38

prithaa

3-Jun-10 1:38

thanks for all your clarification

Re: exe not executed

Luc Pattyn3-Jun-10 1:40

Calling COM fails in C# destructor

3-Jun-10 1:40

you're welcome.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

cmartono1-Jun-10 16:41

cmartono

1-Jun-10 16:41

Hi All,
I am writing a .net application that calls a COM interface. I can use / call this interace through out the program, just fine. But calling the same interface fails in the class destructor. I need to call it there because the COM interface has something like "disconnect" method that i need to call before exiting my app.

The error that i get (only when calling the interface from destructor):
"Unable to cast COM object of type 'MyCOMObject' to interface type 'MyCOMInterface'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{9EA75075-57E3-4DCE-AACC-B87637142867}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))"

Anybody knows what I am missing or doing wrong?
Thanks in advance!

-Chris

Re: Calling COM fails in C# destructor

Abhinav S1-Jun-10 17:43

Abhinav S

1-Jun-10 17:43

You possibly need to implement the IDisposable pattern.
This will help you clean up your unmanaged resources and also call disconnect (possibly) before the Dispose() method is called.

My signature "sucks" today

Click on WindowPattern

mayraglez1-Jun-10 7:41

mayraglez

1-Jun-10 7:41

Hello!!
I'm pretty new in .Net and now I'm using C# to do some test automation with System.Windows.Automation.
I Need to do a click on an specific area of the main window from the application that I want to test, this is defined as WindowPattern, Do you know how could I do this??

modified on Tuesday, June 1, 2010 3:01 PM

DataTable row column lookup possiblity?

Blubbo1-Jun-10 7:11

Blubbo

1-Jun-10 7:11

I'm trying to determine if its possible to get the row index of the data combination while avoiding the interation for-loop?

Here's an example below

DataTable may look like this (with variable named "datTab":

Name Number1 Number2 Number3 Number4
Ron 60 43 33 40
Sco 83 43 33 42
Alb 60 43 32 40
Hei 34 32 45 55
Ant 23 43 33 23

Now, the question is... is it possible to get the row index number if I would find the number combination with 4 numbers? Such as I would say to find 60, 43, 33, 42 and it would find the row index = 1. I understand it can do for one column, such as

int indexTab = datTab.Rows["Number1"].IndexOf("00");

but with multiple columns? I just thought of it as I use it in my code and the software is really sluggish with muliple columns using For-loop and if-statement inside the loop.

I hope someone can answer this. I'm hoping this will provide better performance.

Thanks!

T M Gray1-Jun-10 10:16

T M Gray

1-Jun-10 10:16

select ROW_NUMBER() OVER(ORDER BY Name) AS RowNumber,Name,Number1,Number2,Number3,Number4

Then use a RowFilter on the default view to narrow down to the record you want and get the value of the RowNumber column.

Blubbo2-Jun-10 2:07

Blubbo

2-Jun-10 2:07

can you provide an example? I'm not sure if I quite understand what you're saying.

PIEBALDconsult1-Jun-10 13:31

PIEBALDconsult

1-Jun-10 13:31

Even if you don't write the iteration, it'll be there. I prefer to write my own stuff so I know what's going on, rather than wondering what's going on behind the scenes.

P.S. You could even write your own indexing using a hierarchy of Dictionaries.

AspDotNetDev1-Jun-10 17:58

AspDotNetDev

1-Jun-10 17:58

You could have your fifth column be a combination of the numbers. So, the first row would have a "ComboColumn" value of "60,43,33,40". If you have a SQL query fill your DataTable, you could just have it return that "ComboColumn" in addition to the other columns. You could then use datTab.Rows["ComboColumn"].Indexof("60,43,33,40") to find the correct row. However, if that is still too slow, you may want to condider creating a dictionary object to hold the rows with the ComboColumn string as the key. Alternatively, if you are just looking for a single row and you are using SQL, it might be a good idea to just query for that specific row rather than gather data then find it. If you have an appropriate index setup on the table, that should be very fast (also depends on network speed and such).

[Forum Guidelines]

Send mail through SMTP server

Blubbo2-Jun-10 2:08

Blubbo

2-Jun-10 2:08

hmm ComboColumn may be a good idea... I'll give that a shot and see what happens.

loyal ginger1-Jun-10 7:02

1-Jun-10 7:02

I am playing with a small program that sends emails through SMTP server. This is a C# Windows Forms application. The main part of the program looks like this:

using System;
using System.Text;
using System.Windows.Forms;
using System.Net.Mail;


namespace test_email_smtp
{
	public partial class send_mail_through_smtp : Form
	{
		public send_mail_through_smtp()
		{
			InitializeComponent();
		}

		private void send_mail_Click(object sender, EventArgs e)
		{
			SmtpClient client = new SmtpClient(smtp_server.Text);
			MailMessage message = new MailMessage(send_from.Text, send_to.Text);
			message.Body = mail_body.Text;
			message.Subject = mail_subject.Text;
			client.Send(message);
			message.Dispose();
		}
	}
}

"send_from", "send_to", "mail_body", "mail_subject", and "smtp_server" are TextBox controls on the Form.

When I ran the program and click the "send" button, and then close the program (by closing the form), the mail is sent IMMEDIATELY.

However, if I click the "send" button and leave the program running (not closing the program), after a minute or so, I will get a message saying "Your mail message was unable to be sent because the connection to your mail server was interrupted. Please open your email client and re-send the message from the Sent Messages folder." This does not happen all the time. I'd say 9 out of 10 times this message was shown. The one time it was not shown, the mail was sent after a long time.

By the way, the message is from "Symantec Email Proxy". When this message was shown, a balloon message was also popped up by the system tray area saying "Scanning message 1 of 1", also from Symantec.

All these problems do not exist if I close the program after I click the "send" button. The mail will be sent immediately. I need the program to keep running after the mail is sent. I can't close the program every time a mail needs to be sent. Any ideas? Thanks!

Abhinav S1-Jun-10 7:52

Abhinav S

1-Jun-10 7:52

Trying disabling your antivirus to see if you get the same problem.
If you don't, then it has something to do the the symantec firewall or virus scan.

My signature "sucks" today

loyal ginger1-Jun-10 8:51

1-Jun-10 8:51

I have verified that the antivirus software running on my machine was the problem. Your help is appreciated.

OriginalGriff1-Jun-10 8:22

OriginalGriff

1-Jun-10 8:22

The suggestion made by Abhinav may help; if it does not, then:
SmtpClient implements IDisposable so it may be that the email is sent when the client is disposed. This would give the symptoms you describe, at least in terms of the send-when-application-closed problem. Try wraping your section in a using block.

using (SmtpClient client = new SmtpClient(smtp_server.Text))
   {
   MailMessage message = new MailMessage(send_from.Text, send_to.Text);
   message.Body = mail_body.Text;
   message.Subject = mail_subject.Text;
   client.Send(message);
   message.Dispose();
   }

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

loyal ginger1-Jun-10 8:33

1-Jun-10 8:33

Thanks for your reply. I tried that and got the following compile time message:

Error	1	'System.Net.Mail.SmtpClient': type used in a using statement must be implicitly convertible to 'System.IDisposable'

I will do more research on this matter. Thanks!

OriginalGriff1-Jun-10 8:41

OriginalGriff

1-Jun-10 8:41

My apologies, it looks like MS are lying again... SmtpClient @ MSDN[^]

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

Luc Pattyn1-Jun-10 9:11

1-Jun-10 9:11

OriginalGriff wrote:
it looks like MS are lying again

Hmm. Continuously improving themselves, that is what they are doing. It took them till 4.0 to realize SmtpClient had to implement IDisposable.

Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read formatted code with indentation, so please use PRE tags for code snippets.

I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).

loyal ginger1-Jun-10 8:48

1-Jun-10 8:48

After disabling the antivirus program, the original program sends the email immediately when the button is clicked. That indicates that the antivirus was the problem.

I still don't understand why closing the program bypasses the antivirus program's scanning of the email.

Another issue is that it's hard to ask the program's users to turn off their antivirus program to facilitate the healthy running of my program.

My solution to the problem may be to use separate processes for sending emails. I can spawn a small program just to send an email. It terminates by itself right after the mail is sent.

Thank you for your time!

OriginalGriff1-Jun-10 8:54

OriginalGriff

1-Jun-10 8:54

loyal ginger wrote:
Another issue is that it's hard to ask the program's users to turn off their antivirus program to facilitate the healthy running of my program.

I can see where that might be a problem. Laugh | :laugh:

loyal ginger wrote:
My solution to the problem may be to use separate processes for sending emails. I can spawn a small program just to send an email.

But if you gotta, you gotta. What kind of virus scanner are we talking?

Did you know:
That by counting the rings on a tree trunk, you can tell how many other trees it has slept with.

loyal ginger1-Jun-10 9:14

1-Jun-10 9:14

I have "Symantec AntiVirus" version 10.1.5.500 on my development machine. It's hard to predict what antivirus software will be on my client's machine. I am lucky to see this happen on my machine. Sometimes a fully tested application craps out on client's machines because some other software's interference, making the software developers look bad. I hope that does not happen to me.

Luc Pattyn1-Jun-10 9:59