!!我能够用1.aspx.CS文件显示出数据库里面的内容但是我想在 1.aspx里面用循环表格的形式来显示数据应该在ASPX文件里面这么写呢?这个是我在ASPX文件里面的代码,但是提示有错string connectionstring = ConfigurationManager.ConnectionStrings["bbsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string sql;
sql = "select * from wenzhang";
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader dr = cmd.ExecuteReader();
还有就是 如果想分页,,应该怎么写呢?
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string sql;
sql = "select * from wenzhang";
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader dr = cmd.ExecuteReader();
还有就是 如果想分页,,应该怎么写呢?
不是有很多控件么gridview直接绑定即可
string connectionstring = ConfigurationManager.ConnectionStrings["bbsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string sql;
sql = "select * from wenzhang";
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
html+="<tr><td>"+dr["title"].ToString()+"</td></tr>";
}
html+="</table>"
dr.Close();
前台
<%=html%>
string connectionstring = ConfigurationManager.ConnectionStrings["bbsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string sql;
sql = "select * from wenzhang";
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader dr = cmd.ExecuteReader();
DataSet ds = new DataSet();
dr.Fill(ds);
con.Close();
Public DataTable dt=ds.Tables[0];然后在aspx页面中
<table>
<%
foreach (DataRow row in dt)
{
%>
<tr>
<td><%=row["字段名1"].ToString()%></td>
<td><%=row["字段名2"].ToString()%></td>
</tr>
<%
}
%>
</table>
提示又错误!
{
public string htm="";//要在此次声明html
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
SetHtml();//调用赋值方法。
}
}
public void SetHtml()//给html赋值
{
string html="<table>";
string connectionstring = ConfigurationManager.ConnectionStrings["bbsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string sql;
sql = "select * from wenzhang";
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
html+="<tr><td>"+dr["title"].ToString()+"</td></tr>";
}
html+="</table>"
dr.Close();
}
}
public partial class request_post : System.Web.UI.Page
{
public string htm = "";//要在此次声明html
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SetHtml();//调用赋值方法。
}
} public void SetHtml()//给html赋值
{
string html="<table>";
string connectionstring = ConfigurationManager.ConnectionStrings["bbsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string sql;
sql = "select * from wenzhang";
SqlCommand cmd = new SqlCommand(sql,con);
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
html+="<tr><td>"+dr["title"].ToString()+"</td></tr>";
}
html+="</table>"
dr.Close();
}
}
用不起。
提示
Public DataTable dt=ds.Tables[0];
这一句有错!少个:貌似
public string content = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
string connectionstring = ConfigurationManager.ConnectionStrings["bbsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
con.Open();
string sql;
sql = "select * from wenzhang";
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader dr = cmd.ExecuteReader(); content = "<table><tbody>";
while (dr.Read())
{
content += "<tr><td>" + dr["列名1"] + "</td><td>" + dr["列名1"] + "</td></tr>";
}
content += "<tbody><table>";
}
把拼接好的表格显示到界面上。
<div>
<%=content %>
</div>
至于分页 和这个一样,只是sql语句改变,不是一次全部获取,分段获取就OK了。