I want to retrive data form databae base on combobox select

Question

suppose i have a Film table there was 7 colum id ,name ,story ,image ,cast ,category,trailer

I want that .....when i select combo box and select any movie name the the details of the movie means-----name,story,image,cast ,category,trailer will be display in same jsp page....

when i re select the movie name form combo box the the details will be change .......

NAGARAJU TAMADA · Answer

Hi Kunal Here is the Example First Select the combobox SeSelectedIndexChanged Event Here u use Datagridview on Windows form private void comboCountry_SelectedIndexChanged(object sender EventArgs e) { if (comboCountry.SelectedValue.ToString() != ) { String country= comboCountry.SelectedValue.ToString().Trim(); FillParticipantDetails(country); } } private void FillParticipantDetails(String country) { try { System.Data.DataTable dt = new System.Data.DataTable(); SqlDataAdapter da = new SqlDataAdapter(Select PartcipantIdParticipantNameCountryDepartmentCourseDatefrmDateToDesignationStateDjoinAddressCategoryGenderEmailidLandphoneMobileFaxno from participant_details where CountryName='+country+' vCon); da.Fill(dt); dataGridView1.DataSource = dt.DefaultView; } } Try it once. If it useful Please Mark The Answer NagaRaju T