vb.net中chart,aspnet vb

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

vbnet中chart的问题？

连接数据库例子：数据写到表里

C# code?

string strSql = "SELECT Top 5 empid, COUNT(*) AS lNum FROM log where empid '' GROUP BY empid ORDER BY empid";

DataSet ds = SqlHelper.ExecuteDataset(strConnISPD, CommandType.Text, strSql);

DataView dv = new DataView(ds.Tables[0]);

Chart1.Series["login"].Points.DataBindXY(dv, "empid", dv, "lNum");

SqlCommand cd = new SqlCommand(strSql, conn);

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cd;

DataSet ds = new DataSet();

da.Fill(ds, "log");

DataView dv = new DataView(ds.Tables[0]);

dv.Sort="empid";

Chart1.Series["login"].Points.DataBindXY(dv, "empid", dv, "lNum");