using
System;
2 using System.Collections.Generic;
3 using System.Data;
4
5 namespace Andy.DataSetHelper
6 {
7 public class DataSetHelper
8 {
9
10
11 public DataSet ds;
12
13 private System.Collections.ArrayList m_FieldInfo;
14 private string m_FieldList;
15
16 public DataSetHelper(ref DataSet DataSet)
17 {
18 ds = DataSet;
19 }
20 public DataSetHelper()
21 {
22 ds = null;
23 }
24 /**//// <summary>
25 /// 该方法根据给定的字段列表(FieldList)和表名(TableName),创建表结构,并返回表对象
26 /// 给定的字段可来自创建了关系的两张表,如果是源表(子表)中的字段,直接写字段名即可。
27 /// 如果是关系表(父表)中的字段,
28 /// 字段前面须加上关系名称,格式如:relationname.fieldname
29 /// FieldList语法:[relationname.]fieldname[ alias][,[relationname.]fieldname[ alias]]
30 /// </summary>
31 /// <param name="TableName">生成新结构表的表名</param>
32 /// <param name="SourceTable">源表名(子表)</param>
33 /// <param name="FieldList">生成新结构表的目标字段</param>
34 /// <returns>具有目标结构的表对象</returns>
35 public DataTable CreateJoinTable(string TableName, DataTable SourceTable, string FieldList)
36 {
37 if (FieldList == null)
38 {
39 throw new ArgumentException("You must specify at least one field in the field list.");
40 }
41 else
42 {
43 DataTable dt = new DataTable(TableName);
44 ParseFieldList(FieldList, true);
45 foreach (FieldInfo Field in m_FieldInfo)
46 {
47
2 using System.Collections.Generic;
3 using System.Data;
4
5 namespace Andy.DataSetHelper
6 {
7 public class DataSetHelper
8 {
9
10
11 public DataSet ds;
12
13 private System.Collections.ArrayList m_FieldInfo;
14 private string m_FieldList;
15
16 public DataSetHelper(ref DataSet DataSet)
17 {
18 ds = DataSet;
19 }
20 public DataSetHelper()
21 {
22 ds = null;
23 }
24 /**//// <summary>
25 /// 该方法根据给定的字段列表(FieldList)和表名(TableName),创建表结构,并返回表对象
26 /// 给定的字段可来自创建了关系的两张表,如果是源表(子表)中的字段,直接写字段名即可。
27 /// 如果是关系表(父表)中的字段,
28 /// 字段前面须加上关系名称,格式如:relationname.fieldname
29 /// FieldList语法:[relationname.]fieldname[ alias][,[relationname.]fieldname[ alias]]
30 /// </summary>
31 /// <param name="TableName">生成新结构表的表名</param>
32 /// <param name="SourceTable">源表名(子表)</param>
33 /// <param name="FieldList">生成新结构表的目标字段</param>
34 /// <returns>具有目标结构的表对象</returns>
35 public DataTable CreateJoinTable(string TableName, DataTable SourceTable, string FieldList)
36 {
37 if (FieldList == null)
38 {
39 throw new ArgumentException("You must specify at least one field in the field list.");
40 }
41 else
42 {
43 DataTable dt = new DataTable(TableName);
44 ParseFieldList(FieldList, true);
45 foreach (FieldInfo Field in m_FieldInfo)
46 {
47