Questions on UI for ASP.NET AJAX Forum

3 answers

104 views

X and Y axis on Rad Chart

I am using 3 tier programming
So in my Data Access Layer I have the following code

public List<AdvertisementDAL> displayChart()

{

List<AdvertisementDAL> dal = new List<AdvertisementDAL>();

string sql = "Select * From AdvertisementRecord";

SqlConnection conn = new SqlConnection(_connStr);

SqlCommand cmd = new SqlCommand(sql, conn);

conn.Open();

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())

{

_recordID = int.Parse(dr["RecordID"].ToString());

_recordDate = dr["RecordDate"].ToString();

_noOfClick = int.Parse(dr["NoOfClick"].ToString());

_noOfView = int.Parse(dr["NoOfView"].ToString());

_advertisementID = int.Parse(dr["FK_AdvertisementID"].ToString());

dal.Add(new AdvertisementDAL(_recordID, _recordDate, _noOfClick, _noOfView, _advertisementID));

}

conn.Close();

dr.Close();

dr.Dispose();

return dal;

}

In my business Logic Code I have this:

public List<AdvertisementDAL> pieChart()

{

AdvertisementDAL dal = new AdvertisementDAL();

List<AdvertisementDAL> dll = new List<AdvertisementDAL>();

dll = dal.displayChart();

return dll;

}

In my Presentation Layer I have the following code:

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

AdvertisementBLL bll = new AdvertisementBLL();

RadChart1.DataSource = bll.pieChart();

RadChart1.DataBind();

}

So here is the real problem start:
I want to display in this way
On my Y Axis Label( look at the attachment)
It will be the record date( 12/21/2012, 12/22/2012, 12/23/2012)
On my X Axis Label(look at the attachment)
It will be 1 to 100
My series 1 will be NoOfClick
My series 2 will be NoOfView

I tried the following but it said
The type of column with name Record Date is not numeric

General Discussions

answered on 27 Dec 2012

1 answer

50 views

how to custom grid area with new columns from bounded with databas

hi,
i'm using fileexplorer and i want to add more columns inside the grid area of the file explorer and fill it with the data i have from database i'm allready using dbcontentprovider class
Thank you,

FileExplorer

answered on 27 Dec 2012

1 answer

179 views

Customize my RadTabStrip

Hi,

I had tried following the step in following site:
http://demos.telerik.com/aspnet-ajax/tabstrip/examples/appearance/customcssclasses/defaultcs.aspx
to customize my own Css Class but it didn't quite come up what i want as the Words weren't displayed completely and the tab shown improperly and Hover can't change to yellow (Please see attachment 1 and CSS)
So several questions I like to ask:
1) How can I fixed the CSS class in order to make my tab shown properly.
2.) Larger Tab Size. I want the first tab would be larger and taller among other tabs within ths same Tabstrip. Could you show me the CSS how to do this
3.) Apply my own Sprite Guide. I want to have tab design or shape based on my images, do I have to create sprite image first? Any alternative way? I don know How to create a sprite. Could you show me some tuterials and samples.
3.) Apart from the color, I would like to create my custom Tab (Please see attachment 2) based on my own design images (Please see attachment 3), Please advise How can I do it and sample css provided would be much appreicated.

Thanks.
Patrick

TabStrip

answered on 27 Dec 2012

3 answers

80 views

Compare Datetime

who compare datetime in radgrid itemdatabound? , please help

General Discussions

answered on 27 Dec 2012

5 answers

745 views

How to add GridButtonColumn (Link Button) to Auto generated grid dynamically

my requirement is little different. I have a RadGrid (Auto generated columns) on my web page. I’ve got 4 columns all together (From DB). There is a column called “Doc Name”. As I use Auto generate column feature, I get all columns as GridBoundColumns. I need to change “Doc Name” Grid Bound Column to link button or hyper link column. (Each and every row has a related .PDF file which need to be opened when user click a cell of that column)

Eg:

Doc Name Document Title Fields

Doc 1 Drawing 1 text

Doc 2 Drawing 1 of 2 button

Could you please help me to find how to change GridBoundColumn to GridButtonColumn (Link/Hyperlink) in runtime?

Regards,
Tray

Grid

answered on 27 Dec 2012

9 answers

286 views

issue when using SelectedItemStyle BackColor="#rgb" of firefox3

using <SelectedItemStyle BackColor="Red" /> works fine,
using any <SelectedItemStyle BackColor="#rgb" /> leaves the Background painted with selected color after selecting another row, this only happens on Firefox3.

Grid

answered on 27 Dec 2012

5 answers

314 views

Adding dropdown and button in radgrid

Hi,
I want to add a dropdown and a button in radgrid. The values in the dropdown are static(for example: "male" and "female").

I want to have the dropdown and button in the inseritemtemplate and edititemtemplate as well . Foe the button how should the aspx.cs be invoked?

How to add and use the dropdown and button in radgrid
Thanks

Grid

answered on 27 Dec 2012

4 answers

294 views

Change background image on client

Hello

I'm trying to change the background image of an RadButton with javascript:

<telerik:RadButton runat="server" Width="85px" Height="33px" ID="btnSup"">

<Image IsBackgroundImage="True" ImageUrl="/Images/Buttons/test.png"></Image>

</telerik:RadButton>

But I can't figure out how to do this? I have looked in the documentation here http://www.telerik.com/help/aspnet-ajax/button-client-side-basics.html but did not find anything.

Any suggestions?

-Casper

Button

answered on 26 Dec 2012

1 answer

97 views

GridDropDownColumn dynamic loading records

I have created few GridDropDownColumn in my page in design of the page with the properties of

<telerik:GridDropDownColumn DataField="Department_Name"

FilterControlAltText="Filter ddlDepartment column" HeaderText="Department"

UniqueName="ddlDepartment" ListDataMember="Department" ListTextField="Department_Name" ListValueField="Department_Id">

</telerik:GridDropDownColumn>

I don't want to use DataSourceId to define from the design of the page since I need to load the records in the loading time of the grid and I am using data layer to call the department table records. I have already created the function in data layer which returns all department records in data table.

Same as I need to do for Job Title and Location. I think I need to load these griddropdowns before loading the records in Grid. I read the http://www.telerik.com/help/aspnet-ajax/grid-customize-configure-griddropdowncolumn.html page but still it didn't help me.

Grid

answered on 26 Dec 2012

7 answers

790 views

Change Cell value?

Hi,

I want to change a cell value using itemtamplate field. and after this leaving this cell i want to update row values.
For example:

In itemtamplate field I have Quantity of Product. When I change Quantity the Total amount should also change.

Title Quantity Price Amount
ABC 5 100 5000

If change quantity

Title Quantity Price Amount
ABC 7 100 7000

It should be change when i leave this quantity cell. Please guide me how i can catch particular cell leave event and how i can update value from other cell.

Regards
Mohsin JK

Grid

answered on 26 Dec 2012