gridview其中"序号"列升序排列

[hupanhong33]

gridview其中有一列是"序号"
这一列按升序排列
其它是绑定的数据库上的内容.
我现在添加了一列,下面能知道怎么弄了,
请问高人怎么实现?谢谢

[xutao888]

用第三方控件呀，比如Infragistics里面的gridView控件自带排序，代码都不用写

[jerrylyj]

<asp:GridView ID="GVMain" runat="server" CellPadding="4" OnSorting="GVMain_Sorting" OnRowEditing="GVMain_RowEditing" CssClass="GridView" OnRowDataBound="GVMain_RowDataBound">
                                   <Columns>
                                        <asp:BoundField DataField="id" HeaderText="编号" Visible="False" />
                                        <asp:TemplateField HeaderText="商家账号">
                                            <ItemTemplate>
                                                <a target="_blank" href="AddOrEditShop.aspx?id=<%# Eval("id") %>">
                                                    <%#Eval("shopid")%>
                                                </a>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:BoundField DataField="typename" HeaderText="类型" />
                                        <asp:TemplateField HeaderText="名称">
                                            <ItemTemplate>
                                                <a target="_blank" href="AddOrEditShop.aspx?id=<%# Eval("id") %>">
                                                    <%#Eval("shopname")%>
                                                </a>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:BoundField DataField="shopaddr" HeaderText="地址" />
                                        <asp:BoundField DataField="shoptel" HeaderText="电话" />
                                        <asp:BoundField DataField="shopper" HeaderText="联系人" />
                                        <asp:BoundField DataField="regtime" HeaderText="注册时间" SortExpression="regtime" />
                                        <asp:TemplateField HeaderText="是否首页" Visible="False">
                                            <ItemTemplate>
                                                <asp:Image ID="ImageIndex" runat="server" ImageUrl="../image/index.png" Visible='<%# ((DataBinder.Eval(Container.DataItem, "isindex").ToString()) != "否") %>'>
                                                </asp:Image>
                                            </ItemTemplate>
                                            <ItemStyle HorizontalAlign="Center" />
                                            <HeaderStyle Width="30px" />
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="是否推荐">
                                            <ItemTemplate>
                                                <asp:Image ID="ImagePop" runat="server" ImageUrl="../image/pop.png" Visible='<%# ((DataBinder.Eval(Container.DataItem, "ispop").ToString()) != "否") %>'>
                                                </asp:Image>
                                            </ItemTemplate>
                                            <ItemStyle HorizontalAlign="Center" />
                                            <HeaderStyle Width="30px" />
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="首页" ShowHeader="False" Visible="False">
                                            <ItemTemplate>
                                                <asp:LinkButton ID="LbtnIndex" runat="server" CausesValidation="False" CommandName="Edit"
                                                    Text="设置/取消"></asp:LinkButton>
                                            </ItemTemplate>
                                            <ItemStyle Width="60px" HorizontalAlign="Center" />
                                            <HeaderStyle Width="60px" />
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="推荐" ShowHeader="False">
                                            <ItemTemplate>
                                                <asp:LinkButton ID="LbtnPop" runat="server" CausesValidation="False" CommandName="Select"
                                                    Text="设置/取消"></asp:LinkButton>
                                            </ItemTemplate>
                                            <ItemStyle Width="60px" HorizontalAlign="Center" />
                                            <HeaderStyle Width="60px" />
                                        </asp:TemplateField>
                                        <asp:TemplateField HeaderText="删除" ShowHeader="False">
                                            <ItemStyle HorizontalAlign="Center" Width="40px" />
                                            <ItemTemplate>
                                                <asp:LinkButton ID="LBtnDel" runat="server" CausesValidation="False" CommandName="Delete"
                                                    OnClientClick="return confirm('您确定要删除?');" Text="<img src='../Image/del.gif' border=0/>"></asp:LinkButton>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                    </Columns>
                                </asp:GridView>

给个例子。。。后台代码获得一个dataset绑定到gridview上。。。。。。。。。。。

[jerrylyj]

是要排序哦，，，那可以在获得数据的时候在数据查询中进行排序。。。。。。。。。。order by 序号 desc

[hupanhong33]

我显示出来的全是1.用控件弄的,没写代码.升序不了

[ginni215]

dataGridView1.Columns["列名"].SortMode = DataGridViewColumnSortMode.Programmatic;
ListSortDirection ldDirection = ListSortDirection.Ascending;
dataGridView1.Sort(dataGridView1.Columns["列名"], ldDirection);

这样就可以了~~

[hupanhong33]

这样不对啊.5555555

[lxlongnw]

你在 第一列中加上下面代码
<asp:TemplateColumn HeaderText="序号">
<HeaderStyle Width="20%"></HeaderStyle>
<ItemTemplate>
<%#Container.ItemIndex+1%>
</ItemTemplate>
</asp:TemplateColumn>

[hupanhong33]

上面这样是不对的,是在gridview中插入一列,1.2.3....这样排序就可以了

[hupanhong33]

这个没人回答哦...

[zhwh1981]

<asp:TemplateColumn HeaderText="编号" Visible=False>
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"ID") %>
</ItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="固定资产号" SortExpression="zichannum">


protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (this.DataGrid1.Attributes["SortExpression"] == null)
{
DataGrid1.Attributes["SortExpression"] = "zichannum";
DataGrid1.Attributes["SortDirection"] = " ASC";

}
BindData();

}
}
void BindData()
{
string sql = "Execute B_DeviceList";
SqlDataAdapter adapter = new SqlDataAdapter(sql,MyConn);
DataSet ds = new DataSet();

MyConn.Open();
adapter.Fill(ds);
MyConn.Close();
DataView dv = new DataView();
string SortExpression = DataGrid1.Attributes["SortExpression"];
string SortDirection = DataGrid1.Attributes["SortDirection"];
dv = ds.Tables[0].DefaultView;
dv.Sort = SortExpression + " " + SortDirection;
DataGrid1.DataSource = ds.Tables[0].DefaultView;
DataGrid1.DataBind();

}
protected void Grid1_SortCommand(object source, DataGridSortCommandEventArgs e)
{
string SortExpression = e.SortExpression.ToString();
string SortDirection = "ASC";
if (SortExpression == DataGrid1.Attributes["SortExpression"])
{
SortDirection = (DataGrid1.Attributes["SortDirection"].ToString() == SortDirection ? "DESC" : "ASC");


}
DataGrid1.Attributes["SortExpression"] = SortExpression;
DataGrid1.Attributes["SortDirection"] = SortDirection;
BindData();

}

[hupanhong33]

放我那运行全是错误.这是2003的吧.我要2005的

[hanyangjian]

学习学习..看别人的代码然后学习..