how to get values from two dropdownlist list?

Question

i have two dropdownlist in first dropdown i select 1 and in second dropdown select 7 then i want total number like 1 2 3 4 5 6 7 if i select 2 from first dropdown and 5 from second one then 2 3 4 5

Prasenjit Dey · Answer

Hi please share ur effort

Sunny Sharma · Answer

Hi Hardik Well I don't know what else you're trying to update or insert but I think this piece of code you want to be modified: ------------------------------------------------------------------ str = insert into School values ( + ddlStudentName.SelectedValue + +ddlcrc.SelectedValue++ddlECName.SelectedValue+' + TextBox5.Text + '' + user + '' + date + '); --------------------------------------------------------------------------------------------- If that is the case and the table schema is sae as you've mentioned in your reply like: ---------------------------------- id school standard 1 ssh 1 2 ssh 2 3 ssh 3 // list i got 4 ssh 4 ----------------------------------- then modify your insert string like: foreach(int i in standard) //here I assume standard is the list of integers you generated { str = insert into standard_master values(DEFAULT'schoolName'i'); // here put i in quote if datatype is varachar command.CommandText = str; command.ExecuteNonQuery(); }

Prasenjit Dey · Answer

HI ddlECName.SelectedValue field your list value will be insert. i.e i which field the list data will be insert? is field name  standard ? But there is no field name like  standard

Hardik Patel · Answer

hii sunny i got the list but i want to insert it with my below code if i got list like Standard 1 2 3 4 i want to insert it into database like id school standard 1 ssh 1 2 ssh 2 3 ssh 3 // list i got 4 ssh 4 how to use it with my code string str; string user = Session[UserName].ToString(); string date = System.DateTime.Now.ToString(); if (Request.QueryString.Count > 0 && Request.QueryString[ed] != null) { str = Update School set TalukaCode =  + ddlStudentName.SelectedValue + CrcCode =+ddlcrc.SelectedValue+ECCode =+ddlECName.SelectedValue+SchoolName ='+TextBox5.Text+'LastModifiedBy ='+user+'LastModifiedDate ='+date+' where SchoolCode =  + Request.QueryString[ed] +  ; } else { str = insert into School values ( + ddlStudentName.SelectedValue + +ddlcrc.SelectedValue++ddlECName.SelectedValue+' + TextBox5.Text + '' + user + '' + date + '); } Int64 i; i = ObjConn.ExecuteNonQuery(str); if (i > 0) { Response.Redirect(listSchool.aspx?msg=save); }

Prasenjit Dey · Answer

Use this code int strts = Convert.ToInt32(DropDownList1.SelectedValue); int ends = Convert.ToInt32(DropDownList2.SelectedValue); List lstStore = new List (); for (int i = strts; i { lstStore .Add(i); } foreach( int f in lstStore ) { Response.Write(f.ToString()); }

Sunny Sharma · Answer

Hi hardik You can do it like this: List list = new List (); int num1=0num2=0; num1=Convert.ToInt32(dropdownlist1.SelectedText); //or SelectedValue as per your code num2=Convert.ToInt32(dropdownlist2.SelectedText); for(int i=num1;i { list.Add(i); } now do whatever you want to with list. Hope it helps! Happy Coding :)