How to get the value of a dropdownlist item.

Question

0.00/5 (No votes)

See more:

Hi,

I am having a 2 drop-down list in my page like 1.Location :[ ]
2.Sublocation : [ ] and

I am having 2 tables in my database like Location_Lookup and Sublocation_Lookup,
in Location_Lookup having columns like 'LocationID' 'Location' and
in Sublocation_Lookup havin columns like 'SublocationID' 'LocationID' and 'Sublocation'.

Then I have created a stored Procedure to fetch the sublocation using the LocationID
like

SQL

create procedure PopSublocation @location int as
begin
Select Sublocation from Sublocation_LookUp where LocationID = @location

now for fetching the location items to the Location dropdown list i have written the code like..

C#

protected void LocationBind()
        {
            SqlConnection conn = new SqlConnection(connstr);

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "Location";

            conn.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            ddlLocation.DataSource = reader;
            ddlLocation.DataTextField = "Location";
            ddlLocation.DataValueField = "LocationID";
            ddlLocation.DataBind();
            ddlLocation.Items.Insert(0, new ListItem("Select", "-1"));
            conn.Close();
            reader.Close();
        }

Here i am using stored procedure for getting locationID and Location and in the program for ddlLocation.DataValueField= "LocationID" i am passing.

Now for fetching the related sublocation list in the Sublocation:[ ] dropdown i am writting the code in the "protected void ddlLocation_SelectedIndexChanged(object sender, EventArgs e)" and the code is

C#

protected void ddlLocation_SelectedIndexChanged(object sender, EventArgs e)
      {
          SqlConnection conn = new SqlConnection(connstr);
          SqlCommand cmd = new SqlCommand();
          cmd.Connection = conn;
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.CommandText = "PopSublocation";
          cmd.Parameters.AddWithValue("@location",ddlLocation.SelectedItem.Value);
          ddlSublocation.Items.Insert(0, new ListItem("Select", "-1"));
          SqlDataAdapter da = new SqlDataAdapter(cmd);
          DataSet ds = new DataSet();
          da.Fill(ds);
          ddlSublocation.DataSource = ds;
          ddlSublocation.DataTextField = "Sublocation";
          ddlSublocation.DataValueField = "SublocationID";
          ddlSublocation.DataBind();

      }

Here i am passing the parameter of LocationID,
but here my problem is I am not getting the sublocation details in the Sublocation dropdown list.. please help me out for this... thanks

Posted 17-May-12 21:01pm

vinay7.ra

Add a Solution

4 solutions

Solution 2

Try This:

SQL

create procedure PopSublocation @location int as
begin
Select Sublocation from Sublocation_LookUp where LocationID = @location
end

SQL

protected void LocationBind()
        {
            SqlConnection conn = new SqlConnection(connstr);
 
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "Location";
 
            conn.Open();
DataSet ds=new DataSet();
SqlDataAdapter adp=new SqlDataAdapter(cmd,conn);
adp.fill=ds; 
            ddlLocation.DataSource = ds;
            ddlLocation.DataTextField = "Location";
            ddlLocation.DataValueField = "LocationID";
            ddlLocation.DataBind();
            ddlLocation.Items.Insert(0, new ListItem("Select", "-1"));
            conn.Close();
            reader.Close();
        }

SQL

protected void ddlLocation_SelectedIndexChanged(object sender, EventArgs e)
       {
           SqlConnection conn = new SqlConnection(connstr);
           SqlCommand cmd = new SqlCommand();
           cmd.Connection = conn;
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.CommandText = "PopSublocation";
           cmd.Parameters.AddWithValue("@location",ddlLocation.SelectedValue);
           ddlSublocation.Items.Insert(0, new ListItem("Select", "-1"));
           SqlDataAdapter da = new SqlDataAdapter(cmd,conn);
           DataSet ds = new DataSet();
           da.Fill(ds);
           ddlSublocation.DataSource = ds;
           ddlSublocation.DataTextField = "Sublocation";
           ddlSublocation.DataValueField = "SublocationID";
           ddlSublocation.DataBind();
           
       }

Posted 17-May-12 21:12pm

sunandandutt

Updated 17-May-12 21:17pm

v5

Solution 1

Use

C#

ddlSublocation.DataSource = ds.Table[0];

Posted 17-May-12 21:12pm

Nilesh Rokade

Updated 17-May-12 22:29pm

v2

Solution 5

C#

sqlCommand.Parameters.Add("@location", SqlDbType.Int).Value =  Convert.ToInt32(ddlLocation.SelectedValue);

Posted 18-May-12 1:25am

Ezhil Maran

Updated 18-May-12 1:30am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

bhagirathimfs · Accepted Answer · 2012-05-17T21:14:00

Solution 3

Rather than this

C#

cmd.Parameters.AddWithValue("@location",ddlLocation.SelectedItem.Value);

Try this

C#

cmd.Parameters.AddWithValue("@location",Convert.ToInt32(ddlLocation.SelectedValue));

Posted 17-May-12 21:14pm

bhagirathimfs

Updated 17-May-12 21:18pm

v2

Comments

vinay7.ra 20-May-12 0:59am

Thanks i got the solution....

bhagirathimfs 21-May-12 1:34am

WC :)