用C#绘柱形图(owc编程)

}

调用方法部分代码:

private void Form1_Load(object sender, System.EventArgs e)

{

try

{

System.Threading.Thread thread=new System.Threading.Thread(new System.Threading.ThreadStart(aa));

thread.Start();

//ShowChart();

}

catch

{}

}

void aa()

{

while(true)

{

ShowChart();

System.Threading.Thread.Sleep(1000);

}

}

//调用 首先需要在页面上放置一个pictureBox1来显示产生的统计图

public void ShowChart()

{

try

{

string ConnString = "Data Source=SQL服务器地址;Initial Catalog=数据库名;Persist Security Info=True;User ID=用户名;Password=密码";

DB.sqlDB db = new DB.sqlDB(ConnString);

string sql = "查询字符串";

DataTable table = db.getTable(sql);

if (table != null && table.Rows.Count > 0)

{

StringBuilder sb=new StringBuilder();

for (int i = 0; i < table.Rows.Count; i++)

{

if (i == 0)

{

sb.Append(table.Rows[i]["content"].ToString());

}

else

{

sb.Append("," + table.Rows[i]["content"].ToString());

}

}

string[] CategoriesArr ={sb.ToString()};

sb=new StringBuilder();

for (int i = 0; i < table.Rows.Count; i++)

{

if (i == 0)

{

sb.Append(table.Rows[i]["cnt"].ToString());

}