c# datagridview 将所有记录更新到数据表中
时间: 2024-01-22 10:18:54 浏览: 24
你可以使用以下代码将DataGridView中的所有记录更新到数据表中:
```csharp
private void UpdateData()
{
string connectionString = "your_connection_string_here";
string tableName = "your_table_name_here";
string query = "SELECT * FROM " + tableName;
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(query, connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
dataGridView1.EndEdit();
foreach (DataRow row in dataTable.Rows)
{
if (row.RowState != DataRowState.Deleted)
{
adapter.Update(row);
}
}
}
}
```
在此代码中,您需要将"your_connection_string_here"替换为您的数据库连接字符串,"your_table_name_here"替换为您要更新的表的名称,并且"dataGridView1"应该是您的DataGridView控件的名称。