My company just purchased the Telerik Premium Collection for .NET and asked me to start making some charts that are due in a few days. I have no experience with Telerik or reporting in general so I need as much help as I can get.

I have a database table that represents each developer’s time scheduled by project managers. It has the following fields:
Employee, Date, Hours, Project Code

My manager wants a stacked bar chart that has the date on the X axis and hours on the Y axis. Each bar would show the number of hours scheduled that day grouped by project code. He wants the chart to show one employee at a time with the ability to switch to different employees. The dates on the X axis would show the current week with the ability to scroll to the right to see future dates scheduled, up to 3 months. Also, he wants you to be able to hover over the bar chart to see the project code related to those hours.

System;

Telerik.Web.UI;

System.Web.UI.WebControls;

System.Data;

System.Data.SqlClient;

System.Configuration;

System.Collections;

System.Web;

System.Web.Security;

System.Web.UI;

System.Web.UI.WebControls.WebParts;

System.Web.UI.HtmlControls;

Telerik.GridExamplesCSharp.Programming.Hierarchy

{

public partial class OneView : System.Web.UI.Page

private void DefineGridStructure()

{

RadGrid RadGrid1 = new RadGrid();

RadGrid1.ID =

"RadGrid1";

//RadGrid1.DataSourceID = "SqlDataSource1";

false;

RadGrid1.Skin =

"Web20";

RadGrid1.MasterTableView.DataKeyNames =

new string[] { "CustomerID" };

RadGrid1.Width =

Unit.Percentage(98);

RadGrid1.PageSize = 3;

RadGrid1.AllowPaging =

true;

RadGrid1.AllowSorting =

true;

RadGrid1.PagerStyle.Mode =

GridPagerMode.NextPrevAndNumeric;

RadGrid1.AutoGenerateColumns =

false;

RadGrid1.ShowStatusBar =

true;

RadGrid1.MasterTableView.PageSize = 3;

//Add columns

GridBoundColumn boundColumn;

boundColumn =

new GridBoundColumn();

boundColumn.DataField =

"CustomerID";

boundColumn.HeaderText =

"CustomerID";

RadGrid1.MasterTableView.Columns.Add(boundColumn);

boundColumn =

new GridBoundColumn();

boundColumn.DataField =

"ContactName";

boundColumn.HeaderText =

"Contact Name";

RadGrid1.MasterTableView.Columns.Add(boundColumn);

RadGrid1.DataSource = MakeDS().Tables[0];

RadGrid1.DataBind();

            //Detail table - Orders (II in hierarchy level)

GridTableView tableViewOrders = new GridTableView(RadGrid1);

tableViewOrders.AutoGenerateColumns =

false;

//tableViewOrders.DataSourceID = "SqlDataSource2";

////Add columns

new GridBoundColumn();

boundColumn.DataField =

"OrderID";

boundColumn.HeaderText =

"OrderID";

tableViewOrders.Columns.Add(boundColumn);

boundColumn =

new GridBoundColumn();

boundColumn.DataField =

"OrderDate";

boundColumn.HeaderText =

"Date Ordered";

tableViewOrders.Columns.Add(boundColumn);

tableViewOrders.DataSource = MakeDS().Tables[1];

tableViewOrders.DataBind();

tableViewOrders.Width =

Unit.Percentage(100);

tableViewOrders.DataKeyNames =

new string[] { "OrderID" };

GridRelationFields relationFields = new GridRelationFields();

relationFields.MasterKeyField =

"CustomerID";

relationFields.DetailKeyField =

"CustomerID";

tableViewOrders.ParentTableRelation.Add(relationFields);

RadGrid1.MasterTableView.DetailTables.Add(tableViewOrders);

//Add the RadGrid instance to the controls

this.PlaceHolder1.Controls.Add( RadGrid1 );

}

protected void Page_Init(object source, System.EventArgs e)

{

DefineGridStructure();

}

protected void Page_Load(object sender, EventArgs e)

{

RadGrid Grid1 = (RadGrid)PlaceHolder1.FindControl("RadGrid1");

}

public DataSet MakeDS()

{

SqlDataAdapter DA = new SqlDataAdapter();

DataSet DS = new DataSet();

SqlCommand cmd;

string strconnection =

@"Data Source=MY\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True";

SqlConnection sqlcon = new SqlConnection();

sqlcon.ConnectionString = strconnection;

cmd =

new SqlCommand("SELECT * FROM Customers", sqlcon);

cmd.Connection.Open();

DA.SelectCommand = cmd;

//creating datasets

"MainTable");

cmd =

new SqlCommand("SELECT * FROM Orders ", sqlcon);

DA.SelectCommand = cmd;

DA.Fill(DS,

"SecondTable");

return DS;

}

}

}


Pls help me out!
Thanks for your help in advance.

asp:Panel id="pnlMenu" width="100%" runat="server" CssClass="collapsePanel">

<ak:MainMenu width="100%" height="100%" id="AppMainMenu" Runat="Server" />

</asp:Panel>

protected void ShowQuestions()

{

try

{

    this.radGridQuestions.DataSource = this.questions;

catch

{

}

}

<

tk:RadGrid ID="radGridQuestions" runat="server" AutoGenerateColumns="False" ShowHeader="false" GridLines="None">

<MasterTableView DataKeyNames="Id">

<Columns>

<tk:GridTemplateColumn>

<ItemTemplate>

<table>

<tr>

<td style="width: 30px; vertical-align: top;">

<img src="<%# PostStatusImage(Container.DataItem)%>" alt="PostStatus" />

</td>

<td style="vertical-align: top;">

<asp:LinkButton ID="lbViewQuestion" runat="server" Text='<%# Eval("Title") %>' CommandArgument='<%# Eval("Id") %>'

CommandName="ViewQuestion"></asp:LinkButton>&nbsp; Posted On:&nbsp;<%# Eval("PostedDate") %>

</td>

</tr>

</table>

</ItemTemplate>

</tk:GridTemplateColumn>

</Columns>

<DetailTables>

<tk:GridTableView runat="server" DataKeyNames="Id">

<ParentTableRelation>

<tk:GridRelationFields DetailKeyField="ParentThreadId" MasterKeyField="Id" />

</ParentTableRelation>

<DetailTables>

</DetailTables>

</tk:GridTableView>

</DetailTables>

</MasterTableView>

</tk:RadGrid>