Ad:

ASP.NET Discussion Thread
Unsolved
Views: 2959

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Mar 30th, 2009

Dropdown bind

Expand Post »

Hi,

how to bind dropdownlist in few seconds

I have one table in msaccess database, but this table contains 2500 records. I need to bind these records to asp.net dropdown list, but its take long time to bind the datas. so pls give any new method for binding the datas into dropdownlist with quick and few minutes.

Similar Threads

Dropdown list in ASP.NET - How to get value selected in ASP.NET
Without PostBack bind dropdownlist to textbox in C#
how to bind dropdown to a datasource in C#
How to using diferrent dropdown for the time(c#) in ASP.NET
drop down list selected index change doesn't work in mozilla in ASP.NET

thirumca

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Mar 2009

Permalink

Mar 30th, 2009

Re: Dropdown bind

hi,

can you show u r code for retrieving data from database.

greeny_1984

Reputation Points: 25

Solved Threads: 29

Posting Whiz

Offline

372 posts
since Apr 2007

Permalink

Mar 30th, 2009

Re: Dropdown bind

Hi,
This is code for retrive data from database

ASP.NET Syntax (Toggle Plain Text)
public static void Neweventsfilldd1(DropDownList dd_count,string query , string field,string valfield)
		{
			try
			{				
				DataTable dt = new DataTable();
				OleDbDataAdapter da = new OleDbDataAdapter(query,ConnectionString);
				da.Fill(dt);
				dd_count.DataSource = dt;
				dd_count.DataTextField = dt.Columns[field].ToString();
				dd_count.DataValueField=dt.Columns[valfield].ToString();
				dd_count.DataBind();
			}
			catch(Exception e)
			{
				System.Diagnostics.Debug.Write(e.Message);
				throw;
			}
		}
public static void Neweventsfilldd1(DropDownList dd_count,string query , string field,string valfield)
		{
			try
			{				
				DataTable dt = new DataTable();
				OleDbDataAdapter da = new OleDbDataAdapter(query,ConnectionString);
				da.Fill(dt);
				dd_count.DataSource = dt;
				dd_count.DataTextField = dt.Columns[field].ToString();
				dd_count.DataValueField=dt.Columns[valfield].ToString();
				dd_count.DataBind();
			}
			catch(Exception e)
			{
				System.Diagnostics.Debug.Write(e.Message);
				throw;
			}
		}

Last edited by peter_budo; Mar 30th, 2009 at 1:43 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

thirumca

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Mar 2009

Permalink

Mar 31st, 2009

Re: Dropdown bind

Hi,
Try using caching or ajax, these are the only two ways you can solve this problem.

P.K.Chaudhary

Reputation Points: 10

Solved Threads: 5

Light Poster

Offline

30 posts
since Mar 2009

Permalink

Mar 31st, 2009

Re: Dropdown bind

hi,

you can use webservices to load data in to dropdownlist.

greeny_1984

Reputation Points: 25

Solved Threads: 29

Posting Whiz

Offline

372 posts
since Apr 2007

Permalink

Apr 2nd, 2009

Re: Dropdown bind

Hi,
How can we use webservice for dropdown binding? Please give the sample code for binding dropdown using webservice

thirumca

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Mar 2009

Permalink

Apr 3rd, 2009

Re: Dropdown bind

hi,

check this link

http://www.codeproject.com/KB/aspnet/Bind_Dropdown.aspx

http://codingatlas.wordpress.com/200...-data-binding/

greeny_1984

Reputation Points: 25

Solved Threads: 29

Posting Whiz

Offline

372 posts
since Apr 2007

Permalink

Apr 3rd, 2009

Re: Dropdown bind

Hi,
Thanks for ur reply.

thirumca

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Mar 2009

Permalink

Apr 3rd, 2009

Re: Dropdown bind

What database are you using? OLE is slow but may be your only choice.

Also use a reader (forward only cursor) instead of a DataTable, it's faster for this kind of scenario.

But, consider the design. 2500 options in a drop Down List box ??? I can't think of any reason why I would want to choose from that many items in any application as a user. Consider filtering this list into sections/categories and have another drop down for the user to choose a section/category and then load only those items into the dropdown at a time.

Last edited by hollystyles; Apr 3rd, 2009 at 9:44 am.

hollystyles

Reputation Points: 262

Solved Threads: 68

Veteran Poster

Offline

1,181 posts
since Feb 2005

Permalink

Apr 4th, 2009

Re: Dropdown bind

hi,
Thanks for your reply

thirumca

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

12 posts
since Mar 2009

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: windows authentication

Next Thread in ASP.NET Forum Timeline: Combination of Asp.Net and Php

DaniWeb Message

Cancel Changes

User Name
Password