⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 dsorders.xsd

📁 wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载
💻 XSD
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
                      </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>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, 
                      ShipPostalCode, ShipCountry
FROM         dbo.Orders</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <ShortDeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Orders] WHERE (([OrderID] = @Original_OrderID))</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>
                    </Parameters>
                  </DbCommand>
                </ShortDeleteCommand>
                <ShortInsertCommand>
                  <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">
                      </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>
                    </Parameters>
                  </DbCommand>
                </ShortInsertCommand>
                <ShortUpdateCommand>
                  <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))</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>
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -