protected void databind( )
    {
        string cmd = "select * from banner";
       
        IDataReader dr = WbSQL.ExecuteReader(CommandType.Text, cmd, null);
        BannerView.DataSource = dr;
        BannerView.DataBind();
        dr.Close();
        dr.Dispose();
        
        
    }
    public void style(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='#c8dafa'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e");
        }
    }
    protected void BannerView_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.ToString() == "del")
        {
            int delid = Convert.ToInt32(BannerView.DataKeys[Convert.ToInt32(e.CommandArgument)].Value);
            string cmd = "delete from banner where id='" + delid + "'";
            WbSQL.ExecuteNonQuery(CommandType.Text, cmd, null);
            databind();
        }
    }
页面:
<asp:GridView ID="BannerView" runat="server" Width="756px" AutoGenerateColumns="False" BackColor="#C0FFEE" BorderColor="Black" BorderWidth="1px" DataKeyNames="id" OnRowDataBound="style" RowStyle-Height="20px" OnRowCommand="BannerView_RowCommand" ShowFooter="True">
                        <Columns>
                            <asp:TemplateField SortExpression="id" Visible="False">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                   
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderImageUrl="~/image/can1.gif">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemStyle BorderStyle="Outset" HorizontalAlign="Center" VerticalAlign="Middle" Width="30px"
                                    Wrap="False" />
                                <HeaderStyle BackColor="#8080FF" />
                                <ItemTemplate>
                                    <asp:Image ID="Image2" runat="server" ImageUrl="~/image/can.gif" />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Banner">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                                </EditItemTemplate>
                                <ItemStyle Width="150px" />
                                <HeaderStyle BackColor="#8080FF" />
                                <ItemTemplate>
                                <img src="<%#DataBinder.Eval(Container.DataItem,"pic") %>" height="25px" width="150px" alt="banner图片" />
                                    
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="相关链接">
                                <ItemStyle Width="350px" />
                                <HeaderStyle BackColor="#8080FF" />
                                <ItemTemplate><%#DataBinder.Eval(Container.DataItem,"url") %></ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="添加时间">
                                <HeaderStyle BackColor="#8080FF" />
                                <ItemTemplate><%#DataBinder.Eval(Container.DataItem,"addtime") %></ItemTemplate>
                            </asp:TemplateField>
                            <asp:ButtonField ButtonType="Button" Text="删除" CommandName="del" SortExpression="id" >
                                <ItemStyle HorizontalAlign="Center" />
                                <HeaderStyle BackColor="#8080FF" />
                            </asp:ButtonField>
                            
                        </Columns>
                        <RowStyle Height="20px" />
                        <FooterStyle BackColor="#8080FF" />
                    </asp:GridView>

解决方案 »

  1.   

    忘说了,第一个函数为绑定数据,第二个位鼠标经过变色,第三个位一个删除功能!
    你只需要第一个,
    protected void databind( ) 
        { 
            string cmd = "select * from banner"; 
          
            IDataReader dr = WbSQL.ExecuteReader(CommandType.Text, cmd, null); 
            BannerView.DataSource = dr; 
            BannerView.DataBind(); 
            dr.Close(); 
            dr.Dispose(); 
            
            
        } 
      

  2.   

    我说的是SQL连了之后进行搜索啊,增、填、删、改啥的