关于ASPxGridView的默认查询条件

ASPxGridView 查询

解决方案 »

  1.   

    改别人的半成品,之前也没参与过这个项目,改起来好费劲啊,这个插件应该是自带了ajax功能的.
      

  2.   

    ASPX中GridView控件默认查询条件示例
    //GridView设置显示数据
    <asp:GridView ID="gvGoodsInfo" runat="server" CellPadding="4" 
                    ForeColor="#333333" GridLines="None" Font-Size="9pt" 
                    AutoGenerateColumns="False" AllowPaging="True" PageSize="8" 
                    OnPageIndexChanging="gvGoodsInfo_PageIndexChanging" Width="450px">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                    <EditRowStyle BackColor="#999999" />
                    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#CBCF7A" ForeColor="Black" HorizontalAlign="Right" />
                    <HeaderStyle BackColor="#CBCF7A" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                    <Columns>
                        <asp:BoundField DataField="PicId" HeaderText="商品ID" />
                        <asp:BoundField DataField="PicType" HeaderText="所属类别" />
                        <asp:BoundField DataField="GoodsStock" HeaderText="库存量" />
                        <asp:BoundField DataField="PicName" HeaderText="商品名称" />
                        <asp:HyperLinkField HeaderText="详细信息" Text="详细信息" DataNavigateUrlFields="PicId" 
                            DataNavigateUrlFormatString="EditGInfo.aspx?GoodsID={0}" Target="mainframe" 
                            NavigateUrl="~/MemberManage/EditGInfo.aspx" >
                            <ControlStyle Font-Underline="False" ForeColor="Black" />
                            <ItemStyle Font-Underline="False" ForeColor="Black" />
                            <HeaderStyle Font-Underline="False" ForeColor="Black" />
                        </asp:HyperLinkField>
                    </Columns>
                </asp:GridView><br />
    //加载绑定数据控件显示数据库默认条件查询数据
      SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        protected void Page_Load(object sender, EventArgs e)
        {
            string sqlstr = "select top 10 * from tbPicture where tbContel=1 order by tbDate desc"; //按时间降序且权限为1的在顶部默认显示10条数据实时更新 执行查询操作的SQL语句
            sqlcon.Open();//打开数据库连接
            SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);//创建数据阅读器
            DataSet myds = new DataSet();                           //创建数据集
            myda.Fill(myds);                                        //填充数据集
            gvGoodsInfo.DataSource = myds;                          //设定数据源
            gvGoodsInfo.DataBind();                                 //绑定数据
            sqlcon.Close();                                         //关闭数据库连接
        }
      

  3.   

    数据行绑定
    this.ASPxGridView1.DataSource = currentDs.Tables["test"];
    this.ASPxGridView1.DataBind();
      

  4.   

    标题排序
      ASPxGridView1_BeforeColumnSortingGrouping 事件里面
    参考 http://wwwluo.blog.163.com/blog/static/612902312010102511549784/
      

  5.   

    额,我没说明白,我想说的那个数据行绑定相当于gridview里的RowDataBound的那个事件.在aspxgridview中是哪个..麻烦你乐