hi,
i have designed a registration form where it will automatically display the state based on selected country and automatically display the city based on selected state and its displaying as i needed... but the problem is after inserting if i check in database
its displaying numbers instead of countryname, statename and city name..
how to solve this issue...please assist me...
and here is my code method for country state and city...
public void Bind_ddlCountry()
{
SqlConnection fbs = new SqlConnection();
fbs.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnString77"].ConnectionString;
fbs.Open();
SqlCommand cmd = new SqlCommand("select Country_Name,Country_Id from Countries", fbs);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
//SqlDataReader dr = cmd.ExecuteReader();
ddlCou ...
Go to the complete details ...