asp:DetailsView

最新推荐文章于 2021-06-25 23:53:19 发布

转载最新推荐文章于 2021-06-25 23:53:19 发布 · 188 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/sandy_liao/archive/2010/06/02/1750211.html

博客介绍了Microsoft用户控件asp:DetailsView与asp:SqlDataSource的协作。阐述了asp:dataSource过滤数据库的多种方法，如使用FilterExpression和FilterParameters、OnSelecting事件及SelectParameters等，还提及了asp:DetailsView与asp:sqldatasource的相关操作，如设置模式和插入参数等。

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

Microsoft User control asp:DetailsView Co-operation with asp:SqlDataSource

1. asp:dataSource have many way to filter database

First solution is :

<...

                 FilterExpression=" textname = '{0}' ">
                <FilterParameters>
                    <asp:ControlParameter ControlId="textname " PropertyName="SelectedValue"/>
                </FilterParameters> when the anto dropdownlist refresh which selectedvalue will be working on.

Second solution is :

<.....

                 OnSelecting="dataResources_Selecting">
                <SelectParameters>
                    <asp:ControlParameter ControlID="txt" Name="text" PropertyName="Text"
                        DefaultValue="%" />
                    <asp:QueryStringParameter Name="txt1" QueryStringField="txt1" />
                </SelectParameters>

protected void dataResources_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{ ...... }

third solution strainghtaway

2. asp:DetailsView with asp:sqldatasource have

DetailsView1.DefaultMode = DetailsViewMode.Insert; / Update

SqlDataSource1.InsertParameters

SqlDataSource1.Insert()

转载于:https://www.cnblogs.com/sandy_liao/archive/2010/06/02/1750211.html