none
Auto updating of Data to SQL Server 2005 with VB.NET RRS feed

  • Question

  • I'm writing a VB.NET Database application, and as a part of this I want the data to automatically be written to the database when the datatable is updated. So, to do this, I added the code:
    Me.StockTableAdapter.Update(Me.EmbDataSet.Stock)
    to the event
    StockBindingSource_ListChanged

    This code works a treat, for the first change. After the first change, however, I get the error "Column 'Code' does not allow nulls."

    Now I dont know why. Can anyone help me? Am I going about this wrong? Is there another way of updating data to the database automatically?
    Wednesday, July 25, 2007 12:18 PM