<div>
<div class="content wysiwyg-content">
I'm haveing a problem updateing the smalldatetime column in SQL server 2000.<br />
i'm using C# asp.net<br />
<br />
The command string looks like<br />
string UpdateString= &quot;INSERT INTO RISK_SCR (DateSCR, IMP, PROB) VALUES (&quot; + DateTime.Now.ToShortDateSt<wbr />ring() + &quot;,3,4)&quot;;<br />
<br />
The output of the string looks like<br />
INSERT INTO RISK_SCR (DateSCR, IMP, PROB) VALUES (11/20/2004,3,4) <br />
<br />
All good right??<br />
I'm catching the sqlexception and it pass and it updated the DB ...BUT in the smalldatetime column DateSCR it is defaulting to 1/1/1900, the default if nothing is entered.<br />
<br />
kinda of strange that it updates with out a problem but doesn't update the smalldatetime column.
</div>
</div>


I'm haveing a problem updateing the smalldatetime column in SQL server 2000.
i'm using C# asp.net

The command string looks like
string UpdateString= "INSERT INTO RISK_SCR (DateSCR, IMP, PROB) VALUES (" + DateTime.Now.ToShortDateString() + ",3,4)";

The output of the string looks like
INSERT INTO RISK_SCR (DateSCR, IMP, PROB) VALUES (11/20/2004,3,4) 

All good right??
I'm catching the sqlexception and it pass and it updated the DB ...BUT in the smalldatetime column DateSCR it is defaulting to 1/1/1900, the default if nothing is entered.

kinda of strange that it updates with out a problem but doesn't update the smalldatetime column.

DateTime.Now.ToShortDateString() and smalldatetime c#

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.