1.首先获取datagirdview的datatable
DataTable dt = dataGridView1.DataSource as DataTable;
2.将其更新至数据库
public static bool UpdataSql(DataTable dt)
{
try
{
using (SqlConnection connection = new SqlConnection(PubVariant.ConnectionString))
{
string strSql = "select * from CorrespondField";
using (SqlCommand cmd = new SqlCommand(strSql, connection))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
using (SqlCommandBuilder builder = new SqlCommandBuilder(da))
{
da.Update(dt);
return true;
}