Showing posts with label dynamic news slider by using asp.net and sql server. Show all posts
Showing posts with label dynamic news slider by using asp.net and sql server. Show all posts

Saturday, August 18, 2018

how to create dynamic Marquees any blogs, news portal, Dynamic News Slider etc | Sradha Webcreations

How to create dynamic Marquees any blogs, news portal, Dynamic News Slider 

Controls use :-Repeater, image button,flash control etc……
AdvanceMarquee1.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AdvanceMarquee1.aspx.cs" Inherits="AdvanceMarquee1" %>

<%@ Register assembly="FlashControl" namespace="Bewise.Web.UI.WebControls" tagprefix="Bewise" %>

<!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>
    <style type="text/css">
        .style3
        {
            text-align: center;
            height: 55px;
        }

        .style4
        {
            text-align: center;
            height: 19px;
        }

        .style6
        {
            font-weight: bold;
        }
        .style8
        {
            text-align: left;
            height: 19px;
            font-weight: bold;
        }
        .style9
        {
            text-align: left;
        }
        .style10
        {
            text-align: center;
            height: 19px;
            width: 371px;
        }

    </style>
</head>
<body bgcolor="#669900">
<form id="form1" runat="server">
   
    <div>
   
        <table align="center">
            <tr>
                <td colspan="6" class="style3">
<Bewise:FlashControl ID="FlashControl1" runat="server" Height="300px"
                        MovieUrl="~/sms.swf" Width="1350px" />
                </td>
               </tr>
            <tr>
                <td class="style8" colspan="6">Enter headLine&nbsp;&nbsp;&nbsp;
                    <asp:TextBox ID="TextBoxHeadLine" runat="server" CssClass="style6"
                        Height="28px" Width="183px"></asp:TextBox>
                </td>
            
            </tr>
            <tr>
 <td class="style8" colspan="6">Enter Subject <asp:TextBox ID="TextBoxSubject"
 runat="server" CssClass="style6" Height="28px" Width="183px"></asp:TextBox>
                </td>
               </tr>
            <tr>
                <td class="style10">
<asp:ImageButton ID="ImageButtonSubmit" runat="server" Height="32px" ImageUrl="~/Button.png" Width="116px" onclick="ImageButtonSubmit_Click"
                        style="text-align: left" />
                   
<asp:ImageButton ID="ImageButtonCancel" runat="server" Height="32px"
ImageUrl="~/cancelRed.png"  style="margin-top: 0px"  Width="116px" onclick="ImageButtonCancel_Click" />
                </td>                        
            </tr>
            <tr>
                <td class="style4" colspan="6">
                    <HeaderTemplate>
<table style=" border:1px solid #df5015; width:500px" cellpadding="0">
<tr style="background-color:#df5015; color:White">
<td class="style9">
<b>BirthDay Sms</b>
</td>
</tr>
</HeaderTemplate>
                <td bgcolor="White">
<marquee id="ml" style="text-align: center; width: 542px;" direction="up" height="170"
               scrolldelay="20" scrollamount="1">
                    <asp:Repeater ID="Repeater1" runat="server">                 
                      <ItemTemplate>
                       <br />
                       <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%#"~/AdvanceMarqueePass.aspx?SmsId="+ Eval("SmsId") %>'>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("SmsHeadline") %>'> </asp:Label></asp:HyperLink><br />
                      </ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>


                    </asp:Repeater></marquee>
                </td>
            </tr>
        </table>           
     </div>
    </form>
</body>
</html>
AdvanceMarquee1.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.Security;


public partial class AdvanceMarquee1 : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Repeater1.DataSource = GetData();
           Repeater1.DataBind();
        }
    }

    protected void ImageButtonSubmit_Click(object sender, ImageClickEventArgs e)
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("insert into Sms (SmsHeadLine,SmsSubject,PostedDate) values(@SmsHeadLine,@Smssubject,@postedDate)", con);
        cmd.Parameters.AddWithValue("@SmsHeadLine", TextBoxHeadLine.Text);
        cmd.Parameters.AddWithValue("@Smssubject", TextBoxSubject.Text);
        cmd.Parameters.AddWithValue("@postedDate", DateTime.Now);
        cmd.ExecuteNonQuery();
        con.Close();
        TextBoxHeadLine.Text = string.Empty;
        TextBoxSubject.Text = string.Empty;
       // BindRepeaterData();
      
    }

    public DataSet GetData()
    {
        string sql = "select SmsId,SmsHeadLine from Sms";
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString);

        //SqlConnection conn = new SqlConnection(DatabaseConnectionString);
        {
            conn.Open();
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);

            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("Smsid", typeof(Int32)));
            dt.Columns.Add(new DataColumn("SmsHeadline", typeof(string)));
            DataRow dr;
            int i = 1;
            int len = Convert.ToInt16(ds.Tables[0].Rows.Count);
            if (ds.Tables[0].Rows.Count > 0)
            {
                for (i = 0; i < len; i++)
                {
                    dr = dt.NewRow();
                    dr["SmsId"] = Convert.ToInt16(ds.Tables[0].Rows[i]["SmsId"]);
                    dr["SmsHeadline"] = ds.Tables[0].Rows[i]["SmsHeadLine"].ToString();
                    dt.Rows.Add(dr);
                }
            }
            return ds;
      }
    }

    protected void ImageButtonCancel_Click(object sender, ImageClickEventArgs e)
    {
        TextBoxHeadLine.Text = "";
        TextBoxSubject.Text = "";
    }
}
AdvanceMarqueePass.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AdvanceMarqueePass.aspx.cs" Inherits="AdvanceMarqueePass" %>

<!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 bgcolor="#669900">
    <form id="form1" runat="server">
    <div>
   
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
            DataKeyNames="SmsId" DataSourceID="SqlDataSource1" AllowPaging="True"
            AllowSorting="True" CellPadding="4" ForeColor="#333333" GridLines="None"
            Width="1350px">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
              <asp:BoundField DataField="SmsId" HeaderText="SmsId" InsertVisible="False"
                    ReadOnly="True" SortExpression="SmsId" />
                <asp:BoundField DataField="SmsHeadLine" HeaderText="SmsHeadLine"
                    SortExpression="SmsHeadLine" />
                <asp:BoundField DataField="SmsSubject" HeaderText="SmsSubject"
                    SortExpression="SmsSubject" />
                <asp:BoundField DataField="PostedDate" HeaderText="PostedDate"
                    SortExpression="PostedDate" />
            </Columns>
            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
         <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
            <SortedAscendingCellStyle BackColor="#FDF5AC" />
            <SortedAscendingHeaderStyle BackColor="#4D0000" />
            <SortedDescendingCellStyle BackColor="#FCF6C0" />
            <SortedDescendingHeaderStyle BackColor="#820000" />
        </asp:GridView>
   
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"
            SelectCommand="SELECT * FROM [Sms] where([smsId]=@smsId)">
            <SelectParameters>
<asp:QueryStringParameter Name="SmsId"
QueryStringField="SmsId"
Type="Decimal" />
</SelectParameters>
            </asp:SqlDataSource>   
    </div>
    <asp:ImageButton ID="ImageButton1" runat="server" Height="44px"
        ImageUrl="~/BackRed.png" onclick="ImageButton1_Click" Width="200px" />
    </form>
</body>
</html>

AdvanceMarqueePass.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class AdvanceMarqueePass : System.Web.UI.Page
{
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        Response.Redirect("~/AdvanceMarquee1.aspx");
    }
}