Last post Oct 22, 2012 03:30 PM by limno
Oct 19, 2012 02:01 PM|RSquared|LINK
For example I already am using a sqldatsource to populate a dropdownlist. But I need to make an update to the current row when the user selects a record. Do I need to have another sqldatasource with a stored procedure that I created to handle updateing the
record? Thanks !!!
Another sort of side issue. But why is it that when I update the currently selected item in the dropdownlist. The value that was selected nom longer shows in the dropdown list? Thanks !!!
Oct 20, 2012 08:37 PM|Decker Dong - MSFT|LINK
As far as I see, Any data presentation control can only have one DataSource.
Oct 20, 2012 08:38 PM|Decker Dong - MSFT|LINK
But why is it that when I update the currently selected item in the dropdownlist. The value that was selected nom longer shows in the dropdown list?
What codes have you written？
Oct 22, 2012 06:11 AM|sureshkumar.gundala|LINK
You need not have to use another datasource control to update. Rather modify your stored procedure with if..else block.
Do select * from using current ID. If count >1 update else if count = 0 insert.
Oct 22, 2012 03:30 PM|limno|LINK
There is a updatecommand for your same sqldatasource.