Valarmathi

Valarmathi

  • NA
  • 37
  • 11.3k

Binding large amount of data in dropdownlist very slow?

Aug 28 2015 7:50 AM
 While running this bindingit will take more time for large no of datafrom sql server database table data(Taluk name above 10000), so
what should i do for fast loading page
 
 Ex:
void BindTalukName()
{
DataTable dt;
dt = DataAccessClass.DT_LoadComboDataFromTable(CommandType.StoredProcedure, "Usp_Gettalukbindall");
ddltaluk.DataSource = dt;
ddltaluk.DataValueField = "talukid";
ddltaluk.DataTextField = "talukname";
ddldistrict.DataBind();
}
 
 
SP:
 
GO
 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[Usp_Gettalukbindall]

AS
begin
select talukid,talukname from TBL_TALUKMASTER

end

 

Answers (1)