操作XML文件的又一个方便的方法！

首先使用Vs.net 2003 Tools菜单中的connect to DataBase 命令连接到数据库（以本地数据库为例），然后你可以看到本地数据库中的相应的表结构，这里我建立一个users表。然后再建立一个Dataset实体，如图所示：

然后从Server Explorer 中拖拽users对象到Dataset视图中去，这时能看到视图中有一个users表的结构，然后点击保存。这时默认是自动生成Dataset的代理类。你可以把隐藏的文件都显示出来，然后看Dataset的cs文件，这个就是他的代理类。代码如下：

dataset代理类

  1//------------------------------------------------------------------------------

  2// <autogenerated>

  3//     This code was generated by a tool.

  4//     Runtime Version: 1.1.4322.2300

  5//

  6//     Changes to this file may cause incorrect behavior and will be lost if 

  7//     the code is regenerated.

  8// </autogenerated>

  9//------------------------------------------------------------------------------

 10

 11namespace TestXsd {

 12    using System;

 13    using System.Data;

 14    using System.Xml;

 15    using System.Runtime.Serialization;

 16    

 17    

 18    [Serializable()]

 19    [System.ComponentModel.DesignerCategoryAttribute("code")]

 20    [System.Diagnostics.DebuggerStepThrough()]

 21    [System.ComponentModel.ToolboxItem(true)]

 22    public class Dataset2 : DataSet {

 23        

 24        private usersDataTable tableusers;

 25        

 26        public Dataset2() {

 27            this.InitClass();

 28            System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);

 29            this.Tables.CollectionChanged += schemaChangedHandler;

 30            this.Relations.CollectionChanged += schemaChangedHandler;

 31        }

 32        

 33        protected Dataset2(SerializationInfo info, StreamingContext context) {

 34            string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));

 35            if ((strSchema != null)) {

 36                DataSet ds = new DataSet();

 37                ds.ReadXmlSchema(new XmlTextReader(new System.IO.StringReader(strSchema)));

 38                if ((ds.Tables["users"] != null)) {

 39                    this.Tables.Add(new usersDataTable(ds.Tables["users"]));

 40                }

 41                this.DataSetName = ds.DataSetName;

 42                this.Prefix = ds.Prefix;

 43                this.Namespace = ds.Namespace;

 44                this.Locale = ds.Locale;

 45                this.CaseSensitive = ds.CaseSensitive;

 46                this.EnforceConstraints = ds.EnforceConstraints;

 47                this.Merge(ds, false, System.Data.MissingSchemaAction.Add);

 48                this.InitVars();

 49            }

 50            else {

 51                this.InitClass();

 52            }

 53            this.GetSerializationData(info, context);

 54            System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);

 55            this.Tables.CollectionChanged += schemaChangedHandler;

 56            this.Relations.CollectionChanged += schemaChangedHandler;

 57        }

 58        

 59        [System.ComponentModel.Browsable(false)]

 60        [System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)]

 61        public usersDataTable users {

 62            get {

 63                return this.tableusers;

 64            }

 65        }

 66        

 67        public override DataSet Clone() {

 68            Dataset2 cln = ((Dataset2)(base.Clone()));

 69            cln.InitVars();

 70            return cln;

 71        }

 72        

 73        protected override bool ShouldSerializeTables() {

 74            return false;

 75        }

 76        

 77        protected override bool ShouldSerializeRelations() {

 78            return false;

 79        }

 80        

 81        protected override void ReadXmlSerializable(XmlReader reader) {

 82            this.Reset();

 83            DataSet ds = new DataSet();

 84            ds.ReadXml(reader);

 85            if ((ds.Tables["users"] != null)) {

 86                this.Tables.Add(new usersDataTable(ds.Tables["users"]));

 87            }

 88            this.DataSetName = ds.DataSetName;

 89            this.Prefix = ds.Prefix;

 90            this.Namespace = ds.Namespace;

 91            this.Locale = ds.Locale;

 92            this.CaseSensitive = ds.CaseSensitive;

 93            this.EnforceConstraints = ds.EnforceConstraints;

 94            this.Merge(ds, false, System.Data.MissingSchemaAction.Add);

 95            this.InitVars();

 96        }

 97        

 98        protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() {

 99            System.IO.MemoryStream stream = new System.IO.MemoryStream();

100            this.WriteXmlSchema(new XmlTextWriter(stream, null));

101            stream.Position = 0;

102            return System.Xml.Schema.XmlSchema.Read(new XmlTextReader(stream), null);

103        }

104        

105        internal void InitVars() {

106            this.tableusers = ((usersDataTable)(this.Tables["users"]));

107            if ((this.tableusers != null)) {

108                this.tableusers.InitVars();

109            }

110        }

111        

112        private void InitClass() {

113            this.DataSetName = "Dataset2";

114            this.Prefix = "";

115https%3A%2F%2Fs4.51cto.com%2Fimages%2Fblog%2F202108%2F08%2F1028371768f80a80a62dde99ad20531b.gif%3Fx-oss-process%3Dimage%2Fwatermark%2Csize_16%2Ctext_QDUxQ1RP5Y2a5a6i%2Ccolor_FFFFFF%2Ct_100%2Cg_se%2Cx_10%2Cy_10%2Cshadow_90%2Ctype_ZmFuZ3poZW5naGVpdGk%3D%22%2C%22status%22%3A%22done%22%2C%22percent%22%3A0%2C%22size%22%3A%7B%22width%22%3A11%2C%22height%22%3A16%2C%22naturalWidth%22%3A11%2C%22naturalHeight%22%3A16%7D%2C%22id%22%3A%22d6P5C%22%7D" data-card-type="inline" data-card-key="image" data-card-loading="true" data-card-editable="false">​ ​            this.Namespace = "http://tempuri.org/Dataset2.xsd";

116            this.Locale = new System.Globalization.CultureInfo("en-US");

117            this.CaseSensitive = false;

118            this.EnforceConstraints = true;

119            this.tableusers = new usersDataTable();

120            this.Tables.Add(this.tableusers);

121        }

122        

123        private bool ShouldSerializeusers() {

124            return false;

125        }

126        

127        private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) {

128            if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) {

129                this.InitVars();

130            }

131        }

132        

133        public delegate void usersRowChangeEventHandler(object sender, usersRowChangeEvent e);

134        

135        [System.Diagnostics.DebuggerStepThrough()]

136        public class usersDataTable : DataTable, System.Collections.IEnumerable {

137            

138            private DataColumn columnUserID;

139            

140            private DataColumn columnUsername;

141            

142            private DataColumn columnPassword;

143            

144            private DataColumn columnNickname;

145            

146            private DataColumn columnEmail;

147            

148            private DataColumn columnLastLoginTime;

149            

150            private DataColumn columnGroupID;

151            

152            private DataColumn columnPoint;

153            

154            internal usersDataTable() : 

155                    base("users") {

156                this.InitClass();

157            }

158            

159            internal usersDataTable(DataTable table) : 

160                    base(table.TableName) {

161                if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {

162                    this.CaseSensitive = table.CaseSensitive;

163                }

164                if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {

165                    this.Locale = table.Locale;

166                }

167                if ((table.Namespace != table.DataSet.Namespace)) {

168                    this.Namespace = table.Namespace;

169                }

170                this.Prefix = table.Prefix;

171                this.MinimumCapacity = table.MinimumCapacity;

172                this.DisplayExpression = table.DisplayExpression;

173            }

174            

175            [System.ComponentModel.Browsable(false)]

176            public int Count {

177                get {

178                    return this.Rows.Count;

179                }

180            }

181            

182            internal DataColumn UserIDColumn {

183                get {

184                    return this.columnUserID;

185                }

186            }

187            

188            internal DataColumn UsernameColumn {

189                get {

190                    return this.columnUsername;

191                }

192            }

193            

194            internal DataColumn PasswordColumn {

195                get {

196                    return this.columnPassword;

197                }

198            }

199            

200            internal DataColumn NicknameColumn {

201                get {

202                    return this.columnNickname;

203                }

204            }

205            

206            internal DataColumn EmailColumn {

207                get {

208                    return this.columnEmail;

209                }

210            }

211            

212            internal DataColumn LastLoginTimeColumn {

213                get {

214                    return this.columnLastLoginTime;

215                }

216            }

217            

218            internal DataColumn GroupIDColumn {

219                get {

220                    return this.columnGroupID;

221                }

222            }

223            

224            internal DataColumn PointColumn {

225                get {

226                    return this.columnPoint;

227                }

228            }

229            

230            public usersRow this[int index] {

231                get {

232                    return ((usersRow)(this.Rows[index]));

233                }

234            }

235            

236            public event usersRowChangeEventHandler usersRowChanged;

237            

238            public event usersRowChangeEventHandler usersRowChanging;

239            

240            public event usersRowChangeEventHandler usersRowDeleted;

241            

242            public event usersRowChangeEventHandler usersRowDeleting;

243            

244            public void AddusersRow(usersRow row) {

245                this.Rows.Add(row);

246            }

247            

248            public usersRow AddusersRow(string Username, string Password, string Nickname, string Email, System.DateTime LastLoginTime, short GroupID, int Point) {

249                usersRow rowusersRow = ((usersRow)(this.NewRow()));

250                rowusersRow.ItemArray = new object[] {

251                        null,

252                        Username,

253                        Password,

254                        Nickname,

255                        Email,

256                        LastLoginTime,

257                        GroupID,

258                        Point};

259                this.Rows.Add(rowusersRow);

260                return rowusersRow;

261            }

262            

263            public usersRow FindByUserID(int UserID) {

264                return ((usersRow)(this.Rows.Find(new object[] {

265                            UserID})));

266            }

267            

268            public System.Collections.IEnumerator GetEnumerator() {

269                return this.Rows.GetEnumerator();

270            }

271            

272            public override DataTable Clone() {

273                usersDataTable cln = ((usersDataTable)(base.Clone()));

274                cln.InitVars();

275                return cln;

276            }

277            

278            protected override DataTable CreateInstance() {

279                return new usersDataTable();

280            }

281            

282            internal void InitVars() {

283                this.columnUserID = this.Columns["UserID"];

284                this.columnUsername = this.Columns["Username"];

285                this.columnPassword = this.Columns["Password"];

286                this.columnNickname = this.Columns["Nickname"];

287                this.columnEmail = this.Columns["Email"];

288                this.columnLastLoginTime = this.Columns["LastLoginTime"];

289                this.columnGroupID = this.Columns["GroupID"];

290                this.columnPoint = this.Columns["Point"];

291            }

292            

293            private void InitClass() {

294                this.columnUserID = new DataColumn("UserID", typeof(int), null, System.Data.MappingType.Element);

295                this.Columns.Add(this.columnUserID);

296                this.columnUsername = new DataColumn("Username", typeof(string), null, System.Data.MappingType.Element);

297                this.Columns.Add(this.columnUsername);

298                this.columnPassword = new DataColumn("Password", typeof(string), null, System.Data.MappingType.Element);

299                this.Columns.Add(this.columnPassword);

300                this.columnNickname = new DataColumn("Nickname", typeof(string), null, System.Data.MappingType.Element);

301                this.Columns.Add(this.columnNickname);

302                this.columnEmail = new DataColumn("Email", typeof(string), null, System.Data.MappingType.Element);

303                this.Columns.Add(this.columnEmail);

304                this.columnLastLoginTime = new DataColumn("LastLoginTime", typeof(System.DateTime), null, System.Data.MappingType.Element);

305                this.Columns.Add(this.columnLastLoginTime);

306                this.columnGroupID = new DataColumn("GroupID", typeof(short), null, System.Data.MappingType.Element);

307                this.Columns.Add(this.columnGroupID);

308                this.columnPoint = new DataColumn("Point", typeof(int), null, System.Data.MappingType.Element);

309                this.Columns.Add(this.columnPoint);

310                this.Constraints.Add(new UniqueConstraint("Dataset2Key1", new DataColumn[] {

311                                this.columnUserID}, true));

312                this.columnUserID.AutoIncrement = true;

313                this.columnUserID.AllowDBNull = false;

314                this.columnUserID.ReadOnly = true;

315                this.columnUserID.Unique = true;

316                this.columnLastLoginTime.AllowDBNull = false;

317                this.columnGroupID.AllowDBNull = false;

318                this.columnPoint.AllowDBNull = false;

319            }

320            

321            public usersRow NewusersRow() {

322                return ((usersRow)(this.NewRow()));

323            }

324            

325            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {

326                return new usersRow(builder);

327            }

328            

329            protected override System.Type GetRowType() {

330                return typeof(usersRow);

331            }

332            

333            protected override void OnRowChanged(DataRowChangeEventArgs e) {

334                base.OnRowChanged(e);

335                if ((this.usersRowChanged != null)) {

336                    this.usersRowChanged(this, new usersRowChangeEvent(((usersRow)(e.Row)), e.Action));

337                }

338            }

339            

340            protected override void OnRowChanging(DataRowChangeEventArgs e) {

341                base.OnRowChanging(e);

342                if ((this.usersRowChanging != null)) {

343                    this.usersRowChanging(this, new usersRowChangeEvent(((usersRow)(e.Row)), e.Action));

344                }

345            }

346            

347            protected override void OnRowDeleted(DataRowChangeEventArgs e) {

348                base.OnRowDeleted(e);

349                if ((this.usersRowDeleted != null)) {

350                    this.usersRowDeleted(this, new usersRowChangeEvent(((usersRow)(e.Row)), e.Action));

351                }

352            }

353            

354            protected override void OnRowDeleting(DataRowChangeEventArgs e) {

355                base.OnRowDeleting(e);

356                if ((this.usersRowDeleting != null)) {

357                    this.usersRowDeleting(this, new usersRowChangeEvent(((usersRow)(e.Row)), e.Action));

358                }

359            }

360            

361            public void RemoveusersRow(usersRow row) {

362                this.Rows.Remove(row);

363            }

364        }

365        

366        [System.Diagnostics.DebuggerStepThrough()]

367        public class usersRow : DataRow {

368            

369            private usersDataTable tableusers;

370            

371            internal usersRow(DataRowBuilder rb) : 

372                    base(rb) {

373                this.tableusers = ((usersDataTable)(this.Table));

374            }

375            

376            public int UserID {

377                get {

378                    return ((int)(this[this.tableusers.UserIDColumn]));

379                }

380                set {

381                    this[this.tableusers.UserIDColumn] = value;

382                }

383            }

384            

385            public string Username {

386                get {

387                    try {

388                        return ((string)(this[this.tableusers.UsernameColumn]));

389                    }

390                    catch (InvalidCastException e) {

391                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);

392                    }

393                }

394                set {

395                    this[this.tableusers.UsernameColumn] = value;

396                }

397            }

398            

399            public string Password {

400                get {

401                    try {

402                        return ((string)(this[this.tableusers.PasswordColumn]));

403                    }

404                    catch (InvalidCastException e) {

405                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);

406                    }

407                }

408                set {

409                    this[this.tableusers.PasswordColumn] = value;

410                }

411            }

412            

413            public string Nickname {

414                get {

415                    try {

416                        return ((string)(this[this.tableusers.NicknameColumn]));

417                    }

418                    catch (InvalidCastException e) {

419                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);

420                    }

421                }

422                set {

423                    this[this.tableusers.NicknameColumn] = value;

424                }

425            }

426            

427            public string Email {

428                get {

429                    try {

430                        return ((string)(this[this.tableusers.EmailColumn]));

431                    }

432                    catch (InvalidCastException e) {

433                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);

434                    }

435                }

436                set {

437                    this[this.tableusers.EmailColumn] = value;

438                }

439            }

440            

441            public System.DateTime LastLoginTime {

442                get {

443                    return ((System.DateTime)(this[this.tableusers.LastLoginTimeColumn]));

444                }

445                set {

446                    this[this.tableusers.LastLoginTimeColumn] = value;

447                }

448            }

449            

450            public short GroupID {

451                get {

452                    return ((short)(this[this.tableusers.GroupIDColumn]));

453                }

454                set {

455                    this[this.tableusers.GroupIDColumn] = value;

456                }

457            }

458            

459            public int Point {

460                get {

461                    return ((int)(this[this.tableusers.PointColumn]));

462                }

463                set {

464                    this[this.tableusers.PointColumn] = value;

465                }

466            }

467            

468            public bool IsUsernameNull() {

469                return this.IsNull(this.tableusers.UsernameColumn);

470            }

471            

472            public void SetUsernameNull() {

473                this[this.tableusers.UsernameColumn] = System.Convert.DBNull;

474            }

475            

476            public bool IsPasswordNull() {

477                return this.IsNull(this.tableusers.PasswordColumn);

478            }

479            

480            public void SetPasswordNull() {

481                this[this.tableusers.PasswordColumn] = System.Convert.DBNull;

482            }

483            

484            public bool IsNicknameNull() {

485                return this.IsNull(this.tableusers.NicknameColumn);

486            }

487            

488            public void SetNicknameNull() {

489                this[this.tableusers.NicknameColumn] = System.Convert.DBNull;

490            }

491            

492            public bool IsEmailNull() {

493                return this.IsNull(this.tableusers.EmailColumn);

494            }

495            

496            public void SetEmailNull() {

497                this[this.tableusers.EmailColumn] = System.Convert.DBNull;

498            }

499        }

500        

501        [System.Diagnostics.DebuggerStepThrough()]

502        public class usersRowChangeEvent : EventArgs {

503            

504            private usersRow eventRow;

505            

506            private DataRowAction eventAction;

507            

508            public usersRowChangeEvent(usersRow row, DataRowAction action) {

509                this.eventRow = row;

510                this.eventAction = action;

511            }

512            

513            public usersRow Row {

514                get {

515                    return this.eventRow;

516                }

517            }

518            

519            public DataRowAction Action {

520                get {

521                    return this.eventAction;

522                }

523            }

524        }

525    }

526}

527

你可以用代理类提供的方法方便的对xml文件进行操作，代码如下：

 1            Dataset2 ds = new Dataset2() ;

 2            ds.ReadXml("test.xml") ;

 3             

 4            Dataset2.usersRow row = ds.users.NewusersRow() ;

 5            row.Username="test";

 6com%2Fimages%2Fblog%2F202108%2F08%2F3d26e8d9317e43600e47250e14db614c.gif%3Fx-oss-process%3Dimage%2Fwatermark%2Csize_16%2Ctext_QDUxQ1RP5Y2a5a6i%2Ccolor_FFFFFF%2Ct_100%2Cg_se%2Cx_10%2Cy_10%2Cshadow_90%2Ctype_ZmFuZ3poZW5naGVpdGk%3D%22%2C%22status%22%3A%22done%22%2C%22percent%22%3A0%2C%22size%22%3A%7B%22width%22%3A11%2C%22height%22%3A16%2C%22naturalWidth%22%3A11%2C%22naturalHeight%22%3A16%7D%2C%22id%22%3A%22Ld7sL%22%7D" data-card-type="inline" data-card-key="image" data-card-loading="true" data-card-editable="false">​ ​            row.Email ="[e-mail]";

 7            row.Password ="test";

 8            row.Nickname ="test";

 9            row.LastLoginTime =DateTime.Now ;

10            row.GroupID =1;

11            row.Point =100;

12            ds.users.AddusersRow(row)  ;

13

14            ds.WriteXml("test.xml") ;

这种方法非常方便，使用拖拽的方式生成xml schemal ，当然事先你也可以自己定义好schemal后 ，再生成代理类，偶是个懒人觉得这种方式比较适合我！如果你有什么好的想法都可以回复到下面！