|
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.
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.
|
|
|
|
|
how to bind data table with hash table
help me
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
Piyush Vardhan Singh wrote: bind data table with hash table
Do you mean copying values to datatable from hashtable ?
|
|
|
|
|
You can bind a hastable to a datagrid by first putting the elements into an Arraylist since hashtable does not implement IList interface.
Regards,
Satips.
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
|
|
|
|
|
But he has not mentioned about datagrid.
Apurva Kaushal
|
|
|
|
|
I have given my idea because i have faced problem while Binding the data table with hash table. so i suggested it to do with Datagrid.
So only i replied to that message.
Regards,
Satips.
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
|
|
|
|
|
ya i want copy the value in datatable from hash table
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
9313077379
|
|
|
|
|
Use getEnumerator() method in hashtable object and loop till the end of that. Create rows in datatable and assign hashtable value.
|
|
|
|
|
can any one tell me how to validate a Asp control on keypress in asp.net.
I have to restrict users from entering numerices,I have done it using Html control key press and then adding runat=server tag to it,but I would like to know where its possible in asp.net server controls.
Thanks in Advance.
|
|
|
|
|
You mean asp.net textbox control if so then you can do it same way as you did for your html control.
Apurva Kaushal
|
|
|
|
|
|
Always welcome..
Apurva Kaushal
|
|
|
|
|
There are many ways you can prevent users from entering something u don't want.
1. You can user either Custome validator or Regular expression validator.
2. In Java script you can write:
(on page load)
TextBox1.Attributes.Add("onKeyUp","javascript:validate(this.value)");
then in function validate() you can perform the validation,
if value is this
then delete
hope this helps.
|
|
|
|