Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

asp.net - MSSQL Query Error: "Cannot insert the value NULL into column <X>." -


alt text

following error occurs in /// coding "

cannot insert value null column 'boarding', table 'c:\users\vbi server\documents\visual studio 2008\websites\volvo\app_data\aspnetdb.mdf.dbo.boardingpt'; column not allow nulls. insert fails. statement has been terminated.

protected sub button1_click(byval sender object, byval e system.eventargs) handles button1.click         dim con new sqlconnection         dim cmd new sqlcommand         con.connectionstring = "data source=.\sqlexpress;attachdbfilename=|datadirectory|\aspnetdb.mdf;integrated security=true;user instance=true"         con.open()         cmd.connection = con         cmd.commandtext = "insert boardingpt (service, travelid, bdpt_name, time) values('" & trim(textbox3.text.tostring) & "', '" & trim(textbox4.text.tostring) & "', '" & trim(textbox1.text.tostring) & "','" & trim(textbox2.text.tostring) & "')"         cmd.executenonquery()         con.close()      end sub 

you need change column identity

or under ssms in column defintion select

table designer -> identity specification -> (is identity) true


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -