StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POasp.net parameter update reports 1 row updated but no data in table added
primarykey
Id
7755777
data
AcceptedAnswerId
13708360
AnswerCount
4
ClosedDate
CommentCount
11
CommunityOwnedDate
CreationDate
2011-10-13T14:34:29.677
FavoriteCount
0
LastActivityDate
2012-12-04T17:17:05.563
LastEditDate
2011-10-13T16:04:52.847
LastEditorUserId
873448
OwnerUserId
873448
ParentId
0
PostTypeId
1
Score
0
ViewCount
257
LastEditorDisplayName
text
Body
I am getting an incorrect repsonse after an update to a table. In my RowUpdating event I have the following code which builds an Update Parameter to call an SP to update a table. I must be doing something wrong but everything runs fine. My rowsAffected variable reports 1 after the update, but the table never gets the data. Here is the relevant code behind in RowUpdating event. The values are correctly populated in the parameters as well. <pre><code>itemDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("myConnString").ToString() itemDataSource.UpdateCommandType = SqlDataSourceCommandType.StoredProcedure itemDataSource.UpdateCommand = "usp_updatePTT" ' Call stored procedure 'Establishes value of Primary key and String sent to SP itemDataSource.UpdateParameters.Add("ID", updateKey) itemDataSource.UpdateParameters.Add("lang_String", updateString) Dim rowsAffected As Integer = 0 rowsAffected = itemDataSource.Update() GridView4.DataBind() </code></pre> and here is the SP.... <pre><code>@ID int, @lang_String nvarchar(1000) AS /* SET NOCOUNT ON */ BEGIN UPDATE tblLangROOTptt SET lang_String = @lang_String WHERE (ID = @ID) END RETURN </code></pre> Any suggestions would be appreciated... thanks, UPDATE: I found a solution that is working. On the original DataSource for the update command I needed to add the following.... <pre><code>UpdateCommand="EXEC usp_updatePTTrootString @ID=@original_ID, @lang_String=@lang_string" > </code></pre> This in essence allows the original data source to call the SP. Note: that the command type needs to stay as TEXT not Stored Procedure as one might think.
Tags
<asp.net><vb.net><tsql>
Title
asp.net parameter update reports 1 row updated but no data in table added
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UShtm11h
UserOwnerUserId
1. UShtm11h
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.