how to get values from two dropdownlist list?

Hardik Patel

13y1.4kLearn iOS Programming

i have two dropdownlist

in first dropdown i select 1 and in second dropdown select 7 then

i want total number like

if i select 2 from first dropdown and 5 from second one then

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sunny Sharma13y ago
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 sa,e 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();
}

0
Prasenjit Dey13y ago
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"
0
Hardik Patel13y ago
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");

}
0
Prasenjit Dey13y ago
Use this code

int strts = Convert.ToInt32(DropDownList1.SelectedValue);
        int ends = Convert.ToInt32(DropDownList2.SelectedValue);

        List lstStore = new List();

        for (int i = strts; i <= ends; i++)
        {
            lstStore .Add(i);
        }

        foreach( int f in lstStore )
        {
            Response.Write(f.ToString());
        }
0
Sunny Sharma13y ago
Hi hardik,

You can do it like this:

List list = new List();

int num1=0,num2=0;
num1=Convert.ToInt32(dropdownlist1.SelectedText); //or SelectedValue as per your code
num2=Convert.ToInt32(dropdownlist2.SelectedText);
for(int i=num1;i<=num2;i++)
{
list.Add(i);
}

now do whatever you want to with list.

Hope it helps!

Happy Coding :)
0
Prasenjit Dey13y ago
Hi, please share ur effort
0