problem with dropdownlist

hi

create same code

in aspx page

<asp:DropDownList ID="ddl_offic_depar" runat="server" CssClass="ddl_width" Style="border: 1px solid black;"
                                            DataTextField="dept_name" DataValueField="dept_id" AppendDataBoundItems="true">
                                            <asp:ListItem>--Select Department--</asp:ListItem>
                                        </asp:DropDownList>

in .cs page
<pre lang="cs">protected void Department()
    {
        DataTable dt = Display_Logic.display_department_logic();
        ddl_offic_depar.DataSource = dt;
        ddl_offic_depar.DataBind();
    }</pre>


in  display logic
<pre lang="cs">public static DataTable display_department_logic()
   {
       SqlCommand cmd = new SqlCommand();
       cmd.CommandText = &quot;display_department_sp&quot;;
       return Create_Command.ExecQuery(cmd);
   }</pre>

you are create same code in country and i create a ntire architecture

you can use one of client side state management technique. i.e querystring
Using querystrings, you can pass the data(in your case it's country that inserted in database) from one page to very next page though url.

ex:
http;//www.xxxx.com/default.aspx?countryName=India
or
http;//www.xxxx.com/default.aspx?countryId=12

here 12 is the Id, for country in database.
you can read the values from url using following code

string countryName = Request.QueryString["countryName"];
// or
// If you know the id of the country, then again connect to Database and retrieve the value,
// But passsing the value in querystring is best way.. so that you can avoid unnecessary Database hits
int countryid = Convert.ToInt32(Request.QueryString["countryId"]);

If you mean locking the Dropdownlist is Disabling or read only.

ddlCountry.SelectedValue = countryName;
ddlCountry.Enabled = false;

Hope it will helps you..
Happy coding :)