سلام
من می خوام از بانک sql server اطلاعات رو در repeater نشون بدم :
SqlCommand Cmd = new SqlCommand();
SqlConnection Conn = new SqlConnection();
protected void BBC_NEWS_Activate(object sender, EventArgs e)
{
Conn.ConnectionString = @"Data Source=USER-PC\SQLEXPRESS; initial catalog=News; integrated security=true";
Cmd.CommandType = CommandType.Text;
Cmd.Connection = Conn;
Cmd.CommandText = "Select Top 10 newsID, Title, Description, DatePublished, Link";
Conn.Open();
if (!Page.IsPostBack)
{
Repeater1.DataSource = Cmd.ExecuteReader();
Repeater1.DataBind();
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
}
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
}
و همچنین:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<br />
<div style="text-align: center">
<asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0">
<asp:View ID="BBC_NEWS" runat="server" OnActivate="BBC_NEWS_Activate">
<table style="background-image: url(IMAGE/background.gif); width: 940px">
<tr>
<td style="width: 100px; text-align: left">
<asp:Image ID="Image1" runat="server" Height="36px" ImageUrl="~/IMAGE/powered-by.gif"
Width="172px" /></td>
</tr>
<tr>
<td style="width: 100px">
<asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
<HeaderTemplate>
<table style="width: 807px; border: 0; background-image: url(IMAGE/page_background.gif);">
</table>
<tr>
<td colspan="6" style="height: 21px">
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Size="14pt" Font-Underline="True"
ForeColor="#FF0033" Text="Financial News "></asp:Label>
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td colspan="6" style="height: 21px; text-align: left">
<span style="font-size: 12pt"><em><a href='<%#DataBinder.Eval(Container.DataItem,"Link") %>'>
<%#DataBinder.Eval(Container.DataItem,"Title") %>
</a></em></span>
</td>
</tr>
<tr>
<td color="black" colspan="6" style="vertical-align: top">
<asp:Label ID="Label1" runat="server" Font-Size="12" ForeColor="black" Text='<%#DataBinder.Eval(Container.DataItem,"pubDate") %>'></asp:Label>
</td>
</tr>
<tr>
<td color="black" colspan="6" style="vertical-align: top">
<asp:Label ID="Label2" runat="server" Font-Size="12" ForeColor="black" Text='<%#DataBinder.Eval(Container.DataItem,"Description") %>'></asp:Label>
</td>
</tr>
<tr>
<td colspan="6" style="vertical-align: top">
<hr />
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td colspan="6" style="height: 21px; text-align: left">
<span style="font-size: 12pt"><em><a href='<%#DataBinder.Eval(Container.DataItem,"Link") %>'>
<%#DataBinder.Eval(Container.DataItem,"Title") %>
</a></em></span>
</td>
</tr>
<tr>
<td color="black" colspan="6" style="vertical-align: top">
<asp:Label ID="Label1" runat="server" Font-Size="12" ForeColor="black" Text='<%#DataBinder.Eval(Container.DataItem,"pubDate") %>'></asp:Label>
</td>
</tr>
<tr>
<td color="black" colspan="6" style="vertical-align: top">
<asp:Label ID="Label2" runat="server" Font-Size="12" ForeColor="black" Text='<%#DataBinder.Eval(Container.DataItem,"Description") %>'></asp:Label>
</td>
</tr>
<tr>
<td colspan="6" style="vertical-align: top">
<hr />
</td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</td>
</tr>
</table>
<span style="font-size: 16pt; color: #ff0000"><strong style="background-image: url(IMAGE/background.gif)">
</strong></span>
</asp:View>
</asp:MultiView> </div>
<div style="text-align: left">
</div>
</div>
</form>
</body>
</html>
اما نمی دونم چرا خطا می ده.بچه ها خواهش می کنم برام درستش کنید کارم بدجوری لنگه.2هفته هست که به خاطرش نشستم.کمکم کنید.