Updating password parameter linqdatasource onupdating event
ALTER PROCEDURE users_Update Faculty @EMAIL NVARCHAR(100), @ISLOCKEDOUT BIT, @MOBILENUMBER BIGINT, @USERNAME nvarchar(100) AS BEGIN UPDATE aspnet_Users SET [email protected] where [email protected] UPDATE ASPNET_MEMBERSHIP SET EMAIL = @EMAIL, LOWEREDEMAIL = LOWER(@EMAIL), [email protected] WHERE USERID = (SELECT USERID FROM ASPNET_USERS WHERE [email protected]) END Found the solution: The Select Columns and the Update Parameters should match in order to update using Sql Data Source, that means if you select(query or procedure) is returning 3 fields in gridview, then all of them should be the parameter for the update, you can miss out the actual updations in database if not required, but the I dont think your solution is OK, since I have to use the atribute Old Values Parameter Format String="original_" that means that I would have doble parameters, the ones with the original values and the ones with edited values. I have 4 parameters, Im getting the right values for 2 of them, an null at the others.
Read this: The order of the parameters in the Update Parameters collection might be important, depending on the ADO.
then switch to preview tab and I haven't tried this myself, but I saw an example where they configured Available Values to come from a query, then used an expression to specify the query.
The expression included the value of the first parameter.
You must define some environment variables before installing Oracle Database.
Asynchronous I/O is available only with Automatic Storage Management disk group which uses raw partitions as the storage option for database files.
The character set specified by Specifies the search path for files used by Oracle applications such as SQL*Plus.