Click here to Skip to main content
15,887,596 members
Home / Discussions / C#
   

C#

 
GeneralRe: SMTP Error Pin
Ashish Derhgawen6-Feb-08 4:31
Ashish Derhgawen6-Feb-08 4:31 
GeneralDBNull in Tpyed Datasets Pin
topcatalpha6-Feb-08 2:41
topcatalpha6-Feb-08 2:41 
GeneralRe: DBNull in Tpyed Datasets Pin
Justin Perez6-Feb-08 2:44
Justin Perez6-Feb-08 2:44 
GeneralRe: DBNull in Tpyed Datasets Pin
topcatalpha6-Feb-08 2:53
topcatalpha6-Feb-08 2:53 
GeneralRe: DBNull in Tpyed Datasets Pin
Justin Perez6-Feb-08 2:57
Justin Perez6-Feb-08 2:57 
GeneralRe: DBNull in Tpyed Datasets Pin
topcatalpha6-Feb-08 3:02
topcatalpha6-Feb-08 3:02 
GeneralRe: DBNull in Tpyed Datasets Pin
Justin Perez6-Feb-08 3:14
Justin Perez6-Feb-08 3:14 
GeneralRe: DBNull in Tpyed Datasets Pin
topcatalpha6-Feb-08 3:34
topcatalpha6-Feb-08 3:34 
Found something :


[^]

i need to check each field for null and pass null value myself. Seems very unlogic to me knowning that SQL servers allow DBnull values in tables.

Ex :

<br />
 if(Table1Row.IsID2Null())<br />
                    ATDatabase.AddInParameter(updateCommand, "ID2", DbType.Int32, null);<br />
                else<br />
                    ATDatabase.AddInParameter(updateCommand, "ID2", DbType.Int32, Table1Row.ID2);


Checking the auto generated code from the typed dataset:

[System.Diagnostics.DebuggerNonUserCodeAttribute()]<br />
           public long ID2 {<br />
               get {<br />
                   try {<br />
                       return ((long)(this[this.Table1.ID2Column]));<br />
                   }<br />
                   catch (System.InvalidCastException e) {<br />
                       throw new System.Data.StrongTypingException("The value for column \'ID2\' in table \'Table1\' is DBNull.", e);<br />
                   }<br />
               }<br />
               set {<br />
                   this[this.Table1.ID2Column] = value;<br />
               }<br />
           }


Cannot pass null value here...

greetz

Kurt
GeneralRe: DBNull in Tpyed Datasets Pin
J4amieC6-Feb-08 4:43
J4amieC6-Feb-08 4:43 
GeneralRetrieve from MSAccess Pin
Star096-Feb-08 2:38
Star096-Feb-08 2:38 
GeneralRe: Retrieve from MSAccess Pin
sathish s6-Feb-08 2:45
sathish s6-Feb-08 2:45 
GeneralRe: Retrieve from MSAccess Pin
Justin Perez6-Feb-08 2:48
Justin Perez6-Feb-08 2:48 
Generalwebbrowser control problem Pin
Russell Jones6-Feb-08 2:34
Russell Jones6-Feb-08 2:34 
GeneralRe: webbrowser control problem Pin
led mike6-Feb-08 5:14
led mike6-Feb-08 5:14 
GeneralRe: webbrowser control problem Pin
Russell Jones6-Feb-08 5:32
Russell Jones6-Feb-08 5:32 
GeneralRe: webbrowser control problem Pin
led mike6-Feb-08 5:43
led mike6-Feb-08 5:43 
Questionhow to get all child node from perticular node of xml file in c# .net Pin
dudhat6-Feb-08 1:05
dudhat6-Feb-08 1:05 
AnswerRe: how to get all child node from perticular node of xml file in c# .net Pin
Mircea Puiu6-Feb-08 1:08
Mircea Puiu6-Feb-08 1:08 
Questionincompatibility vlc-Axis w.r.t. rtsp basic authentication ? Pin
Aparna.B6-Feb-08 0:52
Aparna.B6-Feb-08 0:52 
QuestionHow to execute Batch of command in MS_DOS(CMD) Pin
Sanjitrajbanshi6-Feb-08 0:35
Sanjitrajbanshi6-Feb-08 0:35 
AnswerRe: How to execute Batch of command in MS_DOS(CMD) Pin
DaveyM696-Feb-08 1:56
professionalDaveyM696-Feb-08 1:56 
QuestionHow to write code or Upload a file in c# Pin
kalyan12115-Feb-08 23:48
kalyan12115-Feb-08 23:48 
GeneralRe: How to write code or Upload a file in c# Pin
N a v a n e e t h6-Feb-08 0:35
N a v a n e e t h6-Feb-08 0:35 
QuestionSecure single sign on/automatic login [modified] Pin
samcyp115-Feb-08 23:06
samcyp115-Feb-08 23:06 
GeneralMDI Problem Pin
murali_utr5-Feb-08 22:43
murali_utr5-Feb-08 22:43 

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.