C#里如何把一个DataTable的数据追加进数据库里的某个表

方法一：

DataTable table = new DataTable();
            //TODO: init table...
            string connStr = "user id=" + dbInfo.UserName + ";data source=" + dbInfo.DBServerIP + ";persist security info=False;initial catalog=" + dbInfo.DatabaseName + ";password=" + dbInfo.Password;
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(conn);
            sqlBulkCopy.DestinationTableName = dbInfo.TableName;
            sqlBulkCopy.WriteToServer(table);
            sqlBulkCopy.Close();DataTable table = new DataTable();