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>

How to check a number is Prime or no ?

By this Code You can check a number is Prime or not....and can you check static array values also..


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

namespace ConsoleApplication1
{
    class primenumber
    {
        static void Main(string[] args)
        {
            int i;
            Console.WriteLine("Please enter the nu,mber which u want to test");
            int number = Convert.ToInt32(Console.ReadLine());
            for ( i = 2; i < number; i++)
            {
                if (number % i == 0)
                {
                    Console.WriteLine("Number is not prime {0}", number);
                    break;
                }
            }
            if (number == i)
            {
                Console.WriteLine("Number is Prime {0}", number);
            }
            primenumber ob = new primenumber();
            ob.checkedi();
            Console.ReadKey();
        }
        public void checkedi()
        {
            int[] arr = {12,23,34,456,56,1243,123};
            for (int j = 0; j < arr.Length; j++)
            {
                for(int k=2;k<arr.Length; k++)
                {
                    if (arr[j] % k == 0)
                    {
                        Console.WriteLine("array number {0} is not prime", arr[j]);
                        break;
                    }
                    else
                    {
                        Console.WriteLine("Array number is {0} prime",arr[j]);
                        break;
                    }
                }
            }
        }
    }
}

Fibonacci Series code in c#

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

namespace ConsoleApplication1
{
    class Fibonacciseries
    {
        int prev = 0;
        int next = 1;
        public void fibonacci(int n)
        {
            for (int i = 0; i < n; i++)
            {
                int sum = prev + next;
                prev = next;
                next = sum;
                Console.WriteLine(sum);
               
            }
        }
       
        static void Main(string[] args)
        {
            Fibonacciseries ob = new Fibonacciseries();
            Console.WriteLine("Please enter the length of the series");
            ob.fibonacci(Convert.ToInt32(Console.ReadLine()));
            Console.ReadKey();
        }
     
    }
}

How to add Twitter Follow Button to Asp.net Application using c#

If you want to add twitter follow button to your application in Asp.net
Then just do it.............

Add the given code in content place holder section where you want to add twitter button.


 <a href="https://twitter.com/twitterapi" class="twitter-follow-button" data-show-count="true">Follow @twitterapi</a>
      <script>!function (d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (!d.getElementById(id)) { js = d.createElement(s); js.id = id; js.src = "//platform.twitter.com/widgets.js"; fjs.parentNode.insertBefore(js, fjs); } } (document, "script", "twitter-wjs");</script> 


this code taken from twitter developer page. if you want to extra help then go to twitter developer page.

Inheritance using C#

Inheritance is mechanism by which a class can inherit the property of the Base class. A derived class can access all Non-private member of the base class.
Classes can inherit from another class. This is accomplished by putting a colon after the class name when declaring the class

public class A
{
    public A() { }
}

public class B : A
{
    public B() { }
}

Then gains all the non-private data and behavior of the base class in addition to any other data or behaviors it defines for itself.