How to go back to login page after session expires.

I am sharing some links , i think it will help u ...................


http://csharpdotnetfreak.blogspot.com/2008/11/detecting-session-timeout-and-redirect.html

http://aspnetresources.com/blog/count_your_visitors.aspx

http://www.aspdotnetfaq.com/Faq/How-to-show-number-of-online-users-visitors-for-ASP-NET-website.aspx

http://aspnet101.com/aspnet101/tutorials.aspx?id=16

http://stackoverflow.com/questions/1508529/count-number-of-visitors-in-website-using-asp-net-and-c

http://search.code-head.com/F-Count-Number-of-Visitors-in-WebSite-using-ASP.Net-and-C-2183242

http://www.asp101.com/samples/counter_aspx.asp

Write a program to ADD Two Matrix in C#

Yes here ,I am writing a program in C# to add two matrix.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleApplication1
{
    class AddTwo_Matrix
    {
        static void Main(string[] args)
        {
            int[,] a = { { 1, 3, 4 }, { 2, 4, 7 }, { 3, 5, 6 } };
            int[,] b = { { 3, 5, 5 }, { 4, 5, 6 }, { 2, 7, 8 } };
            int[,] c = new int[3,3];
            int f = c.Length;
            int i, m = 0;
            int j = 0, n = 0;
            for (i = 0; i < 3; i++)
            {
                Console.WriteLine("");
                for (j = 0; j < 3; j++)
                {
                    Console.WriteLine(""+a[i,j]);
                }
            }
            Console.WriteLine("\n");
            for (m = 0; m < 3; m++)
            {
                Console.WriteLine("");
                for (n = 0; n < 3; n++)
                {
                    Console.WriteLine(""+b[m,n]);
                }
            }
            Console.WriteLine("\n");
            for (int k = 0; k < 3; k++)
            {
                Console.WriteLine("");
                for (int l = 0; l < 3; l++)
                {
                    Console.WriteLine(a[k,l]+b[k,l]+"\t");
                }
            }
            Console.WriteLine("yes it is Solved ,its very easy to add two matrix");
            Console.Read();

        }
    }
}

How to Find nth Salary and his id from a table in SQL server

I am writhing a query that will be helpful in finding nth salary and his id of that record.

so its very simple and very understandable.......

select ID ,salary from testing where salary in(select MIN(salary) from testing where
salary in (select top 4 salary from testing   order by salary desc))


Here, First we find the nth salary from the table in decreasing order and then we select min salary from that records means from it sub query.
and then can fetch id ,salary of the table from the sub query result as u seeing in query.

if you are unable to understand then please drop a comment at below..............

or mail me at Kushwaha.pankajkumar07@gmail.com

How To check Session authentication in asp.net

 I hope that it will be beneficial for everyone.....

protected void Button1_Click(object sender, EventArgs e)
    {
        if (txtmajorhead.Text == "")
        {
            lbl_msg.Text = "User Name is required !";
        }
        else if (txtdescp.Text == "")
        {
            lbl_msg.Text = "Password is required !";
        }
        else
        {
            Parameter UserId = new Parameter(txtmajorhead.Text);
            Parameter Password = new Parameter(txtdescp.Text);
            SqlDataAdapter da = new SqlDataAdapter("select * from Login where UserID='" + UserId + "' and Password='" + Password + "'", con);
            DataSet ds = new DataSet();
            da.Fill(ds);
           
            if (ds.Tables[0].Rows.Count > 0)
            {
                Session["UserID"] = ds.Tables[0].Rows[0]["UserID"].ToString();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    if ((ds.Tables[0].Rows[i]["UserID"].ToString() == txtmajorhead.Text) && (ds.Tables[0].Rows[i]["Password"].ToString() == txtdescp.Text))
                    {
                        f = 1;

                        Response.Redirect("AddCategory.aspx");
                        break;
                    }
                }
            }
            if (f == 0)
            {

                lbl_msg.Text = "UserName And Password Are Incorrect";


            }
            txtmajorhead.Focus();

        }

How To Bind the Country, State and City in Asp.net

If you want to bind the Country and State and City in asp.net .....follow these Steps

1. Open Visual Studio 2010

2. New Project

3. And .aspx page Design will be like this or as per as your requirement

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="statebinding.aspx.cs" Inherits="WebApplication1.statebinding" %>

<!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">
        .style1
        {
            width: 100%;
            height: 62px;
        }
        .style2
        {
            width: 202px;
        }
        .style3
        {
            width: 202px;
            height: 34px;
        }
        .style4
        {
            height: 34px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <br />
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
       
        </ContentTemplate>
        </asp:UpdatePanel>
   
    </div>
    <table class="style1">
        <tr>
            <td>
                <asp:Label ID="lblCountry" runat="server" Text="Country"></asp:Label>
            </td>
            <td>
                <asp:DropDownList ID="DropDownList1" runat="server" Height="23px" Width="153px"
                    onselectedindexchanged="DropDownList1_SelectedIndexChanged1">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="lblState" runat="server" Text="State"></asp:Label>
            </td>
            <td>
                <asp:DropDownList ID="DropDownList2" runat="server" Height="22px" Width="152px"
                    onselectedindexchanged="DropDownList2_SelectedIndexChanged">
                </asp:DropDownList>
            </td>
        </tr>
    </table>
    <table class="style1">
        <tr>
            <td class="style3">
                <asp:Label ID="lblCity" runat="server" Text="City"></asp:Label>
            </td>
            <td class="style4">
                <asp:DropDownList ID="DropDownList3" runat="server" Height="28px"
                    style="margin-left: 3px" Width="151px">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td class="style2">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    </form>
</body>
</html>
4.And Now Do the Code for aspx.cs File...............

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace WebApplication1
{
    public partial class statebinding : System.Web.UI.Page
    {
      // public string str="Data Source=PANKAJ-PC\\SQLEXPRESS2008;Initial Catalog=Data;User ID=sa;Password=sa2008";
       private SqlConnection con = new SqlConnection("Data Source=PANKAJ-PC\\SQLEXPRESS2008;Initial Catalog=Data;User ID=sa;Password=sa2008");
       public void BindCountry()
       {
           con.Open();
           SqlCommand com = new SqlCommand("Select County,CountryId  from Country",con);
           SqlDataReader ds = com.ExecuteReader();
           DropDownList1.DataSource = ds;
           DropDownList1.Items.Clear();
           DropDownList1.Items.Add("--Please Select Country--");
           DropDownList1.DataTextField = "County";
           DropDownList1.DataValueField = "CountryId";
           DropDownList1.DataBind();
           con.Close();
       }
       public void BindState()
       {
           con.Open();
           SqlCommand com1 = new SqlCommand("select State,StateId from countryState where CountryId='" + DropDownList1.SelectedValue +"'", con);
           SqlDataReader rd = com1.ExecuteReader();
           DropDownList2.DataSource = rd;
           DropDownList2.Items.Clear();
           DropDownList2.Items.Add("--Please select State--");
           DropDownList2.DataTextField = "State";
           DropDownList2.DataValueField = "StateId";
           DropDownList2.DataBind();
           con.Close();

       }
       public void citybind()
       {
           con.Open();
           SqlCommand com2 = new SqlCommand("Select * from stateCity where StateId='"+DropDownList2.SelectedValue+"'",con);
           SqlDataReader dr = com2.ExecuteReader();
           DropDownList3.DataSource = dr;
           DropDownList3.Items.Clear();
           DropDownList3.Items.Add("--Please select City--");
           DropDownList3.DataTextField = "City";
           DropDownList3.DataValueField = "CityId";
           DropDownList3.DataBind();
           con.Close();
       }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindCountry();
            }

        }

        protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
        {
            citybind();
        }

        protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
        {
            BindState();
        }

    }
}

If you face any problem then Send feedback to me ............Thanks

How To Bind Dropdownlist from Database in asp.net

Please follow these steps to bind the dropdown list in asp.net

1. Open Visual Studio 2010

2.New Project

3.Asp.net Web Application

Design the Default page like this:-
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._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></title>
    <style type="text/css">
        .style1
        {
            width: 100%;
        }
        .style2
        {
            width: 89px;
        }
        .style3
        {
            width: 89px;
            height: 41px;
        }
        .style4
        {
            height: 41px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <table class="style1">
            <tr>
                <td class="style2">
                    <asp:Label ID="Label1" runat="server" Text="Please Select"></asp:Label>
                </td>
                <td>
                    <asp:DropDownList ID="DropDownList1" runat="server" Height="22px" Width="152px">
                    </asp:DropDownList>
                &nbsp;<asp:Button ID="Button1" runat="server" onclick="Button1_Click"
                        Text="Button" />
                </td>
              
            </tr>
            <tr>
                <td class="style3">
                    </td>
                <td class="style4">
                    <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
                </td>
                <td class="style4">
                    </td>
                          </tr>
        </table>
   
    </div>
    </form>
</body>
</html>








After that Code for the Default.aspx.cs file

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

namespace WebApplication1
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string connectionstring = "Data Source=PANKAJ-PC\\SQLEXPRESS2008;Initial Catalog=Data;User ID=sa;Password=sa2008";
            SqlConnection con = new SqlConnection(connectionstring);
            string com1="select * from pankaj";
            SqlDataAdapter ad = new SqlDataAdapter(com1,con);
            DataTable dt = new DataTable();
            ad.Fill(dt);
            DropDownList1.DataSource = dt;
            DropDownList1.DataBind();
            GridView1.DataSource = dt;
            GridView1.DataBind();
            DropDownList1.DataTextField = "Name";
            DropDownList1.DataValueField = "Pid";
            DropDownList1.DataBind();
            Label2.Visible = false;
          


        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string connectionstring = "Data Source=PANKAJ-PC\\SQLEXPRESS2008;Initial Catalog=Data;User ID=sa;Password=sa2008";
            SqlConnection conn = new SqlConnection(connectionstring);
            SqlCommand com = new SqlCommand("select * from pankaj where pid='"+DropDownList1.SelectedValue+"'",conn);
            SqlDataAdapter dt1 = new SqlDataAdapter(com);
            DataSet ds = new DataSet();
            dt1.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            Label2.Text = "Record Found According to Selection";
            Label2.Visible = true;
        }

      
    }
}
 
Output will look like this..............................................

How to get text box value by using java Script

Add A text box to the Page and then

 <asp:Button ID="Button1" runat="server" Text="Button" OnClientClick="display()"/>

--JavaScript  Code--

  <script language="javascript" type="text/javascript">
        function display() {
            var text = document.getElementById('<%= TextBox1.ClientID %>').value;
            if (text==="") {
                alert("Please enter Something very carefully");
            }
            else {
                alert("Hi its good");
            }
        }
    </script>