error in appending record from vb 2010.net4 in phpmysql

Posted 10 October 2012 - 08:17 AM

the following error code is vb 2010 with phpmysql

Column 'shcode' cannot be null

this happens for fields in the table

begining of code

Dim cb As New MySqlCommandBuilder(sharemain.daAddMem)

cb.GetInsertCommand.CommandText = ("INSERT INTO `sgtmdatawamp`.`memvbaddr` (`shcode`, `idno`, `pfolno`, `shname`, `shstreet`, `sharea`, `shcity`, `shstate`, `shjoint1`, `shjoint2`, `shjoint3`, `shitpan`, `itstatus`, `shmail`, `script`, `scriptno`, `noshare`, `remarks`, `photopath`, `scansign`) VALUES ('9068', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');")
 
cb.GetInsertCommand.ExecuteNonQuery()

ending of code

This post has been edited by modi123_1: 10 October 2012 - 08:19 AM
Reason for edit:: highlight the text and just click the 'code' button in the text editor