C# Discussion Boards - CodeProject

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.

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

harold aptroot1-Jul-09 3:28

harold aptroot

1-Jul-09 3:28

As an easy alternative, just make it into a switch.

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

SeMartens1-Jul-09 3:29

SeMartens

1-Jul-09 3:29

Hi
As you already mentioned store the abbrevations and the long name in the db. I would suggest using a second table, so that you can use a nested select statement to get the full name. This will enable you to use the full performance power of your relational database.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

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

Keith Barrow1-Jul-09 3:37

Keith Barrow

1-Jul-09 3:37

Use Dictionary<string,string>. The code can be the key. This

e.g.

Dictionary<string,string> companies = new Dictionary<string,string>();


companies.Add("INTC", "Intel Corp");
....

string companyName= companies["INTC"];

Note that you can only have one code entry, but the same company name can appear next to multiple codes.

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

EliottA1-Jul-09 4:25

EliottA

1-Jul-09 4:25

I don't know why this bugged me, but it does.

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

Why abbreviate "Incorporated" in "Google Inc" but not "Corporation" (Corp) in "Intel Corporation"?

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

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

dojohansen1-Jul-09 6:19

dojohansen

1-Jul-09 6:19

I'd definitely make it data-driven if I were you. Whether or not you should just add a column to an existing table is another matter.

In this particular case I think I'd have a look to see if I could get the data from somewhere and go from there. For example, there may be a free web service that let's you retrieve this. (This could be done at run-time, but web services are quite slow though; you probably don't want to look up a code at a time for a collection, for example.)

If you can get the data, storing it in a new table has some benefits: The descriptive string can potentially be sizeable, and adding a large column to any table, especially a small table (I've no idea what row sizes you have here), can have a significant impact on row size and thus on performance. I don't know what DB you're working with, but SQL Server has 8K pages and yet I've seen a "transaction" table (storing financial transactions, not database transactions!) that had a column defined as nvarchar(500) - that's a 1000 bytes just for this one column. That table could have millions of rows, but SQL Server couldn't get more than 6 records per page thanks to this horrible design error.

However you store the data, if it's not too substantial and you need raw speed, load it into a cache once and you should get great results.

add controls to webform

v_vidhya1-Jul-09 2:23

v_vidhya

1-Jul-09 2:23

how to add controls to webform without using placeholder or panel

Re: add controls to webform

Niladri_Biswas1-Jul-09 3:47

Niladri_Biswas

1-Jul-09 3:47

Simple.

Solution 1: Add directly to the Page Control

TextBox txt = new TextBox();
        txt.ID = "txt1";
        this.Page.Form.Controls.Add(txt);

Solution 2:

Create a DIV tag with an ID and Runat = 'Server'

In the code behind, add the dynamic control to the DIV which inturn will be added to the Page Control

TextBox txt = new TextBox();
        txt.ID = "txt1";
        divAddDynamicControlsHere.Controls.Add(txt);
        this.Page.Form.Controls.Add(divAddDynamicControlsHere);

Solution 3:Create a Table with TR & TD. Expose the TD's Id and Runat='Server'

<table>
    <tr>
    <td id="tdAddDynamicControlsHere" runat="server"></td>
    </tr>
    </table>

In the code behind, add the dynamic control to the TD which inturn will be added to the Page Control

TextBox txt = new TextBox();
        txt.ID = "txt1";
        tdAddDynamicControlsHere.Controls.Add(txt);
        this.Page.Form.Controls.Add(divAddDynamicControlsHere);

Solution 4: Use literal control

<asp:literal id="LitDynamicControl" runat="server">

In code behind

string controlText = "<html><head></head>";
        controlText += "<body><input type='txt' id='txt'></body></html>";
        LitDynamicControl.Text = controlText;

Solution 5: Well you know, PLACEHOLDER CONTROL/PANEL

Solution 6:

Using HTTP Modules [ Creating Server Controls at Runtime using HTTP Modules[^] ] - By Niladri Biswas

Hope this helps.

Vote me pls
Smile | :)

Niladri Biswas

Re: add controls to webform

v_vidhya1-Jul-09 18:38

v_vidhya

1-Jul-09 18:38

Thanks for your reply.But this didn't work.My div tag in update panel.

clickonce

arkiboys1-Jul-09 2:12

arkiboys

1-Jul-09 2:12

Hi,
I have developed an application which contains two projects.
It uses xml files which are located inside the bin folder of one of the projects.
When going through the click once, how do I tell the setup to use the xml files inside the bin folder of the project? i.e. Is there a place where I can include the xml files in the click once?
Thanks

Re: clickonce

Manas Bhardwaj1-Jul-09 2:13

Manas Bhardwaj

1-Jul-09 2:13

Read this[^]

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.

Re: clickonce [modified]

arkiboys1-Jul-09 2:27

arkiboys

1-Jul-09 2:27

Solved.
Thanks

modified on Wednesday, July 1, 2009 8:37 AM

Textbox Control function.....

Hum Dum1-Jul-09 2:07

Hum Dum

1-Jul-09 2:07

If there already exist some text in textBox, then

restrict user, so user can not delete/modify that text, but can add(append) text in to textBox. How to do this?

Soppose:
"Quick brown fox jumps" (already present in text box)

so, user can only append text, but can't modify previous text.

like:
"Quick brown fox jumps ......(only from here he can enter/append)"

regards.

Re: Textbox Control function.....

musefan1-Jul-09 2:12

musefan

1-Jul-09 2:12

Try handling the KeyPreview event and then check for 'delete/backspace' key when the current text is at a certain length (i.e. the length of the text you want to always be present). That might work

Life goes very fast. Tomorrow, today is already yesterday.

Re: Textbox Control function.....

Hum Dum1-Jul-09 2:40

Hum Dum

1-Jul-09 2:40

musefan wrote:
(i.e. the length of the text you want to always be present). That might work

I also first thought of this, but suppose if user appended some text then its lenght got increased, now he acts smart and jumps back , then he can delete as length is greater(as he adds some text)

Application is on order progress.
Where user has to update its order action/remarks?

I am fetching text from DB to textControl, and user have to update these fields.

So if user once entered some data and updated it, then next time he can only append new data, can't modify previous data.

Any help appreciated....?
Smile | :)

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