C＃将datagridview数据写入SQL表

尝试这样的事情，然后将其

(DataTable)datagridview2.DataSource

private static void BulkInsertToSQL(DataTable dt, string tableName)        {     using (SqlConnection con = new SqlConnection(_DB))     {         SqlBulkCopy sbc = new SqlBulkCopy(con);         sbc.DestinationTableName = tableName;         //if your DB col names don鈥檛 match your data table column names 100%         //then relate the source data table column names with the destination DB cols         sbc.ColumnMappings.Add("DBAttributeName1", "DTColumnName1");         sbc.ColumnMappings.Add("DBAttributeName2", "DTColumnName2");         sbc.ColumnMappings.Add("DBAttributeName3", "DTColumnName3");         sbc.ColumnMappings.Add("DBAttributeName4", "DTColumnName4");         con.Open();         sbc.WriteToServer(dt);         con.Close();     }        }