Click here to Skip to main content
15,906,558 members
Home / Discussions / C#
   

C#

 
GeneralRe: size of text array - limitations Pin
Luc Pattyn15-Jan-07 4:53
sitebuilderLuc Pattyn15-Jan-07 4:53 
GeneralRe: size of text array - limitations Pin
electriac15-Jan-07 5:02
electriac15-Jan-07 5:02 
AnswerRe: size of text array - limitations Pin
mihksoft15-Jan-07 20:57
mihksoft15-Jan-07 20:57 
GeneralRe: size of text array - limitations [modified] Pin
electriac15-Jan-07 21:09
electriac15-Jan-07 21:09 
QuestionAssigning the result of an SQL ExecuteScalar() to an int? Pin
Red_Wizard_Shot_The_Food15-Jan-07 1:42
Red_Wizard_Shot_The_Food15-Jan-07 1:42 
AnswerRe: Assigning the result of an SQL ExecuteScalar() to an int? Pin
Pete O'Hanlon15-Jan-07 1:57
mvePete O'Hanlon15-Jan-07 1:57 
GeneralRe: Assigning the result of an SQL ExecuteScalar() to an int? Pin
aSarafian15-Jan-07 2:30
aSarafian15-Jan-07 2:30 
GeneralRe: Assigning the result of an SQL ExecuteScalar() to an int? Pin
Colin Angus Mackay15-Jan-07 2:48
Colin Angus Mackay15-Jan-07 2:48 
Sarafian wrote:
you can't do it without using try catch or an if statement which in this case is the same.


No it isn't. A try/catch adds a heck of a processing overhead if an exception is raised. Since this is not an exceptional case getting the value as an object then testing for null would be the better option.


Sarafian wrote:
assuming your id in base are not zero-valued i have implemented a function that executed the command and return zero if not found or the desired value.


Returning magic numbers is not the solution. Testing for null or DBNull.Value is.

It should also be realised that null is not the same as DBNull.Value.

null is returned if the SELECT statement returned nothing at all. DBNull.Value is returned if the SELECT statement found the row and column, but the column was null.


GeneralRe: Assigning the result of an SQL ExecuteScalar() to an int? Pin
aSarafian15-Jan-07 5:04
aSarafian15-Jan-07 5:04 
Questionregular expressions problem Pin
rafiki27015-Jan-07 1:05
rafiki27015-Jan-07 1:05 
AnswerRe: regular expressions problem Pin
Stefan Troschuetz15-Jan-07 3:07
Stefan Troschuetz15-Jan-07 3:07 
QuestionGeneric Dictionary: Dictionary in a Dictionary? Pin
olethroz15-Jan-07 0:33
olethroz15-Jan-07 0:33 
AnswerRe: Generic Dictionary: Dictionary in a Dictionary? Pin
aSarafian15-Jan-07 1:12
aSarafian15-Jan-07 1:12 
GeneralRe: Generic Dictionary: Dictionary in a Dictionary? Pin
olethroz15-Jan-07 9:03
olethroz15-Jan-07 9:03 
Questionchoose file dialog box Pin
ALAQUNAIBI14-Jan-07 23:18
ALAQUNAIBI14-Jan-07 23:18 
AnswerRe: choose file dialog box Pin
Christian Graus14-Jan-07 23:45
protectorChristian Graus14-Jan-07 23:45 
Question.net 2.0 - developing webservice Pin
fmardani14-Jan-07 23:17
fmardani14-Jan-07 23:17 
AnswerRe: .net 2.0 - developing webservice Pin
Christian Graus14-Jan-07 23:51
protectorChristian Graus14-Jan-07 23:51 
Questionpassword generation Pin
quiteSmart14-Jan-07 23:05
quiteSmart14-Jan-07 23:05 
AnswerRe: password generation Pin
Russell Jones14-Jan-07 23:10
Russell Jones14-Jan-07 23:10 
GeneralRe: password generation Pin
Muammar©14-Jan-07 23:23
Muammar©14-Jan-07 23:23 
GeneralRe: password generation Pin
Russell Jones14-Jan-07 23:33
Russell Jones14-Jan-07 23:33 
GeneralRe: password generation Pin
quiteSmart14-Jan-07 23:46
quiteSmart14-Jan-07 23:46 
GeneralRe: password generation Pin
Russell Jones14-Jan-07 23:53
Russell Jones14-Jan-07 23:53 
AnswerRe: password generation Pin
V.15-Jan-07 1:18
professionalV.15-Jan-07 1:18 

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.