MySQL Forums
Forum List  »  MySQL for Visual Studio

IMPORTANT UPDATE Re: Visual Studio dataset designer Insert and Update parameters
Posted by: Mario Kopljar
Date: May 03, 2020 11:07AM

To make it more clear:

UPDATE u_profile
SET u_username = @p1, u_password = @p2, u_fullname = @p3, u_identitytype = @p4, ...

This fails when bound to FormView,

BUT THIS WILL WORK FINE:

UPDATE u_profile
SET u_username = @u_username, u_password = @u_password, u_fullname = @u_fullname, u_identitytype = @u_identitytype, ...


So is there a way to customize or change AutogerenatenName ?

<Parameter AllowDbNull="true" AutogeneratedName="p1" ColumnName="u_username" DataSourceName="safetyfirst.u_profile" DataTypeServer="varchar(50)(50)" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="u_username" SourceColumnNullMapping="false" SourceVersion="Current" />

??

Options: ReplyQuote


Subject
Views
Written By
Posted
IMPORTANT UPDATE Re: Visual Studio dataset designer Insert and Update parameters
133
May 03, 2020 11:07AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.