ASP.NET

Friday, 7 February 2014

count No of User Visited My web Site

Global asax:-

<% Application Language="C#"%>
<Script Runat="server" >
Public void Application_Start(Object Sender EventArgs e)
{
Application["No of user visited My web Site"]=0;
}

public void Session Start(Object Sender Event Args e)
{
Application.Lock();
Application["No of User visited my web Site]=(int)Application["No of user Visited My web Site"] +1;
Application.Unlock();
}
</Script>

Default Page
<br>
No of user Visited web site
<tr>
<td>
<asp:Label Id="lblcount" runat="server">
</td>
</tr>
Page Load

lblCount.Text=Application["No of user Visited my web Site"].To String());

Monday, 3 February 2014

CAPTCHA

CAPTCHA: A best technique to restrict automatic form submission when developing a web page is to add some kind of verification.

HANDLER
<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Web.SessionState;
using System.Drawing;
using System.Drawing.Imaging;

public class Handler : IHttpHandler,IRequiresSessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (Bitmap b = new Bitmap(250, 50))
        {
            Font f = new Font("Arial", 10F);
            Graphics g = Graphics.FromImage(b);
            SolidBrush whiteBrush = new SolidBrush(Color.Blue);
            SolidBrush blackBrush = new SolidBrush(Color.White);
            RectangleF canvas = new RectangleF(0, 0, 250, 50);
            g.FillRectangle(whiteBrush, canvas);
            context.Session["Captcha"] = GetRandomString();
            g.DrawString(context.Session["Captcha"].ToString(), f, blackBrush, canvas);
            context.Response.ContentType = "image/gif";
            b.Save(context.Response.OutputStream, ImageFormat.Gif);
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

    private string GetRandomString()
    {
        string []arrStr = "A,B,C,D,1,2,3,4,5,6,7,8,9,0".Split(",".ToCharArray());
        string strDraw = string.Empty;
        Random r = new Random();
         for(int i = 0; i < 5 ; i++)
         {
              strDraw += arrStr[r.Next(0,arrStr.Length-1)];
         }
        return strDraw;
    }
}

<%@ 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 runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">

<div>

<img src="Handler.ashx" />

<br />

Please type above text here. To identify your self as a human

<br />

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />

<br />

<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />

<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></div>

</form>

</body>
</html>

CODE BEHIND
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Session["Captcha"].ToString() == TextBox1.Text)
        {
            Label1.Text = " Code Matched!";
        }
        else
        {
            Label1.Text = "Please try again";
            TextBox1.Text = "";
        }
    }
}

Friday, 31 January 2014

Always Visible ControlExtender

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

Wednesday, 29 January 2014

Run time Field Add

select sum(sub1+Sub2+Sub3+Sub4+Sub5) as TOTAL from MCA1

HERE MCA 1 IS TABLE NAME
RUN TIME TIME FIELD NAME IS TOTAL

Tuesday, 28 January 2014

Value add dynmanically in Grid view Item template

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

<!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>
    <asp:GridView ID="gvGrade" runat="server" AutoGenerateColumns="false"
            DataKeyNames="RollNo" onrowdatabound="gvGrade_RowDataBound"
           >
    <Columns>
    <asp:TemplateField HeaderText="Name">
    <ItemTemplate>
    <asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="RollNo">
<ItemTemplate>
<asp:Label ID="lblRollNo" runat="server" Text='<%#Bind("RollNo") %>'/>
</ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub1" >
    <ItemTemplate>
<asp:Label ID="lblSub1" runat="server" Text='<%#Bind("Sub1") %>'></asp:Label>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub2">

    <ItemTemplate>
    <asp:Label ID="lblSub2" runat="server" Text='<%#Bind("Sub2") %>'/>
    </ItemTemplate>

    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub3">
    <ItemTemplate>
    <asp:Label ID="lblSub3" runat="server" Text='<%#Bind("Sub3") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub4">
    <ItemTemplate>
    <asp:Label ID="lblSub4" runat="server" Text='<%#Bind("Sub4") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sub5">
    <ItemTemplate>
    <asp:Label ID="lblSub5" runat="server" Text='<%#Bind("Sub5") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="TotalMarks">
    <ItemTemplate>
    <asp:Label ID="lblTotal" runat="server" Text='<%# Bind("Total") %>'></asp:Label>
    </ItemTemplate>
        </asp:TemplateField>
    </Columns>

        <EditRowStyle HorizontalAlign="Left" VerticalAlign="Bottom" />

    </asp:GridView>
    </div>
    </form>
</body>
</html>

Code Behind

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.Data.SqlClient;
using System.Configuration;

public partial class GradeCard : System.Web.UI.Page
{
    DataSet ds = new DataSet();
    SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Marksheet();
            Label sub1 = (Label)gvGrade.Rows[0].FindControl("lblSub1");
          Label sub2 = (Label)gvGrade.Rows[0].FindControl("lblSub2");
          Label sub3 = (Label)gvGrade.Rows[0].FindControl("lblSub3");
          Label sub4 = (Label)gvGrade.Rows[0].FindControl("lblSub4");
          Label sub5 = (Label)gvGrade.Rows[0].FindControl("lblSub5");
            int s = Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub1.Text) + Convert.ToInt32(sub2.Text) + Convert.ToInt32(sub3.Text) + Convert.ToInt32(sub4.Text) + Convert.ToInt32(sub5.Text);
           ds.Tables[0].Columns.Add("Total");
           DataRow dr = ds.Tables[0].NewRow();
            dr["Total"] = s;
           ds.Tables[0].Rows.Add(dr);
           Marksheet();
        }

    }

    private void Marksheet()
    {
        string sql = "Select * From MCA";
        SqlCommand cmd = new SqlCommand(sql, con);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);

        sda.Fill(ds);
        if (!ds.Tables[0].Columns.Contains("Total"))
        {
            ds.Tables[0].Columns.Add("Total");
        }
        gvGrade.DataSource = ds;
        gvGrade.DataBind();

    }

Friday, 24 January 2014

Table Value Parameter

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

<!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>
    <panel>
    <asp:Repeater ID="rpt" runat="server" ViewStateMode="Enabled">
    <HeaderTemplate>
    <table>
    <tr>
    <td width="150px" align="center">Name</td>
    <td width="150px" align="center">Sex</td>
    <td width="150px" align="center">Age</td>
    </tr></table>
    </HeaderTemplate>
    <ItemTemplate>
    <table>
    <tr>
    <td width="150px" align="center"><asp:Label ID="lblName" runat="server" Text='<%#Bind("Name") %>'/></td>
    <td width="150px" align="center"><asp:Label ID="lblSex" runat="server" Text='<%#Bind("Sex") %>'/></td>
    <td width="150px" align="center"><asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/></td>
    </tr>
    </table>
    </ItemTemplate>
    </asp:Repeater>
    <br />
    <br />
    <asp:GridView ID="gv_Details" runat="server" AutoGenerateColumns="false"
            Width="444px">
    <Columns>
    <asp:TemplateField HeaderText="Name">
    <ItemTemplate>
    <asp:Label ID="Name" runat="server" Text='<%#Bind("Name") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Sex">
    <ItemTemplate>
    <asp:Label ID="Sex" runat="server" Text='<%#Bind("Sex") %>'/>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="Age">
    <ItemTemplate>
    <asp:Label ID="Age" runat="server" Text='<%#Bind("Age") %>'/>
    </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    </asp:GridView>
        <br />
        <br />
    <table width="450px">

    <tr>
    <td width="150px" align="center">Name</td>
    <td width="150px" runat="server">
    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
    </td>
     </tr>
     <tr>
    <td width="150px" align="center">Sex</td>
    <td width="150px" runat="server">
    <asp:TextBox ID="txtSex" runat="server"></asp:TextBox>
    </td></tr>
    <tr>
    <td width="150px" align="center">Age</td>
    <td width="150px" runat="server">
    <asp:TextBox ID="txtAge" runat="server"></asp:TextBox>
    </td>
   </tr>
   <tr>
   <td ><asp:Button ID="btnAdd" runat="server" Text="AddNew" onclick="btnAdd_Click"
           style="height: 26px" /></td>
   <td>
   <asp:Button Id="btnBind" Text="Bind" runat="server" onclick="btnBind_Click" />
   </td>
   </tr>
   <tr>
   <td colspan="2" align="center">
   <asp:Button ID="btnInsert" Text="Insert" runat="server" onclick="btnInsert_Click" />
   </td>
   </tr>
    </table>
        </panel>
    </div>
    </form>
</body>
</html>

Code Behind
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.Data.SqlClient;
using System.Configuration;

public partial class ViewState : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    DataTable dt = new DataTable();
    protected void btnBind_Click(object sender, EventArgs e)
    {

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if (ViewState["Emp"] == null)
        {
            dt.Columns.Add("Name");
            dt.Columns.Add("Sex");
            dt.Columns.Add("Age");
        }
        else
            dt=(DataTable)ViewState["Emp"];
            DataRow dr=dt.NewRow();
            dr["Name"]=txtName.Text;
            dr["Sex"]=txtSex.Text;
            dr["Age"]=txtAge.Text;
            dt.Rows.Add(dr);
            ViewState["Emp"] = dt;
            dt =(DataTable)ViewState["Emp"];


    }
    protected void btnInsert_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Y"].ToString());
        con.Open();
        dt = (DataTable)ViewState["Emp"];
        SqlCommand cmd = new SqlCommand("SP_EMP",con);
       cmd.CommandType=CommandType.StoredProcedure;
       SqlParameter para = new SqlParameter();
       para.ParameterName = "@EmployeeDetail";
       para.Value = dt;
       para.SqlDbType = SqlDbType.Structured;
       cmd.Parameters.Add(para);
       cmd.ExecuteNonQuery();

    }
}