ASP NET SQL

ASP NET SQL - 为每一行创建一个新的div(ASP NET SQL - for each row create a new div)

寻找一种解决方案，为SQL Server数据库表中的每一行创建一个新的div及其内容：

Dim com As SqlCommand = New SqlCommand("select Date,Title,Content from Log where Author = @Author", con) com.Parameters.Add("@Author", SqlDbType.Char) com.Parameters("@Author").Value = User.Identity.Name Dim dt As DataTable = New DataTable() For Each Datarow In dt.Rows //create New div with its content Next

这是一个工作，但不能让它创建一个新的div /表的内容呢。

感谢任何帮助。

Looking for a solution to create a new div with its content for each row in SQL Server database table:

Dim com As SqlCommand = New SqlCommand("select Date,Title,Content from Log where Author = @Author", con) com.Parameters.Add("@Author", SqlDbType.Char) com.Parameters("@Author").Value = User.Identity.Name Dim dt As DataTable = New DataTable() For Each Datarow In dt.Rows //create New div with its content Next

This one is working, but can't get it to create a new div/table with its content yet.

Appreciate any help.

最满意答案

DataSet ds = new DataSet(); SqlDataAdapter da1 = new SqlDataAdapter("select Date,Title,Content from Log where Author = @Author", ConfigurationManager.ConnectionStrings["sasa"].ConnectionString); da1.Fill(ds); string makehtml = string.Empty; //however when you have DataSet then you can iterate easily and cerate whatever you want for(int i = 0; i < ds.Tables[0].Rows.Count; i++) { makehtml += "<div><span>Date:</span> " + ds.Tables[0].Rows[i]["Date"] + " <span>Title:</span> " + ds.Tables[0].Rows[i]["Title"] + "< span > Content:</ span > " + ds.Tables[0].Rows[i]["Content"] + " </div>"; }

请检查它是否有帮助。 我不是VB专家，但是当你有DataSet的时候，你可以遍历DataSet Row by Row并创建一个div或者执行一些其他的操作。 一些其他选择或好方法：

<asp:ListView ID="lstVDataBind" runat="server"> <LayoutTemplate> <asp:PlaceHolder ID="itemPlaceholder" runat="server" /> </LayoutTemplate> <ItemTemplate> <div class="col-md-12"><span>Date:</span><%#Eval("Date")%> <span>Title:</span><%#Eval("Title")%>< span > Content:</ span > <%#Eval("Content")%></div> </ItemTemplate> </asp:ListView>

在后面的代码中，您可以将数据集分配给Listview作为数据源，如：

lstVDataBind.DataSource = ds; lstVDataBind.DataBind();

您也可以使用中继器而不是Listview。 另一种方式你可以做同样的事情：

<%-- statrt here --%> <% if (ds.Tables[0].Rows.Count > 0){ for (int i = 0; i < ds.Tables[0].Rows.Count; i++) {%> <div class="col-md-12"> <div class="col-md-12"><span>Date:</span><%=ds.Tables[0].Rows[i]["Date"].ToString()%> <span>Title:</span><%=ds.Tables[0].Rows[i]["Title"].ToString()%><span> Content:</span><%=ds.Tables[0].Rows[i]["Content"].ToString()%></div> </div> <%}} %> <%-- Ends here --%>

此代码将在aspx页面中，但为此，您必须公开您的数据集，以便轻松访问。

DataSet ds = new DataSet(); SqlDataAdapter da1 = new SqlDataAdapter("select Date,Title,Content from Log where Author = @Author", ConfigurationManager.ConnectionStrings["sasa"].ConnectionString); da1.Fill(ds); string makehtml = string.Empty; //however when you have DataSet then you can iterate easily and cerate whatever you want for(int i = 0; i < ds.Tables[0].Rows.Count; i++) { makehtml += "<div><span>Date:</span> " + ds.Tables[0].Rows[i]["Date"] + " <span>Title:</span> " + ds.Tables[0].Rows[i]["Title"] + "< span > Content:</ span > " + ds.Tables[0].Rows[i]["Content"] + " </div>"; }

Please check if it helps. i am not expert in VB but when you have DataSet then you can iterate over the DataSet Row by Row and create a div or have some other operations to perform. Some Other options or good approach:

<asp:ListView ID="lstVDataBind" runat="server"> <LayoutTemplate> <asp:PlaceHolder ID="itemPlaceholder" runat="server" /> </LayoutTemplate> <ItemTemplate> <div class="col-md-12"><span>Date:</span><%#Eval("Date")%> <span>Title:</span><%#Eval("Title")%>< span > Content:</ span > <%#Eval("Content")%></div> </ItemTemplate> </asp:ListView>

And in code behind you can assign your dataset to Listview as datasource like:

lstVDataBind.DataSource = ds; lstVDataBind.DataBind();

You can also use repeater instead of Listview. Another way you can do samething:

<%-- statrt here --%> <% if (ds.Tables[0].Rows.Count > 0){ for (int i = 0; i < ds.Tables[0].Rows.Count; i++) {%> <div class="col-md-12"> <div class="col-md-12"><span>Date:</span><%=ds.Tables[0].Rows[i]["Date"].ToString()%> <span>Title:</span><%=ds.Tables[0].Rows[i]["Title"].ToString()%><span> Content:</span><%=ds.Tables[0].Rows[i]["Content"].ToString()%></div> </div> <%}} %> <%-- Ends here --%>

This code will be in aspx page but for this you have to make your dataset public so it be easilty accessible.