ASP.NET

ASP.NET RSS

Dropdown bind

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Mar 2009

Posts: 12

Reputation: thirumca is an unknown quantity at this point

Solved Threads: 0

thirumca

Offline

Newbie Poster

Dropdown bind

Mar 30th, 2009

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.

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: Dropdown bind

Mar 30th, 2009

hi,

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

If u r query is achieved,mark the thread as solved

Live and Let Live

•

Join Date: Mar 2009

Posts: 12

Reputation: thirumca is an unknown quantity at this point

Solved Threads: 0

thirumca

Offline

Newbie Poster

Re: Dropdown bind

Mar 30th, 2009

Hi,
This is code for retrive data from database

 Help with Code Tags 
 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.

•

Join Date: Mar 2009

Posts: 30

Reputation: P.K.Chaudhary is an unknown quantity at this point

Solved Threads: 5

P.K.Chaudhary P.K.Chaudhary is offline

Offline

Light Poster

Re: Dropdown bind

Mar 31st, 2009

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

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: Dropdown bind

Mar 31st, 2009

hi,

you can use webservices to load data in to dropdownlist.

If u r query is achieved,mark the thread as solved

Live and Let Live

•

Join Date: Mar 2009

Posts: 12

Reputation: thirumca is an unknown quantity at this point

Solved Threads: 0

thirumca

Offline

Newbie Poster

Re: Dropdown bind

Apr 2nd, 2009

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

•

Join Date: Apr 2007

Posts: 370

Reputation: greeny_1984 is an unknown quantity at this point

Solved Threads: 29

greeny_1984 greeny_1984 is offline

Offline

Posting Whiz

Re: Dropdown bind

Apr 3rd, 2009

hi,

check this link

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

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

If u r query is achieved,mark the thread as solved

Live and Let Live

•

Join Date: Mar 2009

Posts: 12

Reputation: thirumca is an unknown quantity at this point

Solved Threads: 0

thirumca

Offline

Newbie Poster

Re: Dropdown bind

Apr 3rd, 2009

Hi,
Thanks for ur reply.

•

Join Date: Feb 2005

Posts: 1,181

Reputation: hollystyles will become famous soon enough

Solved Threads: 67

hollystyles hollystyles is offline

Offline

Veteran Poster

Re: Dropdown bind

Apr 3rd, 2009

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.

==========================================
Yadda yadda yadda...
Web junky, fevered monkey