62,041
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class Index : System.Web.UI.Page
{
protected string hthtml = "";
protected string liHtml = "";
protected string noticeHtml = "";
protected string SYHtml = "";
protected void Page_Load(object sender, EventArgs e)
{
string cisql = "select * from SYtupian ";
DataTable table = SqlDataAdapterDt(cisql);
string imageUrl = "";
string ccsql = "select * from SYliebiao";
DataTable Stable = SqlDataAdapterDt(ccsql);
string lujing = "";
string SimageUrl = "";
string mingcheng = "";
foreach (DataRow row in table.Rows)
{
string isUser = row["url"].ToString();
int rt = 1;
//if (isUser == "False") imageUrl = "images/table.gif";
//else imageUrl = "images/table_3.jpg";
imageUrl = "images/"+isUser+"" ;
liHtml += "<li><a onClick='return false;'><img src="+imageUrl+" alt="+rt+" style='width:100%' /></a></li>";
}
//读取Notice
foreach (DataRow row in Stable.Rows)
{
string tupianurl = row["tupianurl"].ToString();
string mc = row["mingcheng"].ToString();
string lj = row["id"].ToString();
//if (isUser == "False") imageUrl = "images/table.gif";
//else imageUrl = "images/table_3.jpg";
SimageUrl = tupianurl;
mingcheng = mc;
lujing = lj;
SYHtml += "<li><a href="+lujing+".aspx><figure><div><img src="+SimageUrl+" /></div><figcaption>"+mingcheng+"<p>"+mingcheng+"</p></figcaption></figure></a></li>";
}
}
public DataTable SqlDataAdapterDt(string sql)
{
//查询一个表之后
string Conn = ConfigurationManager.ConnectionStrings["duan"].ConnectionString;
SqlConnection myConn = new SqlConnection(Conn);
SqlCommand cmd = new SqlCommand(sql, myConn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
}
public DataSet ExecuteDataSet()
{
oleDbConnection = new OleDbConnection(_ConnectionString);
oleDbDataAdapter = new OleDbDataAdapter(_Sql, oleDbConnection);
DataSet objDs = new DataSet();
oleDbConnection.Open();
oleDbDataAdapter.Fill(objDs);
oleDbConnection.Close();
return objDs;
}
它来自:
http://zzk.cnblogs.com/s?w=blog%3Ainsus+ASP.NET%E5%BC%80%E5%8F%91%EF%BC%8C%E4%BB%8E%E4%BA%8C%E5%B1%82%E8%87%B3%E4%B8%89%E5%B1%82%EF%BC%8C%E8%87%B3%E9%9D%A2%E5%90%91%E5%AF%B9%E8%B1%A1+&t=