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