4,816
社区成员
发帖
与我相关
我的任务
分享
string sql = "select client, count(client) as b ,Year( M_date) as y from comtus group by client ,M_date";
string conn = "Data Source=localhost;Initial Catalog=shaoy;Persist Security Info=True;User ID=sa;Password=0;";
SqlConnection sqlcon = new SqlConnection(conn);
SqlCommand cmd = new SqlCommand(sql, sqlcon);
cmd.Connection.Open();
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
chart2.DataBindCrossTable(sdr, "client", "y", "b", "Label=b");
sdr.Close();
sqlcon.Close();