GridView分页显示问题?

Question

前台CODE:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" CellPadding="4" ForeColor="#333333"
            GridLines="None" PageSize="1" OnPageIndexChanging="GridView1_PageIndexChanging" width="600px">
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <Columns>                
                <asp:BoundField DataField="SlBh" HeaderText="受理编号" InsertVisible="False" ReadOnly="True"
                    SortExpression="SlBh" />
                <asp:BoundField DataField="DwName" HeaderText="受理单位" SortExpression="DwName" />
                
                <asp:BoundField DataField="BsrName" HeaderText="办事人名称" SortExpression="BsrName" />
                <asp:BoundField DataField="Blzt" HeaderText="办理状态" SortExpression="Blzt" />
                <asp:HyperLinkField DataNavigateUrlFields="BsId" DataNavigateUrlFormatString="show_bs.aspx?id={0} &amp;Action=Xxzl"
                                                        HeaderText="办事详情" Text="办事详情" Target= "_blank" />                
            </Columns>
            <RowStyle BackColor="#EFF3FB" />
            <EditRowStyle BackColor="#2461BF" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>   
后台code:
public partial class bslist : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string dwname = Request.QueryString["dwname"];
        if (dwname != null)
        {
            bind();
        }
        else
        {
            bind1();
        }
    }    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }    public void bind()
    {
        string dwname = Request.QueryString["dwname"];
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        SqlConnection conn = new SqlConnection(settings);
        conn.Open();
        SqlDataAdapter daEmployees = new SqlDataAdapter("select * from Bs Where DwName='" + dwname + "' And Sh=1", conn);
        DataSet ds = new DataSet();
        daEmployees.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataKeyNames = new string[] { "BsId" };
        GridView1.DataBind();        
        conn.Close();
    }    public void bind1()
    {
        string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["SqlServices"]);
        SqlConnection conn = new SqlConnection(settings);
        conn.Open();
        SqlDataAdapter daEmployees = new SqlDataAdapter("select * from Bs Where Sh=1", conn);
        DataSet ds = new DataSet();
        daEmployees.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataKeyNames = new string[] { "BsId" };
        GridView1.DataBind();        
        conn.Close();
    }
}
最后的运行结果到是分页了!但是GridView中不但显示了我自定义的要显示的那些列!还把表中的其他的列都显示出来!我只想显示GridView中前台代码里的定义的列,不显示数据库中的其他列该怎么办?
   

Answer 1

可以在bind()的select语句中指定要显示的列吗？不用＊号试试

Answer 2

不行啊!最后显示成这样的了:
受理编号 受理单位 办事人名称 办理状态 办事详情 BsId SlBh DwName BsrName Blzt 
032e09a 电算中心 dsfsdfds 未办理 办事详情 3 032e09a 电算中心 dsfsdfds 未办理 
我只想保留前面在gridview中定义的列名是汉字的!不想要后面列名直接是表中字段的!
该怎么改

Answer 3

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) 
    { 
        GridView1.PageIndex = e.NewPageIndex; 
        GridView1.DataBind(); 
    } 
把这句GridView1.DataBind(); 换成
 if (dwname != null) 
        { 
            bind(); 
        } 
        else 
        { 
            bind1(); 
        } 

Answer 4

不行啊!
运行结果还是:
受理编号 受理单位 办事人名称 办理状态 办事详情 BsId SlBh DwName BsrName Blzt 
032e09a 电算中心 dsfsdfds 未办理 办事详情 3 032e09a 电算中心 dsfsdfds 未办理 protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        //GridView1.DataBind();
string dwname = Request.QueryString["dwname"];
if (dwname != null)
        {
            bind();
        }
        else
        {
            bind1();
        }
    }

Answer 5

AutoGenerateColumns="False"

Answer 6

设置关闭自动创建列AutoGenerateColumns="False“
就行