1.打开vs2010新建windows窗体项目,在数据工具栏拖入Chart控件,选中控件点击属性Servies找到ChartType并且选择Spline.即为曲线图表;
找到MarkerStyle可以设置曲线中数据点的样式;找到IsValueshownAsLable设置为true图表上数据点可以显示数值等;
public static DataTable GetCampaignList()
{
string con = ConfigurationManager.ConnectionStrings["JResearch:Commander:ApiDataConnectioniString"].ConnectionString;
string sql = "select sum(click) click,[date] from dbo.tb_api_simba_rpt_campaignbase where nick='follower_2008'and([date] between DateAdd(day,-16,getdate()) and DateAdd(day,-1,getdate())) group by [date] order by [date]";
SqlDBAccess dbAccess = new SqlDBAccess(con);