|
If you want to stop the page code being written after you have written your data to the page (which by its position i assume is being done with response.write? You can follow it with a response.end which will send the page to the browser without doing the rest.
|
|
|
|
|
Dear All,
I am implementing pagin in my project where I am showing around 10 recordset per page. I want that whenever I click on next page it shouldn't call the database again and again. Data fetching should be done at once. Can anybody tell me how to do this so that I can increase the performance of my database. There are 20,000 records I am getting from this query.
Thanks and Regards,
Virendra
|
|
|
|
|
tou can fetch data from database and store it in xml file before using in gridview or any control, then work with xml file for paging and sorting or ...
We Can Do Anything, If We Want It
|
|
|
|
|
Abolfazl Sheikhloo wrote: tou can fetch data from database and store it in xml file before using in gridview
What is the benefit of doing like this ? Assume 100 user accessing the page same time , will you create 100 XML files ?
|
|
|
|
|
no no no.
you can manage your xml file for all users.
your xml is simulated from database table or view.
for example your xml contains 20,000 record and you need to all records but the database view contains 2,000,000 record and you don't need to all records.
working with 20,000 records is faster than working with 2,000,000 records
We Can Do Anything, If We Want It
|
|
|
|
|
virendra_007 wrote: am implementing pagin in my project where I am showing around 10 recordset per page
What control you are using to show the results ? Is it a datagrid/gridview ? Both supports paging. You can set allowpaging=true and set the pagesize. This method for paging implementation is very easy.
But efficient way will be doing the manual paging. First you need to find the total page by totalrecords/pagesizesize. Then depending on the page number you need to fetch only 10 records(your page size) from the database for that page. So your page may look like this www.yourdomain.com/yourpaging.aspx?page=1.
|
|
|
|
|
|
Hi inside the javascript, i given my hyperlink like this format:
document.write("<br><br><a href=Webform1.aspx target=submenu>Sample test</a>")
Now its the html link tool,
if my cursor over the link it want to show the tool tip of the link
and the text of the link always want to be in blue color...,
How to do that...,
Advance Thanks,
Regards,
Magi
|
|
|
|
|
u'll have a title attribule for html controls. assign ur tool tip to the title attribute.
------------------------------
If u think u can, u can.
If u think u can't, u r right.
|
|
|
|
|
Magh_M wrote: if my cursor over the link it want to show the tool tip of the link
Use <code>title="YourTooltip" in hyperlink tag.
Magh_M wrote: and the text of the link always want to be in blue color...,
Changing color is not possible in the default tooltip. You can go for some javascript that creates a tooltip.
|
|
|
|
|
hello Magi,
The Statement u have written is correct,But u have apply the tool tip for a Button or some control.In that javascript only change the settings ,it will automatically adjust.I have tried i got it u also plz try u will get
ok byee
Murali
|
|
|
|
|
|
hello everyone,
I have a small doubt regarding ReportViewer Control in asp.net 2.0.
I have a report viewer control in .net2.0.I will drag it into the Webform1.aspx.Now i need to generate a report using report server.So, How do i need to do it.The ReportPath and Report Server URL.. how to set .. The report server done using the SQLSERVER2005.It will be in Configuration Tools -->Reporting Service Configuration.From there i need to set the database and i need to generate the Report in the Report Viewer Control in .net.So plz help me fast in solving this solution.
ok byee
Murali
Murali
|
|
|
|
|
What exactly is your question?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hello Friend I am new in asp. I write program for asp pagging but when i run this program on browser its show the record at multiple page.
Can any tell me How can i solve this problem
Regard's
Kaushik
|
|
|
|
|
Y_Kaushik wrote: show the record at multiple page.
Could not understand the problem correctly. Can you give some more detail?
Apurva Kaushal
|
|
|
|
|
what code you have written for Paging?
we cannot tell without seeing it,why this is happening?
Regards,
Satips. ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
This is code Which i have write for showing my data
In this code problem is that when i run this code on browser Its show the record more then one time .I am unable for identified this problem.
Please help Me.
Imp How we set the record limit on a page.
<%
Option Explicit
Dim conn,rst,sql,Rs,uname,passwd
-
Dim intTotalpages,intCurrentpage,intI,strQ,j, varSearch,objConec
Const intPagesize=10
intI=1
If Request("currentPage")="" Then intCurrentpage=1 Else intCurrentpage=Request("currentPage")
if request("currentPage")="0" Then intCurrentpage=1
-
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=MSDASQL;" & _
"DSN=subscribedsn;DATABASE=ABC;UID=ABC;PWD=ABC;"
Set conn = Server.CreateObject("ADODB.Connection")
With conn
' Set .ActiveConnection=objConec
.cursorLocation=3
' .cachesize=intPagesize
' Set conn =objConec.Execute (StrQ)
End With
conn.open "PROVIDER=MSDASQL;" & _
"DSN=subscribedsn;DATABASE=ABC;UID=ABC;PWD=ABC;"
sql = "select * from ABC_tbl order by email "
'response.Write(sql)
'response.End()
Set rst = Server.CreateObject("Adodb.Recordset")
rst.Open sql, conn, 3, 3
'--------------------------------------------------
If Not rst.Eof Then
'response.write "true" & "
"
rst.pageSize=intPageSize
If Not isNumeric(intCurrentpage) Then intCurrentpage=1
If (CInt(intCurrentpage) > rst.PageCount) Then intCurrentpage=1
rst.absolutePage=intCurrentpage
intTotalpages=rst.pageCount
End If
%>
<title>ABC :: Admin Section
| | | | |
| |
<% If rst.EOF or rst.BOF then %>
<%
Else
do while not rst.EOF %>
<% rst.movenext
loop
rst.movefirst
End If
%>
| List Of Subscribe Members | User Name | E Mail | Project | Country | Dated | Status | Delete | | No Registration posted !( Database Empty ) | | <%=rst("nam")%> | <%=rst("email")%> | <%=rst("prj_type")%> | <%=rst("country")%> | <%=rst("date_field")%> | <%=rst("status")%> | "> | |
| <%if not rst.BOF or not rst.EOF then%>
Page -»
<%
for j=1 to intTotalpages
if j=int(intCurrentPage) then
%>
?currentPage=<%=j%>"><%=j%>
<%else%>
?currentPage=<%=j%>"><%=j%>
<%
end if
next
end if
rst.close : conn.close
set rst=nothing : set objConec=nothing
%> |
| | |
Regard's
Kaushik
|
|
|
|
|
i am doing an application in ASP .NET and AJAX...I felt a difficulty in implementing the Ajax Validator CalloutExtender Control.
I am new to AJAX, so someone plz help me recover this....
Thnx in advance......
SAJAN A PILLAI
C#.NET Programmer
TELESOFT INDIA PVT LTD...
BANGALORE
|
|
|
|
|
Hi Sajan,
first take one textbox , apply required field validator to it ... set its property(control to validate = textbox ,display property =none and error message )
then add validator callout extender to page set its TargetControlID property to control i.e textbox and u done.
pallavi
|
|
|
|
|
i want to establish datagrid paging in asp.net1.1 ..
i've used the following code
Private Sub dgListFeature_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles dgListFeature.PageIndexChanged
dgListFeature.CurrentPageIndex = e.NewPageIndex
dgListFeature.DataSource = CType(Viewstate("objds"), DataSet)
dgListFeature.DataBind()
End Sub
but it wont work ... plz help me ....
by anup
|
|
|
|
|
anupravi wrote: but it wont work
What is the error you are getting?
Also please give a meaningful subject.
Apurva Kaushal
|
|
|
|
|
Give in ur datagrid html code the following properties:
PageSize="10"
OnPageIndexChanged="myDataGrid_PageChanger"
AllowPaging="True"
Then in ur back end code give this code:
Sub myDataGrid_PageChanger(ByVal Source As Object, ByVal E As DataGridPageChangedEventArgs)
' Set the CurrentPageIndex before binding the grid
dgrdmain.CurrentPageIndex = E.NewPageIndex
binddata()
End Sub
Sub binddata()
mySqlDataAdapter = New SqlDataAdapter("SELECT * from table name", sqlconn)
myDataSet = New DataSet
mySqlDataAdapter.Fill(myDataSet, "st")
dgrdmain.DataSource = myDataSet
dgrdmain.DataBind()
mySqlDataAdapter.Dispose()
myDataSet.Dispose()
sqlconn.Close()
End sub
If u satisfy of this code rate my msg...,
Regards,
Magi
|
|
|
|
|
Please read the forum guidelines. Highlights include:
1. Do not use text speak.
2. Give your message title something with meaning.
3. When you say it doesn't work, it helps to give us what the error is.
4. Please use the code tags for your code to help separate it from the message.
_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!
|
|
|
|
|
Hi,
I am looking for some help, on how to add a dropdownlist to a gridview header, and then having the same functionality as auto filter in MS Excel. If I sort on one column, it filters my gridview, if I sort on more then one column, it filters on the combonation. Now here is the tricky part(for me atleast)... I will not know how many columns there are, as the information is imported from an excel spreadsheet. Any help will be welcome.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
