C# Discussion Boards - CodeProject

Nafiseh Salmani1-Jul-09 4:58

1-Jul-09 4:58

I need to use search engine like www.alibaba.com via my code! Is there any way to send a query or parameters through my C#.net code to this or any other search engines?!!

Re: Send query to a search engine!!

led mike1-Jul-09 5:46

led mike

1-Jul-09 5:46

Nafiseh Salmani wrote:
I need to use search engine like www.alibaba.com via my code! Is there any way to send a query or parameters through my C#.net code to this or any other search engines?!!

Yes, probably, maybe. Depends on the search engine.

Re: Send query to a search engine!!

Nafiseh Salmani1-Jul-09 6:14

Nafiseh Salmani

1-Jul-09 6:14

So how?!!

Re: Send query to a search engine!!

led mike1-Jul-09 6:31

led mike

1-Jul-09 6:31

Well the first step would be to learn how a specific engine needs to receive the parameters, this is called "requirements".

Now I say that would be the first step for someone that is capable of developing the software to those requirements, otherwise the first step would be to learn a whole bunch of other things that a developer would have to know to do this project.

Thread of a delegate

TheLaTouf1-Jul-09 3:43

TheLaTouf

1-Jul-09 3:43

Hi all,

I would like in C# to initialize a thread with a delegate. It looks like this :

<br />
internal delegate void MyDelegateType();<br />
internal  MyDelegateType MyDelegate;<br />
<br />
public Init_Launch_Thread()<br />
{<br />
Thread lThread_Groupe = new Thread(MyDelegate); //Is not allowed<br />
 lThread_Groupe.Start();<br />
}<br />

It is not allowed and I do not really get why. My problem is that I do not know before construction of my class what actually will be launched in the thread. Is anyone got an idea ? I would like to avoid polymorphism there for other reasons.
thx

Re: Thread of a delegate

Ennis Ray Lynch, Jr.1-Jul-09 4:11

Ennis Ray Lynch, Jr.

1-Jul-09 4:11

Personally, I would read the documentation of Thread and ThreadStart.

And then I would use the Thread pool instead.

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Re: Thread of a delegate

Nicholas Butler1-Jul-09 4:32

Nicholas Butler

1-Jul-09 4:32

I'm not sure I understand. Your MyDelegateType has the same signature as the Framework's ThreadStart delegate Confused | :confused:

If the signature of your thread's method is changing, maybe using a lambda would help:

new Thread( _ => ThreadMain( ... parameters ... ) );

Nick

----------------------------------
Be excellent to each other Smile | :)

Re: Thread of a delegate

TheLaTouf1-Jul-09 4:40

TheLaTouf

1-Jul-09 4:40

Thanks for your answers, I'll have a look at it

Automatic download attachment from emails

spankyleo1231-Jul-09 3:36

spankyleo123

1-Jul-09 3:36

Hello people, My client wants to have an app which will automatically download excel 2003 attachments from emails and store it into the database.

At the moment I have designed an app in C# which reads excel sheet by browsing to it from the local machine and then displays contents into the GUI.

Is there any way in which I can automate this process..

Cheers!

Re: Automatic download attachment from emails

c0ax_lx1-Jul-09 3:55

c0ax_lx

1-Jul-09 3:55

Here's A POP3 Client in C# .NET[^] a good link to get you started on the emails. look at the last codeblock for attachment retrieval.

If it' stuck, DO NOT pull harder!

Re: Automatic download attachment from emails

moon_stick1-Jul-09 5:09

moon_stick

1-Jul-09 5:09

If you're using Outlook you could write a small add-in and hook onto the mail received event. This would then start a process to check the received message, check for attachments and do any further processing required.

I assume you're talking about holding the actual file in the database - it might be a better idea to save the files on a drive and write a reference to the path in a table somewhere.

It definitely isn't definatley

Re: Automatic download attachment from emails

spankyleo1231-Jul-09 8:57

spankyleo123

1-Jul-09 8:57

Yea am using outlook 2003 to receive emails from clients. The emails contain the Excel sheet with a fixed format. Could u elaborate on how it would be possible to write a reference to Outlook using C#, so that application click even can check for new attachments and download it.

Re: Automatic download attachment from emails

moon_stick1-Jul-09 9:18

moon_stick

1-Jul-09 9:18

It's a couple of years since I've done this and don't appear to have anything directly relevant to hand. However, you'll be best doing some research into Visual Studio Tools for Office (VSTO - there's some good articles here[^]) as well as the Outlook object model (try here[^]).

In summary, you'll create an Add-in for Outlook using VSTO. This add-in will register as a listener with the NewMailEx event (mail received) and once the event is fired, the add-in will examine the new mail to determine whether or not is has any attachments and if any of these are excel documents.

From here the rest of your task should be fairly trivial; either you'll copy the file to a folder somewhere and execute a stored procedure to write an entry into a database table somewhere or you'll stream the file directly into the database (depending on what method of storage you use).

A quick google will bring up a stack of articles; I remember in the past having some trouble deploying Office 2003 add-ins but think they were mostly resolved by ensuring that VSTO was installed on the client machine (free download from MS[^])

Sorry I don't have anything more specific but with a little bit of research you should be able to find your way.

HTH

It definitely isn't definatley

Re: Automatic download attachment from emails

moon_stick1-Jul-09 9:22

moon_stick

1-Jul-09 9:22

I've just re-read this; it sound like you're wanted to copy the contents of the excel file into a database table. If you know that the format of the file is going to be identical each time, I'd suggest creating a DTS package using integration services and executing this, passing in the name of the file as a variable. If it's not identical you might struggle - it's non-trivial at any rate.

It definitely isn't definatley

Re: Automatic download attachment from emails

spankyleo1231-Jul-09 9:57

spankyleo123

1-Jul-09 9:57

The name of the Excel File varies, but the sheet has fixed columns & column names. Data appearing in the column varies.

Re: Automatic download attachment from emails

moon_stick1-Jul-09 11:13

moon_stick

1-Jul-09 11:13

In which case you should be able to build a simple DTS package and execute it from within the add-in. I've not really got enough room to explain here but there's plenty of articles and the SSIS newsgroups have some pretty comprehensive examples.

It definitely isn't definatley

Cut, Copy & Paste from variable text boxes

Martin310881-Jul-09 3:20

Martin31088

1-Jul-09 3:20

Hi guys,

What I'm trying to do is cut copy and paste the selected text from any text box in my application. I have it working if it copies the entire text from the box, and I have it working if I hard code the text box name into to function.

Ive looked all over for an answer to this, and have got nowhere

This is the current code I am using:

string ActiveCon = this.ActiveControl.Name;
string SelText = ActiveCon.SelectedText;
Clipboard.SetText(SelText);
this.ActiveControl.Text = "";

It just does not like SelectedText used on a variable

Any help on this would be greatly appreciated.
Regards
Martin

Re: Cut, Copy & Paste from variable text boxes

Eddy Vluggen1-Jul-09 3:39

Eddy Vluggen

1-Jul-09 3:39

TextBoxes don't have a SelectedText property, I believe that this is limited to RichTextBoxes. There's also a Copy[^] method that does what you want Smile | :)

I are troll Smile | :)

Re: Cut, Copy & Paste from variable text boxes

Baeltazor1-Jul-09 7:39

Baeltazor

1-Jul-09 7:39

Sorry to correct you eddy but TextBox's do have a SelectedText property.

Smile | :)

jason

Re: Cut, Copy & Paste from variable text boxes

Eddy Vluggen1-Jul-09 8:20

Eddy Vluggen

1-Jul-09 8:20

Found it, along with the SelectionStart and the SelectionLength Smile | :)

Thanks for the correction Thumbs Up | :thumbsup:

I are troll Smile | :)

Re: Cut, Copy & Paste from variable text boxes

Baeltazor1-Jul-09 20:28

Baeltazor

1-Jul-09 20:28

You're welcome Eddy Smile | :)

Re: Cut, Copy & Paste from variable text boxes

DaveyM691-Jul-09 3:46

DaveyM69

1-Jul-09 3:46

Why are you using a string for the active control?

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: Cut, Copy & Paste from variable text boxes

Luc Pattyn1-Jul-09 3:49

Luc Pattyn

1-Jul-09 3:49

Hi,

You can't just get directly to a TextBox when all you know is its name.
Here is a little snippet that would do something akin to what you want, assuming your class
is a Form or whatever Container that is holding the TextBoxes:

public string GetTextBoxText(string name) {
    string text=null;
    foreach(Control c in Controls) {
        TextBox tb=c as TextBox;
        if (tb!=null && tb.Name==name) text=tb.SelectedText;
    }
    return text;
}

BTW: If some of your TextBoxes are located deeper in the Control hierarchy, you would have to adapt for that.

PS: as Dave said, if you would hold a reference to the ActiveControl, rather than just holding its name, you could get to its text right away!

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care.

Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation)

MagForJ1-Jul-09 3:11

MagForJ

1-Jul-09 3:11

Does anyone know the best way to store and access thousands of abbreviations which are stored in a db and output the full string. For example Intel's stock symbol is INTC. When i read INTC from the db i want to set string str to Intel Corporation so the full name can be displayed to the user. currently the full string is not stored anywhere, just output on the fly based on the abbreviation and a million if-else statements OMG | :OMG:

ie.

if(abrev.equals("INTC")) str = "Intel Corporation";
else if(abrev.equals("GOOG")) str = "Google Inc";
....
....

Obviously the wrong way to go about it. Should the full name just be added to the db? could create hash table with abbreviation as key and full string as value. Yes the if-else method works but is awful to look at and hilariously bad. Thanks guys and gals

Re: Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation)

Manas Bhardwaj1-Jul-09 3:27

Manas Bhardwaj

1-Jul-09 3:27

MagForJ wrote:
Should the full name just be added to the db?

I would say stroe it in the db itself and use a dictionary to find the mapping. Rose | [Rose]

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

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