Bind Drop down to a sql table column in 3 tier architecture

Question

1.00/5 (1 vote)

See more:

I am using 3 tier first time the first thing i want to bind my dropdownlist with a sql table column.
I have in APPCODE BLL folder (empty) while in DAL two built in classess Sqlhelper.cs and DBBridge.cs.
App code
BLLempty
DAL
sqlhelper.cs
DBBridge.cs

while on presentation layer drop down list present.
so how can i bind my dropdownlist?
do i need to make a function in sqlhelper or DBBridge.cs or i need to make class then a function in BLL Folder??
or do i need to bind dropdown directly through wizard ?? which is absolutely not acceptable in professional programming..

Posted 5-Sep-13 19:25pm

Muhamad Faizan Khan

Add a Solution

Comments

Member 10425929 13-Dec-13 1:06am

dropdown.DataBind(); this code not working on windows application ..how to resolve this error

4 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)

bitofweb · Answer 1 · 2013-09-05T22:04:00

Hi Muhammad,

You can do this by following two ways.

1. By using ListItemCollection

In SqlHelper fetch the data from database and then build ListItemCollection by following way.
In Your SqlHelper class you need to Add the following namespace System.Web.UI.WebControls.

C#

Public ListItemCollection GetData()
{
//Code to fetch data from database.
 ListItemCollection collection = new ListItemCollection();
//Now loop the rows retrieved from db.

foreach(var row in db.rows)
{
//First Parameter of ListItem refers the DataTextField of Dropdown;
//Second Parameter of ListItem refers to DataValueField of Dropdown.
 collection.Add(new ListItem(row[0],row[1]));
}

return collection
}

Now in your presentation layer

C#

ListItemCollection col  = GetData();
dropdown.datasource = col;
dropdown.DataBind();

2 By using DataTable.

In Your SqlHelper return the Datatable

C#

public DataTable  GetData()
{
    DataTable dt  = new DataTable();
    dt  = //fetched data from database. 
    
return dt;
}

In Your Presentation Layer.

C#

DataTable  dt  = GetData();
dropDown.DataSource  = dt;
// Here you have to explicitly set these two properties, because now we are getting datatable //form GetData()

dropdown.DataTextField = dt.col[0]; // Display Member
dropdown.DataValueField= dt.col[1]; // Value Member
dropdown.DataBind();

we can also do this by using Dictionary also.
Leave the comment if you want to achieve this by using Dictionary.

Hope this Helps.

Kishor_Kadam · Answer 2 · 2013-09-05T20:39:00

Hi Muhammad,

I think you should return a list/table from a function and then bind it to the dropdownlist.

in sqlhelper.cs

C#

public DataTable GetData(parameters)
{
DataTable dt=new DataTable;
//implement logic for Data Retrieval.

return dt;
}

in Presentation Layer give a call to this function and bind the dropdownlist;

DataTable Dt=GetData(parameters);
Drplist.DataSource=Dt;
DrpList.DataTextField=Dt.Col[0].ToString(); //Text displayed in DropDown
DrpList.DataValueField=Dt.Col[1].ToString();//Backend Value associated with Text i.e include PK.
DrpList.DataBind();

I hope this will solve your problem.

Note :Binding dropdown directly through wizard is not a good solution.

indrajeet jadhav · Answer 3 · 2013-09-05T23:06:00

Solution 3

Did you Add Reference the related dll files??
Firstly you have add reference to BLL to DAl
in that case you have to create object:

C#

business.classname objclass=new business.classname();
 objclass.Methodname();

its way to you can access your methods

Posted 5-Sep-13 23:06pm

indrajeet jadhav

Updated 14-Jan-14 8:44am

v4

Ra'fat O · Answer 4 · 2014-01-14T06:16:00

Solution 4

1. Write a method in DAL to get data from database.
2. Write a method in BLL, Call the above method from write your business if there is any ...
3. Call the method which you wrote in BLL and bind it to the drop dwon list.

Posted 14-Jan-14 6:16am

Ra'fat O

Bind Drop down to a sql table column in 3 tier architecture

4 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0