dsorders.xsd

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

                    </Parameters>
                  </DbCommand>
                </ShortUpdateCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Orders] SET [CustomerID] = @CustomerID, [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate, [RequiredDate] = @RequiredDate, [ShippedDate] = @ShippedDate, [ShipVia] = @ShipVia, [Freight] = @Freight, [ShipName] = @ShipName, [ShipAddress] = @ShipAddress, [ShipCity] = @ShipCity, [ShipRegion] = @ShipRegion, [ShipPostalCode] = @ShipPostalCode, [ShipCountry] = @ShipCountry 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="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">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShipCity" Precision="0" Scale="0" Size="0" SourceColumn="ShipCity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShipRegion" Precision="0" Scale="0" Size="0" SourceColumn="ShipRegion" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShipPostalCode" Precision="0" Scale="0" Size="0" SourceColumn="ShipPostalCode" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ShipCountry" Precision="0" Scale="0" Size="0" SourceColumn="ShipCountry" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <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>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrderID" DataSetColumn="OrderID" />
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />