asp.net 学习笔记[02] 便捷数据邦定 -优快云博客

本文链接：https://blog.youkuaiyun.com/ermen/article/details/1755381

本文介绍ASP.NET中的DataSource控件，该控件简化了数据绑定过程，通过设置参数即可实现数据的增删改查操作，无需编写复杂的连接代码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

便捷数据邦定

DataSource控件

将并行操作变为串行操作，并且连接方便。不需要i编写连接代码

该控件可以通过设置参数对数据进行操作

代码例子：

< asp:SqlDataSource ID = " SqlDataSource1 " runat = " server " ConflictDetection = " CompareAllValues "

ConnectionString = " <%$ ConnectionStrings:pubsConnectionString %> " DeleteCommand = " DELETE FROM [authors] WHERE [au_id] = @original_au_id AND [au_lname] = @original_au_lname AND [au_fname] = @original_au_fname AND [phone] = @original_phone AND [address] = @original_address AND [city] = @original_city AND [state] = @original_state AND [zip] = @original_zip AND [contract] = @original_contract "

InsertCommand = " INSERT INTO [authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (@au_id, @au_lname, @au_fname, @phone, @address, @city, @state, @zip, @contract) "

SelectCommand = " SELECT * FROM [authors] " UpdateCommand = " UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [phone] = @phone, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip, [contract] = @contract WHERE [au_id] = @original_au_id AND [au_lname] = @original_au_lname AND [au_fname] = @original_au_fname AND [phone] = @original_phone AND [address] = @original_address AND [city] = @original_city AND [state] = @original_state AND [zip] = @original_zip AND [contract] = @original_contract " >

< DeleteParameters >

< asp:Parameter Name = " original_au_id " Type = " String " />

< asp:Parameter Name = " original_au_lname " Type = " String " />

< asp:Parameter Name = " original_au_fname " Type = " String " />

< asp:Parameter Name = " original_phone " Type = " String " />

< asp:Parameter Name = " original_address " Type = " String " />

< asp:Parameter Name = " original_city " Type = " String " />

< asp:Parameter Name = " original_state " Type = " String " />

< asp:Parameter Name = " original_zip " Type = " String " />

< asp:Parameter Name = " original_contract " Type = " Boolean " />

</ DeleteParameters >

< UpdateParameters >

< asp:Parameter Name = " au_lname " Type = " String " />

< asp:Parameter Name = " au_fname " Type = " String " />

< asp:Parameter Name = " phone " Type = " String " />

< asp:Parameter Name = " address " Type = " String " />

< asp:Parameter Name = " city " Type = " String " />

< asp:Parameter Name = " state " Type = " String " />

< asp:Parameter Name = " zip " Type = " String " />

< asp:Parameter Name = " contract " Type = " Boolean " />