如何使用数据库C#中的数据创建chartjs图表

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.DataVisualization.Charting;

public partial class ChartPage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 连接数据库
        string connectionString = "YourConnectionString";
        SqlConnection connection = new SqlConnection(connectionString);
        connection.Open();

        // 查询数据
        string query = "SELECT Category, Sales FROM SalesData";
        SqlCommand command = new SqlCommand(query, connection);
        SqlDataAdapter adapter = new SqlDataAdapter(command);
        DataTable dataTable = new DataTable();
        adapter.Fill(dataTable);

        // 创建Chart.js图表
        Chart chart = new Chart();
        chart.Width = 500;
        chart.Height = 300;

        // 添加柱状图系列
        Series series = new Series();
        series.ChartType = SeriesChartType.Column;
        series.XValueMember = "Category";
        series.YValueMembers = "Sales";
        chart.Series.Add(series);

        // 绑定数据
        chart.DataSource = dataTable;
        chart.DataBind();

        // 将图表显示在网页中
        ChartContainer.Controls.Add(chart);

        // 关闭数据库连接
        connection.Close();
    }
}