|
Perfect, Thanks Luc. 
|
|
|
|
|
you're welcome.
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.
|
|
|
|
|
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?!!
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
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);
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
|
|
|
|
|
Personally, I would read the documentation of Thread and ThreadStart.
And then I would use the Thread pool instead.
|
|
|
|
|
I'm not sure I understand. Your MyDelegateType has the same signature as the Framework's ThreadStart delegate 
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
|
|
|
|
|
Thanks for your answers, I'll have a look at it
|
|
|
|
|
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!
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
The name of the Excel File varies, but the sheet has fixed columns & column names. Data appearing in the column varies.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
I are troll
|
|
|
|
|
Sorry to correct you eddy but TextBox's do have a SelectedText property.
jason
|
|
|
|
|
|
You're welcome Eddy
|
|
|
|
|
Why are you using a string for the active control?
DaveBTW, 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)
|
|
|
|
|
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!
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
