dsorders.xsd

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsOrders" targetNamespace="http://tempuri.org/dsOrders.xsd" xmlns:mstns="http://tempuri.org/dsOrders.xsd" xmlns="http://tempuri.org/dsOrders.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" GeneratorTypeConverterClassName="Converter" Modifier="AutoLayout, AnsiClass, NotPublic, Public" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Server=localhost;Integrated Security=True;Database=Northwind;Packet Size=16384" IsAppSettingsProperty="False" Modifier="Public" Name="cnNwind" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <DbTable BaseClass="System.ComponentModel.Component" DataAccessorName="OrdersTableAdapter" GeneratorDataComponentClassName="OrdersTableAdapter" GeneratorDataComponentInterfaceName="IOrdersTableAdapter" Modifier="AutoLayout, AnsiClass, NotPublic, Public" Name="Orders" UserDataComponentName="OrdersTableAdapter" WebServiceAttribute="False">
            <MainSource>
              <DbSource ConnectionRef="cnNwind" DbObjectName="Northwind.dbo.Orders" DbObjectType="Table" EnableWebMethods="False" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GeneratePagingMethods="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Orders] WHERE (([OrderID] = @Original_OrderID) AND ((@IsNull_CustomerID = 1 AND [CustomerID] IS NULL) OR ([CustomerID] = @Original_CustomerID)) AND ((@IsNull_EmployeeID = 1 AND [EmployeeID] IS NULL) OR ([EmployeeID] = @Original_EmployeeID)) AND ((@IsNull_OrderDate = 1 AND [OrderDate] IS NULL) OR ([OrderDate] = @Original_OrderDate)) AND ((@IsNull_RequiredDate = 1 AND [RequiredDate] IS NULL) OR ([RequiredDate] = @Original_RequiredDate)) AND ((@IsNull_ShippedDate = 1 AND [ShippedDate] IS NULL) OR ([ShippedDate] = @Original_ShippedDate)) AND ((@IsNull_ShipVia = 1 AND [ShipVia] IS NULL) OR ([ShipVia] = @Original_ShipVia)) AND ((@IsNull_Freight = 1 AND [Freight] IS NULL) OR ([Freight] = @Original_Freight)) AND ((@IsNull_ShipName = 1 AND [ShipName] IS NULL) OR ([ShipName] = @Original_ShipName)) AND ((@IsNull_ShipAddress = 1 AND [ShipAddress] IS NULL) OR ([ShipAddress] = @Original_ShipAddress)) AND ((@IsNull_ShipCity = 1 AND [ShipCity] IS NULL) OR ([ShipCity] = @Original_ShipCity)) AND ((@IsNull_ShipRegion = 1 AND [ShipRegion] IS NULL) OR ([ShipRegion] = @Original_ShipRegion)) AND ((@IsNull_ShipPostalCode = 1 AND [ShipPostalCode] IS NULL) OR ([ShipPostalCode] = @Original_ShipPostalCode)) AND ((@IsNull_ShipCountry = 1 AND [ShipCountry] IS NULL) OR ([ShipCountry] = @Original_ShipCountry)))</CommandText>
                    <Parameters>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderID" Precision="0" Scale="0" Size="0" SourceColumn="OrderID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerID" Precision="0" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EmployeeID" Precision="0" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EmployeeID" Precision="0" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OrderDate" Precision="0" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_OrderDate" Precision="0" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RequiredDate" Precision="0" Scale="0" Size="0" SourceColumn="RequiredDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RequiredDate" Precision="0" Scale="0" Size="0" SourceColumn="RequiredDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShippedDate" Precision="0" Scale="0" Size="0" SourceColumn="ShippedDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ShippedDate" Precision="0" Scale="0" Size="0" SourceColumn="ShippedDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipVia" Precision="0" Scale="0" Size="0" SourceColumn="ShipVia" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ShipVia" Precision="0" Scale="0" Size="0" SourceColumn="ShipVia" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Freight" Precision="0" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Freight" Precision="0" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipName" Precision="0" Scale="0" Size="0" SourceColumn="ShipName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShipName" Precision="0" Scale="0" Size="0" SourceColumn="ShipName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipAddress" Precision="0" Scale="0" Size="0" SourceColumn="ShipAddress" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShipAddress" Precision="0" Scale="0" Size="0" SourceColumn="ShipAddress" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipCity" Precision="0" Scale="0" Size="0" SourceColumn="ShipCity" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShipCity" Precision="0" Scale="0" Size="0" SourceColumn="ShipCity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipRegion" Precision="0" Scale="0" Size="0" SourceColumn="ShipRegion" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShipRegion" Precision="0" Scale="0" Size="0" SourceColumn="ShipRegion" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipPostalCode" Precision="0" Scale="0" Size="0" SourceColumn="ShipPostalCode" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShipPostalCode" Precision="0" Scale="0" Size="0" SourceColumn="ShipPostalCode" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ShipCountry" Precision="0" Scale="0" Size="0" SourceColumn="ShipCountry" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ShipCountry" Precision="0" Scale="0" Size="0" SourceColumn="ShipCountry" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Orders] ([CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipRegion], [ShipPostalCode], [ShipCountry]) VALUES (@CustomerID, @EmployeeID, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @Freight, @ShipName, @ShipAddress, @ShipCity, @ShipRegion, @ShipPostalCode, @ShipCountry)</CommandText>
                    <Parameters>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@CustomerID" Precision="0" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EmployeeID" Precision="0" Scale="0" Size="0" SourceColumn="EmployeeID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@OrderDate" Precision="0" Scale="0" Size="0" SourceColumn="OrderDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RequiredDate" Precision="0" Scale="0" Size="0" SourceColumn="RequiredDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ShippedDate" Precision="0" Scale="0" Size="0" SourceColumn="ShippedDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ShipVia" Precision="0" Scale="0" Size="0" SourceColumn="ShipVia" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Freight" Precision="0" Scale="0" Size="0" SourceColumn="Freight" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShipName" Precision="0" Scale="0" Size="0" SourceColumn="ShipName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShipAddress" Precision="0" Scale="0" Size="0" SourceColumn="ShipAddress" SourceColumnNullMapping="False" SourceVersion="Current">