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>
{
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>
解决方案 »
- 看看这道题目
- 位域的Enum 类型如何使用"&"符号
- 在winform程序中,如何用进度条显示调用web服务的进度,谢谢各位高手指点!!!
- 无聊和死掉有什么区别
- |M| 在WinForm中MDI窗口打开新窗口的时候如何实现像WebForm的showModuleDailog功能
- .Net2003VisualC#开发IntelliWhereOnDemand 如何初始化API类的实例?
- 上传图片操作!
- 请教一个关于文档转换为XML的问题
- 如何在程序中調整報表邊界?
- 求ComponentOne for ASP.NET的下载地址及注册码!!!
- C#如何格式化磁盘,不使用CMD命令。
- c++建立的二进制数据中的字符串读取
你只需要第一个,
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();
}