Re: dynamically create a webchart within a repeater control. - ASP.NET Discussion Boards

Hi All,

Greetings.Can any one tell me clear about what is session and what is the difference between session and cookies?

Thanks in advance

Babu

Session is saved in memory on the server, cookies are small text files saved on the client.

You have to make the distinction between session, session and Session:

:: A session in the browser is as long as you have a web site open.

:: A session for the server is until it assumes that the user went away, usually 20 minutes after the last request.

:: The Session object is the object that the server uses to keep track of a session.

As you are comparing the session to cookies, I assume that you don't mean sessions at all, but session variables.

Session variables is stored in the Session object on the server. Cookies is stored in the browser (or by the browser in a file) and are sent to the server in every request.

---
b { font-weight: normal; }

Hi!
my aspx code looks something like,
--------------------------------------
<asp:repeater id="myRepeater" runat="server" OnItemDataBound="myRepeater_ItemDataBound">
<ItemTemplate>
<h3><%#DataBinder.Eval(Container.DataItem, "ScoreCardId")%></h3>
<br />
<asp:repeater id="NestedRepeater" runat="server" OnItemDataBound="nestedRepeater_ItemDataBound">
<ItemTemplate>
<h4><%#DataBinder.Eval(Container.DataItem,"Measure_ID")%></h4>
<table>
<asp:Repeater id="SubNestedRepeater" Runat="server">
<ItemTemplate>
<tr>
<asp:PlaceHolder id="PlaceHolder1" runat="server"></asp:PlaceHolder>
<td><%#DataBinder.Eval(Container.DataItem,"Period")%></td>
<td><%#DataBinder.Eval(Container.DataItem,"Target")%></td>
<td><%#DataBinder.Eval(Container.DataItem,"Actual")%></td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>
</ItemTemplate>
</asp:repeater>
</ItemTemplate>
</asp:repeater>
--------------------------------------

The output is something like,
--------------------------------------
Hi,

Actually now my result looks exactly it should be which is as:
----------------------------------------------------------
1

1.1.1.1
2001/02 95 95
2002/03 95 94
2003/04 95 94
2004/05 90 93.05
2005/06 H1 90 93.8
2005/06 H2 90 0

1.1.1.2
2001/02 100 99
2002/03 100 100
2003/04 100 100
2004/05 100 100
2005/06 Q1 100 100
2005/06 Q2 100 0
2005/06 Q3 100 0
2005/06 Q4 100 0

2

1.1.10.1
2001/02 90 91
2002/03 90 91
2003/04 90 92.5
2004/05 90 92.65
2005/06 H1 90 94
2005/06 H2 90 0

----------------------------------------------------------

the above data should be dynamically converted into 3 webcharts

2 webchart for scorecard ID 1 and 1 chart for scorecard ID 2

it would have been much easier if i could actually assign a datasource to a webchart programatically as i used to by simply

dotnetchart.datasource = [a data view that gives me a chart data]
dotnetchart.databind

I tried this but my chart is not showing up.

but i am having problem binding those data dynamically to dynamic web charts
--------------------------------------

I tried mycos and dotnetcharting but i couldnt bind those data to a webchart object dynamically. i tried using placeholder inside the third repeater too but i didnt get much luck with that.

a piece of vb code with both dotnetchart and mycos is below

---------------

Public Sub nestedRepeater_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs)
Dim dv As DataRowView = e.Item.DataItem

If Not (dv Is Nothing) Then
Dim subNestedRepeater As Repeater = e.Item.FindControl("SubNestedRepeater")

If Not (subNestedRepeater Is Nothing) Then
Dim Measure_ID As String = dv("Measure_ID").ToString()

'Here, instead of connecting to DB, we can simply get the previously populated
''dataset object stored in the DataSource of the parent repeater and query data.

'FOR DOTNETCHARTING
'---------------------
Dim dynChart As New dotnetCHARTING.Chart
'Set Chart 1 properties

dynChart.Title = "My Chart 1"
dynChart.Type = dotnetCHARTING.ChartType.Combo
dynChart.XAxis.Label.Text = "Customers"
dynChart.DefaultSeries.DefaultElement.Transparency = 35
dynChart.TempDirectory = "temp"
dynChart.Use3D = True
dynChart.Debug = True
dynChart.Width = Unit.Parse(420)
dynChart.Height = Unit.Parse(300)
' Add the random data.

Dim nestedRepeater As Repeater = e.Item.Parent
Dim subDs As DataSet = nestedRepeater.DataSource
Dim dataView As DataView = New DataView(subDs.Tables(1))
dataView.RowFilter = "Measure_ID = '" & Measure_ID & "'"

'raw data
'-------------
'subNestedRepeater.DataSource = dataView ' dv.CreateChildView("NestThemSub")
'subNestedRepeater.DataBind()

'FOR MYCOS CHARTING TOOL
'----------------------------
Dim chart As New MycosChartWeb
chart.DataSource = dataView
chart.DataBind()

Dim i As Integer
For i = 0 To subNestedRepeater.Items.Count - 1
subNestedRepeater.Items(i).FindControl("Placeholder1").Controls.Add(chart)
Next

'dotNetCharting.dll
'---------------------
'dynChart.Series.Data = dataView
'dynChart.SeriesCollection.Add()

End If
End If
End Sub
---------------

please help

Hi there,
IMHO, you might want to check out their support sites to get better help as you are asking about a specific product:

http://www.dotnetcharting.com/support.aspx[^]

Hi,

is there anyway i can implement charting function freely available within visual studio.net framework

thanks.

Yes, you can manage on your own to create chart in the ASP.NET like the example from the article[^], however IMO you'd better use a third party component which may save lot of your effort, for example the DundasChart. If you're not familiar with a third party component, you might want to contact thier support team, and I think they're more than willing to give you a hand to integrate the component into your application.

I tried to use dotnetcharting and few others but it seems that its not rendering is there sumthing i am doing wrong.

from my previous post my output are (without chart)
------------------------------------------------
1

1.1.1.1
2001/02 95 95
2002/03 95 94
2003/04 95 94
2004/05 90 93.05
2005/06 H1 90 93.8
2005/06 H2 90 0

1.1.1.2
2001/02 100 99
2002/03 100 100
2003/04 100 100
2004/05 100 100
2005/06 Q1 100 100
2005/06 Q2 100 0
2005/06 Q3 100 0
2005/06 Q4 100 0

2

1.1.10.1
2001/02 90 91
2002/03 90 91
2003/04 90 92.5
2004/05 90 92.65
2005/06 H1 90 94
2005/06 H2 90 0
-------------------------------

my aspx code
----------------------------------
<form id="Form1" method="post" runat="server">
<asp:repeater id="myRepeater" runat="server" OnItemDataBound="myRepeater_ItemDataBound">
<ItemTemplate>
<h3><%#DataBinder.Eval(Container.DataItem, "ScoreCardId")%></h3>
<br />
<asp:repeater id="NestedRepeater" runat="server" OnItemDataBound="nestedRepeater_ItemDataBound">
<ItemTemplate>
<h4><%#DataBinder.Eval(Container.DataItem,"Measure_ID")%></h4>
<table>
<asp:Repeater id="SubNestedRepeater" Runat="server">
<ItemTemplate>
<tr><td><asp:PlaceHolder ID="placeholder" Runat="server"></asp:PlaceHolder></td></tr>
</ItemTemplate>
</asp:Repeater>
</table>
</ItemTemplate>
</asp:repeater>
</ItemTemplate>
</asp:repeater>
</form>
---------------------------

my VB code with dotnetcharting integration
-----------------------------

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
objConn = New SqlConnection(dbPath)
cmd = New SqlCommand("select Distinct(ScoreCardId) from measuredata;", objConn)
Dim sdap As New SqlDataAdapter(cmd)
Dim ds As New DataSet
sdap.Fill(ds)

myRepeater.DataSource = ds
myRepeater.DataBind()
End Sub
Public Sub myRepeater_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs)
Dim dv As DataRowView = e.Item.DataItem '
If Not (dv Is Nothing) Then
Dim nestedRepeater As Repeater = e.Item.FindControl("NestedRepeater") '

If Not (nestedRepeater Is Nothing) Then
objConn = New SqlConnection(dbPath)
Dim scorecardID As String = dv("ScoreCardId").ToString()
cmd = New SqlCommand("select distinct(Measure_ID) from measuredata where ScoreCardID='" & scorecardID & "'; select * from measuredata where ScoreCardID='" & scorecardID & "'", objConn)
Dim subadap As New SqlDataAdapter(cmd)
Dim subDs As New DataSet
subadap.Fill(subDs)

nestedRepeater.DataSource = subDs
'We need to specify the DataMember as the dataset has 2 tables.
nestedRepeater.DataMember = subDs.Tables(0).TableName
nestedRepeater.DataBind()
End If
End If
End Sub 'myRepeater_ItemDataBound

Public Sub nestedRepeater_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs)
Dim dv As DataRowView = e.Item.DataItem

If Not (dv Is Nothing) Then
Dim subNestedRepeater As Repeater = e.Item.FindControl("SubNestedRepeater")

If Not (subNestedRepeater Is Nothing) Then
Dim Measure_ID As String = dv("Measure_ID").ToString()

'FOR DOTNETCHARTING
'---------------------
Dim nestedRepeater As Repeater = e.Item.Parent
Dim subDs As DataSet = nestedRepeater.DataSource
Dim dataView As DataView = New DataView(subDs.Tables(1))
dataView.RowFilter = "Measure_ID = '" & Measure_ID & "'"

'raw dataview assigned to a repeater
'-------------
'subNestedRepeater.DataSource = dataView ' dv.CreateChildView("NestThemSub")
'subNestedRepeater.DataBind()
'------------------------------------------------------------

'FOR DOTNETCHARTING CHARTING TOOL
'----------------------------

Dim chart As New dotnetCHARTING.Chart

'Set Chart 1 properties
chart.Title = "My Chart 1"
chart.Type = dotnetCHARTING.ChartType.Combo
chart.DefaultSeries.DefaultElement.Transparency = 35
chart.TempDirectory = "temp"
chart.ChartArea.XAxis.Label.Text = "Customers"
chart.Debug = True
chart.TempDirectory = "temp"
chart.Width = Unit.Parse(420)
chart.Height = Unit.Parse(300)

'Adding series programatically
chart.Series.Name = "Item sales"
chart.Series.Data = dataView
chart.SeriesCollection.Add()
Dim i As Integer
For i = 0 To subNestedRepeater.Items.Count - 1
subNestedRepeater.Items(i).FindControl("Placeholder1").Controls.Add(chart)
Next

End If
End If
End Sub
----------------------

If I do this nothing is rendered in subnestedrepeater. please help.

thanks

i want to create Login User Control with the following requirements

1. restricting the number of attempts i.e. Locking the attempt on failure
2. Prompting the user to change the password on first login
3. Password Resetting
4. Password Retrieval(Self service password Management)
5. Timely Expiry and updating the password
6. Restricting Multiple Logins by the same user for different Applications
7. Registration Request by the user
8. Automatic Logout of the user on closing of the browser
9. Audit of each login with time stamp will be maintained
10. Session Idle time out.

And your question is?

...

It is up to us to guess. Laugh | :laugh:

Best Regards,
Apurva Kaushal

And my question is where can i get the complete code to implement all the requirements...it's urgent plzzzzz help me..

And my question is where can i get the complete code to implement all the requirements...it's urgent plzzzzz help me

Hi How I can generate dynamic column in a crystal report. My problem is I have 50 students in a class. I want to generate a mark list. The number of examination may vary. suppose it is Two Exam or three exam like wise. The number of column must be corresponding to the number of examination for a particular Subject.(Si No, Name, Ex1, Ex2) or (SiNo , Name, Ex1, Ex2,Ex3).
I generate a Data table for my need , But i have no idea about how i display this datatable in Crystal Report. This is an ASp.net application. Pls Help me
Urgent................
Binu Varghese

-- modified at 2:28 Thursday 22nd June, 2006

Hi,

I am new to Biztalk server. Can any one explain me what is Biztalk server and what is the relation between Biztalk and .Net?

Regards,
Giriprasad

Hi there,
I guess the ASP.NET forum is not a place to look for your answer, try the Biztalk Home[^] instead.

i hv a datagrid and in this datagrid i hv dropdownlists,this dropdownlists is populated through database,mean it is dynamic,i wnt to validate the dropdwnlist on the client side ,either some value is selected or nt if nt selected then show message that select value frm dropdwonlist in the datagrid.i done it on serverside..its take time,nw i wnt to do it on client side mean iwnt some JavaScript or some other way to validate this dropdwn on the client End..i shall b vry thnk full if some one help me

-- modified at 0:49 Thursday 22nd June, 2006

Hi,
You can use javascript to validate the dropdown list. What you need to do is just call a javascript function on onChange event of the dropdown list and and perform the validation in that function.

Best Regards,
Apurva Kaushal

thnks for taking interest ,i try it .and let me inform u ..

i check it in the code of dropdwnlist ,there is no onChange Event,bt there exist a onselectIndexchange Event..this is my code

<itemtemplate>
<asp:dropdownlist id="DropDownList1" width="150" runat="server" autopostback="false" datasource="<% #load_ ()%>" datatextfield="GradeDescription" datavaluefield="GradeDescription">

waiting for ur rply

-- modified at 1:34 Thursday 22nd June, 2006

in the html part of the dropdownlist you just write onChange= "javascript function name".

Best Regards,
Apurva Kaushal

hi,
this is code...
plz chek it and tell me,u told me b4 write Removed="javasrcipt fuction" there is no removed in the html
kinldy help me
asp:DropDownList id=DropDownList1 Width="150" Runat="server" AutoPostBack="false" DataSource="<%#load_()%>" DataTextField="GradeDescription" DataValueField="GradeDescription"

whn i add it on the in OnselectIndexChanged="javascript:getselected()" the showing me the error," javascript is nt the member of Page.aspx"

/asp:DropDownList

-- modified at 1:40 Thursday 22nd June, 2006

you try like this:

<asp:DropDownList id=DropDownList1 Width="150" Runat="server" AutoPostBack="false" DataSource="<%#load_()%>" DataTextField="GradeDescription" DataValueField="GradeDescription" onChange="javacsript:test(this);">
</asp:DropDownList>

here test is a javascript function name.

Best Regards,
Apurva Kaushal

plz chek it out i hv write this javascript is it correct or wrong

function get_selected()
{
// document.Form1.
var theContent=document.getElementById ("DropDownList1").sourceIndex;
//var theContent=document.getElementById("DropDownList1")
if (theContent="[SELECT ONE]")
{
window.alert("Select all the value from the dropdownList");
}
}

if the dropdownlist control is inside the datagrid control then you can't access the dropdownlist id like that. Because the id will be changed after rendering. you can send that as parameter and then use it.

Best Regards,
Apurva Kaushal