|
Create a paging procedure of your own.... Loading for example 100 rows max per page, in stead of loading the entire rows collection at once..
|
|
|
|
|
i m using asp.net datagrid with its paging. there are only 20 rows per page and previous next to move from 1 to onwards, problem is when i load whole data in data table memory of aspnet_wp process shoots. i want to keep the table so that when sorting i dont have to get data from database.
Regards
Shajeel
|
|
|
|
|
It's not a memory problem. It's a programming problem. Don't retrieve 10 million rows at one time.
|
|
|
|
|
That's exactly what I said... load the rows required to display on the current page, not more, not less...
|
|
|
|
|
then how can i use it with datagrid
now i m using
DataTable dt = GetDataTableFromDB();
grid.DataSource = dt;
grid.DataBind();
Session["dt"] = dt;
this data table contains all the rows based on search criterea and which can be 10 million, then in sortcommand event i m using
DataTable dt = (DataTable)Session["dt"];
DataView dv = dt.DefaultView;
//Sort criterea
grid.DataSource = dv;
grid.DataBind();
Regards
Shajeel
|
|
|
|
|
|
It's possible that it is a problem with temporary files. Check the settings for temporary files in the browser. The default setting is that it uses a certain percentage of the disk space, which may be much more than it can handle. Set the limit to a reasonable value, like 50 MB.
---
b { font-weight: normal; }
|
|
|
|
|
Is it a large picture that takes time to load?
|
|
|
|
|
hi all,
i am getting problem in datagrid .the problem as follows,
i am able to retrieve the Ticket numbers for Ex:1 ,2, 3 in a method return type is datatable .i want to disply this number in one cell forEx:
1
2
3
help me plse
P.gurukiran
|
|
|
|
|
Hi everyone,
Here's the situation.
We migrated an ASP (VB) site from machine 1 to machine 2
Machine 1 had IIS, SQL Server.
Machine 2 has IIS, SQL Server and .NET Framework 1.1
The site from machine 1 used to work perfectly.
But when requesting pages from the new server for index.asp,
I get the following error.
-------------------------------------------
Server object error 'ASP 0177 : 80040111'
Server.CreateObject Failed
//global.asa, line 36
ClassFactory cannot supply requested class
-------------------------------------------
Please help. If you need more info, please ask.
This is critical.
forged
|
|
|
|
|
What kind of object is it that the code tries to create in line 36?
an ASP (VB) site
You mean "an ASP (VBScript) site", I assume?
---
b { font-weight: normal; }
|
|
|
|
|
Yes absolutely, ASP VBScript.
Object? Here's the line of code which is failing:
set myObj = server.CreateObject("BETCA.clsBETCA")
Now I'm getting the followign error after changing some IIS settings:
Error Type:
Server object, ASP 0177 (0x80040111)
ClassFactory cannot supply requested class
/qanew/global.asa, line 34
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 1.1.4322)
Page:
GET /qanew/waqt/asp/waqtmain.asp
Time:
Friday, December 01, 2006, 5:22:17 PM
More information:
Microsoft Support
forged
|
|
|
|
|
Bulky Fellow wrote: Object? Here's the line of code which is failing:
set myObj = server.CreateObject("BETCA.clsBETCA")
Have you registered your BETCA dll?
Bulky Fellow wrote: Now I'm getting the followign error after changing some IIS settings:
Error Type:
Server object, ASP 0177 (0x80040111)
ClassFactory cannot supply requested class
/qanew/global.asa, line 34
Do I even have to write the inevitable question for that?
Well, here goes anyway:
What kind of object is the code in line 34 trying to create?
---
b { font-weight: normal; }
|
|
|
|
|
Hey why are you getting irritated?
I am a PHP developer just starting out with ASP.NET, still a novice.
Days in PHP were good, this stupid ASP sucks anyways. PHP was much
better and much easier, and equally powerful, if not more.
register a dll? Ever heard of the oracle joke? here goes:
There were different jokes of how you can shoot yourself in the
leg with different languages. The oracle version is as follows:
You decide to shoot yourself in the foot, so you go out and buy a gun, but the gun won't work without "deploying" a shoulder holster solution, relational titanium-alloy bullets, body armor infrastructure, a laser sight assistant, a retractable arm stock application, and an enterprise team of ballistic experts and a chiropodist.
The menus for coding foot_shooting have not been implemented yet, and you can't do foot_shooting in SQL.
And the asp version is as follows:
You try to shoot yourself in the foot, but the most advanced thing you can manage is to cut your wrist.
Have fun pal, and please calm down.
And every morning when you wake up, utter the following phrase
three times:
"PHP is much much much better than ASP, Apache is much much much better than IIS". Repeat repeat.......
forged
|
|
|
|
|
I didn't sense any hostility. He answered your question. Your DLL has not been registered on the server. Thus, it cannot create an instance of that class because it doesn't exist.
|
|
|
|
|
Sorry Guffa, being bogged down with the same problem for two days
really got into me. Really didn't mean to be that rude. (but hey,
teh jokes weren't that bad, were they?
The problem is fixed. Copied the dll and registered it on the new
server. And it works like a charm.
Thanks a lot for your help buddy. All the best, and once again,
sorry.
Bye.
forged
|
|
|
|
|
I'm not irritated. I'm just trying to point out how you can improve your experience in the forum by supplying the information needed to answer your questions from the start, so that I don't have to repeatedly ask for the same kind of information for the same kind of error messages.
---
b { font-weight: normal; }
|
|
|
|
|
I am using two grids in my program.Here is the code on page load and buttonevent.
My problem is ,ican display ccode,cname in the first grid,and by selecting ccode with checkboxes from first grid,
i am displaying cname in the 2nd datagrid.
---->>>html code is
<asp:datagrid id="dgscreens" runat="server" width="348px" height="200px" datakeyfield="screen_id"
autogeneratecolumns="false" cellpadding="2" headerstyle-backcolor="Black" headerstyle-forecolor="White"
headerstyle-horizontalalign="Center" headerstyle-font-bold="True" oneditcommand="dgscreens_edit"
style="Z-INDEX: 103; LEFT: 40px; POSITION: absolute; TOP: 140px">
<headerstyle font-bold="True" horizontalalign="Center" forecolor="White" backcolor="Black">
<columns>
<asp:templatecolumn headertext="Select">
<itemtemplate>
<asp:checkbox id="chekbox1" runat="server">
<asp:boundcolumn datafield="ccode" readonly="True" headertext="code">
<asp:boundcolumn datafield="cname" readonly="True" headertext="CrName">
->>>>the code is as below,on pageload
Dim strsql As String
Dim cmd As SqlCommand
Dim dr1 As SqlDataReader
strsql = "Select CCode,CName from CMaster order by ccode"
cmd = New SqlCommand(strsql, dbconn)
dr1 = cmd.ExecuteReader()
dgscreens.DataSource = dr1
dgscreens.DataBind()
dr1.Close()
->>>>on buttonclick(Means for the second grid)
Dim dgItem As DataGridItem
Dim chkSelected As CheckBox
Dim sel_ccode As integer
Dim strSQL1 As String = ""
For Each dgItem In dgscreens.Items
chkSelected = dgItem.FindControl("chekbox1")
If chkSelected.Checked Then
sel_ccode = dgscreens.DataKeys(dgItem.ItemIndex).ToString()
strSQL1 = "Select CName from CMaster WHERE ccode=" & sel_ccode & ""
Dim cmd1 As SqlCommand = New SqlCommand(strSQL1, dbconn)
Dim dr2 As SqlDataReader = cmd1.ExecuteReader()
DG.DataSource = dr2
DG.DataBind()
End If
Next
kissy
|
|
|
|
|
Hai,
My web page contains large data.so it takes more time to load.I want to display an message to user.ie)Please wait page is loading.....with one GIF image.I want to show this image for each time when the page is loading.
Thanks............
|
|
|
|
|
|
You might want to look into why the page is taking so long, instead of a hacky workaround.
|
|
|
|
|
There are many posts for this exact question. This is obviously homework.
|
|
|
|
|
in my web page m retrieving thousands of records thats why it is taking much time (25 to 35 sec) in the mean time i want to display a hourglass.
pls give me some idea
thank u
|
|
|
|
|
People here usually don't do homework for others.
|
|
|
|
|
In datagid there is a hyperlink column. I want to open a gif file in internet explorer, by clicking on this hyperlink column
aasstt
|
|
|
|