Hello everybody,
I am very new to VWD and I am having difficulty in passing default values to the INSERT command.
Using a FormView, certain values to be added to each new record will remain the same for every record and will come from either the Profile values or from a user related table (The same table that populates my SELECT query).
Now it is easy enough to set the text of a textbox to be say, Profile.Address1 but I then need to use this value as an update parameter value for the new row (INSERT Address1 Value @Address1)
If I set the textbox to bind to the table, I cannot also then allocate some other text to this textbox.
Hope someone can help or point me to a good example.
Thanks.