static void Main(string[] args) { TestDBDataSet ds = new TestDBDataSet(); MemberInfoTableAdapter da = new MemberInfoTableAdapter(); // 새로운 레코드를 삽입: INSERT da.Insert("Julie", new DateTime(1985, 5, 6), "*****@*****.**", 1); // 테이블의 모든 레코드를 조회: SELECT da.Fill(ds.MemberInfo); foreach (TestDBDataSet.MemberInfoRow row in ds.MemberInfo) { Console.WriteLine(string.Format("{0}, {1}, {2}, {3}", row.Name, row.Birth, row.Email, row.Family)); } // 테이블의 특정 레코드의 값을 변경: UPDATE TestDBDataSet.MemberInfoRow[] rows = ds.MemberInfo.Select("Name = 'Julie'") as TestDBDataSet.MemberInfoRow[]; rows[0].Name = "July"; da.Update(rows[0]); // 테이블의 특정 레코드를 삭제: DELETE da.Delete(rows[0].Name, rows[0].Birth, rows[0].Email, rows[0].Family); }
public override global::System.Data.DataSet Clone() { TestDBDataSet cln = ((TestDBDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { TestDBDataSet ds = new TestDBDataSet(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }