private void button1_Click(object sender, EventArgs e) { // SqlConnection connection = new SqlConnection(@"Server=Tambu-PC\SQLEXPRESS; initial catalog=BLOG; Integrated Security=True"); // connection.Open(); BlogDataSet dataSet = new BlogDataSet(); UserSetTableAdapter userAdapter = new UserSetTableAdapter(); userAdapter.Fill(dataSet.UserSet); userAdapter.Insert("Tom"); userAdapter.Update(dataSet); //SqlCommand command = // new SqlCommand(@"SELECT * FROM UserSet Where UserSet.UserName=@pname", connection); //SqlParameter param = new SqlParameter("@pname", "John"); //command.Parameters.Add(param); //SqlDataReader reader = command.ExecuteReader(); //while (reader.Read()) //{ // int id = reader.GetInt32(0); // string name = reader.GetString(1); //} //reader.Dispose(); // connection.Dispose(); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { BlogDataSet ds = new BlogDataSet(); 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; }