ASP.Net Example: 2012

Wednesday, August 1, 2012

How to embed blogger video audio player all in one plugin for mp3, mp4,mov,.3gp,swf

Lets Rock coding

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<script src="http://player.longtailvideo.com/jwplayer.js" type="text/javascript">
</script><br />
<br />
<div id="mediaplayer1">
</div>
<script type="text/javascript">
  jwplayer('mediaplayer1').setup({
    'flashplayer': 'http://player.longtailvideo.com/player.swf',
    
    'width': '480',
    'height': '270',
    'file': 'http://content.longtailvideo.com/videos/8.flv',
    'image': 'http://content.longtailvideo.com/images/8.jpg',
    'plugins': {
       'viral-2': {
           'onpause': 'false',
           'callout': 'none'
       }
    }
  });
</script>

</div>

Sunday, July 8, 2012

How to use substring and len function in sql server 2005 or 2008

I am giving one example from that you will understand How to use Substring and Len Funcation.
Suppose I have one table employee with 1000 of Record. and Having one Column Name is stImage.
This column contain link of Image. stImage contain data like http://www.example.com/images/sqlserversubstring.jpg now I want to change only domain name only replace with http://aspdotnet-example.com/images/sqlserversubstring.jpg for that we will do

update employee set stImage= 'http://aspdotnet-example.com'+
SUBSTRING(stImage,len('http://www.example.com'),len(stImage))
from employee

Tuesday, June 19, 2012

How to Set Identity in Sql Server 2005 or 2008 ?

You have Sql Table Which Having for Example 20 Records. And Identity also 20. Now you want insert new Record with Identity 100 then you pass 99 in below function as Parameter and Table Name and Reseed .

DBCC CHECKIDENT (TableName, reseed, 99)

Tuesday, May 1, 2012

DropDownList value set By FindBy ASP.NET Example

In asp.net there are two ways to FindBy DropdownList. 1.FindByValue and 2.FindByText In FindByValue if more then one List Item text is same then it is working Properly also.

ddlDropDownList.Items.FindByValue(strSearchText).Selected = true;

In FindByText ASP.NET In FindByText if more then one List Item text is same then it is not working Properly also.

ddlDropDownList.Items.FindByText(strSearchText).Selected = true;

There is also other way to DropDownList Select Value through Text but this is Best Way. That's why I choose it.

Friday, March 9, 2012

unable to find the requested .net framework data provider. it may not be installed. sql ce 4.0

unable to find the requested .net framework data provider.
it may not be installed. sql ce 4.0
this error with asp.net mvc music store example.
you have install
in web.config

Monday, March 5, 2012

File Type Filter FileUpload Control

File Upload File Type Filter With ASP.NET
File Upload File Type Filter is not available in asp.net.
There is one way using that we can achieve our goal that is
File Dialogue of Window Desktop Application can filter type but is working only one window7, window xp or
other Microsoft OS only that is not working with Mac,Linux based system for we need to study their file system. so that is not easy way.

Friday, February 24, 2012

GridView Show Footer And Header No Record in Grid

When No Record in Grid view at that time show Header and Footer.
only we add on Row in Dataset.

GridViewNoRecord.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="GridViewNoRecord.aspx.cs" 
Inherits="GridViewNoRecord" %>

<!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>GridView Show Footer And Header No Record in Grid</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1>
<a href="http://aspdotnet-example.blogspot.com/">http://aspdotnet-example.blogspot.com
</a>
</h1>
<h1>GridView Show Footer And Header No Record in Grid</h1>
<asp:GridView ID="gridView" runat="server" AutoGenerateColumns="false" DataKeyNames="MetalId"
EmptyDataText="No Data Found." PageSize="10" CellPadding="4" ForeColor="#333333"
GridLines="None" Style="margin-right: 0px" AllowPaging="True">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:BoundField DataField="MetalName" HeaderText="GridView Name" ReadOnly="True"
SortExpression="MetalName" />
<asp:BoundField DataField="Status" ItemStyle-HorizontalAlign="Center"
 HeaderText="Is GridView Active?"
ReadOnly="True" SortExpression="Status" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</div>
</form>
</body>
</html>

GridViewNoRecord.aspx.cs

using System;
using System.Linq;
using System.Web.UI.WebControls;
using System.Data;

public partial class GridViewNoRecord : System.Web.UI.Page

{

    LogicLayer objLogicLayer = new LogicLayer();

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)
        {

            FillGridView();

        }

    }

    protected void FillGridView()

    {

        if (objLogicLayer.ListMetals().Tables[0].Rows.Count != 0)

        {

            gridView.DataSource = objLogicLayer.ListMetals();

            gridView.DataBind();

        }

        else

        {

            BuildNoRecords(gridView, objLogicLayer.ListMetals());

        }

    }
     public void BuildNoRecords(GridView gridView, DataSet ds)
    {

        try

        {

            ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());

            ds.Tables[0].Rows[0][1] = "No Records Found.";

            gridView.DataSource = ds;

            gridView.DataBind();
}

        catch (Exception ex)

        {

        }

    }

}

GridView Show Footer And Header No Record in Grid

How to send mail using SMTP Mail in asp.net

using System;
using System.Web.Mail;

public class SmtpMailExample
{
public static void Main()
{
string FromSMTP = "from@asp.net";
string ToSMTP = "to@smtp.net";
string SubjectSMTP = "This is a SMTP Test Mail Example Message";
string BodySMTP = "Hi .";

SmtpMail.SmtpServer = "192.168.1.151";
SmtpMail.Send(FromSMTP, ToSMTP, SubjectSMTP, BodySMTP);
}
}

Tuesday, February 14, 2012

call system dll method csharp

call system dll method in csharp application.

in this example we are using User32.dll file.

How to Clear Browser Cache using Javascript ?

This very Common Problem facing web developer. whenever user updating style sheet.

they need to press (Ctrl + F5) for clear browser cache.

Now if you are using any JavaScript file  then give name like

for i.e 
JavaScriptFileName.js?Math.random()

<script type="text/javascript"

src="http://hostname.net/js/JavaScriptFileName.js?Math.random()">

</script>

this is solution for clear browser cache.

List View Drag and Drop Control using Jquery

 In this example two things are covered.

1. List View Drag and Drop Control using Jquery

2. How to read data from XML ?

 dragNdrop.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="dragNdrop.aspx.cs"

Inherits="DragItemInListViewASPNET.dragNdrop" %>

<!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>
    <link href="JQuery/jquery-ui.css" rel="stylesheet" type="text/css" />
    <script src="JQuery/jquery-1.4.4.min.js" type="text/javascript"></script>
    <script src="JQuery/jquery-ui.min.js" type="text/javascript"></script>
    <style type="text/css">
        #DragableTable1, #DragableTable2
        {
            list-style-type: none;
            border-right: #669999 2px solid;
            padding-right: 5px;
            border-top: #669999 2px solid;
            padding-left: 5px;
            float: left;
            padding-bottom: 0px;
            margin: 3px;
            border-left: #669999 2px solid;
            width: 160px;
            padding-top: 5px;
            border-bottom: #669999 2px solid;
        }
        #DragableTable1 li, #DragableTable2 li
        {
            border-right: #000 1px solid;
            padding-right: 2px;
            border-top: #000 1px solid;
            padding-left: 2px;
            font-size: 15px;
            margin-bottom: 5px;
            padding-bottom: 2px;
            border-left: #000 1px solid;
            width: 156px;
            cursor: pointer;
            padding-top: 2px;
            border-bottom: #000 1px solid;
            background-color: #eee;
        }
    </style>
    <script type="text/javascript">
        $(function () {
            $("#DragableTable1, #DragableTable2").sortable({
                connectWith: ".connectedDragableTable"
            }).disableSelection();
        });

        $(document).ready(function () {
            $("li").dblclick(function () {
                $(this).closest('li').remove();
            });
        });   
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <h1>
        <b>List view Drag and Drop Example</b></h1>
    <br />
    <div>
        <asp:ListView ID="ListView1" runat="server">
            <LayoutTemplate>
                <ul id="DragableTable1" class="connectedDragableTable">
                    <asp:PlaceHolder runat="server" ID="itemPlaceholder">

</asp:PlaceHolder>
                </ul>
            </LayoutTemplate>
            <ItemTemplate>
                <li class="ui-state-default">
                    <%# Eval("Dragvalue1") %></li>
            </ItemTemplate>
        </asp:ListView>
        <asp:ListView ID="ListView2" runat="server">
            <LayoutTemplate>
                <ul id="DragableTable2" class="connectedDragableTable">
                    <asp:PlaceHolder runat="server" ID="itemPlaceholder">

</asp:PlaceHolder>
                </ul>
            </LayoutTemplate>
            <ItemTemplate>
                <li class="ui-state-highlight">
                    <%# Eval("Dragvalue2") %></li>
            </ItemTemplate>
        </asp:ListView>
    </div>
    </form>
</body>
</html>

dragNdrop.aspx.cs

using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Data;
namespace DragItemInListViewASPNET
{
    public partial class dragNdrop : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

            XmlDocument xmlDocument = new XmlDocument();
            using (DataTable objListView1 = new DataTable())
            {
                objListView1.Columns.Add("Dragvalue1", Type.GetType("System.String"));
 xmlDocument.Load(AppDomain.CurrentDomain.BaseDirectory + "/XmlFile/ListViewData1.xml");
 XmlNodeList xmlNodeList = xmlDocument.SelectNodes("root/data[@open='1']");
                foreach (XmlNode xmlNode in xmlNodeList)
                {
                    DataRow dr = objListView1.NewRow();
                    dr["Dragvalue1"] = xmlNode.InnerText;
                    objListView1.Rows.Add(dr);
                }
                ListView1.DataSource = objListView1;
                ListView1.DataBind();
            }

            XmlDocument xmlDocument2 = new XmlDocument();
            using (DataTable objListView2 = new DataTable())
            {
                objListView2.Columns.Add("Dragvalue2", Type.GetType("System.String"));

xmlDocument2.Load(AppDomain.CurrentDomain.BaseDirectory + "/XmlFile/ListViewData2.xml");
 XmlNodeList xmlNodeList2 = xmlDocument2.SelectNodes("root/data[@open='1']");
                foreach (XmlNode xmlNode in xmlNodeList2)
                {
                    DataRow dr = objListView2.NewRow();
                    dr["Dragvalue2"] = xmlNode.InnerText;
                    objListView2.Rows.Add(dr);
                }
                ListView2.DataSource = objListView2;
                ListView2.DataBind();
            }
        }
    }
}

ListViewData1.xml

<?xml version="1.0" encoding="utf-8" ?>
<root>
  <data open="1">drag and drop element 1</data>
  <data open="1">drag and drop element 2</data>
  <data open="1">drag and drop element 3</data>
  <data open="1">drag and drop element 4</data>
  <data open="1">drag and drop element 5</data>
  <data open="1">drag and drop element 6</data>
  <data open="1">drag and drop element 7</data>
</root>

 This Linq example show you how to use where clause with array

How to create Chart in asp.net ?

Create Chart control in asp.net

 Chart.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Chart.aspx.cs"

Inherits="Chart" %>

<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0,

Culture=neutral, PublicKeyToken=31bf3856ad364e35"

Namespace="System.Web.UI.DataVisualization.Charting"

TagPrefix="asp" %>
<!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>ASP.NET Chart Control Example</title>
</head>
<body>

<form id="form1" runat="server">

<div>

<h1><b>ASP.NET Chart Control Example</b></h1>

<asp:Chart ID="ChartAspnet" runat="server" Height="400px" Width="500px">

<Series>

<asp:Series Name="SeriesASPNET" ChartType="Column" ChartArea="ChartAreaASPnet">

</asp:Series>

<asp:Series Name="SeriesASPNET1" ChartType="Column" ChartArea="ChartAreaASPnet">

</asp:Series>

</Series>

<ChartAreas>

<asp:ChartArea Name="ChartAreaASPnet">

</asp:ChartArea>

</ChartAreas>

</asp:Chart>

</div>

</form>
</body>
</html>

if condition in gridview source code page

if condition in gridview in source code or .aspx page

this will decrease many operation so performance increase.

<Columns>
  <asp:TemplateField>
    <ItemTemplate>
      <asp:ImageButton ID="ifgridview" runat="server" 
         ImageUrl=<%# ((bool) Eval("condition"))? "yes.png":"no.png" %>
         OnClick="ifgridview_Click" />
    </ItemTemplate>
  </asp:TemplateField>
</columns>

Thursday, January 26, 2012

scroll bar in table

Scrollbar in table is not possible.

There is one way in that UI is like Scroll bar in table.

 <div style="height: 250px; overflow: scroll;">

<table></table>
</div>

Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
And Repeat 1	And Repeat 2	And Repeat 3
Scroll bar Table Cell Content 1	Scroll bar Table Cell Content 2	Scroll bar Table Cell Content 3
More Scroll bar Table Cell Content 1	More Scroll bar Table Cell Content 2	More Scroll bar Table Cell Content 3
Even More Scroll bar Table Cell Content 1	Even More Scroll bar Table Cell Content 2	Even More Scroll bar Table Cell Content 3
End of Scroll bar Table Cell Content 1	End of Scroll bar Table Cell Content 2	End of Scroll bar Table Cell Content 3

Wednesday, January 18, 2012

video audio player all in one plugin for mp3, mp4,mov,.3gp,swf in asp.net,php,jsp

Browser JWPlayer support .mp3, .mp4, .mov, .swf
below example is given

<script type='text/javascript' src='/jwplayer/jwplayer.js'></script>
<div id='mediaplayer'></div>
<script type="text/javascript">
  jwplayer('mediaplayer').setup({
    'flashplayer': 'player.swf',
    'id': 'playerID',
    'width': '480',
    'height': '270',
    'file': 'video.flv',
    'image': 'image.jpg',
    'plugins': {
       'viral-2': {
           'onpause': 'false',
           'callout': 'none'
       }
    }
  });
</script>

Plugin Download

ASP.Net Example

Pages