anyone have idea of bar chart,
<asp:Chart ID="Chart1" runat="server" ImageLocation="~/document/Images_Chart/ChartPic_#SEQ(300,3)" ImageStorageMode="UseImageLocation" Width="800px" BackGradientStyle="LeftRight">
<Series>
<asp:Series Name="Series1" ChartType="Column" ChartArea="ChartArea1" >
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1" Area3DStyle-IsClustered="true">
</asp:ChartArea>
</ChartAreas>
<BorderSkin SkinStyle="Emboss" /> </asp:Chart>
private void loadChart()
{
DataBase12 obj = new DataBase12();
DataSet ds_chart = new DataSet();
IFormatProvider cult = new CultureInfo("en-us");
ds_chart = obj.GetFeedBackChartReport(DateTime.ParseExact(txtFromdt.Text.ToString(), "dd/MM/yyyy", cult), DateTime.ParseExact(txtTodt.Text.ToString(), "dd/MM/yyyy", cult));
if (ds_chart.Tables[0].Rows.Count == 0)
{
pnl_Chart.Visible = false;
LblErrorMessage.Text = "No records found !";
}
else
{
Chart1.DataSource = ds_chart;
Chart1.DataBind();
pnl_Chart.Visible = true;
LblErrorMessage.Text = "";
}
}
in database i hv 2 question with q1,q2 if yes q1=1 if no q1=2 ,same for q2
i use this sp
Create PROC [dbo].[usp_GetFeedbackReport]
@FromDate Datetime,
@ToDate datetime
AS
BEGIN
SET NOCOUNT ON;
declare @q1yes int
declare @q1no int
declare @q2yes int
declare @q2no int
select @q1yes=count(q1) from tbl_feedbackDetails where q1=1
and Createdon >= @FromDate AND Createdon <= @ToDate
GROUP BY convert(varchar,Createdon,103)
ORDER BY convert(varchar,Createdon,103)
select @q1no=count(q1) from tbl_feedbackDetails where q1=2
and Createdon >= @FromDate AND Createdon <= @ToDate
GROUP BY convert(varchar,Createdon,103)
ORDER BY convert(varchar,Createdon,103)
select @q2yes=count(q2) from tbl_feedbackDetails where q2=1
and Createdon >= @FromDate AND Createdon <= @ToDate
GROUP BY convert(varchar,Createdon,103)
ORDER BY convert(varchar,Createdon,103)
select @q2no=count(q2) from tbl_feedbackDetails where q2=2
and Createdon >= @FromDate AND Createdon <= @ToDate
GROUP BY convert(varchar,Createdon,103)
ORDER BY convert(varchar,Createdon,103)
END
my bar chart is not displaying where i m doing wrong in x-axis i want show q1,q2