Default value in SQL table not set after addto

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > ASP.NET 4 General Discussion
Default value in SQL table not set after addto

ASP.NET 4 General Discussion For ASP.NET 4 discussions not relating to a specific Wrox book

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 4 General Discussion section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 6th, 2011, 03:47 PM

avidan

Authorized User

Join Date: Nov 2010

Posts: 63

Thanks: 3

Thanked 0 Times in 0 Posts

Default value in SQL table not set after addto

Hello
I have set in a table a column field as int and set its default value as ((0)). When adding a row trough VB (with the myentity.addtotables(table) method), the default value is not set (the content of the column is Null). But when adding manually (through the server explorer) the default value is set. Any idea?
Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nested Loops in SQL Query values from table/set	miamikk	SQL Server 2000	1	August 31st, 2007 12:35 AM
how do i set default parameter value..	rupen	Classic ASP Basics	5	January 5th, 2007 12:14 AM
how to set up system time as default for SQL 2000	rainman12	SQL Server 2000	0	October 28th, 2005 10:14 PM
how to set parameter default value	oranginalab	Classic ASP Basics	0	August 28th, 2003 02:53 AM