后台数据:
string Strcon = "server=.;uid=sa;pwd=;database=ds;";
SqlConnection con = new SqlConnection(Strcon);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select title,content from News",con);
DataSet ds = new DataSet();
sda.Fill(ds);
DataRow dr1 = ds["title"];
DataRow dr2 = ds["content"]; 我要在前台显示title,Content改怎么调用。
string Strcon = "server=.;uid=sa;pwd=;database=ds;";
SqlConnection con = new SqlConnection(Strcon);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter("select title,content from News",con);
DataSet ds = new DataSet();
sda.Fill(ds);
DataRow dr1 = ds["title"];
DataRow dr2 = ds["content"]; 我要在前台显示title,Content改怎么调用。
GridView.DataSource = ds;
GridView.DataBind();
<%=变量名%>
<HeaderTemplate>
<ul>
</HeaderTemplate>
<ItemTemplate>
<li>
<asp:LinkButton ID="LB" runat="server" CommandName="ViewArticle"><%# Eval("articleTitle") %></asp:LinkButton></li>
</ItemTemplate>
<FooterTemplate>
</ul>
</FooterTemplate>
</asp:DataList>
后台代码
sda.Fill(ds);
GridView.DataSource = ds;
GridView.DataBind();
前台绑定
<%# DataBinder.Eval(Container.DataItem,"title")%>
<%# DataBinder.Eval(Container.DataItem,"content")%>如果是显示新闻的话
加两个label
sda.Fill(ds);
DataRwo newRow = ds.Tables[0].Rows[0];
label1.Text = newRow["title"].ToString();
label2.Text = newRow["content"].ToString();
DataRow dr2 = ds["content"]; 这是啥代码?