Click here to Skip to main content
15,914,359 members
Home / Discussions / C#
   

C#

 
AnswerRe: Cut, Copy & Paste from variable text boxes Pin
Luc Pattyn1-Jul-09 3:49
sitebuilderLuc Pattyn1-Jul-09 3:49 
QuestionExpanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation) Pin
MagForJ1-Jul-09 3:11
MagForJ1-Jul-09 3:11 
AnswerRe: Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation) Pin
Manas Bhardwaj1-Jul-09 3:27
professionalManas Bhardwaj1-Jul-09 3:27 
AnswerRe: Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation) Pin
harold aptroot1-Jul-09 3:28
harold aptroot1-Jul-09 3:28 
AnswerRe: Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation) Pin
SeMartens1-Jul-09 3:29
SeMartens1-Jul-09 3:29 
AnswerRe: Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation) Pin
Keith Barrow1-Jul-09 3:37
professionalKeith Barrow1-Jul-09 3:37 
QuestionRe: Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation) Pin
EliottA1-Jul-09 4:25
EliottA1-Jul-09 4:25 
AnswerRe: Expanding String Abbreviations To Full String ( NASDAQ:INTC --> Intel Corporation) Pin
dojohansen1-Jul-09 6:19
dojohansen1-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.
Questionadd controls to webform Pin
v_vidhya1-Jul-09 2:23
v_vidhya1-Jul-09 2:23 
AnswerRe: add controls to webform Pin
Niladri_Biswas1-Jul-09 3:47
Niladri_Biswas1-Jul-09 3:47 
GeneralRe: add controls to webform Pin
v_vidhya1-Jul-09 18:38
v_vidhya1-Jul-09 18:38 
Questionclickonce Pin
arkiboys1-Jul-09 2:12
arkiboys1-Jul-09 2:12 
AnswerRe: clickonce Pin
Manas Bhardwaj1-Jul-09 2:13
professionalManas Bhardwaj1-Jul-09 2:13 
GeneralRe: clickonce [modified] Pin
arkiboys1-Jul-09 2:27
arkiboys1-Jul-09 2:27 
QuestionTextbox Control function..... Pin
Hum Dum1-Jul-09 2:07
Hum Dum1-Jul-09 2:07 
AnswerRe: Textbox Control function..... Pin
musefan1-Jul-09 2:12
musefan1-Jul-09 2:12 
GeneralRe: Textbox Control function..... Pin
Hum Dum1-Jul-09 2:40
Hum Dum1-Jul-09 2:40 
GeneralRe: Textbox Control function..... Pin
musefan1-Jul-09 2:43
musefan1-Jul-09 2:43 
GeneralRe: Textbox Control function..... Pin
Hum Dum1-Jul-09 2:56
Hum Dum1-Jul-09 2:56 
GeneralRe: Textbox Control function..... Pin
dojohansen1-Jul-09 6:27
dojohansen1-Jul-09 6:27 
AnswerRe: Textbox Control function..... Pin
OriginalGriff1-Jul-09 2:16
mveOriginalGriff1-Jul-09 2:16 
GeneralRe: Textbox Control function..... Pin
Hum Dum1-Jul-09 2:46
Hum Dum1-Jul-09 2:46 
GeneralRe: Textbox Control function..... Pin
OriginalGriff1-Jul-09 3:46
mveOriginalGriff1-Jul-09 3:46 
AnswerRe: Textbox Control function..... Pin
K03061-Jul-09 2:19
K03061-Jul-09 2:19 
GeneralRe: Textbox Control function..... Pin
Luc Pattyn1-Jul-09 2:35
sitebuilderLuc Pattyn1-Jul-09 2:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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