使用 IBM DB2 Visual Studio 2005 .Net 插件进行 XML 数据验证

                
      // Populate the dataGrid.
      // If "All" is selected, all data from the table will be displayed.
      // if a city's name is selected, only rows whose CARPOOLINFO contain
      // <City>cityName</City> will be displayed.        

      public void populate(String cityName)
        {
            if ( cityName.Equals("All"))
            {
                carpoolInfo.DataSource = ds.Tables[xsdname];
            }
            else
            {
                xq = "select * from CARPOOL where " +
                 "xmlexists('declare namespace 
                 def=\"http://tempuri.org/XMLSchema.xsd\";" +
                 
                 "$c/def:CARPOOLINFO/def:Address[def:City=" + "\"" + cityName +
                 "\"]' passing CARPOOL.CARPOOLINFO as \"c\")" +
                 "order by ID";
                DB2DataAdapter da1 = new DB2DataAdapter(xq, m_conn);
                DataSet ds1 = new DataSet();
                da1.Fill(ds1, xsdname);
                carpoolInfo.DataSource = ds1.Tables[xsdname];                
            }
        }