Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Binding large amount of data in dropdownlist very slow?
Valarmathi
Aug 28 2015 7:50 AM
1.9k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
trying to fetch multiple images from database
Upload image using base64