Mega Code Archive
Categories
/
ASP.Net Tutorial
/
Data Binding
Link DropDownList with SqlDataSource and do the editing
<%@ Page Language="C#" AutoEventWireup="true"%>
Record Editor
" SelectCommand="SELECT ProductName, ProductID FROM Products"/>
" SelectCommand="SELECT ProductID, ProductName, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued FROM Products WHERE ProductID=@ProductID" UpdateCommand="UPDATE Products SET ProductName=@ProductName, UnitPrice=CONVERT(money, @UnitPrice), UnitsInStock=@UnitsInStock, UnitsOnOrder=@UnitsOnOrder, ReorderLevel=@ReorderLevel, Discontinued=@Discontinued WHERE ProductID=@ProductID">
File: Web.config