在Visual Studio上通过C#中的datagridview更新SQL Server数据库

using System.Data.SqlClient;

private void Form_Load(object sender, EventArgs e)
{
    string connectionString = "Data Source=服务器名称;Initial Catalog=数据库名称;User ID=用户名;Password=密码";
    SqlConnection connection = new SqlConnection(connectionString);
    connection.Open();
    // 可以执行其他初始化操作或查询数据的代码
    connection.Close();
}

using System.Data;

private void Form_Load(object sender, EventArgs e)
{
    string connectionString = "Data Source=服务器名称;Initial Catalog=数据库名称;User ID=用户名;Password=密码";
    SqlConnection connection = new SqlConnection(connectionString);
    connection.Open();
    
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM 表名", connection);
    DataSet dataSet = new DataSet();
    adapter.Fill(dataSet, "表名");
    
    dataGridView.DataSource = dataSet.Tables["表名"];
    
    connection.Close();
}

using System.Data.SqlClient;

private void btnSave_Click(object sender, EventArgs e)
{
    string connectionString = "Data Source=服务器名称;Initial Catalog=数据库名称;User ID=用户名;Password=密码";
    SqlConnection connection = new SqlConnection(connectionString);
    connection.Open();
    
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM 表名", connection);
    DataSet dataSet = new DataSet();
    adapter.Fill(dataSet, "表名");
    
    // 修改DataGridView中的数据
    
    SqlCommandBuilder commandBuilder = new SqlCommandBuilder(adapter);
    adapter.Update(dataSet, "表名");
    
    connection.Close();
}