I want to bind data to DropDown

Question

0.00/5 (No votes)

See more:

Hi folks,
I am facing problem.I wanna bind data to DropDown.Here my SP is

C#

ALTER PROCEDURE dbo.SelectAreaRouteInfo
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
select routeinfo.routeid, area.areaname + ' / ' + routeinfo.routename from 
routeinfo inner join area 
on routeinfo.areaid  = area.areaid
	RETURN


DataTable dtAreaRoute = objAreaData.SelectRouteArea(objAreaBusiness);
            if (dtAreaRoute.Rows.Count > 0)
            {
                cmbDefaultRoute.DataSource = dtAreaRoute;
                cmbDefaultRoute.DataTextField = "AreaName";
                cmbDefaultRoute.DataValueField = "RouteID";
                cmbDefaultRoute.DataBind();

            }
        }

DataTextField="AreaName";
DataValueField = "RouteID";.Data coming from two table.Its not allowing me..given error

 Need your help.Thanks in advance.

Posted 10-Oct-13 23:38pm

indrajeet jadhav

Updated 11-Oct-13 0:40am

v3

Add a Solution

Comments

[no name] 11-Oct-13 5:47am

Your question is not clear where is the code where you are facing problem?
where are u binding, which language you are using to bind the drop down list?

JoCodes 11-Oct-13 5:54am

Are you looking for some code which binds data for you using your stored procedure?

indrajeet jadhav 11-Oct-13 6:16am

yes..Means In my Stored proc ..Inner join is used.data coming from different table
So RouteID may be DataValue field and DataTextField is AreaName..Means it..so here i am nt getting solution

JoCodes 11-Oct-13 8:10am

I have posted a solution for binding the dropdown list using SP. once you fetch the join data from both tables into a dataset pass the datavalue and datatextfield accoringly.

JoCodes 11-Oct-13 8:11am

Also use more appropriate question subject heading..

Thanks7872 11-Oct-13 5:57am

I am also facing the problem understanding your problem. Help you with what? Where is the question?

indrajeet jadhav 11-Oct-13 6:12am

I wanna bind data to DropDown

Thanks7872 11-Oct-13 6:26am

Bind it. You have my permission. Don't worry. Keep it up.

indrajeet jadhav 11-Oct-13 6:32am

.Inner join is used.data coming from different table
So RouteID may be DataValue field and DataTextField is AreaName..Means it..so here i am nt getting solution

2 solutions

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)

**Azee** · Answer 1 · 2013-10-11T00:51:00

Hey there,

The problem is in your Stored Procedure and this line:

C#

mbDefaultRoute.DataTextField = "AreaName";

Your Stored Procedure is not returning any column with name AreaName because in your Select statement you are concatenating areaname with routename :

SQL

area.areaname + ' / ' + routeinfo.routename

which probably returns value but without a column name. Change the Select statement to this:

SQL

select routeinfo.routeid AS RouteID, area.areaname + ' / ' + routeinfo.routename AS AreaName from 
routeinfo inner join area 
on routeinfo.areaid  = area.areaid

It should work for you.

Do let me know if it does.

Azee...

JoCodes · Answer 2 · 2013-10-10T23:54:00

Solution 1

Check this link

http://aspalliance.com/618_CodeSnip_Populate_a_DropDownList_with_a_Stored_Procedure[^]

Posted 10-Oct-13 23:54pm

JoCodes