如何在DataBase中保存特征线并在文本区winform c#中显示它

// 引入必要的命名空间
using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

// 数据库连接字符串
string connectionString = "Data Source=数据库服务器地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码";

// 连接数据库
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    // 插入特征线数据
    string insertQuery = "INSERT INTO FeatureLines (Id, Name, Coordinates) VALUES (@Id, @Name, @Coordinates)";
    using (SqlCommand command = new SqlCommand(insertQuery, connection))
    {
        command.Parameters.AddWithValue("@Id", "特征线的唯一标识符");
        command.Parameters.AddWithValue("@Name", "特征线的名称");
        command.Parameters.AddWithValue("@Coordinates", "特征线的坐标点");

        command.ExecuteNonQuery();
    }

    // 检索特征线数据
    string selectQuery = "SELECT * FROM FeatureLines";
    using (SqlCommand command = new SqlCommand(selectQuery, connection))
    {
        SqlDataAdapter adapter = new SqlDataAdapter(command);
        DataTable dataTable = new DataTable();
        adapter.Fill(dataTable);

        // 在文本区控件中显示特征线数据
        foreach (DataRow row in dataTable.Rows)
        {
            string featureLineId = row["Id"].ToString();
            string featureLineName = row["Name"].ToString();
            string featureLineCoordinates = row["Coordinates"].ToString();

            string featureLineText = $"特征线ID: {featureLineId}\n特征线名称: {featureLineName}\n特征线坐标点: {featureLineCoordinates}\n";

            // 将特征线数据显示在文本区控件中
            textBox.AppendText(featureLineText);
        }
    }
}