CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!



Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.portal_starter_kit Tags:
Item Type: NewsGroup Date Entered: 5/10/2004 7:13:57 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 121 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
cheong
Asp.Net User
How to insert null value to date field ?5/10/2004 7:13:57 AM

0/0

if ExpireField.Text is no input value,
then DateTime.Parse(ExpireField.Text) will error,

so how to insert null value to date field ??

-----------------------------------
Private Sub UpdateBtn_Click(ByVal sender As Object, ByVal e As EventArgs) Handles updateButton.Click
..............

' Add the event within the Events table
events.AddEvent(moduleId, itemId, Context.User.Identity.Name,

TitleField.Text, DateTime.Parse(ExpireField.Text), DescriptionField.Text, WhereWhenField.Text)

................
End Sub
doctorallia
Asp.Net User
Re: How to insert null value to date field ?5/12/2004 3:29:48 PM

0/0

make sure the DB will allow nulls.
socrates
2 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Oracle9i Development by Example Authors: Dan Hotka, Pages: 620, Published: 2002
Crystal Reports 8.5: The Complete Reference Authors: George Peck, Pages: 799, Published: 2001
MySQL: The Complete Reference Authors: Vikram Vaswani, Monty Widenius, Pages: 537, Published: 2003
PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide Authors: Larry Edward Ullman, Pages: 572, Published: 2003
Oracle Design: The Definitive Guide Authors: Dave Ensor, Ian Stevenson, Pages: 526, Published: 1997
MySQL Client-Server Applications with Visual FoxPro Authors: Whil Hentzen, Ted Roche, Pages: 414, Published: 2007
Microsoft Office Access 2003: The Complete Reference Authors: Virginia Andersen, Pages: 719, Published: 2003
Practical Django Projects Authors: James Bennett, Pages: 256, Published: 2008
Programming the Perl DBI: Database Programming with Perl Authors: Alligator Descartes, Tim Bunce, Pages: 346, Published: 2000
ColdFusion MX Developer's Handbook Authors: Raymond Camden, Arman Danesh, Hal Helms, Guy Rish, Emily Kim, Shlomy Gantz, Jen deHaan, Peter deHaan, Selene Bainum, Charles Mohnike, John Colasante, William Baum, Kenneth N. Fricklas, Matt Liotta, Pages: 940, Published: 2003

Web:
Enter Null Values for DateTime Column of SQL Server Inserting a null value to the DateTime Field in SQL Server is one of the most ... sqlStmt = "insert into Emp (FirstName,LastName,Date) Values (@FirstName ...
How to assign a null value to a date variable - .NET assign a null value to vb.net date variable so that when the date field is blank a null value is inserted by my SQL insert statment. many thanks, ...
Insert null into Date field in Database | Tech Off | Channel 9 Insert null into Date field in Database. Posted By: Riaz | May 8th, 2006 @ 4:44 PM. page 1 of 1. Comments: 8 | Views: 8421. Delete Edit Reply ...
About Insert Null to DateTime Field Old 11-11-2003, 12:25 AM. Default About Insert Null to DateTime Field. When I using dataset to append a null value to the datetime field. ...
how to insert null in DateTime Field with Access Driver - MSDN Forums finally , how can i add null value in DateTime field? ... OleDbCommand command= new OleDbCommand("INSERT INTO MyTable VALUES(null)",connection); ...
How to insert NULL in int and datetime field from VB - ITtoolbox ... Apr 3, 2005 ... How should I code to send NULL in integer and datetime field in VB. insert into t1(f1, f2, f3) values('NULL', ?, ? ) Regsrda, MRL ...
About Insert Null to DateTime Field - .NET ASP i use the following to insert NULL into datetime field and it works Object. DateTimeField = DBNull.Value; ofcourse the field should be able ...
Inserting NULL into ms sql 2005 datetime field How to i insert a null field into a ms sql 2005 date/time field? All I get is it inserting the value 01/1/1900. Thanks! ...
Insert Null Value into DateTime Field Errors - ASP.NET Forums Maybe because your Date Field in the the database is NOT Nullable that's why will not accept null or empty values.. So instead of inserting ...
RE: Adding a NULL value in DateTime field..... Date Else dtActivation = NULL End If after this i will make the SQL string and execute. (Qusestion is how to insert the NULL value in the dateTime field, ...

Videos:
Using Static Analysis For Software Defect Detection Google TechTalks July 6, 2006 William Pugh ABSTRACT I'll talk about some of my experience in using and expanding static analysis tools for defect d...
Debugging Backwards in Time Google TechTalks January 11, 2006 Bil Lewis Bil Lewis is a computer scientist who has worked on natural language understanding, expert systems, lan...




Search This Site:










i have problem installing starter portal kit in my home pc

using both windows authentication and forms authentication, how?

portal security in new aspx pages

free on-the-fly powerpoint converter (on-line slideshows) module

tabs don't work

tdn streamreader for dnn

.net newbie -- how does productdetails.aspx know about the productsdb file?

problem to test ibuyspy on localhost. help!!!!!!!!!!

login failed for user 'nt authority\network service

bug : tabs don't move; new tabs have bad tab oder

copy right

does anyone have any documentation on the siteconfiguration class?

runtime error on my machine, but not on the web server itself

newbie locked himself out of the site! help!

format of html module

"discussions" module doesn't work

cant view code

running the application on my machine

skinnable ibs/dnn ready, based on davids posted sample only with a lot of things added and fully adminnable

importing users into the portal database

no admin tab shown to initial portal user

authenticating intranet users

remote sql server connection

email notification from discussion module?

select one instance of sql server

not recognizing my sql server instance during instalation

converting dnn modules to work with standard ibs

how to implement registered user(s) predefine role when user register?

portal.xml file

inconsistent use of sqldatareader.close() when returning from xxxdb.cs classes

  Privacy | Contact Us
All Times Are GMT