当前位置:编程学习 > C#/ASP.NET >>

SqlDataSource参数化查询时,怎样实现点击button,根据textbox内容刷新gridview


        <tr>
            <td style="text-align: justify">
                车牌号码:            
                <asp:TextBox ID="car_p_input" runat="server"></asp:TextBox>
                    <asp:Button ID="car_cha" runat="server" Text="查询"  />
                           </td>
        </tr>
        <tr>
            <td>
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    DataKeyNames="car_p" DataSourceID="SqlDataSource1" AllowPaging="True" 
                    Width="875px">
                    <Columns>
                        <asp:BoundField DataField="car_p" HeaderText="车牌号" ReadOnly="True" 
                            SortExpression="car_p" />
                        <asp:BoundField DataField="car_user" HeaderText="车辆所有者" 
                            SortExpression="car_user" />
                        <asp:BoundField DataField="car_brand" HeaderText="车辆品牌" 
                            SortExpression="car_brand" />
                        <asp:BoundField DataField="car_insure_id" HeaderText="保险单号" 
                            SortExpression="car_insure_id" />
                        <asp:BoundField DataField="car_machine_id" HeaderText="发动机号" 
                            SortExpression="car_machine_id" />
                        <asp:HyperLinkField DataNavigateUrlFields="car_p" 
                            DataNavigateUrlFormatString="car_infor_edit.aspx?car_p{0}" HeaderText="详细" />
                        <asp:CommandField ShowDeleteButton="True" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:YJGL_dataConnectionString %>" 
                    
                    SelectCommand="SELECT [car_p], [car_user], [car_brand], [car_insure_id], [car_machine_id] FROM [car_infor] WHERE ([car_infor].[car_p]=@car_p OR @car_p=-1)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="car_p_input" DefaultValue="-1" Name="car_p" 
                            PropertyName="Text" />
                        <asp:Parameter />
                    </SelectParameters>
                </asp:SqlDataSource>
                
            </td>
        </tr>
        <tr>
            <td>
                 </td>
        </tr>
    </table>
</asp:Content>

界面上我放置了一个textbox控件,一个button控件,一个gridwiew控件,gridview已经配置了数据源,要怎样实现点击button,gridview里根据textbox里的输入显示相应内容?入门级新手,希望能讲解详细点,如果要添加代码的话,希望能告诉我添哪里,代码内容是什么~~~ GridView ASP 控件 --------------------编程问答--------------------
这是界面截图 --------------------编程问答--------------------
 不需要sqlDatasoucse
 在后台page_load里面绑定初始数据源到gridview控件。
 点击按钮事件car_cha事件里面进行数据的重新绑定到gridview控件然后显示

新手愚见 --------------------编程问答--------------------

protected void Button1_Click(object sender, EventArgs e)
    {

        string cx = "select * from 表 where 车牌号TEXT='" + TextBox1.Text + "'";
            SqlDataSource1.SelectCommand = cx;     
        GridView1.DataSourceID = "SqlDataSource1";
        GridView1.DataBind();
    }
--------------------编程问答--------------------
引用 3 楼 asdp26266 的回复:

protected void Button1_Click(object sender, EventArgs e)
    {

        string cx = "select * from 表 where 车牌号TEXT='" + TextBox1.Text + "'";
            SqlDataSource1.SelectCommand = cx;     
        GridView1.DataSourceID = "SqlDataSource1";
        GridView1.DataBind();
    }

车牌号TEXT 是数据库里那个车牌号的列名 --------------------编程问答-------------------- 点击重新获取数据。。重新绑定
补充:.NET技术 ,  ASP.NET
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,