datagrid分頁,增加選項框

前台

  <form id="Form1" method="post" runat="server" name="Form1">
  <br />
  <cc1:Button ID="SaveInfo" runat="server" Text=" 提 交 "></cc1:Button>
  <br />
  <asp:DataGrid ID ="datagrid1" runat ="server" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Horizontal" Width="95%" AutoGenerateColumns="False" AllowPaging="True" OnPageIndexChanged="datagrid1_PageIndexChanged" PageSize="5">
            <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
            <SelectedItemStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" Mode="NumericPages" />
            <HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:BoundColumn DataField="tid" HeaderText="主題ID">
                    <HeaderStyle Width="5%" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="fid" HeaderText="版塊ID">
                    <HeaderStyle Width="5%" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="title" HeaderText="主題名稱">
                    <HeaderStyle Width="35%" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="poster" HeaderText="發表者">
                    <HeaderStyle Width="10%" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="postdatetime" HeaderText="發表時間">
                    <HeaderStyle Width="15%" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="lastposter" HeaderText="最後回複者">
                    <HeaderStyle Width="10%" />
                </asp:BoundColumn>
                <asp:BoundColumn DataField="lastpost" HeaderText="最後回複時間">
                    <HeaderStyle Width="15%" />
                </asp:BoundColumn>
                <asp:TemplateColumn HeaderText="选 择">
    <HeaderStyle Width="5%"></HeaderStyle>
    <ItemTemplate>
     <asp:CheckBox id="myCheckBox" Runat="server"></asp:CheckBox>
    </ItemTemplate>
   </asp:TemplateColumn>
            </Columns>
        </asp:DataGrid>
 </form>

 

後台

public partial class admin_setindex_set_topics : AdminPage
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DataBind();
        }
    }

    private void DataBind()
    {
        datagrid1.DataSource = GetData("tid,fid,title,poster,postdatetime,lastposter,lastpost", "");
        datagrid1.DataKeyField = "tid";
        datagrid1.DataBind();
    }

    public DataSet GetData(string p_str_column,string p_str_where)
    {
        string commandText = string.Format("SELECT " + p_str_column + " from [{0}topics] " + p_str_where, BaseConfigFactory.GetTablePrefix);
        return Database.ExecuteDataset(CommandType.Text, commandText);
    }
    protected void datagrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        datagrid1.CurrentPageIndex = e.NewPageIndex;
        DataBind();
    }

    protected void SaveInfo_Click(object sender, EventArgs e)
    {
        string l_str_writetext = "";
        string path = Server.MapPath("") + "//tid.txt";

        foreach (DataGridItem dgi in datagrid1.Items)
        {
            CheckBox myCheckBox = (CheckBox)dgi.FindControl("myCheckBox");
            if (myCheckBox.Checked)
            {
                int l_int_tid = Convert.ToInt32(datagrid1.DataKeys[dgi.ItemIndex]);
                l_str_writetext += "," + l_int_tid;
            }
        }

        if (l_str_writetext != "")
        {
            l_str_writetext = l_str_writetext.Substring(1);
            //寫文件 
            if (File.Exists(path))
            {
                File.Delete(path);
            }
            using (StreamWriter sw = File.CreateText(path))
            {
                sw.Write(l_str_writetext);
            }

        }
        else
        {
            Page.RegisterStartupScript("", "<script language=/"javascript/">alert('沒有選擇項');</script>");
            return;
        }

        Page.RegisterStartupScript("PAGE", "window.location.href='set_topics.aspx';");

    }

    #region Web 窗体设计器生成的代码

    protected override void OnInit(EventArgs e)
    {
        InitializeComponent();
        base.OnInit(e);
    }

    private void InitializeComponent()
    {
        this.SaveInfo.Click += new EventHandler(this.SaveInfo_Click);
        this.Load += new EventHandler(this.Page_Load); //注意
    }

    #endregion

 

}