
asp.net中在后台编写的表格中怎样把绑定数据
StringBuildersbr=newStringBuilder();sbr.Append("<table>");for(inti=0;i<10;i++){sbr.Ap...
StringBuilder sbr = new StringBuilder();
sbr.Append("<table>");
for (int i = 0; i < 10; i++)
{
sbr.Append("<tr>");
sbr.Append("<td>");
sbr.Append("<a href='aaa.aspx'>");
sbr.Append("张");
sbr.Append("</a>");
sbr.Append("</td>");
sbr.Append("<td>");
sbr.Append("维");
sbr.Append("</td>");
sbr.Append("</tr>");
}
sbr.Append("</table>");
Panel.Controls.Add(new LiteralControl(sbr.ToString()));
这是我在后台编写的表格!应该怎么才能绑定数据呢!从数据库读出来的数据! 要源代码··· 展开
sbr.Append("<table>");
for (int i = 0; i < 10; i++)
{
sbr.Append("<tr>");
sbr.Append("<td>");
sbr.Append("<a href='aaa.aspx'>");
sbr.Append("张");
sbr.Append("</a>");
sbr.Append("</td>");
sbr.Append("<td>");
sbr.Append("维");
sbr.Append("</td>");
sbr.Append("</tr>");
}
sbr.Append("</table>");
Panel.Controls.Add(new LiteralControl(sbr.ToString()));
这是我在后台编写的表格!应该怎么才能绑定数据呢!从数据库读出来的数据! 要源代码··· 展开
展开全部
string sql = "select * from userInfo";
if (!string.IsNullOrEmpty(txtSelect.Text.Trim()))
{
sql = "select * from userInfo where userName='" + txtSelect.Text + "'";
}
SqlDataAdapter da = new SqlDataAdapter(sql, strConString);
DataTable dt = new DataTable();
da.Fill(dt);
string table = "";
table += "<table style=' border-collapse: collapse;border: solid #999;border-width: 1px 0 0 1px;font-size: 12px;font-weight:bold;'>";
table += "<tr>";
table += "<td style=' border: solid #999;border-width: 0 1px 1px 0;padding: 2px;'>";
table+=dt.Rows[0]["数据库字段名"].ToString();
table += "</td>";
table += "</tr>";
table += "</table>";
divHtml.InnerHtml = table;
if (!string.IsNullOrEmpty(txtSelect.Text.Trim()))
{
sql = "select * from userInfo where userName='" + txtSelect.Text + "'";
}
SqlDataAdapter da = new SqlDataAdapter(sql, strConString);
DataTable dt = new DataTable();
da.Fill(dt);
string table = "";
table += "<table style=' border-collapse: collapse;border: solid #999;border-width: 1px 0 0 1px;font-size: 12px;font-weight:bold;'>";
table += "<tr>";
table += "<td style=' border: solid #999;border-width: 0 1px 1px 0;padding: 2px;'>";
table+=dt.Rows[0]["数据库字段名"].ToString();
table += "</td>";
table += "</tr>";
table += "</table>";
divHtml.InnerHtml = table;
本回答被提问者采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
20分少点 这样我先给你个动态创建表格的源码
HTML 代码:
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<h1>HtmlTable实例演示</h1>
<form id="Form1" runat="server">
<table id="MyTable" cellpadding="5" cellspacing="0" border="1" runat="server" >
<tbody>
</tbody>
</table><p>
输入表格行数:
<input type="text" id="MyTextOne" value="1" runat="server" /></p>
<p>输入表格单元格:
<input type="text" id="MyTextTwo" value="1" runat="server" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="创建表格" /></p>
<p>
</p>
<div>
<br />
<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>
</div>
</form>
</body>
</html>
aspx.cs 代码:
/// <summary>
/// 创建表格
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
int rows = Convert.ToInt32(MyTextOne.Value);
int colunms = Convert.ToInt32(MyTextTwo.Value);
this.CreateHtmlTable(rows, colunms, null);
}
private void CreateHtmlTable(int rows, int cells, string color)
{
HtmlTable dt = new HtmlTable();
dt.Border = 1; ; dt.CellPadding = 1;
if (string.IsNullOrEmpty(color))
{
dt.BorderColor = "black";
}
else
{
dt.BorderColor = color;
}
if (rows <= 0)
rows = 1;
if (cells <= 0)
cells = 1;
for (int i = 0; i < rows; i++)
{
HtmlTableRow row = new HtmlTableRow();
for (int j = 0; j < cells; j++)
{
HtmlTableCell cell = new HtmlTableCell();
LiteralControl lc = new LiteralControl();
TextBox tb = new TextBox();
tb.Text = "行:" + (i + 1) as string + " 列:" + (j + 1) as string;
//lc.Text = "行:" + (i + 1) as string + " 列:" + (j + 1) as string;
cell.Controls.Add(tb);
row.Cells.Add(cell);
}
dt.Rows.Add(row);
PlaceHolder1.Controls.Add(dt);
}
}
动态加载数据就在这个基础上再做修改一下就可以了 有问题找我吧
HTML 代码:
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<h1>HtmlTable实例演示</h1>
<form id="Form1" runat="server">
<table id="MyTable" cellpadding="5" cellspacing="0" border="1" runat="server" >
<tbody>
</tbody>
</table><p>
输入表格行数:
<input type="text" id="MyTextOne" value="1" runat="server" /></p>
<p>输入表格单元格:
<input type="text" id="MyTextTwo" value="1" runat="server" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="创建表格" /></p>
<p>
</p>
<div>
<br />
<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>
</div>
</form>
</body>
</html>
aspx.cs 代码:
/// <summary>
/// 创建表格
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
int rows = Convert.ToInt32(MyTextOne.Value);
int colunms = Convert.ToInt32(MyTextTwo.Value);
this.CreateHtmlTable(rows, colunms, null);
}
private void CreateHtmlTable(int rows, int cells, string color)
{
HtmlTable dt = new HtmlTable();
dt.Border = 1; ; dt.CellPadding = 1;
if (string.IsNullOrEmpty(color))
{
dt.BorderColor = "black";
}
else
{
dt.BorderColor = color;
}
if (rows <= 0)
rows = 1;
if (cells <= 0)
cells = 1;
for (int i = 0; i < rows; i++)
{
HtmlTableRow row = new HtmlTableRow();
for (int j = 0; j < cells; j++)
{
HtmlTableCell cell = new HtmlTableCell();
LiteralControl lc = new LiteralControl();
TextBox tb = new TextBox();
tb.Text = "行:" + (i + 1) as string + " 列:" + (j + 1) as string;
//lc.Text = "行:" + (i + 1) as string + " 列:" + (j + 1) as string;
cell.Controls.Add(tb);
row.Cells.Add(cell);
}
dt.Rows.Add(row);
PlaceHolder1.Controls.Add(dt);
}
}
动态加载数据就在这个基础上再做修改一下就可以了 有问题找我吧
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询