前台
<asp:Literal ID="Literal2" runat="server"></asp:Literal>
后台
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection objSqlConnection = new SqlConnection("server=127.0.0.1;uid=sa;pwd=1;database=ThpDb");
objSqlConnection.Open();
System.Text.StringBuilder sb = new StringBuilder();
System.Text.StringBuilder sbjiaoxue = new StringBuilder();
SqlCommand sqlcom = new SqlCommand("select * from navtable where parentname='培训资讯'", objSqlConnection);
SqlDataReader datareader = sqlcom.ExecuteReader();
while (datareader.Read())
{
string str1 = "";
string str2 = "";
str1 = (string)datareader["aname"];
str2 = (string)datareader["ahref"];
sb.Append("<li>");
sb.Append("<a href='");
sb.Append(str2);
sb.Append("'>");
sb.Append(str1);
sb.Append("</a></li>");
}
datareader.Close();
SqlCommand sqlcom1 = new SqlCommand("select * from jiaoxue ", objSqlConnection);
SqlDataReader datareader1 = sqlcom1.ExecuteReader();
while (datareader1.Read())
{
sbjiaoxue.Append("<li><a href='");
sbjiaoxue.Append((string)datareader1["ahref"]);
sbjiaoxue.Append("'>");
sbjiaoxue.Append("<img src='");
sbjiaoxue.Append((string)datareader1["imgsrc"]);
sbjiaoxue.Append("'width='");
sbjiaoxue.Append((string)datareader1["withd"]);
sbjiaoxue.Append("'height='");
sbjiaoxue.Append((string)datareader1["heghit"]);
sbjiaoxue.Append("'</a><a href='");
sbjiaoxue.Append((string)datareader1["ahref"]);
sbjiaoxue.Append("'>");
sbjiaoxue.Append((string)datareader1["aname"]);
sbjiaoxue.Append("</a></li>");
}
//<li>
//<a href="jiaoxue.php?id=80"><img src="userfiles/20120828025512.jpg" width="178" height="97"></a>
//<a href="jiaoxue.php?id=80">拆除下部吊具</a>
// </li>
datareader1.Close();
Literal1.Text = Convert.ToString(sb);
Literal2.Text = Convert.ToString(sbjiaoxue);
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>MyFun();</script>");
}