Posted on: 9/30/2015 12:48:23 PM | Views : 911

I have two dropdownlist. On Selection of City(first) dropdownlist. I get the values of Area(second) dropdownlist.
But after saving when I came again to check the value, the value of second dropdownlist gets disappears. I dont know why this happens.
Here is my code below:-
[WebMethod] public static string GetState(string City) { string State = ""; DataTable DtState = new DataTable(); OracleConnection Conn = new OracleConnection(System.Configuration.ConfigurationManager.ConnectionStrings["OracleConn"].ToString()); Conn.Open(); OracleDataAdapter ObjPriState = new OracleDataAdapter("select state_code||'~'||Country_Code State_Country from XXCUS.XXACL_PN_STATE_V where state_code = (select state_code from XXCUS.XXACL_PN_CITY_V where city_code='" + City + "')", Conn); ObjPriState.Fill(DtState); if (DtState.Rows.Count > 0 ...

Go to the complete details ...