Hi guys:

I open AddEditArticle.aspx for adding a new article. but when i click the insert,
the error came out. If insert category, the same problem.

Server Error in '/' Application.
Cannot insert the value NULL into column 'ArticleID', table 'aspnetdb.dbo.tbh_Articles'; column does not allow nulls. INSERT fails.
The statement has been terminated.

and SQL server profiler said that:
declare @p16 int
set @p16=NULL
exec tbh_Articles_InsertArticle @AddedDate=''2009-11-02
09:15:27:140'',@AddedBy=N'wxt',@CategoryID=1,@Titl e=N'jl;',@Abstract=N'jl;',@Body=N'<p>&nbsp;jkl;</p>',@Country=N'Albania',@State=N'jkll;',@City=N'kl jl',@ReleaseDate=''2009-11-02
09:15:27:140'',@ExpireDate=''9999-12-31 23:59:59:997'',@Approved=0,@Listed=1,@CommentsEnab led=1,@OnlyForMembers=0,@[email protected] output
select @p16

i am confused the BLL and DAL insert function and store procedure are right, I just copy them from the code download here( insert without error). any help would be appreciate.

What do you have for Insert parameters in the objCurrentArticle ObjectDataSource?

Also, are you absolutely sure you have ArticleID set up in the database as an auto-incrementing Identity field?

__________________
Visit my blog at http://leedumond.com
Follow me on Twitter: http://twitter.com/LeeDumond

Lee Dumond
you are so brightness, my problem is i don't have ID set up as an auto-incrementing Identity field. I just correct it and running right, thanks a lot.

Yes, yes I am. Thanks for noticing.

__________________
Visit my blog at http://leedumond.com
Follow me on Twitter: http://twitter.com/LeeDumond