Inserting Database Record Using DataSource

Question

This code: Me .SqlDataSource1.InsertParameters( @term ) = New Parameter( @term  Data.DbType.AnsiString test ) Me .SqlDataSource1.InsertParameters( @definition ) = New Parameter( @definition  Data.DbType.AnsiString test ) Me .SqlDataSource1.Insert() Gives me this error: Cannot insert the value NULL into column 'term' table 'GeneralAssembly.dbo.tblGACMSGlossary'; column does not allow nulls. INSERT fails. The statement has been terminated. Insert code is defined in data source as InsertCommand =INSERT INTO [tblGACMSGlossary] ([term] [definition]) VALUES (@term @definition)

Algo Rhythm · Answer

Problem was the '@' symbols. Once I removed them it worked.

Abhimanyu K Vatsa · Answer

hey.... i think you are missing to use some lines like which control's data will be used to insert. like you have not used test.text look at this article [ here ] i hope it will work for you

Inserting Database Record Using DataSource

Cannot insert the value NULL into column 'term', table 'GeneralAssembly.dbo.tblGACMSGlossary'; column does not allow nulls. INSERT fails.The statement has been terminated.

Cannot insert the value NULL into column 'term', table 'GeneralAssembly.dbo.tblGACMSGlossary'; column does not allow nulls. INSERT fails.
The statement has been terminated.