LoadDataRow - Attempt 2

payork

New Member
Hey Gang, <BR><BR>I've posted on this before w/o much luck, but have any of you successfully gotten LoadDataRow to work with a datatable? According to MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatatableclassloaddatarowtopic.asp) LoadDataRow is supposed to look in a datatable for a matching value in the primary key column. If it exists it updates the row, if not it inserts it. The insert is working correctly, but the update is not, it just does nothing. <BR><BR>Here is the function:<BR><BR>protected function loadLinks(pageID AS integer)<BR> dim pageSet AS dataSet = Session("sitePages" & session.Sessionid)<BR> dim linkTable AS dataTable = pageSet.Tables("linkTable")<BR> dim myRow AS dataRow<BR> <BR> dim updArray(3) AS object<BR> updArray(0) = nothing <BR> updArray(1) = curSlotID.Value <BR> updArray(2) = pageID<BR> updArray(3) = lstTemplates.SelectedItem.Value<BR><BR> linkTable.BeginLoadData()<BR> myRow = linkTable.LoadDataRow(updArray, false)<BR> linkTable.EndLoadData()<BR> linkTable.AcceptChanges()<BR> <BR> Session("sitePages" & session.Sessionid) = pageSet<BR>end function<BR><BR>In the linkTable dataTable the columns are as follows: <BR><BR>linkID (autoincrement=true, dbnull=false)<BR>slotID (primaryKey, dbnull=false)<BR>pageID (dbnull=false)<BR>templateID (dbnull=false)<BR><BR>All of these are of Int32 datatype. <BR><BR>Any ideas?<BR><BR>Thanks again,<BR><BR>])ry
 
Back
Top