1) Drag A Repeater from ToolBox into NewsScroller.aspx Design Surface
2) Create Table News with Columns as id int,URL varchar(50),Description varchar(50)
3) go to solution explorer--> right Click--> Add New Item--> add Class file-->Name it as connection.cs
in connection.cs write as
===========================================================
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
/// <summary>
/// Summary description for Connection
/// </summary>
public class Connection
{
public SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
public SqlCommand cmd = new SqlCommand();
public SqlDataReader dr;
public SqlDataAdapter da = new SqlDataAdapter();
public DataSet ds = new DataSet();
}
Write in Html as
=========================================================================
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="NewsReelMarquee.aspx.cs" Inherits="NewsReelMarquee" %>
<!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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<marquee id="ml" style="text-align: center" direction="up" width="195" height="170"
scrolldelay="20" scrollamount="1">
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<br />
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("URL") %>'>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("Description") %>'></asp:Label></asp:HyperLink><br />
</ItemTemplate>
</asp:Repeater>
</marquee>
</div>
</form>
</body>
</html>
In News Scroll.aspx.cs page Write as
======================================================
public partial class NewsReelMarquee : System.Web.UI.Page
{
Connection obj = new Connection();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Repeater1.DataSource = newsscroll();
Repeater1.DataBind();
}
}
public DataSet newsscroll()
{
obj.con.Close();
obj.con.Open();
obj.cmd = new SqlCommand("select url,description from news ",obj.con);
obj.da = new SqlDataAdapter(obj.cmd);
obj.da.Fill(obj.ds, "sdfasd");
return obj.ds;
}
Reference:
No comments:
Post a Comment