哪个是填写gridview的最佳和最快的方法？ [英] Which is best and fastest way to fill gridview?

问题描述

我有超过30个表的数据库，有些表有大约25000多个记录，大约有15列以上....

我想知道哪种是最快速有效的显示方式gridview中的记录，我也有一个formview在formview中显示所选记录以进行更新操作....

i使用sqldatasource实现了这个....

但是网站在某些日子里，有人告诉我使用数据集，因为sqldatasource是一个重要的控件....

我还想在显示的表格上执行全文搜索或者我可以使用LIKE子句...

但LIKE子句有点像

SELECT * FROM STUDENT_TBL WHERE（（Name ='％@ Name％'）OR（Address ='％ @ Address％'）OR .......）

解决方案

您可以在默认数据视图中使用Rowfilters。下面是一个简单的例子。

 dataTableConfig = _wrapper.GetMedcoProductConfig（）;  //  这是获取数据的数据库调用 
 DataView dvPDPD = dataTableConfig .Tables [  0 ]。DefaultView; 
 dvPDPD.RowFilter =   RX_PDPD_ID =' + txtSuggest.Text.Trim（）。 ToUpper（）+  '; 
 gvConfig.DataSource = dvPDPD.ToTable（）; 
 gvConfig.DataBind（）; 

使用Sql数据源。这是我们在ASP.NET中最好的。

USe FilterExpression =Name LIKE'{0}'和地址LIKE'{1}'这里0和1从FilterParameters元素。



但是我认为使用SQLdatasource有一些限制因此在开发人员中不太受欢迎，我认为使用像JQGrid这样的客户端控制。参考

在ASP.NET中使用JqGrid [ ^ ]

I am having database with more than 30 tables and some table are having about 25000+ records with about 15+ columns....
I want to know which is fastest and efficient way to display records in gridview and i am also having a formview to display selected record in formview for update operation....
i have achieved this using sqldatasource....
but website is going to live in some days,someone told me to use dataset for this purpose since sqldatasource is a heavy control....
and i also want to perform Full text Search on displayed table or may i use LIKE clause...
but LIKE clause is somewhat like
SELECT * FROM STUDENT_TBL WHERE ((Name='%@Name%') OR (Address='%@Address%') OR .......)

解决方案

You can use Rowfilters on your default dataview. Below is a simple example.

dataTableConfig = _wrapper.GetMedcoProductConfig(); //this is the DB call to get your datatable
             DataView dvPDPD = dataTableConfig .Tables[0].DefaultView;
             dvPDPD.RowFilter = "RX_PDPD_ID = '" + txtSuggest.Text.Trim().ToUpper()+"'";
             gvConfig.DataSource = dvPDPD.ToTable();
             gvConfig.DataBind();

USe Sql Data Source. It's the best we've got in ASP.NET.

USe FilterExpression="Name LIKE '{0}' AND Address LIKE '{1}'" here 0 and 1 are passed from FilterParameters element.

However i think use of SQLdatasource has some limitations and thus not very popular among developers, I think use client side control like JQGrid. Refer
Using JqGrid in ASP.NET[^]

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