asp.net中的Datagrid如何实现动态下拉框的功能?

发布网友发布时间：2022-04-07 20:19

共2个回答

懂视网时间：2022-04-08 00:41

C#" AutoEventWireup="true" CodeBehind="滑动门.aspx.cs" Inherits="UI.滑动门" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title></title> 　　<link rel="stylesheet" href="css/style.css" /> </head> <body> <form id="form1" runat="server"> <div class="solidBox"> <h3 class="solidBox_title"> <asp:ListView ID="ListTitle" runat="server"> <ItemTemplate>  <strong runat="server" id="Title" class=""> <%#Eval("Title") %> </strong> </ItemTemplate> </asp:ListView> </h3> <div class="solidBox_content"> <asp:ListView ID="ListContent" runat="server"> <ItemTemplate>  <strong runat="server" id="Content"> <%#Eval("Content") %> </strong> </ItemTemplate> </asp:ListView> </div> </div> </form> </body> </html>

样式重置：

/*
 * 样式重置文件
 */
body,
div,
dl,
dt,
dd,
ul,
ol,
li,
h1,
h2,
h3,
h4,
h5,
h6,
pre,
form,
fieldset,
input,
textarea,
p,
blockquote,
th,
td {
 margin: 0;
 padding: 0;
 font-weight: normal;
 font-style: normal;
 font-size: 12px;
 font-family: inherit;
}
table {
 border-collapse: collapse;
 border-spacing: 0;
}
fieldset,
img {
 border: 0;
}
address,
caption,
cite,
code,
dfn,
em,
strong,
th,
var {
 font-style: normal;
 font-weight: normal;
}
ol,
ul {
 list-style: none;
}
caption,
th {
 text-align: left;
}
h1,
h2,
h3,
h4,
h5,
h6 {
 font-size: 100%;
 font-weight: normal;
}
q:before,
q:after {
 content: ‘‘;
}
abbr,
acronym {
 border: 0;
}
a {
 color: #333;
 text-decoration: none;
}
a:hover {
 text-decoration: underline;
}
/*通用父子盒子嵌套浮动问题解决，开始*/

.clearfix:after {
 content: ".";
 display: block;
 height: 0;
 clear: both;
 visibility: hidden;
}
.clearfix {
 display: inline-block;
}
* html .clearfix {
 height: 1%;
}
.clearfix {
 display: block;
}
/*通用父子盒子嵌套浮动问题解决，结束*/
/*间隙层开始*/

.space_hx {
 /*横向间隙*/
 
 clear: both;
 width: 100%;
 height: 10px;
 font-size: 1px;
 overflow: hidden;
}
.space_zx {
 /*纵向间隙*/
 
 float: left;
 width: 10px;
 font-size: 1px;
 overflow: hidden;
}
/*间隙层结束*/

样式：

 .solidBox {
  width: 330px;
  height: 187px;
  margin: 20px;
  border-left: #CCCCCC 1px solid;
  overflow: hidden;
 }
  /*.solidBox .solidBox_title 中间空格是父子关系，以逗号隔开是同级关系*/

  .solidBox .solidBox_title {
  height: 30px;
  line-height: 30px;
  }

  .solidBox .solidBox_title div {
   float: left;
   /*变成块级元素*/
   width: 109px;
   height: 30px;
   border: #CCCCCC 1px solid;
   text-align: center;
   border-left: none;
   font: 16px "微软雅黑";
   cursor: pointer;
   /*cursor局部鼠标的样式*/
  }

  .solidBox .solidBox_title .hover {
   background: #9D9D9D;
   color: #FFF;
  }

  .solidBox .solidBox_content {
  padding: 5px;
  border: #CCCCCC 1px solid;
  border-left: none;
  border-top: none;
  height: 157px;
  width: 327px;
  overflow: hidden;
  }

后台：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace UI
{
 public partial class 滑动门 : System.Web.UI.Page
 {
 protected void Page_Load(object sender, EventArgs e)
 {
  DBind();
 }
 private void DBind()
 {
  SqlConnection conn = new SqlConnection("Server=.;database=Test;uid=sa;pwd=x");
  conn.Open();
  SqlCommand cmd = new SqlCommand("select * from huadongmen",conn);
  SqlDataReader reader = cmd.ExecuteReader();
  List<huadongmen> list = new List<huadongmen>();
  while (reader.Read())
  {
  huadongmen sb = new huadongmen();
  sb.Title = reader[0].ToString();
  sb.Content = reader[1].ToString();
  list.Add(sb);
  }
  reader.Close();
  conn.Close();
  ListTitle.DataSource = list;
  ListTitle.DataBind();
  ListContent.DataSource = list;
  ListContent.DataBind();
 }
 }
}

附上数据库脚本：

create database Test
go
use Test
create table huadongmen
(
 title varchar(20),
 content varchar(500)
)
go
insert into huadongmen values(‘标题一‘,‘这是标题一的内容‘)
insert into huadongmen values(‘标题二‘,‘这是标题二的内容‘)
insert into huadongmen values(‘标题三‘,‘这是标题三的内容‘)

update huadongmen set content=‘这是标题二的内容‘ where title=‘标题二‘
select * from huadongmen

asp.net实现数据库版动态网页滑动门

标签：

热心网友时间：2022-04-07 21:49

可以！把打算下拉的那列变成模板列（TemplateField），在模板列中拖入下拉框，这个最好用IDE完成，完成之后看前台源码如下：（这是我的程序片段）
<asp:TemplateField HeaderText=*模板
<ItemStyle HorizontalAlign=Center VerticalAlign=Middle Width=100px /
<ItemTemplate
 <asp:DropDownList ID=DDLContent runat=server DataTextField=模板名称 DataValueField=模板编号 AutoPostBack=True OnSelectedIndexChanged=DDLContent_SelectedIndexChanged
</asp:DropDownList
<asp:Label ID=LbtopicID runat=server Visible=False</asp:Label
</ItemTemplate
</asp:TemplateField
在后台要做两件事，1是把数据库中的数据绑定到下拉框，2是当下拉框被选择时程序要做出的反应：
1.把数据库中的数据绑定到下拉框
protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)//该事件是自动生成{if (e.Row.RowType == DataControlRowType.DataRow)//如果此行是DataGrid控件数据行{string topicID = GridView.DataKeys[e.Row.RowIndex].Value.ToString();//获取本行关键字的值
//***************下面是*模板列的绑定**********************
if (((DropDownList)e.Row.FindControl(DDLContent)) != null)//我的下拉框叫DDLContent{DataSet ds = cd.getContentModel(topicID);//从数据库中取得要放入下拉框的数据
DropDownList DDLContent = (DropDownList)e.Row.FindControl(DDLContent);
DDLContent.Items.Clear();
DDLContent.DataSource = cd.listModel();
DDLContent.DataBind();//绑定
if (ds.Tables[0].Rows.Count 0)//{DDLContent.SelectedValue = ds.Tables[0].Rows[0][模板编号].ToString();}else{DDLContent.Items.Insert(0, 请选择...);//用户没进行选择时显示这行}}//******************模板列绑定结束************************}}
2.如果被绑定的下拉框被用户选择，那么。。。
protected void DDLContent_SelectedIndexChanged(object sender, EventArgs e){//下面都是我的具体业务逻辑，你把它们换成你自己的
GridViewRow GVR = (GridViewRow)((Control)sender).Parent.Parent;
DropDownList DDLC = (DropDownList)(GVR.FindControl(DDLContent));