62,072
社区成员
发帖
与我相关
我的任务
分享
public partial class tuandui_huwai_Default : System.Web.UI.Page
{
protected string news;
public static string connectString = Convert.ToString(ConfigurationManager.ConnectionStrings["conn"]);
SqlConnection con = new SqlConnection(connectString);
protected void Page_Load(object sender, EventArgs e)
{
kcbind();
}
void kcbind()
{
string sql = "select news_id,news_name from news";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader();
string s = "";
s+="<ul>";
while (dr.Read())
{
s+="<li><a href=news.aspx?id="+ dr["news_id"] +">"+ dr["news_name"] +"</a></li>";
}
s+="</ul>";
con.Close();
news= s;
}
}