强类型化的DataSet,从繁琐的数据处理中解脱出来

最新推荐文章于 2022-09-20 17:36:19 发布
最新推荐文章于 2022-09-20 17:36:19 发布
阅读量3.2k 收藏
点赞数
分类专栏： c# 文章标签： dataset table string null object stream
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/BingGroup/article/details/645866
版权

看了一下强类型化的DataSet．ｘｓｄ，发现这个东东还真不错，可以让程序员从复杂的繁琐的数据增，删，改中解脱出来。

看看怎么用吧：

新建立一个ｗｅｂ工程，建立一个数据库，就ａｃｃｅｓｓ的吧，添加一个表，简单一些，几个字段就行。

在工程中添加一个．ｘｓｄ文件，会提示你把它放到ａｐｐ＿ｃｏｄｅ目录下面

配置一下，利用向导，加上插入，删除等操作，完成。

在工程中添加一个页面，加一个ｇｒｉｄｖｉｅｗ控件和ｏｂｊｅｃｔ　ｄａｔａｓｏｕｒｃｅ，ｄａｔａｓｏｕｒｃｅ控件配置，选择刚建立的ｘｓｄ即可。

ｇｒｉｄｖｉｅｗ　的ｄａｔａｓｏｕｒｃｅ　中选择ｏｂｊｅｃｔ　ｄａｔａｓｏｕｒｃｅ，运行。

 

系统为项目生成了这样一个文件：

#pragma checksum "F:/hooh/web/XSDTest/App_Code/hoohtest.xsd" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "8A6E9043F71E5618147B6F8B90ACCBEA"
//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:2.0.50727.42
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

using System;

 

[System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
[Serializable()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.ToolboxItem(true)]
[System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
[System.Xml.Serialization.XmlRootAttribute("hoohtest")]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
public partial class hoohtest : System.Data.DataSet {
   
    private Table1DataTable tableTable1;
   
    private System.Data.SchemaSerializationMode _schemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    public hoohtest() {
        this.BeginInit();
        this.InitClass();
        System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
        base.Tables.CollectionChanged += schemaChangedHandler;
        base.Relations.CollectionChanged += schemaChangedHandler;
        this.EndInit();
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    protected hoohtest(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) :
            base(info, context, false) {
        if ((this.IsBinarySerialized(info, context) == true)) {
            this.InitVars(false);
            System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
            this.Tables.CollectionChanged += schemaChangedHandler1;
            this.Relations.CollectionChanged += schemaChangedHandler1;
            return;
        }
        string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
        if ((this.DetermineSchemaSerializationMode(info, context) == System.Data.SchemaSerializationMode.IncludeSchema)) {
            System.Data.DataSet ds = new System.Data.DataSet();
            ds.ReadXmlSchema(new System.Xml.XmlTextReader(new System.IO.StringReader(strSchema)));
            if ((ds.Tables["Table1"] != null)) {
                base.Tables.Add(new Table1DataTable(ds.Tables["Table1"]));
            }
            this.DataSetName = ds.DataSetName;
            this.Prefix = ds.Prefix;
            this.Namespace = ds.Namespace;
            this.Locale = ds.Locale;
            this.CaseSensitive = ds.CaseSensitive;
            this.EnforceConstraints = ds.EnforceConstraints;
            this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
            this.InitVars();
        }
        else {
            this.ReadXmlSchema(new System.Xml.XmlTextReader(new System.IO.StringReader(strSchema)));
        }
        this.GetSerializationData(info, context);
        System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
        base.Tables.CollectionChanged += schemaChangedHandler;
        this.Relations.CollectionChanged += schemaChangedHandler;
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    [System.ComponentModel.Browsable(false)]
    [System.ComponentModel.DesignerSerializationVisibility(System.ComponentModel.DesignerSerializationVisibility.Content)]
    public Table1DataTable Table1 {
        get {
            return this.tableTable1;
        }
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    [System.ComponentModel.BrowsableAttribute(true)]
    [System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Visible)]
    public override System.Data.SchemaSerializationMode SchemaSerializationMode {
        get {
            return this._schemaSerializationMode;
        }
        set {
            this._schemaSerializationMode = value;
        }
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    [System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
    public new System.Data.DataTableCollection Tables {
        get {
            return base.Tables;
        }
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    [System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Hidden)]
    public new System.Data.DataRelationCollection Relations {
        get {
            return base.Relations;
        }
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    protected override void InitializeDerivedDataSet() {
        this.BeginInit();
        this.InitClass();
        this.EndInit();
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    public override System.Data.DataSet Clone() {
        hoohtest cln = ((hoohtest)(base.Clone()));
        cln.InitVars();
        cln.SchemaSerializationMode = this.SchemaSerializationMode;
        return cln;
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    protected override bool ShouldSerializeTables() {
        return false;
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    protected override bool ShouldSerializeRelations() {
        return false;
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    protected override void ReadXmlSerializable(System.Xml.XmlReader reader) {
        if ((this.DetermineSchemaSerializationMode(reader) == System.Data.SchemaSerializationMode.IncludeSchema)) {
            this.Reset();
            System.Data.DataSet ds = new System.Data.DataSet();
            ds.ReadXml(reader);
            if ((ds.Tables["Table1"] != null)) {
                base.Tables.Add(new Table1DataTable(ds.Tables["Table1"]));
            }
            this.DataSetName = ds.DataSetName;
            this.Prefix = ds.Prefix;
            this.Namespace = ds.Namespace;
            this.Locale = ds.Locale;
            this.CaseSensitive = ds.CaseSensitive;
            this.EnforceConstraints = ds.EnforceConstraints;
            this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
            this.InitVars();
        }
        else {
            this.ReadXml(reader);
            this.InitVars();
        }
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() {
        System.IO.MemoryStream stream = new System.IO.MemoryStream();
        this.WriteXmlSchema(new System.Xml.XmlTextWriter(stream, null));
        stream.Position = 0;
        return System.Xml.Schema.XmlSchema.Read(new System.Xml.XmlTextReader(stream), null);
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    internal void InitVars() {
        this.InitVars(true);
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    internal void InitVars(bool initTable) {
        this.tableTable1 = ((Table1DataTable)(base.Tables["Table1"]));
        if ((initTable == true)) {
            if ((this.tableTable1 != null)) {
                this.tableTable1.InitVars();
            }
        }
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    private void InitClass() {
        this.DataSetName = "hoohtest";
        this.Prefix = "";
        this.Namespace = "http://tempuri.org/hoohtest.xsd";
        this.EnforceConstraints = true;
        this.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
        this.tableTable1 = new Table1DataTable();
        base.Tables.Add(this.tableTable1);
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    private bool ShouldSerializeTable1() {
        return false;
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) {
        if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) {
            this.InitVars();
        }
    }
   
    [System.Diagnostics.DebuggerNonUserCodeAttribute()]
    public static System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(System.Xml.Schema.XmlSchemaSet xs) {
        hoohtest ds = new hoohtest();
        System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
        System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
        xs.Add(ds.GetSchemaSerializable());
        System.Xml.Schema.XmlSchemaAny any = new System.Xml.Schema.XmlSchemaAny();
        any.Namespace = ds.Namespace;
        sequence.Items.Add(any);
        type.Particle = sequence;
        return type;
    }
   
    public delegate void Table1RowChangeEventHandler(object sender, Table1RowChangeEvent e);
   
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
    [System.Serializable()]
    [System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
    public partial class Table1DataTable : System.Data.DataTable, System.Collections.IEnumerable {
       
        private System.Data.DataColumn columnAutoId;
       
        private System.Data.DataColumn columnName;
       
        private System.Data.DataColumn columnAddress;
       
        private System.Data.DataColumn columnTel;
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1DataTable() {
            this.TableName = "Table1";
            this.BeginInit();
            this.InitClass();
            this.EndInit();
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        internal Table1DataTable(System.Data.DataTable table) {
            this.TableName = table.TableName;
            if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
                this.CaseSensitive = table.CaseSensitive;
            }
            if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
                this.Locale = table.Locale;
            }
            if ((table.Namespace != table.DataSet.Namespace)) {
                this.Namespace = table.Namespace;
            }
            this.Prefix = table.Prefix;
            this.MinimumCapacity = table.MinimumCapacity;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected Table1DataTable(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) :
                base(info, context) {
            this.InitVars();
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public System.Data.DataColumn AutoIdColumn {
            get {
                return this.columnAutoId;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public System.Data.DataColumn NameColumn {
            get {
                return this.columnName;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public System.Data.DataColumn AddressColumn {
            get {
                return this.columnAddress;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public System.Data.DataColumn TelColumn {
            get {
                return this.columnTel;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Browsable(false)]
        public int Count {
            get {
                return this.Rows.Count;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1Row this[int index] {
            get {
                return ((Table1Row)(this.Rows[index]));
            }
        }
       
        public event Table1RowChangeEventHandler Table1RowChanging;
       
        public event Table1RowChangeEventHandler Table1RowChanged;
       
        public event Table1RowChangeEventHandler Table1RowDeleting;
       
        public event Table1RowChangeEventHandler Table1RowDeleted;
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public void AddTable1Row(Table1Row row) {
            this.Rows.Add(row);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1Row AddTable1Row(string Name, string Address, string Tel) {
            Table1Row rowTable1Row = ((Table1Row)(this.NewRow()));
            rowTable1Row.ItemArray = new object[] {
                    null,
                    Name,
                    Address,
                    Tel};
            this.Rows.Add(rowTable1Row);
            return rowTable1Row;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1Row FindByAutoId(int AutoId) {
            return ((Table1Row)(this.Rows.Find(new object[] {
                        AutoId})));
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public virtual System.Collections.IEnumerator GetEnumerator() {
            return this.Rows.GetEnumerator();
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public override System.Data.DataTable Clone() {
            Table1DataTable cln = ((Table1DataTable)(base.Clone()));
            cln.InitVars();
            return cln;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected override System.Data.DataTable CreateInstance() {
            return new Table1DataTable();
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        internal void InitVars() {
            this.columnAutoId = base.Columns["AutoId"];
            this.columnName = base.Columns["Name"];
            this.columnAddress = base.Columns["Address"];
            this.columnTel = base.Columns["Tel"];
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        private void InitClass() {
            this.columnAutoId = new System.Data.DataColumn("AutoId", typeof(int), null, System.Data.MappingType.Element);
            base.Columns.Add(this.columnAutoId);
            this.columnName = new System.Data.DataColumn("Name", typeof(string), null, System.Data.MappingType.Element);
            base.Columns.Add(this.columnName);
            this.columnAddress = new System.Data.DataColumn("Address", typeof(string), null, System.Data.MappingType.Element);
            base.Columns.Add(this.columnAddress);
            this.columnTel = new System.Data.DataColumn("Tel", typeof(string), null, System.Data.MappingType.Element);
            base.Columns.Add(this.columnTel);
            this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
                            this.columnAutoId}, true));
            this.columnAutoId.AutoIncrement = true;
            this.columnAutoId.AllowDBNull = false;
            this.columnAutoId.Unique = true;
            this.columnName.MaxLength = 50;
            this.columnAddress.MaxLength = 50;
            this.columnTel.MaxLength = 50;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1Row NewTable1Row() {
            return ((Table1Row)(this.NewRow()));
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
            return new Table1Row(builder);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected override System.Type GetRowType() {
            return typeof(Table1Row);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
            base.OnRowChanged(e);
            if ((this.Table1RowChanged != null)) {
                this.Table1RowChanged(this, new Table1RowChangeEvent(((Table1Row)(e.Row)), e.Action));
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
            base.OnRowChanging(e);
            if ((this.Table1RowChanging != null)) {
                this.Table1RowChanging(this, new Table1RowChangeEvent(((Table1Row)(e.Row)), e.Action));
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
            base.OnRowDeleted(e);
            if ((this.Table1RowDeleted != null)) {
                this.Table1RowDeleted(this, new Table1RowChangeEvent(((Table1Row)(e.Row)), e.Action));
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
            base.OnRowDeleting(e);
            if ((this.Table1RowDeleting != null)) {
                this.Table1RowDeleting(this, new Table1RowChangeEvent(((Table1Row)(e.Row)), e.Action));
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public void RemoveTable1Row(Table1Row row) {
            this.Rows.Remove(row);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
            System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
            System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
            hoohtest ds = new hoohtest();
            xs.Add(ds.GetSchemaSerializable());
            System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
            any1.Namespace = "http://www.w3.org/2001/XMLSchema";
            any1.MinOccurs = new decimal(0);
            any1.MaxOccurs = decimal.MaxValue;
            any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
            sequence.Items.Add(any1);
            System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
            any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
            any2.MinOccurs = new decimal(1);
            any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
            sequence.Items.Add(any2);
            System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
            attribute1.Name = "namespace";
            attribute1.FixedValue = ds.Namespace;
            type.Attributes.Add(attribute1);
            System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
            attribute2.Name = "tableTypeName";
            attribute2.FixedValue = "Table1DataTable";
            type.Attributes.Add(attribute2);
            type.Particle = sequence;
            return type;
        }
    }
   
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
    public partial class Table1Row : System.Data.DataRow {
       
        private Table1DataTable tableTable1;
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        internal Table1Row(System.Data.DataRowBuilder rb) :
                base(rb) {
            this.tableTable1 = ((Table1DataTable)(this.Table));
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public int AutoId {
            get {
                return ((int)(this[this.tableTable1.AutoIdColumn]));
            }
            set {
                this[this.tableTable1.AutoIdColumn] = value;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public string Name {
            get {
                try {
                    return ((string)(this[this.tableTable1.NameColumn]));
                }
                catch (System.InvalidCastException e) {
                    throw new System.Data.StrongTypingException("The value for column /'Name/' in table /'Table1/' is DBNull.", e);
                }
            }
            set {
                this[this.tableTable1.NameColumn] = value;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public string Address {
            get {
                try {
                    return ((string)(this[this.tableTable1.AddressColumn]));
                }
                catch (System.InvalidCastException e) {
                    throw new System.Data.StrongTypingException("The value for column /'Address/' in table /'Table1/' is DBNull.", e);
                }
            }
            set {
                this[this.tableTable1.AddressColumn] = value;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public string Tel {
            get {
                try {
                    return ((string)(this[this.tableTable1.TelColumn]));
                }
                catch (System.InvalidCastException e) {
                    throw new System.Data.StrongTypingException("The value for column /'Tel/' in table /'Table1/' is DBNull.", e);
                }
            }
            set {
                this[this.tableTable1.TelColumn] = value;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public bool IsNameNull() {
            return this.IsNull(this.tableTable1.NameColumn);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public void SetNameNull() {
            this[this.tableTable1.NameColumn] = System.Convert.DBNull;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public bool IsAddressNull() {
            return this.IsNull(this.tableTable1.AddressColumn);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public void SetAddressNull() {
            this[this.tableTable1.AddressColumn] = System.Convert.DBNull;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public bool IsTelNull() {
            return this.IsNull(this.tableTable1.TelColumn);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public void SetTelNull() {
            this[this.tableTable1.TelColumn] = System.Convert.DBNull;
        }
    }
   
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
    public class Table1RowChangeEvent : System.EventArgs {
       
        private Table1Row eventRow;
       
        private System.Data.DataRowAction eventAction;
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1RowChangeEvent(Table1Row row, System.Data.DataRowAction action) {
            this.eventRow = row;
            this.eventAction = action;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1Row Row {
            get {
                return this.eventRow;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public System.Data.DataRowAction Action {
            get {
                return this.eventAction;
            }
        }
    }
}
namespace hoohtestTableAdapters {
   
   
    [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
    [System.ComponentModel.DesignerCategoryAttribute("code")]
    [System.ComponentModel.ToolboxItem(true)]
    [System.ComponentModel.DataObjectAttribute(true)]
    [System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
        ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
    [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    public partial class Table1TableAdapter : System.ComponentModel.Component {
       
        private System.Data.OleDb.OleDbDataAdapter _adapter;
       
        private System.Data.OleDb.OleDbConnection _connection;
       
        private System.Data.OleDb.OleDbCommand[] _commandCollection;
       
        private bool _clearBeforeFill;
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public Table1TableAdapter() {
            this.ClearBeforeFill = true;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        private System.Data.OleDb.OleDbDataAdapter Adapter {
            get {
                if ((this._adapter == null)) {
                    this.InitAdapter();
                }
                return this._adapter;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        internal System.Data.OleDb.OleDbConnection Connection {
            get {
                if ((this._connection == null)) {
                    this.InitConnection();
                }
                return this._connection;
            }
            set {
                this._connection = value;
                if ((this.Adapter.InsertCommand != null)) {
                    this.Adapter.InsertCommand.Connection = value;
                }
                if ((this.Adapter.DeleteCommand != null)) {
                    this.Adapter.DeleteCommand.Connection = value;
                }
                if ((this.Adapter.UpdateCommand != null)) {
                    this.Adapter.UpdateCommand.Connection = value;
                }
                for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
                    if ((this.CommandCollection[i] != null)) {
                        ((System.Data.OleDb.OleDbCommand)(this.CommandCollection[i])).Connection = value;
                    }
                }
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        protected System.Data.OleDb.OleDbCommand[] CommandCollection {
            get {
                if ((this._commandCollection == null)) {
                    this.InitCommandCollection();
                }
                return this._commandCollection;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        public bool ClearBeforeFill {
            get {
                return this._clearBeforeFill;
            }
            set {
                this._clearBeforeFill = value;
            }
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        private void InitAdapter() {
            this._adapter = new System.Data.OleDb.OleDbDataAdapter();
            System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
            tableMapping.SourceTable = "Table";
            tableMapping.DataSetTable = "Table1";
            tableMapping.ColumnMappings.Add("AutoId", "AutoId");
            tableMapping.ColumnMappings.Add("Name", "Name");
            tableMapping.ColumnMappings.Add("Address", "Address");
            tableMapping.ColumnMappings.Add("Tel", "Tel");
            this._adapter.TableMappings.Add(tableMapping);
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        private void InitConnection() {
            this._connection = new System.Data.OleDb.OleDbConnection();
            this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["db1ConnectionString"].ConnectionString;
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        private void InitCommandCollection() {
            this._commandCollection = new System.Data.OleDb.OleDbCommand[1];
            this._commandCollection[0] = new System.Data.OleDb.OleDbCommand();
            this._commandCollection[0].Connection = this.Connection;
            this._commandCollection[0].CommandText = "SELECT          AutoId, Name, Address, Tel/r/nFROM            Table1/r/nWHERE        " +
                "   (AutoId = ?)";
            this._commandCollection[0].CommandType = System.Data.CommandType.Text;
            this._commandCollection[0].Parameters.Add(new System.Data.OleDb.OleDbParameter("AutoId", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AutoId", System.Data.DataRowVersion.Current, false, null));
        }
       
        [System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public virtual hoohtest.Table1DataTable GetData22222(int AutoId) {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            this.Adapter.SelectCommand.Parameters[0].Value = ((int)(AutoId));
            hoohtest.Table1DataTable dataTable = new hoohtest.Table1DataTable();
            this.Adapter.Fill(dataTable);
            return dataTable;
        }
    }
}

BingGroup
关注
专栏目录
MATLAB算法实战应用案例精讲-【图像处理】缺陷检测（补充篇）（附matlab实现代码）
qq_36130719的博客
12-15 5213
差异模型（Variation Model）使用标准图像与待检测图像灰度值相比较，来判断产品是否OK，适用于印刷品检测及产品表面检测。
经历工业自动化行业的磨炼让我了解到的工业缺陷检测，今天就细说工业缺陷检测_混色缺陷用分割模型好检出么
最新发布
2401_84239830的博客
04-29 799
比如同样是划痕，表现形式各种各样，有的发白，有的发黑，有的吃视角，有的发生在边缘地带等等，出现在不同位置，表现形式都不一样。也就是你的训练集和测试集存在的明显影响性能的偏差，这里的偏差不是标注导致的，而是数据本身导致的。不过也有说法是，脏数据作为噪声，也能给网络带来好的收益，让网络搜索参数的时候增加扰动，避免陷入局部最优，却能防止网络过拟合。当然，大部分场景还是很容易做的，因为在工业领域，至少是受限的和可控的场景。能否给出对应的量化指标，也是很大的问题，比如明显的缺陷判分很低，微弱的缺陷置信度又很高。
强类型DataSet 数据集的应用
C# 移动手机应用
12-13 806
T_person2TableAdapter adapter = new T_person2TableAdapter(); DataSet数据集.DataSetT_Person2.T_person2DataTable dt = adapter.GetData();//利用数据集读取表数据 //for (int i
codeDOM动态创建类及反射使用的小例子
03-23
根据网上例子，自己做了一个例子，内容包括： 1.使用winform按钮事件，反射dll中函数调用； 2.codeDOM创建动态类整个过程 3.类中包括函数和属性； 4.反射dll,并获取方法。
C#弱类型Dataset和强类型Dataset
Hello World
06-19 1322
原文地址：http://zzagain.blog.163.com/blog/static/16930562820122179922819/ 一、弱类型Dataset       1、自动生成InsertCommand,DeleteCommand....                         new SqlCommandBuilder(SqlDataAdapter
c# xml自动生成工具使用
xiao1227372602的专栏
07-16 586
xsd.exe语‍法示例 xsd.exe语法示例 一般情况下，xsd.exe位于C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin 1、将xsd文件自成.CS类库。 xsd.exe /d /l:C# a.xsd /n:Namespace1.Namespace2 /d 指令指示该工具生成 ...
分子模拟可视化_fanviz数据可视化狂热分子
weixin_26707803的博客
09-04 474
分子模拟可视化 Fanatics BI和数据工程总监Amit Jain (Amit Jain, Director BI, and Data Engineering at Fanatics) Fanatics generates a tremendous amount of data, and the best way for us to leverage this is to ensure it ...
java dataset flatmap_DataSet数据集在使用sql()时，无法使用map，flatMap等转换算子的解决办法...
weixin_42467573的博客
02-28 257
摘要我们在使用spark的一个流程是：利用spark.sql()函数把数据读入到内存形成DataSet[Row](DataFrame)由于Row是新的spark数据集中无法实现自动的编码，需要对这个数据集进行编码，才能利用这些算子进行相关的操作，如何编码是一个问题，在这里就把这几个问题进行总结一下。报的错误：error: Unable to find encoder for type stored...
第8章 数据组件和DataSet
从今天起
11-10 3116
第8章 数据组件和DataSet  在前面的章节里，你对ADO.NET有了初步了解，并且研究了基于连接的数据访问。现在，将你的数据访问代码放入设计良好的应用中就摆上了桌面。在组织合理的应用中，数据访问代码绝不会直接嵌入到网页的后置代码中。相反，它会被分离到专门的数据组件里。本章中，你将看到如何自己创建一个简单的数据访问类，并为每个要执行的数据任务添加一个单独的方法。最为重要的是，这
DataSet数据集在使用sql()时，无法使用map，flatMap等转换算子的解决办法
weixin_34051201的博客
03-13 473
2019独角兽企业重金招聘Python工程师标准>>> ...
利用Python进行数据分析----第七章数据清晰与准备
qq_35594345的博客
09-20 585
根据《利用Python进行数据分析》书籍进行书写
CVPR 2021 TrafficQA
smile909的博客
04-28 858
TraffificQA: A Question Answering Benchmark and an Effificient Network forVideo Reasoning over Traffific Events 动机 视频中的交通事件认知与推理是一项非常重要的任务，在智能交通、辅助驾驶、自动驾驶等领域有着广泛的应用。 设计良好的数据集对于开发、适应和评价不同的数据驱动的方法往往是至关重要的。 有了数据集后，需要通过任务探索交通事件推理过程中复杂的因果结构。不同任务分别对应于不同的交通场景，以评
"学习视频和图像中完整3D可变形人脸模型的方法
3361从图像和视频中学习完整的3D可变形人脸模型马利卡君B R Ayush Tewari Hans-Peter Seidel Mohamed Elgharib Christian Theobalt马克斯普朗克信息学研究所萨尔信息学校区图1.我们提出了一种从视频和图像中学习完整...
【Go语言性能分析终极指南】：pprof在Web应用中的高级应用
[【Go语言性能分析终极指南】：pprof在Web应用中的高级应用](https://opengraph.githubassets.com/ef6b6b61e22a158ad4ded060f054a15f60b203527844a273c2003c709bd887d5/dogukanzorlu/pprof) # 1. Go语言性能分析基础...
强类型数据集DataSet入门1
dayudodo的专栏
03-30 1829
新建了一个会员数据的表 将这个表拖放到新建立的数据集文件中,就自动生成了下面的一个类 点击查看 会员数据TableAdapter的属性,会发现它为我们自动生成了连接字符串,这样不需要自己在麻烦的手写了,以往ado.net入门的时候对这个连接字符串很是头大 这样当你在程序中使用这个类的实例时,就能发现这个类的好处了 using System; using System.Collections.Generic; using System.Linq; using System.Text;
导出.csv文件与unicode(utf-16)
05-24 3229
以前把表格到处为.csv文件，没有注意文件编码格式，今天发现自己到处的.csv文件不能用excel打开。于是发现.csv文件编码格式没有写入，windows 文本文件的开头有两字节表示文件的编码。///参考：http://www.websina.com/bugzero/kb/unicode-bom.htmlbyte[] btyeUTF16 = {0xFF, 0xFE};    ///u
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值