I'm going to start out by saying I'm still pretty new to this. I had done some searching on the web before I posted, but my situation doesn't exactly match what others have experienced.
I've written a BLL that does an update through an DS and the control is a FormView. When I do an insert function, all the fields I insert data into gets inserted into the DB (verified). When I go to test an update call, all the fields but one updates. To make it more interesting, the content is completely wiped from the database, no error given. I've deleted and recreated the datatable, the query in the table, the BLL and dropped and recreated the dbo table in SQL - all to no avail. I'm doing dev in VS 2k10 x64.
<System.ComponentModel.DataObjectMethod(ComponentModel.DataObjectMethodType.Update, False)> _
Public Function ProjectUpdate(ByVal projectID As Integer, ByVal projectDescription As String, ByVal samplesDueDate As Nullable(Of DateTime), ByVal projectStatus As String, _
ByVal projectDateClosed As Nullable(Of DateTime), ByVal projectProducts As String, ByVal projectComponents As String, _
ByVal projectFormula As String, ByVal projectCompWeight As String, ByVal projectCount As String, ByVal projectNetWeight As String, _
View Complete Post