datasetdetail.cs

asp.net數據庫程序范例

                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new 客戶DataTable();
            }
            
            internal void InitVars() {
                this.column公司名稱 = this.Columns["公司名稱"];
                this.column客戶地址 = this.Columns["客戶地址"];
                this.column客戶編號 = this.Columns["客戶編號"];
                this.column連絡人名字 = this.Columns["連絡人名字"];
                this.column電話號碼 = this.Columns["電話號碼"];
                this.column傳真號碼 = this.Columns["傳真號碼"];
                this.column郵遞區號 = this.Columns["郵遞區號"];
            }
            
            private void InitClass() {
                this.column公司名稱 = new DataColumn("公司名稱", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column公司名稱);
                this.column客戶地址 = new DataColumn("客戶地址", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客戶地址);
                this.column客戶編號 = new DataColumn("客戶編號", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客戶編號);
                this.column連絡人名字 = new DataColumn("連絡人名字", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column連絡人名字);
                this.column電話號碼 = new DataColumn("電話號碼", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column電話號碼);
                this.column傳真號碼 = new DataColumn("傳真號碼", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column傳真號碼);
                this.column郵遞區號 = new DataColumn("郵遞區號", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column郵遞區號);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.column客戶編號}, true));
                this.column客戶編號.AutoIncrement = true;
                this.column客戶編號.AllowDBNull = false;
                this.column客戶編號.Unique = true;
            }
            
            public 客戶Row New客戶Row() {
                return ((客戶Row)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new 客戶Row(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(客戶Row);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.客戶RowChanged != null)) {
                    this.客戶RowChanged(this, new 客戶RowChangeEvent(((客戶Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.客戶RowChanging != null)) {
                    this.客戶RowChanging(this, new 客戶RowChangeEvent(((客戶Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.客戶RowDeleted != null)) {
                    this.客戶RowDeleted(this, new 客戶RowChangeEvent(((客戶Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.客戶RowDeleting != null)) {
                    this.客戶RowDeleting(this, new 客戶RowChangeEvent(((客戶Row)(e.Row)), e.Action));
                }
            }
            
            public void Remove客戶Row(客戶Row row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 客戶Row : DataRow {
            
            private 客戶DataTable table客戶;
            
            internal 客戶Row(DataRowBuilder rb) : 
                    base(rb) {
                this.table客戶 = ((客戶DataTable)(this.Table));
            }
            
            public string 公司名稱 {
                get {
                    try {
                        return ((string)(this[this.table客戶.公司名稱Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.table客戶.公司名稱Column] = value;
                }
            }
            
            public string 客戶地址 {
                get {
                    try {
                        return ((string)(this[this.table客戶.客戶地址Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.table客戶.客戶地址Column] = value;
                }
            }
            
            public int 客戶編號 {
                get {
                    return ((int)(this[this.table客戶.客戶編號Column]));
                }
                set {
                    this[this.table客戶.客戶編號Column] = value;
                }
            }
            
            public string 連絡人名字 {
                get {
                    try {
                        return ((string)(this[this.table客戶.連絡人名字Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.table客戶.連絡人名字Column] = value;
                }
            }
            
            public string 電話號碼 {
                get {
                    try {
                        return ((string)(this[this.table客戶.電話號碼Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.table客戶.電話號碼Column] = value;
                }
            }
            
            public string 傳真號碼 {
                get {
                    try {
                        return ((string)(this[this.table客戶.傳真號碼Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.table客戶.傳真號碼Column] = value;
                }
            }
            
            public string 郵遞區號 {
                get {
                    try {
                        return ((string)(this[this.table客戶.郵遞區號Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.table客戶.郵遞區號Column] = value;
                }
            }
            
            public bool Is公司名稱Null() {
                return this.IsNull(this.table客戶.公司名稱Column);
            }
            
            public void Set公司名稱Null() {
                this[this.table客戶.公司名稱Column] = System.Convert.DBNull;
            }
            
            public bool Is客戶地址Null() {
                return this.IsNull(this.table客戶.客戶地址Column);
            }
            
            public void Set客戶地址Null() {
                this[this.table客戶.客戶地址Column] = System.Convert.DBNull;
            }
            
            public bool Is連絡人名字Null() {
                return this.IsNull(this.table客戶.連絡人名字Column);
            }
            
            public void Set連絡人名字Null() {
                this[this.table客戶.連絡人名字Column] = System.Convert.DBNull;
            }
            
            public bool Is電話號碼Null() {
                return this.IsNull(this.table客戶.電話號碼Column);
            }
            
            public void Set電話號碼Null() {
                this[this.table客戶.電話號碼Column] = System.Convert.DBNull;
            }
            
            public bool Is傳真號碼Null() {
                return this.IsNull(this.table客戶.傳真號碼Column);
            }
            
            public void Set傳真號碼Null() {
                this[this.table客戶.傳真號碼Column] = System.Convert.DBNull;
            }
            
            public bool Is郵遞區號Null() {
                return this.IsNull(this.table客戶.郵遞區號Column);
            }
            
            public void Set郵遞區號Null() {
                this[this.table客戶.郵遞區號Column] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 客戶RowChangeEvent : EventArgs {
            
            private 客戶Row eventRow;
            
            private DataRowAction eventAction;
            
            public 客戶RowChangeEvent(客戶Row row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public 客戶Row Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}