谁用过RadGrid

有没有RadGrid增删查改 删除的例子。

解决方案 »

  1.   

    大哥级人物，没用过radgrid？不可能吧？
      

  2.   

    ...
    <%@ Register assembly="RadGrid.Net2" namespace="Telerik.WebControls" tagprefix="radG" %>
    ...
    <radG:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                                            GridLines="None" OnPageIndexChanged="RadGrid1_PageIndexChanged"  
                                            Skin="Windows" Width="98%">
                                            <MasterTableView DataKeyNames="c_id">                                          <RowIndicatorColumn Visible="False">
                                            <HeaderStyle Width="20px"></HeaderStyle>
                                            </RowIndicatorColumn>                                        <ExpandCollapseColumn Visible="False" Resizable="False">
                                            <HeaderStyle Width="20px"></HeaderStyle>
                                            </ExpandCollapseColumn>
                                                <Columns>
                                                    <radG:GridTemplateColumn HeaderText="编号">
                                                        <ItemTemplate>
                                                            <%#Container.DataSetIndex+1 %>
                                                        </ItemTemplate>
                                                        <ItemStyle Width="4%" HorizontalAlign="Center"/>
                                                    </radG:GridTemplateColumn>
                                                    <radG:GridBoundColumn HeaderText="公告标题" DataField="c_title">
                                                        <ItemStyle Width="70%" HorizontalAlign="Center"/>
                                                    </radG:GridBoundColumn> 
                                                    <radG:GridBoundColumn HeaderText="发布日期" DataField="c_dt" DataFormatString="{0:yyyy-MM-dd}">
                                                        <ItemStyle Width="10%" HorizontalAlign="Center"/>
                                                    </radG:GridBoundColumn> 
                                                    <radG:GridTemplateColumn HeaderText="编辑">   
                                                        <ItemStyle Width="5%" HorizontalAlign="Center"/>
                            <ItemTemplate>
                            <asp:LinkButton ID="LinkButton1" runat="server" Text="修改" CommandArgument='<%#Eval("c_id")%>' CausesValidation="False" OnCommand="LinkButton1_Command"></asp:LinkButton>
                            </ItemTemplate>   
                                                    </radG:GridTemplateColumn>   
                                                    <radG:GridTemplateColumn HeaderText="删除">
                                                        <ItemStyle Width="5%" HorizontalAlign="Center"/>
                            <ItemTemplate>
                            <asp:ImageButton CausesValidation="False" id="Imagebutton2" runat="server" ImageUrl="../img/delete2.gif" OnClientClick="javascript:return confirm('确认要删除吗？')"
                              AlternateText="删除此条目" CommandArgument='<%#Eval("c_id") %>' OnCommand="ImageButton2_Command"></asp:ImageButton>
                            </ItemTemplate>   
                                                    </radG:GridTemplateColumn>
                                                </Columns>   
                                                <NoRecordsTemplate>   
                                                    <div style="color: #F00; height: 40px; line-height: 40px;">   
                                                        <span style="margin-left: 10px; font-size: 14px; font-weight: bold;">没有符合的记录！</span>
                                                    </div>   
                                                </NoRecordsTemplate>   
                                            </MasterTableView>                                          <ExportSettings>
                                            <Pdf PageWidth="8.5in" PageHeight="11in" PageTopMargin="" PageBottomMargin="" PageLeftMargin="" PageRightMargin="" PageHeaderMargin="" PageFooterMargin=""></Pdf>
                                            </ExportSettings>                                        <PagerStyle NextPagesToolTip="下一页" NextPageText="下一页" NextPageToolTip="下一页" PagerTextFormat="分页&nbsp;:&nbsp;{4} &nbsp;|&nbsp; 当前页面&nbsp;:&nbsp;第{0}页/共{1}页, 数据条目&nbsp;:&nbsp;第{2}条-第{3}条/共{5}条."  
                                                PrevPagesToolTip="上一页" PrevPageText="上一页" PrevPageToolTip="上一页" />   
                                        </radG:RadGrid>
                                        <asp:linkbutton id="cmdAdd" runat="server"  OnClick="cmdAdd_Click">
                                <font size="2"><img src="../img/add2.gif" border="0" alt="添加新信息"/>&nbsp;添加...</font>
                                        </asp:linkbutton>
    ...
    <table id="tabxx" runat="server" width="100%">
        <TR >
    <TD style="height: 340px">
    <TABLE width="100%" class="tablesingle">
    <TR>
    <TD width="15%" align="right" valign="top" class="tablesingletdlable">
                                        公告标题：</TD>
    <TD><asp:textbox id="Text_p_name" runat="server" CssClass="edline" Width="80%"></asp:textbox></TD>
    <TD style="WIDTH: 4px" align="left">

    </TD>
    </TR>
    <TR>
    <TD align="right" valign="top" class="tablesingletdlable">
                                        公告内容：</TD>
    <TD>
    <asp:TextBox  ID="txtContent" TextMode="MultiLine" runat="server" Rows="12" Columns="80" width="100%" />
    </TD>
    <TD></TD>
    </TR>
    <tr>
    <TD colspan="2"><TABLE  width="100%">
    <tr>
    <td bgcolor="#f5f5f5" class="chinese" height="30" align="center">
    <asp:Button ID="btnSubmit" runat="server" Text="提交" onclick="btnSubmit_Click"/>&nbsp;&nbsp;&nbsp;
    <asp:Button ID="btnReset" runat="server" Text="取消" onclick="btnReset_Click" />
    </td>
    </tr>
    </TABLE>
    </TD>
    <TD></TD>
    </tr>
    </TABLE>
    </TD>
    </TR>
    </table>
    ...
        //绑定数据
        public void BindRadData()
        {
            string strSQL = "select * from MB_NoticePublic order by c_dt desc";
            DM dm = new DM();
            DataSet ds = dm.GetData(strSQL);
            this.RadGrid1.DataSource = ds;
            this.RadGrid1.DataBind();
        }    protected void cmdAdd_Click(object sender, EventArgs e)
        {
            this.Text_p_name.Text = "";
            this.txtContent.Text = "";
            ViewState["id"] = null;
            this.tabxx.Visible = true;
        }    //修改页面
        protected void LinkButton1_Command(object sender, CommandEventArgs e)
        {
            this.tabxx.Visible = true;
            DM dm = new DM();
            ViewState["id"] = e.CommandArgument.ToString();
            //首先根据获取到的id和sbid将数据填充到表格中让其修改
            string strSQL = "select * from MB_NoticePublic where c_id=" + ViewState["id"];
            DataSet ds = dm.GetData(strSQL);
            foreach (DataRowView drv in ds.Tables[0].DefaultView)
            {
                this.Text_p_name.Text = drv["c_title"].ToString();
                this.txtContent.Text = drv["c_content"].ToString();
            }
        }    //删除页面
        protected void ImageButton2_Command(object sender, CommandEventArgs e)
        {
            DM dm = new DM();
            try
            {
                string strSQL = "delete from MB_NoticePublic where c_id=" + e.CommandArgument.ToString();
                dm.SetData(strSQL);
                ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert(\'删除成功!\'); </script>");
            }
            catch
            {
            }
            BindRadData();    }    //RadGrid分页功能代码
        protected void RadGrid1_PageIndexChanged(object source, Telerik.WebControls.GridPageChangedEventArgs e)
        {
            //分页代码
            this.RadGrid1.CurrentPageIndex = e.NewPageIndex;
            this.RadGrid1.DataBind();
        }    //提交按钮事件
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            string title = this.Text_p_name.Text;
            string content = this.txtContent.Text;
            int user_id = int.Parse(Page.Session["uid"].ToString());
            if (ViewState["id"] == null)
            {
                //新增加记录
                if (title == "" || title == null)
                {
                    ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert(\'添加公告的标题不能为空...\'); </script>");
                    return;
                }
                DM dm = new DM();
                string strSQL = "insert into MB_NoticePublic(c_title,c_reuser,c_content) values('" + title + "'," + user_id + ",'" + content + "')";
                dm.SetData(strSQL);
                ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert(\'增加公告成功！\'); </script>");
                this.tabxx.Visible = false;
                BindRadData();
            }
            else
            {
                DM dm = new DM();
                string strSQL2 = "";
                strSQL2 += (strSQL2 == "" ? "" : ",") + "c_title='" + title + "'";
                strSQL2 += (strSQL2 == "" ? "" : ",") + "c_reuser=" + user_id + "";
                strSQL2 += (strSQL2 == "" ? "" : ",") + "c_content='" + content + "'";
                string strSQL3 = "update MB_NoticePublic set " + strSQL2 + " where c_id=" + ViewState["id"];
                dm.SetData(strSQL3);
                ClientScript.RegisterClientScriptBlock(GetType(), "", "<script>alert(\'更新公告成功！\'); </script>");
                this.tabxx.Visible = false;
                BindRadData();
            }
        }
        protected void btnReset_Click(object sender, EventArgs e)
        {
            //重置按钮事件
            this.tabxx.Visible = false;
        }
      

  3.   


    using System;
    using System.Web.UI.WebControls;using Telerik.Web.UI;
    using System.Web.UI;namespace Telerik.GridExamplesCSharp.Programming.SelectRowWithCheckBox
    {
        public partial class DefaultCS : System.Web.UI.Page
        {
            protected void ToggleRowSelection(object sender, EventArgs e)
            {
                ((sender as CheckBox).Parent.Parent as GridItem).Selected = (sender as CheckBox).Checked;
            }
        
            protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)
            {
                if (e.Item is GridDataItem)
                {
                    e.Item.PreRender += new EventHandler(RadGrid1_ItemPreRender);
                }
            }        private void RadGrid1_ItemPreRender(object sender, EventArgs e)
            {
                ((sender as GridDataItem)["CheckBoxTemplateColumn"].FindControl("CheckBox1") as CheckBox).Checked = (sender as GridDataItem).Selected;
            }
            protected void ToggleSelectedState(object sender, EventArgs e)
            {
                if ((sender as CheckBox).Checked)
                {
                    foreach (GridDataItem dataItem in RadGrid1.MasterTableView.Items)
                    {
                        (dataItem.FindControl("CheckBox1") as CheckBox).Checked = true;
                        dataItem.Selected = true;
                    }
                }
                else
                {
                    foreach (GridDataItem dataItem in RadGrid1.MasterTableView.Items)
                    {
                        (dataItem.FindControl("CheckBox1") as CheckBox).Checked = false;
                        dataItem.Selected = false;
                    }
                }
            }
            protected void Page_PreRender(object sender, EventArgs e)
            {
                Literal1.Text = String.Format("<h3 class=\"qsfSubtitle\">Selected rows count is: {0}</h3>", RadGrid1.SelectedItems.Count);
            }
        }
    }
    参考：    希望对你有帮助
      

  4.   

    我以前只用repeater。其它不是被逼也不会用
      

  5.   


    怎样在里面加一个新增的
    <radG:GridTemplateColumn UniqueName="Part_Num" HeaderText="Part_Num" EditFormColumnIndex="1" Visible="false">
                            <ItemTemplate>
                                <asp:Label ID="LblPart_Num" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Part_Num") %>'></asp:Label>
                            </ItemTemplate>
                            <EditItemTemplate>
                               <asp:Label ID="LblPart_Num2" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Part_Num") %>'></asp:Label>
                            </EditItemTemplate>
                            
                            <ItemStyle Width="110px" HorizontalAlign="Left"/>
                            <HeaderStyle Width="110px" />
                        </radG:GridTemplateColumn>