哪个是最快的填充工具 [英] Which is the fastest populating tool

问题描述

我正在使用ASP.net（C＃）和Sql Server 2005.我的数据库表中有3000个数据。我需要在网页中填充这些数据。我使用aspAjax：ComboBox和dropdownlist以及所有。但是问题是网站变得很慢。这是填充这些数据的最快工具。谢谢提前

I am using ASP.net(C#) and Sql Server 2005.I have 3000 datas in my database table.And I need to populate these datas in a web page.I using aspAjax:ComboBox and dropdownlist and all.But the Problem is website become slow.Which is the fastest tool to populate these datas..Thanks In Advance

推荐答案

你是否认真地建议你加载一个组合框（小的有一个文本框和下拉列表的愚蠢的东西，有3000个项目？并且您希望用户从这些项目中选择他需要的项目吗？



您是否真的试图在愤怒中使用您的界面？因为愤怒可能是它将在用户中调用的情感...



停止并重新考虑您的界面设计：加载需要很长时间由于某种原因，大量数据进入组合框：它不打算保存大量数据...

Are you seriously suggesting that you are loading a combobox (the little, dumb thing with a textbox and a drop-down list) with 3,000 items? And that you expect the user to choose from these the one item he requires?

Have you actually tried to use your interface in anger? Because "anger" is probably the emotion it is going to invoke in the user...

Stop, and rethink your interface design: it takes a long time to load a huge amount of data into a combo box for a reason: it's not intended to hold huge amounts of data...

所有控件都有不同的用途和功能。最快的解决方案是使用 SqlDataReader 填充控件（例如gridview）。还要优化你的逻辑以减少加载的数据。



问候......：笑：

All the controls have different purpose and functionality.The fastest solution is to fill control(e.g. gridview) using SqlDataReader . Also refine your logic in order to reduce the data that gets loaded.

Regards..:laugh:

这篇关于哪个是最快的填充工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！