Date AutoPopulate

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;
using System.IO;


namespace gridviewImg
{
    public partial class ddl : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString());
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Fill_Country();
                DropDownList2.Items.Insert(0, new ListItem("--select state--", "0"));
                DropDownList3.Items.Insert(0, new ListItem("--select city--", "0"));

                DropDownList2.Enabled = false;
                DropDownList3.Enabled = false;
            }
            if (!IsPostBack)
            {
                BindEmployeeData();
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string empName = Convert.ToString(DropDownList1.SelectedItem);
            string address = Convert.ToString(DropDownList2.SelectedItem);
            string cit=Convert.ToString(DropDownList3.SelectedItem);


            if (FileUpload1.HasFile && FileUpload2.HasFile)
            {
                string profileImageName = FileUpload1.PostedFile.FileName;
                string profileImage = FileUpload2.PostedFile.FileName;
                string filePath = Server.MapPath(@"~/Images/" + profileImageName);
                string newfilepath = Server.MapPath(@"~/Images/" + profileImage);
                FileUpload1.SaveAs(filePath);
                FileUpload2.SaveAs(newfilepath);
                        string commandText = "insert into Akll1 (country, state, city,img1,img2) values ('" + empName + "','" + address + "','"+cit+"','~/Images/" + profileImageName + "','~/Images/"+profileImage+"')";
                        var com = new SqlCommand(commandText, con);
                con.Open();
                        int result = com.ExecuteNonQuery();
                        if (result > 0)
                        {
                            BindEmployeeData();
                        }
                        else
                        {
                        Response.Write("nothing");
                        }
                con.Close();
            }
        }
    
        public void Fill_Country()
        {
            DataSet ds = new DataSet();
            ds = GetData("usp_country_get", null);
            if (ds.Tables[0].Rows.Count > 0)
            {
                DropDownList1.DataSource = ds;
                DropDownList1.DataBind();
                DropDownList1.Items.Insert(0, new ListItem("--select country--", "0"));
            }
        }
        private DataSet GetData(string SP_Name, SqlParameter param)
        {
            SqlDataAdapter da = new SqlDataAdapter(SP_Name, con);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            if (param != null)
            {
                da.SelectCommand.Parameters.Add(param);
            }
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds;

        }
        public void BindEmployeeData()
        {
                string commandText = "select * from Akll1";
                var com = new SqlCommand(commandText, con);
                var adapter = new SqlDataAdapter(com);
                DataSet ds = new DataSet();
                adapter.Fill(ds);
                GridView1.DataSource = ds;
                GridView1.DataBind();
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (DropDownList1.SelectedValue == "0")
            {
                DropDownList2.SelectedValue = "0";
                DropDownList2.Enabled = false;
            }
            else
            {
                DropDownList2.Enabled = true;
                SqlParameter param = new SqlParameter("@cid", DropDownList1.SelectedValue);
                DataSet ds = new DataSet();
                ds = GetData("usp_state_get", param);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    DropDownList2.DataSource = ds;
                    DropDownList2.DataBind();
                    DropDownList2.Items.Insert(0, new ListItem("--select state--", "0"));


                }
            }
            DropDownList3.SelectedValue = "0";
            DropDownList3.Enabled = false;
        }

        protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (DropDownList2.SelectedValue == "0")
            {
                DropDownList3.SelectedValue = "0";
                DropDownList3.Enabled = false;
            }
            else
            {
                DropDownList3.Enabled = true;
                SqlParameter param = new SqlParameter("@sid", DropDownList2.SelectedValue);
                DataSet ds = new DataSet();
                ds = GetData("usp_city_get", param);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    DropDownList3.DataSource = ds;
                    DropDownList3.DataBind();
                    DropDownList3.Items.Insert(0, new ListItem("--select city--", "0"));
                }
            }
        }
    }
}

CREATE TABLE Country(
          cid int IDENTITY(1,1) NOT NULL Primary Key,
          cname varchar(50) NULL,
)


CREATE TABLE State
(
          sid  int IDENTITY(1,1) NOT NULL Primary Key,
          sname varchar(50) NULL,
          cid int NULL,
)


CREATE TABLE City
(
          ctid int IDENTITY(1,1) NOT NULL Primary Key,
          ctname varchar(50) NULL,
          sid int NULL)

 create proc usp_country_get
as
begin
select * from Country
end

create proc usp_state_get  2
@cid int
as
begin
select * from State where cid=@cid
end


create proc usp_city_get
@sid int
as
begin
select * from City where sid=@sid
end



create table Akll1(country varchar(65),state varchar(65),city varchar(65),img1 nvarchar(100),img2 nvarchar(100))

insert into Country values('India')
insert into Country values('Russia')
insert into Country values('US')
insert into Country values('Japan')

insert into State values('Up',1)
insert into State values('Bihar',1)
insert into State values('MH',1)
insert into State values('Gujarat',1)
insert into State values('Altai Territory.',2)
insert into State values('Arkhangelsk Region',2)
insert into State values('California',3)
insert into State values('Texas',3)
insert into State values('Hokkaido',4)
insert into State values('Tohoko',4)


insert into City values('ndd',1)
insert into City values('tpg',1)
insert into City values('ckl',1)
insert into City values('rjy',2)
insert into City values('nsp',2)
insert into City values('plk',2)
insert into City values('tnk',3)
insert into City values('amp',3)
insert into City values('bvm',4)
insert into City values('vjw',4)
insert into City values('vza',5)
insert into City values('vja',5)
insert into City values('atp',6)
insert into City values('kdp',6)
insert into City values('kkd',7)
insert into City values('rjl',7)
insert into City values('el',8)
insert into City values('kvr',8)
insert into City values('tnv',9)
insert into City values('gn',9)
insert into City values('hrn',10)
insert into City values('delhi',10)

Thank You Sir.