在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();
}
这样,通过以上步骤,您可以在Visual Studio中使用C#中的DataGridView更新SQL Server数据库。请根据您的实际项目进行相应的修改和适应。同时,推荐腾讯云相关产品:云服务器SQL Server版,产品介绍链接:https://cloud.tencent.com/product/cdb-mssql
领取专属 10元无门槛券
手把手带您无忧上云