数据库:Northwind
Table :Categories
下面的操作将实现下图中的功能
- 列表中的数据可以根据查询条件而改变
- 列表中可进行编辑,删除,选中操作
- 选中某条数据后,Details中显示详细信息
- 在详细信息显示区域,可进行新增,编辑,删除操作
这是一个非常常见的数据维护页面,在asp.net1.1中要实现以上操作,还是有一定的编码工作量,如果数据底层封装得比较好,或是使用了ORM,那么这个页面在1.1下估计是2个小时完成,而使用asp.net 2.0,10分钟搞定。
1. 新建一个SqlDataSource
<
asp:SqlDataSource
ID
="SqlDataSource1"
runat
="server"
ConnectionString
="<%$ ConnectionStrings:NorthwindConnectionString %>"
DeleteCommand ="DELETE FROM [Categories] WHERE [CategoryID] = @CategoryID"
InsertCommand ="INSERT INTO [Categories] ([CategoryName], [Description]) VALUES (@CategoryName, @Description)"
SelectCommand ="SELECT [CategoryID], [CategoryName], [Description], [Picture] FROM [Categories] WHERE CategoryName LIKE '%'+@CategoryName+'%'"
UpdateCommand ="UPDATE [Categories] SET [CategoryName] = @CategoryName, [Description] = @Description WHERE [CategoryID] = @CategoryID" >
< SelectParameters >
<
DeleteCommand ="DELETE FROM [Categories] WHERE [CategoryID] = @CategoryID"
InsertCommand ="INSERT INTO [Categories] ([CategoryName], [Description]) VALUES (@CategoryName, @Description)"
SelectCommand ="SELECT [CategoryID], [CategoryName], [Description], [Picture] FROM [Categories] WHERE CategoryName LIKE '%'+@CategoryName+'%'"
UpdateCommand ="UPDATE [Categories] SET [CategoryName] = @CategoryName, [Description] = @Description WHERE [CategoryID] = @CategoryID" >
< SelectParameters >
<