G
Guest
I have been trying to get a grasp on how I can use a sqlserver storedproc as
the UpdateCommand of a Dataview.
The control (datview / SqlDatasource / Edit control) works great when you
supply it with an adhoc sql statement (somthing that I dont' like to do for
many reasons) and populating the select part with a storedproc works well
also, however I have been unable to find a way to get the update to work with
a paramitized storedproc.
Any clues would be welcome.! (if it just isn't possible could someone also
post that and save me hours of bashing my head against the wall!)
Thanks
Rob
the UpdateCommand of a Dataview.
The control (datview / SqlDatasource / Edit control) works great when you
supply it with an adhoc sql statement (somthing that I dont' like to do for
many reasons) and populating the select part with a storedproc works well
also, however I have been unable to find a way to get the update to work with
a paramitized storedproc.
Any clues would be welcome.! (if it just isn't possible could someone also
post that and save me hours of bashing my head against the wall!)
Thanks
Rob