请问我的这段代码为什么没有排序的功能效果呢？

悬赏园豆：10 [已关闭问题]

这是源代码：

                            </asp:RadioButtonList></div>
                    </td>
                </tr>
                <tr>
                    <td style="width: 76px; height: 21px;">
                         </td>
                    <td style="width: 97px; height: 21px;">
                        <asp:Button ID="btnShuxin" runat="server" Text="刷新" OnClick="btnShuxin_Click" /></td>
                </tr>
            </table>
        </div>
        <div style="z-index: 103; left: 461px; width: 105px; position: absolute; top: 69px;
            height: 23px">
            <asp:TextBox ID="txtUserName" runat="server" Width="97px"></asp:TextBox></div>
        <div style="z-index: 104; left: 138px; width: 52px; position: absolute; top: 128px;
            height: 22px">
            <asp:Button ID="btnSelect" runat="server" Text="查询" OnClick="btnSelect_Click" /></div>
    </div>
    </form>

后台代码：

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using MyMode;

public partial class InfoDetail : System.Web.UI.Page
{
public static readonly string connectionString = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
              DDlBirtdayByBind();
              DGbindInfo();
        }
    }

    /// <summary>
    /// 绑定所有数据
    /// </summary>
    public void DGbindInfo()
    {
        conn.Open();
        string sql = "select [id],[UserName],[PassWord],[Age],[Email],[Thone],[Birthday],[FirstPass] from MyInfoTable";

        SqlDataAdapter sdr = new SqlDataAdapter(sql,conn);
        DataSet ds = new DataSet();
        sdr.Fill(ds, "MyInfoTable");

        DGInfo.DataKeyField = "id";
        DGInfo.DataSource = ds;
        DGInfo.DataBind();
        conn.Close();
    }

    /// <summary>
    /// 根据id来排序
    /// </summary>
    public void DGbindById()
    {
        conn.Open();
        string sql = "select [id],[UserName],[PassWord],[Age],[Email],[Thone],[Birthday],[FirstPass] from MyInfoTable order by id";
        SqlDataAdapter sdr = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        sdr.Fill(ds, "MyInfoTable");

        DGInfo.DataKeyField = "id";
        DGInfo.DataSource = ds;
        DGInfo.DataBind();
        conn.Close();
    }
    /// <summary>
    /// 根据用户名排序
    /// </summary>
    public void DGbindByName()
    {
        conn.Open();
        string sql = "select [id],[UserName],[PassWord],[Age],[Email],[Thone],[Birthday],[FirstPass] from MyInfoTable order by UserName";
        SqlDataAdapter sdr = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        sdr.Fill(ds, "MyInfoTable");

        DGInfo.DataKeyField = "id";
        DGInfo.DataSource = ds;
        DGInfo.DataBind();
        conn.Close();
    }
    /// <summary>
    /// 绑定DropDownList控件
    /// </summary>
    public void DDlBirtdayByBind()
    {
        conn.Open();
        string sql = "select [UserName],[PassWord],[Age],[Email],[Thone],[Birthday],[FirstPass] from MyInfoTable";
        sql += " order by Birthday";

        SqlDataAdapter sdr = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        sdr.Fill(ds, "MyInfoTable");

        //DDLBirthday.DataTextField = "Birthday";
        DDLBirthday.DataValueField = "Birthday";
        DDLBirthday.DataSource = ds;
        DDLBirthday.DataBind();
        conn.Close();

}

    protected void DGInfo_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
        {
            e.Item.Attributes.Add("onmouseover", "this.style.backgroundColor='#f1f1f1';");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='#ffffff';");
        }
    }

protected void DGInfo_DeleteCommand(object source, DataGridCommandEventArgs e)
{

        if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
        {
            e.Item.Cells[7].Attributes.Add("onclick", "return confirm('你确认删除吗？')");
        }

int id = Convert.ToInt16(DGInfo.DataKeys[e.Item.ItemIndex]);

            string sql = "delete from MyInfoTable where id ='" + id + "'";
            SqlCommand cmd = new SqlCommand(sql, conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            DGbindInfo();

    }
    protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        this.DGInfo.CurrentPageIndex = 0;
        DGbindInfo();
    }
    protected void DDLBirthday_SelectedIndexChanged(object sender, EventArgs e)
    {
        DDlBirtdayByBind();
    }
    protected void btnSelect_Click(object sender, EventArgs e)
    {
        DGbindById();
    }
    protected void btnShuxin_Click(object sender, EventArgs e)
    {
        txtId.Text = "";
        txtUserName.Text = "";

        DDLBirthday.SelectedIndex = 0;
        DGbindInfo();
    }
}

请各位大虾指点其中的问题，谢谢

.NET技术 ASP.NET

boboisboy | 菜鸟二级 | 园豆：346
提问于：2009-12-01 17:37

< >

清除回答草稿

您需要登录以后才能回答，未注册用户请先注册。

欢迎，请先 登录 或者 注册 。

请问我的这段代码为什么没有排序的功能效果呢？

欢迎，请先登录或者注册。