Populate multiple Column values in DropDownList using Pivot in ASP.Net

Question

HiI have one database in which student enroll no with his sem is stored  i want that if i enter stud enroll no then in dropdown list all the sem related to that stud should comemy database Stud enroll no        sem1           sem2              sem3          sem4        1                  july 2013     Jan 2014      July 2014     Jan 2015        2                  Feb 2013     Aug 2014      Feb 2014     Aug 2015         3                 july 2012     Jan 2013     July 2013     Jan 201

Azim · Accepted Answer

You have to use Pivot tableHTML123456789ltform idform1 runatservergt   ltdivgt       ltaspTextBox IDtxtEnrollNumber runatserver gt       ltaspButton IDbtnSearhEnrollNumber runatserver OnClickSearhEnrollNumber           TextSearh Enroll Number gt       ltaspDropDownList IDddlSemesters runatservergt       ltaspDropDownListgt   ltdivgt   ltformgtC1234567891011121314151617181920212223242526protected void SearhEnrollNumberobject sender EventArgs e            int number  intParsethistxtEnrollNumberTextTrim        thisPopulateDropDownListnumber        private void PopulateDropDownList int enrollNumber            string constr  ConfigurationManagerConnectionStringsConStringConnectionString        using SqlConnection cn  new SqlConnectionconstr                    using SqlCommand cmd  new SqlCommandGetStudentDetailsByEnrollNumber cn                            using SqlDataA

Populate multiple Column values in DropDownList using Pivot in ASP.Net

Company

Explore

Follow us

Contact Us