hello, 

Its wrong code clear after search other user, when i search for first user i got all info.

Then when i try search other user without full info like from DropDownList not add country, i get same country first user search before

protected void Searchdata()
{
    try
    { String constring = ConfigurationManager.ConnectionStrings["cmConnectionString"].ConnectionString;
        SqlConnection sqlcon = new SqlConnection(constring);
        String pname = "Insert_Userupdate";
        sqlcon.Open();
        SqlCommand com = new SqlCommand(pname, sqlcon);
        com.CommandType = CommandType.StoredProcedure;
        com.Parameters.AddWithValue("civilid", txtSearch.Text);
        com.Parameters.AddWithValue("name", txtSearch.Text);
 
        SqlDataReader rdr;
        rdr = com.ExecuteReader();
        if (rdr.Read())
        {
            fName.Text = rdr["name"].ToString();
            ffileid.Text = rdr["fileid"].ToString();
            fcivilid.Text = rdr["civilid"].ToString();
            codeid.Text = rdr["id"].ToString();
            mobile.Text = rdr["mobile"].ToString();
            joptitel.Text = rdr["jop"].ToString();
            ddlCountries2.Text = rdr["Countries"].ToString();
            ddlStates2.Text = rdr["States"].ToString();
            ddlCities2.Text = rdr["Cities"].ToString();
            toplist.Text = rdr["CountryId3"].ToString();
 
            if (fcivilid.Text.Trim().Length == 12)
            {
                int year = 0;
                if (fcivilid.Text.StartsWith("3"))
                {
                    year = Convert.ToInt32("20" + fcivilid.Text.Substring(1, 2));
                }
                else if (fcivilid.Text.StartsWith("2"))
                {
                    year = Convert.ToInt32("19" + fcivilid.Text.Substring(1, 2));
                }
 
                int current = DateTime.Today.Year;
                result_civilid_Age.Text = (current - year).ToString();
            }
        }
        else
        {
            fName.Text = " ";
            fcivilid.Text = " ";
            ffileid.Text = " ";
            codeid.Text = " ";
            toplist.Text = " ";
            result_civilid_Age.Text = " ";
 
            ddlCountries.Items.Clear();
            ddlStates.Items.Clear();
            ddlCities.Items.Clear();
            ddlStates.Items.Insert(0, new ListItem("إسم الإدارة", "0"));
            ddlCities.Items.Insert(0, new ListItem("إسم القسم", "0"));
            ddlCountries.Items.Insert(0, new ListItem("إسم القطاع", "0"));
 
            ClientScript.RegisterClientScriptBlock(GetType(), "alert",
                "alert('" + "لاتوجد بيانات\\n " + txtSearch.Text.ToString() + "');", true);
        }
 
        sqlcon.Close();
    }
    catch (Exception)
    {
    }
}

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> 
    <div> 
        <table align="center" border="2" class="auto-style13" dir="rtl">
            <tr>
                <td class="auto-style224">
                    <fieldset class="auto-style9">
                        <asp:TextBox ID="txtSearch" Style="text-align: center" placeholder="الاسم / رقم المدنى" runat="server" AutoPostBack="True" BackColor="#FFFFCC" Font-Names="Arial" Font-Size="X-Large" OnTextChanged="txtSearch_TextChanged" Width="300px" Height="31px" Font-Bold="True"></asp:TextBox>
                        <ajaxToolkit:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" ServiceMethod="SearchCustomers"
                            MinimumPrefixLength="2" CompletionInterval="100" EnableCaching="false" CompletionSetCount="10"
                            TargetControlID="txtSearch" FirstRowSelected="false">
                        </ajaxToolkit:AutoCompleteExtender> 
                        <br />
                        <asp:Button ID="Button30" runat="server" Text="بحث" OnClick="btnsavedata" CssClass="button" Font-Bold="True" Font-Names="Arial" Height="35px" Width="50px" Font-Size="12pt" BorderColor="Black" BorderStyle="Solid" BorderWidth="2px" />
                        <asp:Button ID="ButNewuser" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="12pt"
                            OnClick="NewUser" Text="جديد" CssClass="button" Height="35px" Width="50px" BorderColor="Black" BorderStyle="Solid" BorderWidth="2px" /> 
                        <asp:Button ID="Button25" runat="server" Font-Bold="True" Font-Names="Arial" Font-Size="12pt"
                            OnClick="RegisterUser" Text="حفظ" CssClass="button" Height="35px" Width="50px" BorderColor="Black" BorderStyle="Solid" BorderWidth="2px" /> 
                    </fieldset>
        </table> 
        <table align="center" style="border: thin solid #000000; font-family: Arial, Helvetica, sans-serif; height: 40px;">
            <tr>
                <td class="auto-style34" style="border: medium solid #000000" colspan="3">
                    <asp:Label ID="Label11" runat="server" Font-Size="Large" ForeColor="White" Text="بيانات الموظف" Font-Bold="True" Font-Names="Arial"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="auto-style17" style="border: thin solid #000000;">
                    <asp:Label ID="Label2" runat="server" Font-Size="Large" ForeColor="Black" Text="الإسم" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style54">
                    <asp:TextBox ID="fName" runat="server" Font-Size="Medium" ForeColor="Black" BorderStyle="None" Font-Names="Arial" Height="100%" Font-Bold="True"></asp:TextBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style43">
                    <asp:Label ID="codeid" runat="server" Font-Size="Large" ForeColor="Gray" Height="100%" Text="0" Width="30%"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="auto-style45" style="border: thin solid #000000;">
                    <asp:Label ID="Label3" runat="server" Font-Size="Large" ForeColor="Black" Text="الرقم المدني" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style54">
                    <asp:TextBox ID="fcivilid" runat="server" Font-Size="Medium" ForeColor="Black" BorderStyle="None" Font-Names="Arial" Height="100%" Font-Bold="True"></asp:TextBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style36">
                    <asp:Label ID="result_civilid_Age" runat="server" Font-Size="Large" ForeColor="Red" Text="0"></asp:Label>
                    <asp:Label ID="result_civilid_Age0" runat="server" Font-Size="Large" ForeColor="Black" Text="سنة"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="auto-style45" style="border: thin solid #000000;">
                    <asp:Label ID="Label4" runat="server" Font-Size="Large" ForeColor="Black" Text="رقم الملف" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style54">
                    <asp:TextBox ID="ffileid" runat="server" Font-Size="Medium" ForeColor="Black" BorderStyle="None" Font-Names="Arial" Height="100%" Font-Bold="True"></asp:TextBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style43">&nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style45" style="border: thin solid #000000;">
                    <asp:Label ID="Label10" runat="server" Font-Size="Large" ForeColor="Black" Text="الوظيفة" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style54">
                    <asp:TextBox ID="joptitel" runat="server" Font-Size="Medium" ForeColor="Black" BorderStyle="None" Font-Names="Arial" Height="100%" Font-Bold="True"></asp:TextBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style43">
                    <asp:DropDownList ID="toplist" runat="server" BackColor="#FFFF99" Font-Bold="True" Font-Size="Medium" Height="100%" Width="100%" Font-Names="Arial">
                        <asp:ListItem Value="top1">وزير</asp:ListItem>
                        <asp:ListItem Value="top2">وكيل</asp:ListItem>
                        <asp:ListItem Value="top3">وكيل مساعد</asp:ListItem>
                        <asp:ListItem Value="top4">مدير</asp:ListItem>
                        <asp:ListItem Value="top5">مراقب</asp:ListItem>
                        <asp:ListItem Value="top6">رئيس قسم</asp:ListItem>
                        <asp:ListItem Selected="True" Value="top7">موظف</asp:ListItem>
                        <asp:ListItem Value="top8">مراسل</asp:ListItem>
                        <asp:ListItem Value="top9">سائق</asp:ListItem>
                    </asp:DropDownList>
                </td>
            </tr>
            <tr>
                <td class="auto-style45" style="border: thin solid #000000;">
                    <asp:Label ID="Label8" runat="server" Font-Size="Large" ForeColor="Black" Text="رقم الهاتف" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style54">
                    <asp:TextBox ID="mobile" runat="server" BorderStyle="None" Font-Bold="True" Font-Size="Medium" Font-Names="Arial" Height="100%">0</asp:TextBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style50">
                    <asp:Button ID="Button48" runat="server" BackColor="#00CC00" BorderStyle="Solid" BorderWidth="1px" Font-Bold="True" ForeColor="Black" OnClick="Button48_Click" Text="WhatsApp" Width="100px" Height="25px" Font-Names="Arial" Font-Size="Small" />
                </td>
            </tr>
            <tr>
                <td class="auto-style25" style="border: thin solid #000000;" colspan="3">
                    <asp:Label ID="Label12" runat="server" Font-Size="Large" ForeColor="White" Text="الجهة" Font-Bold="True" Font-Names="Arial"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="auto-style56" style="border: thin solid #000000;">
                    <asp:Label ID="Label5" runat="server" Font-Size="Large" ForeColor="Black" Text="القطاع" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style57">
                    <cc1:ComboBox ID="ddlCountries2" runat="server" AutoCompleteMode="SuggestAppend" DataSourceID="SqlDataSource1" DataTextField="CountryName" DataValueField="CountryId" AppendDataBoundItems="False" BorderStyle="None">
                    </cc1:ComboBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style61"></td>
            </tr>
            <tr>
                <td class="auto-style56" style="border: thin solid #000000;">
                    <asp:Label ID="Label6" runat="server" Font-Size="Large" ForeColor="Black" Text="الإدارة" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style57">
                    <cc1:ComboBox ID="ddlStates2" runat="server" AutoCompleteMode="SuggestAppend" DataSourceID="SqlDataSource2" DataTextField="StateName" DataValueField="StateName" MaxLength="0" BorderStyle="None" Font-Size="Medium" ForeColor="Blue" Font-Names="Arial">
                    </cc1:ComboBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style58">
                    <asp:Button ID="ButtonLocations0" runat="server" BackColor="#FF9933" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" Font-Bold="True" Font-Names="Arial" Font-Size="Large" ForeColor="Black" Text="اضافة إدارة" Width="100px" OnClick="ButtonLocations0_Click" Height="25px" />
                </td>
            </tr>
            <tr>
                <td class="auto-style56" style="border: thin solid #000000;">
                    <asp:Label ID="Label7" runat="server" Font-Size="Large" ForeColor="Black" Text="القسم" Font-Bold="True" Font-Names="Arial" CssClass="auto-style62"></asp:Label>
                </td>
                <td style="border: thin solid #000000;" class="auto-style57">
                    <cc1:ComboBox ID="ddlCities2" runat="server" AutoCompleteMode="SuggestAppend" DataSourceID="SqlDataSource3" DataTextField="CityName" DataValueField="CityName" MaxLength="0" BorderStyle="None" Font-Size="Medium" Font-Names="Arial">
                    </cc1:ComboBox>
                </td>
                <td style="border: thin solid #000000;" class="auto-style58">
                    <asp:Button ID="ButtonCities" runat="server" BackColor="#FF9933" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px" Font-Bold="True" Font-Names="Arial" Font-Size="Large" ForeColor="Black" Text="اضافة قسم" Width="100px" OnClick="ButtonCities_Click" Height="25px" />
                </td>
            </tr>
            <tr>
                <td style="border: medium solid #000000" colspan="3" class="auto-style49">
                    <asp:Button ID="Button28" runat="server" BorderColor="Black" BorderStyle="None" BorderWidth="1px" OnClick="Button28_Click" Text="تحـــــديث" BackColor="#99CCFF" Font-Bold="True" Font-Names="Arial" Font-Size="Large" Width="100%" />
                </td>
            </tr>
        </table>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:cmConnectionString %>" SelectCommand="SELECT * FROM [Cities]" />
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:cmConnectionString %>" SelectCommand="SELECT * FROM [States]"></asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:cmConnectionString %>" SelectCommand="SELECT * FROM [Countries]"></asp:SqlDataSource>
    </div> 
</asp:Content>