Click here to Skip to main content
15,924,193 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Html tool tip.........., Pin
ballameharmurali12-Jul-07 22:54
ballameharmurali12-Jul-07 22:54 
AnswerRe: Html tool tip.........., Pin
Vasudevan Deepak Kumar12-Jul-07 23:18
Vasudevan Deepak Kumar12-Jul-07 23:18 
QuestionHow to Generate Reports using Report Viewer Pin
ballameharmurali12-Jul-07 21:16
ballameharmurali12-Jul-07 21:16 
AnswerRe: How to Generate Reports using Report Viewer Pin
Paul Conrad13-Jul-07 12:18
professionalPaul Conrad13-Jul-07 12:18 
QuestionShow record more then one page Pin
Y_Kaushik12-Jul-07 21:16
Y_Kaushik12-Jul-07 21:16 
AnswerRe: Show record more then one page Pin
_AK_12-Jul-07 21:24
_AK_12-Jul-07 21:24 
AnswerRe: Show record more then one page Pin
Sathesh Sakthivel12-Jul-07 21:30
Sathesh Sakthivel12-Jul-07 21:30 
AnswerRe: Show record more then one page Pin
Y_Kaushik12-Jul-07 21:38
Y_Kaushik12-Jul-07 21:38 
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











  Back
Logout  
<% 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

QuestionHow to implement Ajax Validator Callout Control Pin
codingrocks12-Jul-07 21:14
codingrocks12-Jul-07 21:14 
AnswerRe: How to implement Ajax Validator Callout Control Pin
Pallavi Bhoite13-Jul-07 20:57
Pallavi Bhoite13-Jul-07 20:57 
Questionhi friends, Pin
Anoop_Ravindran12-Jul-07 20:43
Anoop_Ravindran12-Jul-07 20:43 
AnswerRe: hi friends, Pin
_AK_12-Jul-07 20:55
_AK_12-Jul-07 20:55 
AnswerRe: hi friends, Pin
Member 387988112-Jul-07 22:22
Member 387988112-Jul-07 22:22 
AnswerThe rules Pin
leckey13-Jul-07 3:11
leckey13-Jul-07 3:11 
Questionauto filter on gridview Pin
playout12-Jul-07 20:34
playout12-Jul-07 20:34 
Questionhow to bind data table with hash table Pin
Piyush Vardhan Singh12-Jul-07 20:19
Piyush Vardhan Singh12-Jul-07 20:19 
AnswerRe: how to bind data table with hash table Pin
N a v a n e e t h12-Jul-07 20:23
N a v a n e e t h12-Jul-07 20:23 
AnswerRe: how to bind data table with hash table Pin
Sathesh Sakthivel12-Jul-07 20:23
Sathesh Sakthivel12-Jul-07 20:23 
GeneralRe: how to bind data table with hash table Pin
_AK_12-Jul-07 20:37
_AK_12-Jul-07 20:37 
GeneralRe: how to bind data table with hash table Pin
Sathesh Sakthivel12-Jul-07 21:28
Sathesh Sakthivel12-Jul-07 21:28 
GeneralRe: how to bind data table with hash table Pin
Piyush Vardhan Singh12-Jul-07 21:35
Piyush Vardhan Singh12-Jul-07 21:35 
GeneralRe: how to bind data table with hash table Pin
N a v a n e e t h12-Jul-07 22:41
N a v a n e e t h12-Jul-07 22:41 
QuestionKeyPress event for server control Pin
Archana New to Dotnet12-Jul-07 19:43
Archana New to Dotnet12-Jul-07 19:43 
AnswerRe: KeyPress event for server control Pin
_AK_12-Jul-07 19:45
_AK_12-Jul-07 19:45 
GeneralRe: KeyPress event for server control Pin
Archana New to Dotnet12-Jul-07 19:58
Archana New to Dotnet12-Jul-07 19:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.