Sradha WebCreations | mobile app designing Company In Cuttack,Bhubaneswar odisha: how to create dynamic Marquees any blogs

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">

.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>

<div>

<tr>

<Bewise:FlashControl ID="FlashControl1" runat="server" Height="300px"

MovieUrl="~/sms.swf" Width="1350px" />

</td>

</tr>

<tr>

<td class="style8" colspan="6">Enter headLine   

<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>

<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>

<b>BirthDay Sms</b>

</td>

</tr>

</HeaderTemplate>

<marquee id="ml" style="text-align: center; width: 542px;" direction="up" height="170"

scrolldelay="20" scrollamount="1">

<asp:Repeater ID="Repeater1" runat="server">

<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>

</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">

</head>

<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">

<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>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"

SelectCommand="SELECT * FROM [Sms] where([smsId]=@smsId)">

<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");

}

#SradhaWebCreations Contact : +91-9040573923, +91-7008182025 http://sradhawebcreations.com/ http://sradhawebcreations.blogspot.in/ https://facebook.com/sradhawebcreations https://www.facebook.com/Sradhawebeducation/

Pages

Saturday, August 18, 2018

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