protected void DDLCity_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("procGetSponsorDetails", con); con.Open(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@CityId", SqlDbType.Int).Value = DDLCity.SelectedItem.Value; SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.Read()) { ImgLogoSponsor.ImageUrl = Server.MapPath("~/Templates/") + sdr[0].ToString(); LblAllotedCards.Text = "You have " + sdr[10].ToString() + " free/sponsored cards"; } sdr.Close(); con.Close(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)