CODEWITHSUNDEEP
c#asp.net
Mayank
Mayank

Reputation: 141

Multiple Column Chart From Database in C#

I want to create a Multiple column chart on button click. Data for chart will come From Database. I have used following code. 

protected void btnEffortProject_Click(object sender, EventArgs e)
{
    string str = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnection"].ToString();
    SqlConnection con = new SqlConnection(str);
    con.Open();
    SqlCommand cmd = new SqlCommand("Select Title, Planned_Estimate, TotalEffort from DBAgile.dbo.Project Where Status = 'Completed'", con);
    SqlDataAdapter sdp = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    sdp.Fill(ds);

    Chart1.DataSource = ds;
    Chart1.Series["Series1"].XValueMember = "Title";
    Chart1.Series["Series1"].YValueMembers = "Planned_Estimate";
    Chart1.Series["Series2"].XValueMember = "Title";
    Chart1.Series["Series2"].YValueMembers = "TotalEffort";
    Chart1.DataBind();
}

aspx Code is as follows : 

<asp:Chart ID="Chart1" runat="server" Width="400px" Visible="False">
        <Titles>
            <asp:Title ShadowOffset="3" Name="Items" />
        </Titles>
        <Legends>
            <asp:Legend Alignment="Center" Docking="Bottom" IsTextAutoFit="False" Name="Default"
                LegendStyle="Row" />
        </Legends>
        <Series>
            <asp:Series Name="Series1" XValueMember="Title" YValueMembers="Planned_Estimate" LegendText="Quarter 1"
                IsValueShownAsLabel="false" ChartArea="ChartArea1" MarkerBorderColor="#DBDBDB">
            </asp:Series>
            <asp:Series Name="Series2" XValueMember="Title" YValueMembers="TotalEffort" LegendText="Quarter 2"
                IsValueShownAsLabel="false" ChartArea="ChartArea1" MarkerBorderColor="#DBDBDB">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1" BorderWidth="0" />
        </ChartAreas>
    </asp:Chart>

am i doing anything wrong ?? because code runs fine but doesn't display any chart. Where i am wrong ? Please Help

Upvotes: 1

Views: 2160

Answers (1)

Sid M
Sid M

Reputation: 4364

Change Visible="False" to Visible="True" in 

<asp:Chart ID="Chart1" runat="server" Width="400px" Visible="False">

Upvotes: 1

Related Questions