如何将gridview中的边界字段值和模板字段值插入数据库

using System;
using System.Data;
using MySql.Data.MySqlClient;

public class GridViewToDatabase
{
    public static void Main(string[] args)
    {
        // 获取gridview中的边界字段值和模板字段值
        string boundaryFieldValue = "边界字段值";
        string templateFieldValue = "模板字段值";

        // 创建数据库连接
        string connectionString = "server=localhost;database=mydatabase;uid=root;pwd=123456;";
        MySqlConnection connection = new MySqlConnection(connectionString);

        try
        {
            // 打开数据库连接
            connection.Open();

            // 构建SQL插入语句
            string insertQuery = "INSERT INTO mytable (boundary_field, template_field) VALUES (@boundary, @template)";
            MySqlCommand command = new MySqlCommand(insertQuery, connection);
            command.Parameters.AddWithValue("@boundary", boundaryFieldValue);
            command.Parameters.AddWithValue("@template", templateFieldValue);

            // 执行SQL插入语句
            command.ExecuteNonQuery();

            Console.WriteLine("数据插入成功！");
        }
        catch (Exception ex)
        {
            Console.WriteLine("数据插入失败：" + ex.Message);
        }
        finally
        {
            // 关闭数据库连接
            connection.Close();
        }
    }
}