|
AFAIK, this isn't possible. Either you fetch all of the data in one synchronous request, or you make multiple requests for blocks of n records.
If the data didn't change often, you could consider implementing the Singleton pattern and cache it in a DataSet or something similar on the server. You could then fetch blocks of this data without having to make subsequent calls to the database. Obviously there would be memory implications in storing a large dataset in memory.
BTW, by 'lakh' I assume you mean 100,000? I don't think this word is in common use outside of the Indian subcontinent. I had to look it up to see what it meant!
Paul Marfleet
|
|
|
|
|
yes Paul it means 100,000
Well i had seen this working in my current asp application and i m trying to replicate the same in .net but struggling with it.
i can tell u how it is working in asp application.
below is the code of how it is implemented in asp
response.buffer = false '
Sub DisplayRecords()
sql = "spPatientSelectList "
set oRs = oConn.execute(sql)
if (oRs.eof) then
response.write "No record found" & vbCrLf
end if
do while not oRs.eof
response.write ""
response.write "" & oRs("vchMedRecNum") & ""
response.write "" & oRs("vchPatientFirstName") & ""
response.write "" & oRs("vchPatientLastName") & ""
response.write "" & oRs("dtPatientDateOfBirth") & ""
response.write "" & oRs("vchPatientContactNumber") & ""
response.write "" & oRs("vchPatientSSN") & ""
response.write "" & vbCrLf
oRs.moveNext
loop
oRs.close
U see the key in the above code is
response.buffer=false.
but implementing the same in dotnet doesn't seems to help.
Thanx in Advance
|
|
|
|
|
You can still use Response.Buffer = false; to disable buffering of output in ASP.NET.
In your example, the database query is executed synchronously. The ASP code has to wait for it to fully complete. Disabling buffering just means that a partial response can be sent to the client instead of being accumulated on the server and flushed out in 1 go.
Paul Marfleet
|
|
|
|
|
exactly Paul. and that's what i am trying to do in asp.net. But struggling big time with this.
Thanx in Advance
|
|
|
|
|
I think you need to go back to first principles. Consider whether it is necessary or appropriate to display 100,000 records on a page. There are a number of problems with this.
Firstly, the size of your HTTP response is going to be huge, putting pressure on your web server.
Secondly, your users are going to have to wait some significant time for the page to download, even if you switch buffering off.
Thirdly, do your users want ot need to view 100,000 records at once? I don't think I could make sense of so much information. IMHO, no more than 100-150 records should be displayed on a page at any one time.
You should consider implementing some sort of paging/filtering mechanism to allow your users to get to the data they need. Yes, multiple requests would be made to the database as the user filters the data or moves through the pages. However it is surely better application design for your users to be making multiple requests for 100-150 records instead of a single request for 100,000 records.
Paul Marfleet
|
|
|
|
|
i have a gridview in my forum, can i calculate that the gridview contains how many rows (in javascript)?
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Try This,
 <script>
var tableElement = document.getElementById('Grid');
for (var i=0;i<tableElement.rows.count;i++)
{
}
</script>
|
|
|
|
|
it is not showing the message box
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
var gridViewCtlId = document.getElementById('<%=GdFriend.ClientID%>');
alert(gridViewCtlId.rows.length);
|
|
|
|
|
when u binding grid with data use to set Attributes
gridManList.Attributes["Count"] = dt.rows.count;
after that u can find out eaisly.
function count(id)
{
var grid=document.getElementById(id);
var integer=grid.Count;
alert(integer);
}
Devjit Das
|
|
|
|
|
InsDev wrote: gridManList.Attributes["Count"] = dt.rows.count;
it has a compilation error.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
put ur code here.
Devjit Das
|
|
|
|
|
error is cannot implicitly convert from int to sting
GridView1.Attributes["count"] = GridView1.Rows.Count;
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
what is this u r not able to convert int to string. some sort of thing u should able to find out and solve urself. ok .....
GridView1.Attributes["count"] = GridView1.Rows.Count.ToString();
Devjit Das
|
|
|
|
|
still not showing the messagebox
<script language="javascript" type="text/javascript">
function abc()
{
var d = document.getElementById("<%=GridView1.ClientID %>");
var int1= d.count;
alet(int1);
return false;
}
</script>
GridView1.Attributes["count"] = GridView1.Rows.Count.ToString();
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
on which event u call this function. u have to call this function on any event after the grid has fill with data.ok go on it will work.
Devjit Das
|
|
|
|
|
Wohhhhhhhhh Thanks.It is working now
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
try it urself first.just not to worrying and keep patience. ok .
Devjit Das
|
|
|
|
|
ok Thanks....
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
u can implement also this
document.getElementById(gridid).rows.length;
will count only the display row.
Devjit Das
|
|
|
|
|
not showing the message box
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
try it ur self it will work . ok..
Devjit Das
|
|
|
|
|
hi....Inside thescript u'll write following code.I think it will work
var r="";
r = document.getElementById('GridId');
for (var i=0;i<r.rows.count;i++)
{
}
<div="" class="ForumSig">Rajendran
|
|
|
|
|
code is incomplete?
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
i think that u r not working any where.
Devjit Das
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
