开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 查看源码
BookStoreDataSet.xsd
资源名称：BookStore.rar　[点击查看]
上传用户：xyl529207
上传日期：2022-08-03
资源大小：935k
文件大小：92k
源码类别：

行业应用

开发平台：

SQL

BookStoreDataSet.xsd：源码内容
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="BookStoreDataSet" targetNamespace="http://tempuri.org/BookStoreDataSet.xsd" xmlns:mstns="http://tempuri.org/BookStoreDataSet.xsd" xmlns="http://tempuri.org/BookStoreDataSet.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">
  3.   <xs:annotation>
  4.     <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5.       <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6.         <Connections>
  7.           <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="BookStoreConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="BookStoreConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.BookStoreMan.Properties.Settings.GlobalReference.Default.BookStoreConnectionString" Provider="System.Data.SqlClient">
  8.           </Connection>
  9.         </Connections>
  10.         <Tables>
  11.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BookTableAdapter" GeneratorDataComponentClassName="BookTableAdapter" Name="Book" UserDataComponentName="BookTableAdapter">
  12.             <MainSource>
  13.               <DbSource ConnectionRef="BookStoreConnectionString (Settings)" DbObjectName="BookStore.dbo.Book" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
  14.                 <DeleteCommand>
  15.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  16.                     <CommandText>DELETE FROM [dbo].[Book] WHERE (([ID] = @Original_ID) AND ([ISBN] = @Original_ISBN) AND ([Name] = @Original_Name) AND ((@IsNull_Author = 1 AND [Author] IS NULL) OR ([Author] = @Original_Author)) AND ((@IsNull_Press = 1 AND [Press] IS NULL) OR ([Press] = @Original_Press)) AND ((@IsNull_PublishDate = 1 AND [PublishDate] IS NULL) OR ([PublishDate] = @Original_PublishDate)) AND ([Price] = @Original_Price) AND ((@IsNull_Pages = 1 AND [Pages] IS NULL) OR ([Pages] = @Original_Pages)) AND ([Barcode] = @Original_Barcode) AND ((@IsNull_CD = 1 AND [CD] IS NULL) OR ([CD] = @Original_CD)) AND ([Storage] = @Original_Storage))</CommandText>
  17.                     <Parameters>
  18.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  19.                       </Parameter>
  20.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ISBN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ISBN" SourceColumnNullMapping="False" SourceVersion="Original">
  21.                       </Parameter>
  22.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
  23.                       </Parameter>
  24.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Author" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Author" SourceColumnNullMapping="True" SourceVersion="Original">
  25.                       </Parameter>
  26.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Author" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Author" SourceColumnNullMapping="False" SourceVersion="Original">
  27.                       </Parameter>
  28.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Press" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Press" SourceColumnNullMapping="True" SourceVersion="Original">
  29.                       </Parameter>
  30.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Press" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Press" SourceColumnNullMapping="False" SourceVersion="Original">
  31.                       </Parameter>
  32.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PublishDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PublishDate" SourceColumnNullMapping="True" SourceVersion="Original">
  33.                       </Parameter>
  34.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PublishDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PublishDate" SourceColumnNullMapping="False" SourceVersion="Original">
  35.                       </Parameter>
  36.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Original">
  37.                       </Parameter>
  38.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pages" SourceColumnNullMapping="True" SourceVersion="Original">
  39.                       </Parameter>
  40.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Pages" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Pages" SourceColumnNullMapping="False" SourceVersion="Original">
  41.                       </Parameter>
  42.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Barcode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="False" SourceVersion="Original">
  43.                       </Parameter>
  44.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CD" SourceColumnNullMapping="True" SourceVersion="Original">
  45.                       </Parameter>
  46.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CD" SourceColumnNullMapping="False" SourceVersion="Original">
  47.                       </Parameter>
  48.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Storage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Storage" SourceColumnNullMapping="False" SourceVersion="Original">
  49.                       </Parameter>
  50.                     </Parameters>
  51.                   </DbCommand>
  52.                 </DeleteCommand>
  53.                 <InsertCommand>
  54.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  55.                     <CommandText>INSERT INTO [dbo].[Book] ([ISBN], [Name], [Author], [Press], [PublishDate], [Price], [Pages], [Barcode], [CD], [Storage]) VALUES (@ISBN, @Name, @Author, @Press, @PublishDate, @Price, @Pages, @Barcode, @CD, @Storage);
  56. SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Storage FROM Book WHERE (ID = SCOPE_IDENTITY())</CommandText>
  57.                     <Parameters>
  58.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ISBN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ISBN" SourceColumnNullMapping="False" SourceVersion="Current">
  59.                       </Parameter>
  60.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
  61.                       </Parameter>
  62.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Author" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Author" SourceColumnNullMapping="False" SourceVersion="Current">
  63.                       </Parameter>
  64.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Press" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Press" SourceColumnNullMapping="False" SourceVersion="Current">
  65.                       </Parameter>
  66.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PublishDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PublishDate" SourceColumnNullMapping="False" SourceVersion="Current">
  67.                       </Parameter>
  68.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
  69.                       </Parameter>
  70.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Pages" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Pages" SourceColumnNullMapping="False" SourceVersion="Current">
  71.                       </Parameter>
  72.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Barcode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="False" SourceVersion="Current">
  73.                       </Parameter>
  74.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CD" SourceColumnNullMapping="False" SourceVersion="Current">
  75.                       </Parameter>
  76.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Storage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Storage" SourceColumnNullMapping="False" SourceVersion="Current">
  77.                       </Parameter>
  78.                     </Parameters>
  79.                   </DbCommand>
  80.                 </InsertCommand>
  81.                 <SelectCommand>
  82.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  83.                     <CommandText>SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Storage FROM dbo.Book</CommandText>
  84.                     <Parameters>
  85.                     </Parameters>
  86.                   </DbCommand>
  87.                 </SelectCommand>
  88.                 <UpdateCommand>
  89.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  90.                     <CommandText>UPDATE [dbo].[Book] SET [ISBN] = @ISBN, [Name] = @Name, [Author] = @Author, [Press] = @Press, [PublishDate] = @PublishDate, [Price] = @Price, [Pages] = @Pages, [Barcode] = @Barcode, [CD] = @CD, [Storage] = @Storage WHERE (([ID] = @Original_ID) AND ([ISBN] = @Original_ISBN) AND ([Name] = @Original_Name) AND ((@IsNull_Author = 1 AND [Author] IS NULL) OR ([Author] = @Original_Author)) AND ((@IsNull_Press = 1 AND [Press] IS NULL) OR ([Press] = @Original_Press)) AND ((@IsNull_PublishDate = 1 AND [PublishDate] IS NULL) OR ([PublishDate] = @Original_PublishDate)) AND ([Price] = @Original_Price) AND ((@IsNull_Pages = 1 AND [Pages] IS NULL) OR ([Pages] = @Original_Pages)) AND ([Barcode] = @Original_Barcode) AND ((@IsNull_CD = 1 AND [CD] IS NULL) OR ([CD] = @Original_CD)) AND ([Storage] = @Original_Storage));
  91. SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Storage FROM Book WHERE (ID = @ID)</CommandText>
  92.                     <Parameters>
  93.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ISBN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ISBN" SourceColumnNullMapping="False" SourceVersion="Current">
  94.                       </Parameter>
  95.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
  96.                       </Parameter>
  97.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Author" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Author" SourceColumnNullMapping="False" SourceVersion="Current">
  98.                       </Parameter>
  99.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Press" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Press" SourceColumnNullMapping="False" SourceVersion="Current">
  100.                       </Parameter>
  101.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PublishDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PublishDate" SourceColumnNullMapping="False" SourceVersion="Current">
  102.                       </Parameter>
  103.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Current">
  104.                       </Parameter>
  105.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Pages" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Pages" SourceColumnNullMapping="False" SourceVersion="Current">
  106.                       </Parameter>
  107.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Barcode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="False" SourceVersion="Current">
  108.                       </Parameter>
  109.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@CD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CD" SourceColumnNullMapping="False" SourceVersion="Current">
  110.                       </Parameter>
  111.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Storage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Storage" SourceColumnNullMapping="False" SourceVersion="Current">
  112.                       </Parameter>
  113.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  114.                       </Parameter>
  115.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ISBN" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ISBN" SourceColumnNullMapping="False" SourceVersion="Original">
  116.                       </Parameter>
  117.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
  118.                       </Parameter>
  119.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Author" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Author" SourceColumnNullMapping="True" SourceVersion="Original">
  120.                       </Parameter>
  121.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Author" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Author" SourceColumnNullMapping="False" SourceVersion="Original">
  122.                       </Parameter>
  123.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Press" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Press" SourceColumnNullMapping="True" SourceVersion="Original">
  124.                       </Parameter>
  125.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Press" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Press" SourceColumnNullMapping="False" SourceVersion="Original">
  126.                       </Parameter>
  127.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PublishDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PublishDate" SourceColumnNullMapping="True" SourceVersion="Original">
  128.                       </Parameter>
  129.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PublishDate" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="PublishDate" SourceColumnNullMapping="False" SourceVersion="Original">
  130.                       </Parameter>
  131.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="False" SourceVersion="Original">
  132.                       </Parameter>
  133.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Pages" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Pages" SourceColumnNullMapping="True" SourceVersion="Original">
  134.                       </Parameter>
  135.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Pages" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Pages" SourceColumnNullMapping="False" SourceVersion="Original">
  136.                       </Parameter>
  137.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Barcode" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Barcode" SourceColumnNullMapping="False" SourceVersion="Original">
  138.                       </Parameter>
  139.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CD" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CD" SourceColumnNullMapping="True" SourceVersion="Original">
  140.                       </Parameter>
  141.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_CD" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="CD" SourceColumnNullMapping="False" SourceVersion="Original">
  142.                       </Parameter>
  143.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Storage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Storage" SourceColumnNullMapping="False" SourceVersion="Original">
  144.                       </Parameter>
  145.                       <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="ID" DataSourceName="BookStore.dbo.Book" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
  146.                       </Parameter>
  147.                     </Parameters>
  148.                   </DbCommand>
  149.                 </UpdateCommand>
  150.               </DbSource>
  151.             </MainSource>
  152.             <Mappings>
  153.               <Mapping SourceColumn="ID" DataSetColumn="ID" />
  154.               <Mapping SourceColumn="ISBN" DataSetColumn="ISBN" />
  155.               <Mapping SourceColumn="Name" DataSetColumn="Name" />
  156.               <Mapping SourceColumn="Author" DataSetColumn="Author" />
  157.               <Mapping SourceColumn="Press" DataSetColumn="Press" />
  158.               <Mapping SourceColumn="PublishDate" DataSetColumn="PublishDate" />
  159.               <Mapping SourceColumn="Price" DataSetColumn="Price" />
  160.               <Mapping SourceColumn="Pages" DataSetColumn="Pages" />
  161.               <Mapping SourceColumn="Barcode" DataSetColumn="Barcode" />
  162.               <Mapping SourceColumn="CD" DataSetColumn="CD" />
  163.               <Mapping SourceColumn="Storage" DataSetColumn="Storage" />
  164.             </Mappings>
  165.             <Sources>
  166.             </Sources>
  167.           </TableAdapter>
  168.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CustomerTableAdapter" GeneratorDataComponentClassName="CustomerTableAdapter" Name="Customer" UserDataComponentName="CustomerTableAdapter">
  169.             <MainSource>
  170.               <DbSource ConnectionRef="BookStoreConnectionString (Settings)" DbObjectName="BookStore.dbo.Customer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
  171.                 <DeleteCommand>
  172.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  173.                     <CommandText>DELETE FROM [dbo].[Customer] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Levels] = @Original_Levels) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ((@IsNull_Degree = 1 AND [Degree] IS NULL) OR ([Degree] = @Original_Degree)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_Telephone = 1 AND [Telephone] IS NULL) OR ([Telephone] = @Original_Telephone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Score = 1 AND [Score] IS NULL) OR ([Score] = @Original_Score)))</CommandText>
  174.                     <Parameters>
  175.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  176.                       </Parameter>
  177.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
  178.                       </Parameter>
  179.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Levels" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Levels" SourceColumnNullMapping="False" SourceVersion="Original">
  180.                       </Parameter>
  181.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="True" SourceVersion="Original">
  182.                       </Parameter>
  183.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="False" SourceVersion="Original">
  184.                       </Parameter>
  185.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Birthday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="True" SourceVersion="Original">
  186.                       </Parameter>
  187.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Birthday" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="False" SourceVersion="Original">
  188.                       </Parameter>
  189.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree" SourceColumnNullMapping="True" SourceVersion="Original">
  190.                       </Parameter>
  191.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree" SourceColumnNullMapping="False" SourceVersion="Original">
  192.                       </Parameter>
  193.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="True" SourceVersion="Original">
  194.                       </Parameter>
  195.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Original">
  196.                       </Parameter>
  197.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telephone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="True" SourceVersion="Original">
  198.                       </Parameter>
  199.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="False" SourceVersion="Original">
  200.                       </Parameter>
  201.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="True" SourceVersion="Original">
  202.                       </Parameter>
  203.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Original">
  204.                       </Parameter>
  205.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Score" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Score" SourceColumnNullMapping="True" SourceVersion="Original">
  206.                       </Parameter>
  207.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Score" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Score" SourceColumnNullMapping="False" SourceVersion="Original">
  208.                       </Parameter>
  209.                     </Parameters>
  210.                   </DbCommand>
  211.                 </DeleteCommand>
  212.                 <InsertCommand>
  213.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  214.                     <CommandText>INSERT INTO [dbo].[Customer] ([Name], [Levels], [Gender], [Birthday], [Degree], [Address], [Telephone], [Email], [Score]) VALUES (@Name, @Levels, @Gender, @Birthday, @Degree, @Address, @Telephone, @Email, @Score);
  215. SELECT ID, Name, Levels, Gender, Birthday, Degree, Address, Telephone, Email, Score FROM Customer WHERE (ID = SCOPE_IDENTITY())</CommandText>
  216.                     <Parameters>
  217.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
  218.                       </Parameter>
  219.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Levels" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Levels" SourceColumnNullMapping="False" SourceVersion="Current">
  220.                       </Parameter>
  221.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="False" SourceVersion="Current">
  222.                       </Parameter>
  223.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Birthday" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="False" SourceVersion="Current">
  224.                       </Parameter>
  225.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree" SourceColumnNullMapping="False" SourceVersion="Current">
  226.                       </Parameter>
  227.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Current">
  228.                       </Parameter>
  229.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="False" SourceVersion="Current">
  230.                       </Parameter>
  231.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Current">
  232.                       </Parameter>
  233.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Score" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Score" SourceColumnNullMapping="False" SourceVersion="Current">
  234.                       </Parameter>
  235.                     </Parameters>
  236.                   </DbCommand>
  237.                 </InsertCommand>
  238.                 <SelectCommand>
  239.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  240.                     <CommandText>SELECT ID, Name, Levels, Gender, Birthday, Degree, Address, Telephone, Email, Score FROM dbo.Customer</CommandText>
  241.                     <Parameters>
  242.                     </Parameters>
  243.                   </DbCommand>
  244.                 </SelectCommand>
  245.                 <UpdateCommand>
  246.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  247.                     <CommandText>UPDATE [dbo].[Customer] SET [Name] = @Name, [Levels] = @Levels, [Gender] = @Gender, [Birthday] = @Birthday, [Degree] = @Degree, [Address] = @Address, [Telephone] = @Telephone, [Email] = @Email, [Score] = @Score WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ([Levels] = @Original_Levels) AND ((@IsNull_Gender = 1 AND [Gender] IS NULL) OR ([Gender] = @Original_Gender)) AND ((@IsNull_Birthday = 1 AND [Birthday] IS NULL) OR ([Birthday] = @Original_Birthday)) AND ((@IsNull_Degree = 1 AND [Degree] IS NULL) OR ([Degree] = @Original_Degree)) AND ((@IsNull_Address = 1 AND [Address] IS NULL) OR ([Address] = @Original_Address)) AND ((@IsNull_Telephone = 1 AND [Telephone] IS NULL) OR ([Telephone] = @Original_Telephone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Score = 1 AND [Score] IS NULL) OR ([Score] = @Original_Score)));
  248. SELECT ID, Name, Levels, Gender, Birthday, Degree, Address, Telephone, Email, Score FROM Customer WHERE (ID = @ID)</CommandText>
  249.                     <Parameters>
  250.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
  251.                       </Parameter>
  252.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Levels" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Levels" SourceColumnNullMapping="False" SourceVersion="Current">
  253.                       </Parameter>
  254.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Gender" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="False" SourceVersion="Current">
  255.                       </Parameter>
  256.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Birthday" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="False" SourceVersion="Current">
  257.                       </Parameter>
  258.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Degree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree" SourceColumnNullMapping="False" SourceVersion="Current">
  259.                       </Parameter>
  260.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Current">
  261.                       </Parameter>
  262.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="False" SourceVersion="Current">
  263.                       </Parameter>
  264.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Current">
  265.                       </Parameter>
  266.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Score" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Score" SourceColumnNullMapping="False" SourceVersion="Current">
  267.                       </Parameter>
  268.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  269.                       </Parameter>
  270.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
  271.                       </Parameter>
  272.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Levels" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Levels" SourceColumnNullMapping="False" SourceVersion="Original">
  273.                       </Parameter>
  274.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Gender" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="True" SourceVersion="Original">
  275.                       </Parameter>
  276.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Gender" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Gender" SourceColumnNullMapping="False" SourceVersion="Original">
  277.                       </Parameter>
  278.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Birthday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="True" SourceVersion="Original">
  279.                       </Parameter>
  280.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Birthday" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Birthday" SourceColumnNullMapping="False" SourceVersion="Original">
  281.                       </Parameter>
  282.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Degree" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Degree" SourceColumnNullMapping="True" SourceVersion="Original">
  283.                       </Parameter>
  284.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Degree" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Degree" SourceColumnNullMapping="False" SourceVersion="Original">
  285.                       </Parameter>
  286.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Address" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="True" SourceVersion="Original">
  287.                       </Parameter>
  288.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="False" SourceVersion="Original">
  289.                       </Parameter>
  290.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telephone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="True" SourceVersion="Original">
  291.                       </Parameter>
  292.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Telephone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Telephone" SourceColumnNullMapping="False" SourceVersion="Original">
  293.                       </Parameter>
  294.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="True" SourceVersion="Original">
  295.                       </Parameter>
  296.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="False" SourceVersion="Original">
  297.                       </Parameter>
  298.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Score" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Score" SourceColumnNullMapping="True" SourceVersion="Original">
  299.                       </Parameter>
  300.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Score" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Score" SourceColumnNullMapping="False" SourceVersion="Original">
  301.                       </Parameter>
  302.                       <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="ID" DataSourceName="BookStore.dbo.Customer" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
  303.                       </Parameter>
  304.                     </Parameters>
  305.                   </DbCommand>
  306.                 </UpdateCommand>
  307.               </DbSource>
  308.             </MainSource>
  309.             <Mappings>
  310.               <Mapping SourceColumn="ID" DataSetColumn="ID" />
  311.               <Mapping SourceColumn="Name" DataSetColumn="Name" />
  312.               <Mapping SourceColumn="Levels" DataSetColumn="Levels" />
  313.               <Mapping SourceColumn="Gender" DataSetColumn="Gender" />
  314.               <Mapping SourceColumn="Birthday" DataSetColumn="Birthday" />
  315.               <Mapping SourceColumn="Degree" DataSetColumn="Degree" />
  316.               <Mapping SourceColumn="Address" DataSetColumn="Address" />
  317.               <Mapping SourceColumn="Telephone" DataSetColumn="Telephone" />
  318.               <Mapping SourceColumn="Email" DataSetColumn="Email" />
  319.               <Mapping SourceColumn="Score" DataSetColumn="Score" />
  320.             </Mappings>
  321.             <Sources>
  322.             </Sources>
  323.           </TableAdapter>
  324.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SellTableAdapter" GeneratorDataComponentClassName="SellTableAdapter" Name="Sell" UserDataComponentName="SellTableAdapter">
  325.             <MainSource>
  326.               <DbSource ConnectionRef="BookStoreConnectionString (Settings)" DbObjectName="BookStore.dbo.Sell" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
  327.                 <DeleteCommand>
  328.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  329.                     <CommandText>DELETE FROM [dbo].[Sell] WHERE (([ID] = @Original_ID) AND ((@IsNull_CustomerID = 1 AND [CustomerID] IS NULL) OR ([CustomerID] = @Original_CustomerID)) AND ([Sum] = @Original_Sum) AND ([Time] = @Original_Time))</CommandText>
  330.                     <Parameters>
  331.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  332.                       </Parameter>
  333.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="True" SourceVersion="Original">
  334.                       </Parameter>
  335.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Original">
  336.                       </Parameter>
  337.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Original">
  338.                       </Parameter>
  339.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Original">
  340.                       </Parameter>
  341.                     </Parameters>
  342.                   </DbCommand>
  343.                 </DeleteCommand>
  344.                 <InsertCommand>
  345.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  346.                     <CommandText>INSERT INTO [dbo].[Sell] ([CustomerID], [Sum], [Time]) VALUES (@CustomerID, @Sum, @Time);
  347. SELECT ID, CustomerID, Sum, Time FROM Sell WHERE (ID = SCOPE_IDENTITY())</CommandText>
  348.                     <Parameters>
  349.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Current">
  350.                       </Parameter>
  351.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Current">
  352.                       </Parameter>
  353.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
  354.                       </Parameter>
  355.                     </Parameters>
  356.                   </DbCommand>
  357.                 </InsertCommand>
  358.                 <SelectCommand>
  359.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  360.                     <CommandText>SELECT ID, CustomerID, Sum, Time FROM dbo.Sell</CommandText>
  361.                     <Parameters>
  362.                     </Parameters>
  363.                   </DbCommand>
  364.                 </SelectCommand>
  365.                 <UpdateCommand>
  366.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  367.                     <CommandText>UPDATE [dbo].[Sell] SET [CustomerID] = @CustomerID, [Sum] = @Sum, [Time] = @Time WHERE (([ID] = @Original_ID) AND ((@IsNull_CustomerID = 1 AND [CustomerID] IS NULL) OR ([CustomerID] = @Original_CustomerID)) AND ([Sum] = @Original_Sum) AND ([Time] = @Original_Time));
  368. SELECT ID, CustomerID, Sum, Time FROM Sell WHERE (ID = @ID)</CommandText>
  369.                     <Parameters>
  370.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Current">
  371.                       </Parameter>
  372.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Current">
  373.                       </Parameter>
  374.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
  375.                       </Parameter>
  376.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  377.                       </Parameter>
  378.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="True" SourceVersion="Original">
  379.                       </Parameter>
  380.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CustomerID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CustomerID" SourceColumnNullMapping="False" SourceVersion="Original">
  381.                       </Parameter>
  382.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Original">
  383.                       </Parameter>
  384.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Original">
  385.                       </Parameter>
  386.                       <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="ID" DataSourceName="BookStore.dbo.Sell" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
  387.                       </Parameter>
  388.                     </Parameters>
  389.                   </DbCommand>
  390.                 </UpdateCommand>
  391.               </DbSource>
  392.             </MainSource>
  393.             <Mappings>
  394.               <Mapping SourceColumn="ID" DataSetColumn="ID" />
  395.               <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
  396.               <Mapping SourceColumn="Sum" DataSetColumn="Sum" />
  397.               <Mapping SourceColumn="Time" DataSetColumn="Time" />
  398.             </Mappings>
  399.             <Sources>
  400.             </Sources>
  401.           </TableAdapter>
  402.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SellItemTableAdapter" GeneratorDataComponentClassName="SellItemTableAdapter" Name="SellItem" UserDataComponentName="SellItemTableAdapter">
  403.             <MainSource>
  404.               <DbSource ConnectionRef="BookStoreConnectionString (Settings)" DbObjectName="BookStore.dbo.SellItem" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
  405.                 <DeleteCommand>
  406.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  407.                     <CommandText>DELETE FROM [dbo].[SellItem] WHERE (([ID] = @Original_ID) AND ([SellID] = @Original_SellID) AND ([BookID] = @Original_BookID) AND ([Number] = @Original_Number) AND ([Discount] = @Original_Discount) AND ((@IsNull_Sum = 1 AND [Sum] IS NULL) OR ([Sum] = @Original_Sum)))</CommandText>
  408.                     <Parameters>
  409.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  410.                       </Parameter>
  411.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SellID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SellID" SourceColumnNullMapping="False" SourceVersion="Original">
  412.                       </Parameter>
  413.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BookID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BookID" SourceColumnNullMapping="False" SourceVersion="Original">
  414.                       </Parameter>
  415.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Original">
  416.                       </Parameter>
  417.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Discount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Discount" SourceColumnNullMapping="False" SourceVersion="Original">
  418.                       </Parameter>
  419.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="True" SourceVersion="Original">
  420.                       </Parameter>
  421.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Original">
  422.                       </Parameter>
  423.                     </Parameters>
  424.                   </DbCommand>
  425.                 </DeleteCommand>
  426.                 <InsertCommand>
  427.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  428.                     <CommandText>INSERT INTO [dbo].[SellItem] ([SellID], [BookID], [Number], [Discount], [Sum]) VALUES (@SellID, @BookID, @Number, @Discount, @Sum);
  429. SELECT ID, SellID, BookID, Number, Discount, Sum FROM SellItem WHERE (ID = SCOPE_IDENTITY())</CommandText>
  430.                     <Parameters>
  431.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SellID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SellID" SourceColumnNullMapping="False" SourceVersion="Current">
  432.                       </Parameter>
  433.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BookID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BookID" SourceColumnNullMapping="False" SourceVersion="Current">
  434.                       </Parameter>
  435.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Current">
  436.                       </Parameter>
  437.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Discount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Discount" SourceColumnNullMapping="False" SourceVersion="Current">
  438.                       </Parameter>
  439.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Current">
  440.                       </Parameter>
  441.                     </Parameters>
  442.                   </DbCommand>
  443.                 </InsertCommand>
  444.                 <SelectCommand>
  445.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  446.                     <CommandText>SELECT ID, SellID, BookID, Number, Discount, Sum FROM dbo.SellItem</CommandText>
  447.                     <Parameters>
  448.                     </Parameters>
  449.                   </DbCommand>
  450.                 </SelectCommand>
  451.                 <UpdateCommand>
  452.                   <DbCommand CommandType="Text" ModifiedByUser="False">
  453.                     <CommandText>UPDATE [dbo].[SellItem] SET [SellID] = @SellID, [BookID] = @BookID, [Number] = @Number, [Discount] = @Discount, [Sum] = @Sum WHERE (([ID] = @Original_ID) AND ([SellID] = @Original_SellID) AND ([BookID] = @Original_BookID) AND ([Number] = @Original_Number) AND ([Discount] = @Original_Discount) AND ((@IsNull_Sum = 1 AND [Sum] IS NULL) OR ([Sum] = @Original_Sum)));
  454. SELECT ID, SellID, BookID, Number, Discount, Sum FROM SellItem WHERE (ID = @ID)</CommandText>
  455.                     <Parameters>
  456.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SellID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SellID" SourceColumnNullMapping="False" SourceVersion="Current">
  457.                       </Parameter>
  458.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BookID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BookID" SourceColumnNullMapping="False" SourceVersion="Current">
  459.                       </Parameter>
  460.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Current">
  461.                       </Parameter>
  462.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Discount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Discount" SourceColumnNullMapping="False" SourceVersion="Current">
  463.                       </Parameter>
  464.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Current">
  465.                       </Parameter>
  466.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Original">
  467.                       </Parameter>
  468.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SellID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SellID" SourceColumnNullMapping="False" SourceVersion="Original">
  469.                       </Parameter>
  470.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BookID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BookID" SourceColumnNullMapping="False" SourceVersion="Original">
  471.                       </Parameter>
  472.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Number" SourceColumnNullMapping="False" SourceVersion="Original">
  473.                       </Parameter>
  474.                       <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Discount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Discount" SourceColumnNullMapping="False" SourceVersion="Original">
  475.                       </Parameter>
  476.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="True" SourceVersion="Original">
  477.                       </Parameter>
  478.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Sum" Precision="0" ProviderType="SmallMoney" Scale="0" Size="0" SourceColumn="Sum" SourceColumnNullMapping="False" SourceVersion="Original">
  479.                       </Parameter>
  480.                       <Parameter AllowDbNull="False" AutogeneratedName="ID" ColumnName="ID" DataSourceName="BookStore.dbo.SellItem" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="False" SourceVersion="Current">
  481.                       </Parameter>
  482.                     </Parameters>
  483.                   </DbCommand>
  484.                 </UpdateCommand>
  485.               </DbSource>
  486.             </MainSource>
  487.             <Mappings>
  488.               <Mapping SourceColumn="ID" DataSetColumn="ID" />
  489.               <Mapping SourceColumn="SellID" DataSetColumn="SellID" />
  490.               <Mapping SourceColumn="BookID" DataSetColumn="BookID" />
  491.               <Mapping SourceColumn="Number" DataSetColumn="Number" />
  492.               <Mapping SourceColumn="Discount" DataSetColumn="Discount" />
  493.               <Mapping SourceColumn="Sum" DataSetColumn="Sum" />
  494.             </Mappings>
  495.             <Sources>
  496.             </Sources>
  497.           </TableAdapter>
  498.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="V_BookSellTableAdapter" GeneratorDataComponentClassName="V_BookSellTableAdapter" Name="V_BookSell" UserDataComponentName="V_BookSellTableAdapter">
  499.             <MainSource>
  500.               <DbSource ConnectionRef="BookStoreConnectionString (Settings)" DbObjectName="BookStore.dbo.V_BookSell" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
  501.                 <SelectCommand>
  502.                   <DbCommand CommandType="Text" ModifiedByUser="True">
  503.                     <CommandText>SELECT ID, SellID, CustomerID, Time, ISBN, Name, Press, Price, Number, Discount, Sum FROM dbo.V_BookSell</CommandText>
  504.                     <Parameters>
  505.                     </Parameters>
  506.                   </DbCommand>
  507.                 </SelectCommand>
  508.               </DbSource>
  509.             </MainSource>
  510.             <Mappings>
  511.               <Mapping SourceColumn="ID" DataSetColumn="ID" />
  512.               <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
  513.               <Mapping SourceColumn="Time" DataSetColumn="Time" />
  514.               <Mapping SourceColumn="ISBN" DataSetColumn="ISBN" />
  515.               <Mapping SourceColumn="Name" DataSetColumn="Name" />
  516.               <Mapping SourceColumn="Press" DataSetColumn="Press" />
  517.               <Mapping SourceColumn="Price" DataSetColumn="Price" />
  518.               <Mapping SourceColumn="Number" DataSetColumn="Number" />
  519.               <Mapping SourceColumn="Discount" DataSetColumn="Discount" />
  520.               <Mapping SourceColumn="Sum" DataSetColumn="Sum" />
  521.               <Mapping SourceColumn="SellID" DataSetColumn="SellID" />
  522.             </Mappings>
  523.             <Sources>
  524.             </Sources>
  525.           </TableAdapter>
  526.           <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="P_GetSellDetailTableAdapter" GeneratorDataComponentClassName="P_GetSellDetailTableAdapter" Name="P_GetSellDetail" UserDataComponentName="P_GetSellDetailTableAdapter">
  527.             <MainSource>
  528.               <DbSource ConnectionRef="BookStoreConnectionString (Settings)" DbObjectName="BookStore.dbo.P_GetSellDetail" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
  529.                 <SelectCommand>
  530.                   <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
  531.                     <CommandText>dbo.P_GetSellDetail</CommandText>
  532.                     <Parameters>
  533.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
  534.                       </Parameter>
  535.                       <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SellID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
  536.                       </Parameter>
  537.                     </Parameters>
  538.                   </DbCommand>
  539.                 </SelectCommand>
  540.               </DbSource>
  541.             </MainSource>
  542.             <Mappings>
  543.               <Mapping SourceColumn="BookID" DataSetColumn="BookID" />
  544.               <Mapping SourceColumn="ISBN" DataSetColumn="ISBN" />
  545.               <Mapping SourceColumn="Name" DataSetColumn="Name" />
  546.               <Mapping SourceColumn="Price" DataSetColumn="Price" />
  547.               <Mapping SourceColumn="Number" DataSetColumn="Number" />
  548.               <Mapping SourceColumn="Discount" DataSetColumn="Discount" />
  549.               <Mapping SourceColumn="Sum" DataSetColumn="Sum" />
  550.             </Mappings>
  551.             <Sources>
  552.             </Sources>
  553.           </TableAdapter>
  554.         </Tables>
  555.         <Sources>
  556.         </Sources>
  557.       </DataSource>
  558.     </xs:appinfo>
  559.   </xs:annotation>
  560.   <xs:element name="BookStoreDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="BookStoreDataSet" msprop:Generator_DataSetName="BookStoreDataSet">
  561.     <xs:complexType>
  562.       <xs:choice minOccurs="0" maxOccurs="unbounded">
  563.         <xs:element name="Book" msprop:Generator_UserTableName="Book" msprop:Generator_RowDeletedName="BookRowDeleted" msprop:Generator_RowChangedName="BookRowChanged" msprop:Generator_RowClassName="BookRow" msprop:Generator_RowChangingName="BookRowChanging" msprop:Generator_RowEvArgName="BookRowChangeEvent" msprop:Generator_RowEvHandlerName="BookRowChangeEventHandler" msprop:Generator_TableClassName="BookDataTable" msprop:Generator_TableVarName="tableBook" msprop:Generator_RowDeletingName="BookRowDeleting" msprop:Generator_TablePropName="Book">
  564.           <xs:complexType>
  565.             <xs:sequence>
  566.               <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
  567.               <xs:element name="ISBN" msprop:Generator_UserColumnName="ISBN" msprop:Generator_ColumnPropNameInRow="ISBN" msprop:Generator_ColumnVarNameInTable="columnISBN" msprop:Generator_ColumnPropNameInTable="ISBNColumn">
  568.                 <xs:simpleType>
  569.                   <xs:restriction base="xs:string">
  570.                     <xs:maxLength value="10" />
  571.                   </xs:restriction>
  572.                 </xs:simpleType>
  573.               </xs:element>
  574.               <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
  575.                 <xs:simpleType>
  576.                   <xs:restriction base="xs:string">
  577.                     <xs:maxLength value="256" />
  578.                   </xs:restriction>
  579.                 </xs:simpleType>
  580.               </xs:element>
  581.               <xs:element name="Author" msprop:Generator_UserColumnName="Author" msprop:Generator_ColumnPropNameInRow="Author" msprop:Generator_ColumnVarNameInTable="columnAuthor" msprop:Generator_ColumnPropNameInTable="AuthorColumn" minOccurs="0">
  582.                 <xs:simpleType>
  583.                   <xs:restriction base="xs:string">
  584.                     <xs:maxLength value="100" />
  585.                   </xs:restriction>
  586.                 </xs:simpleType>
  587.               </xs:element>
  588.               <xs:element name="Press" msprop:Generator_UserColumnName="Press" msprop:Generator_ColumnPropNameInRow="Press" msprop:Generator_ColumnVarNameInTable="columnPress" msprop:Generator_ColumnPropNameInTable="PressColumn" minOccurs="0">
  589.                 <xs:simpleType>
  590.                   <xs:restriction base="xs:string">
  591.                     <xs:maxLength value="50" />
  592.                   </xs:restriction>
  593.                 </xs:simpleType>
  594.               </xs:element>
  595.               <xs:element name="PublishDate" msprop:Generator_UserColumnName="PublishDate" msprop:Generator_ColumnPropNameInRow="PublishDate" msprop:Generator_ColumnVarNameInTable="columnPublishDate" msprop:Generator_ColumnPropNameInTable="PublishDateColumn" type="xs:dateTime" minOccurs="0" />
  596.               <xs:element name="Price" msprop:Generator_UserColumnName="Price" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInTable="PriceColumn" type="xs:decimal" />
  597.               <xs:element name="Pages" msprop:Generator_UserColumnName="Pages" msprop:Generator_ColumnPropNameInRow="Pages" msprop:Generator_ColumnVarNameInTable="columnPages" msprop:Generator_ColumnPropNameInTable="PagesColumn" type="xs:short" minOccurs="0" />
  598.               <xs:element name="Barcode" msprop:Generator_UserColumnName="Barcode" msprop:Generator_ColumnPropNameInRow="Barcode" msprop:Generator_ColumnVarNameInTable="columnBarcode" msprop:Generator_ColumnPropNameInTable="BarcodeColumn">
  599.                 <xs:simpleType>
  600.                   <xs:restriction base="xs:string">
  601.                     <xs:maxLength value="13" />
  602.                   </xs:restriction>
  603.                 </xs:simpleType>
  604.               </xs:element>
  605.               <xs:element name="CD" msprop:Generator_UserColumnName="CD" msprop:Generator_ColumnPropNameInRow="CD" msprop:Generator_ColumnVarNameInTable="columnCD" msprop:Generator_ColumnPropNameInTable="CDColumn" type="xs:boolean" minOccurs="0" />
  606.               <xs:element name="Storage" msprop:Generator_UserColumnName="Storage" msprop:Generator_ColumnPropNameInRow="Storage" msprop:Generator_ColumnVarNameInTable="columnStorage" msprop:Generator_ColumnPropNameInTable="StorageColumn" type="xs:int" />
  607.             </xs:sequence>
  608.           </xs:complexType>
  609.         </xs:element>
  610.         <xs:element name="Customer" msprop:Generator_UserTableName="Customer" msprop:Generator_RowDeletedName="CustomerRowDeleted" msprop:Generator_RowChangedName="CustomerRowChanged" msprop:Generator_RowClassName="CustomerRow" msprop:Generator_RowChangingName="CustomerRowChanging" msprop:Generator_RowEvArgName="CustomerRowChangeEvent" msprop:Generator_RowEvHandlerName="CustomerRowChangeEventHandler" msprop:Generator_TableClassName="CustomerDataTable" msprop:Generator_TableVarName="tableCustomer" msprop:Generator_RowDeletingName="CustomerRowDeleting" msprop:Generator_TablePropName="Customer">
  611.           <xs:complexType>
  612.             <xs:sequence>
  613.               <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
  614.               <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
  615.                 <xs:simpleType>
  616.                   <xs:restriction base="xs:string">
  617.                     <xs:maxLength value="20" />
  618.                   </xs:restriction>
  619.                 </xs:simpleType>
  620.               </xs:element>
  621.               <xs:element name="Levels" msprop:Generator_UserColumnName="Levels" msprop:Generator_ColumnPropNameInRow="Levels" msprop:Generator_ColumnVarNameInTable="columnLevels" msprop:Generator_ColumnPropNameInTable="LevelsColumn" type="xs:short" />
  622.               <xs:element name="Gender" msprop:Generator_UserColumnName="Gender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInTable="GenderColumn" type="xs:boolean" minOccurs="0" />
  623.               <xs:element name="Birthday" msprop:Generator_UserColumnName="Birthday" msprop:Generator_ColumnPropNameInRow="Birthday" msprop:Generator_ColumnVarNameInTable="columnBirthday" msprop:Generator_ColumnPropNameInTable="BirthdayColumn" type="xs:dateTime" minOccurs="0" />
  624.               <xs:element name="Degree" msprop:Generator_UserColumnName="Degree" msprop:Generator_ColumnPropNameInRow="Degree" msprop:Generator_ColumnVarNameInTable="columnDegree" msprop:Generator_ColumnPropNameInTable="DegreeColumn" minOccurs="0">
  625.                 <xs:simpleType>
  626.                   <xs:restriction base="xs:string">
  627.                     <xs:maxLength value="20" />
  628.                   </xs:restriction>
  629.                 </xs:simpleType>
  630.               </xs:element>
  631.               <xs:element name="Address" msprop:Generator_UserColumnName="Address" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInTable="AddressColumn" minOccurs="0">
  632.                 <xs:simpleType>
  633.                   <xs:restriction base="xs:string">
  634.                     <xs:maxLength value="256" />
  635.                   </xs:restriction>
  636.                 </xs:simpleType>
  637.               </xs:element>
  638.               <xs:element name="Telephone" msprop:Generator_UserColumnName="Telephone" msprop:Generator_ColumnPropNameInRow="Telephone" msprop:Generator_ColumnVarNameInTable="columnTelephone" msprop:Generator_ColumnPropNameInTable="TelephoneColumn" minOccurs="0">
  639.                 <xs:simpleType>
  640.                   <xs:restriction base="xs:string">
  641.                     <xs:maxLength value="50" />
  642.                   </xs:restriction>
  643.                 </xs:simpleType>
  644.               </xs:element>
  645.               <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
  646.                 <xs:simpleType>
  647.                   <xs:restriction base="xs:string">
  648.                     <xs:maxLength value="50" />
  649.                   </xs:restriction>
  650.                 </xs:simpleType>
  651.               </xs:element>
  652.               <xs:element name="Score" msprop:Generator_UserColumnName="Score" msprop:Generator_ColumnPropNameInRow="Score" msprop:Generator_ColumnVarNameInTable="columnScore" msprop:Generator_ColumnPropNameInTable="ScoreColumn" type="xs:int" minOccurs="0" />
  653.             </xs:sequence>
  654.           </xs:complexType>
  655.         </xs:element>
  656.         <xs:element name="Sell" msprop:Generator_UserTableName="Sell" msprop:Generator_RowDeletedName="SellRowDeleted" msprop:Generator_RowChangedName="SellRowChanged" msprop:Generator_RowClassName="SellRow" msprop:Generator_RowChangingName="SellRowChanging" msprop:Generator_RowEvArgName="SellRowChangeEvent" msprop:Generator_RowEvHandlerName="SellRowChangeEventHandler" msprop:Generator_TableClassName="SellDataTable" msprop:Generator_TableVarName="tableSell" msprop:Generator_RowDeletingName="SellRowDeleting" msprop:Generator_TablePropName="Sell">
  657.           <xs:complexType>
  658.             <xs:sequence>
  659.               <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
  660.               <xs:element name="CustomerID" msprop:Generator_UserColumnName="CustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" type="xs:int" minOccurs="0" />
  661.               <xs:element name="Sum" msprop:Generator_UserColumnName="Sum" msprop:Generator_ColumnPropNameInRow="Sum" msprop:Generator_ColumnVarNameInTable="columnSum" msprop:Generator_ColumnPropNameInTable="SumColumn" type="xs:decimal" />
  662.               <xs:element name="Time" msprop:Generator_UserColumnName="Time" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInTable="TimeColumn" type="xs:dateTime" />
  663.             </xs:sequence>
  664.           </xs:complexType>
  665.         </xs:element>
  666.         <xs:element name="SellItem" msprop:Generator_UserTableName="SellItem" msprop:Generator_RowDeletedName="SellItemRowDeleted" msprop:Generator_RowChangedName="SellItemRowChanged" msprop:Generator_RowClassName="SellItemRow" msprop:Generator_RowChangingName="SellItemRowChanging" msprop:Generator_RowEvArgName="SellItemRowChangeEvent" msprop:Generator_RowEvHandlerName="SellItemRowChangeEventHandler" msprop:Generator_TableClassName="SellItemDataTable" msprop:Generator_TableVarName="tableSellItem" msprop:Generator_RowDeletingName="SellItemRowDeleting" msprop:Generator_TablePropName="SellItem">
  667.           <xs:complexType>
  668.             <xs:sequence>
  669.               <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
  670.               <xs:element name="SellID" msprop:Generator_UserColumnName="SellID" msprop:Generator_ColumnPropNameInRow="SellID" msprop:Generator_ColumnVarNameInTable="columnSellID" msprop:Generator_ColumnPropNameInTable="SellIDColumn" type="xs:int" />
  671.               <xs:element name="BookID" msprop:Generator_UserColumnName="BookID" msprop:Generator_ColumnPropNameInRow="BookID" msprop:Generator_ColumnVarNameInTable="columnBookID" msprop:Generator_ColumnPropNameInTable="BookIDColumn" type="xs:int" />
  672.               <xs:element name="Number" msprop:Generator_UserColumnName="Number" msprop:Generator_ColumnPropNameInRow="Number" msprop:Generator_ColumnVarNameInTable="columnNumber" msprop:Generator_ColumnPropNameInTable="NumberColumn" type="xs:int" />
  673.               <xs:element name="Discount" msprop:Generator_UserColumnName="Discount" msprop:Generator_ColumnPropNameInRow="Discount" msprop:Generator_ColumnVarNameInTable="columnDiscount" msprop:Generator_ColumnPropNameInTable="DiscountColumn" type="xs:double" />
  674.               <xs:element name="Sum" msprop:Generator_UserColumnName="Sum" msprop:Generator_ColumnPropNameInRow="Sum" msprop:Generator_ColumnVarNameInTable="columnSum" msprop:Generator_ColumnPropNameInTable="SumColumn" type="xs:decimal" minOccurs="0" />
  675.             </xs:sequence>
  676.           </xs:complexType>
  677.         </xs:element>
  678.         <xs:element name="V_BookSell" msprop:Generator_UserTableName="V_BookSell" msprop:Generator_RowDeletedName="V_BookSellRowDeleted" msprop:Generator_RowChangedName="V_BookSellRowChanged" msprop:Generator_RowClassName="V_BookSellRow" msprop:Generator_RowChangingName="V_BookSellRowChanging" msprop:Generator_RowEvArgName="V_BookSellRowChangeEvent" msprop:Generator_RowEvHandlerName="V_BookSellRowChangeEventHandler" msprop:Generator_TableClassName="V_BookSellDataTable" msprop:Generator_TableVarName="tableV_BookSell" msprop:Generator_RowDeletingName="V_BookSellRowDeleting" msprop:Generator_TablePropName="V_BookSell">
  679.           <xs:complexType>
  680.             <xs:sequence>
  681.               <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
  682.               <xs:element name="CustomerID" msprop:Generator_UserColumnName="CustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" type="xs:int" minOccurs="0" />
  683.               <xs:element name="Time" msprop:Generator_UserColumnName="Time" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInTable="TimeColumn" type="xs:dateTime" />
  684.               <xs:element name="ISBN" msprop:Generator_UserColumnName="ISBN" msprop:Generator_ColumnPropNameInRow="ISBN" msprop:Generator_ColumnVarNameInTable="columnISBN" msprop:Generator_ColumnPropNameInTable="ISBNColumn">
  685.                 <xs:simpleType>
  686.                   <xs:restriction base="xs:string">
  687.                     <xs:maxLength value="10" />
  688.                   </xs:restriction>
  689.                 </xs:simpleType>
  690.               </xs:element>
  691.               <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
  692.                 <xs:simpleType>
  693.                   <xs:restriction base="xs:string">
  694.                     <xs:maxLength value="256" />
  695.                   </xs:restriction>
  696.                 </xs:simpleType>
  697.               </xs:element>
  698.               <xs:element name="Press" msprop:Generator_UserColumnName="Press" msprop:Generator_ColumnPropNameInRow="Press" msprop:Generator_ColumnVarNameInTable="columnPress" msprop:Generator_ColumnPropNameInTable="PressColumn" minOccurs="0">
  699.                 <xs:simpleType>
  700.                   <xs:restriction base="xs:string">
  701.                     <xs:maxLength value="50" />
  702.                   </xs:restriction>
  703.                 </xs:simpleType>
  704.               </xs:element>
  705.               <xs:element name="Price" msprop:Generator_UserColumnName="Price" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInTable="PriceColumn" type="xs:decimal" />
  706.               <xs:element name="Number" msprop:Generator_UserColumnName="Number" msprop:Generator_ColumnPropNameInRow="Number" msprop:Generator_ColumnVarNameInTable="columnNumber" msprop:Generator_ColumnPropNameInTable="NumberColumn" type="xs:int" />
  707.               <xs:element name="Discount" msprop:Generator_UserColumnName="Discount" msprop:Generator_ColumnPropNameInRow="Discount" msprop:Generator_ColumnVarNameInTable="columnDiscount" msprop:Generator_ColumnPropNameInTable="DiscountColumn" type="xs:double" />
  708.               <xs:element name="Sum" msprop:Generator_UserColumnName="Sum" msprop:Generator_ColumnPropNameInRow="Sum" msprop:Generator_ColumnVarNameInTable="columnSum" msprop:Generator_ColumnPropNameInTable="SumColumn" type="xs:decimal" minOccurs="0" />
  709.               <xs:element name="SellID" msprop:Generator_UserColumnName="SellID" msprop:Generator_ColumnVarNameInTable="columnSellID" msprop:Generator_ColumnPropNameInRow="SellID" msprop:Generator_ColumnPropNameInTable="SellIDColumn" type="xs:int" />
  710.             </xs:sequence>
  711.           </xs:complexType>
  712.         </xs:element>
  713.         <xs:element name="P_GetSellDetail" msprop:Generator_UserTableName="P_GetSellDetail" msprop:Generator_RowDeletedName="P_GetSellDetailRowDeleted" msprop:Generator_RowChangedName="P_GetSellDetailRowChanged" msprop:Generator_RowClassName="P_GetSellDetailRow" msprop:Generator_RowChangingName="P_GetSellDetailRowChanging" msprop:Generator_RowEvArgName="P_GetSellDetailRowChangeEvent" msprop:Generator_RowEvHandlerName="P_GetSellDetailRowChangeEventHandler" msprop:Generator_TableClassName="P_GetSellDetailDataTable" msprop:Generator_TableVarName="tableP_GetSellDetail" msprop:Generator_RowDeletingName="P_GetSellDetailRowDeleting" msprop:Generator_TablePropName="P_GetSellDetail">
  714.           <xs:complexType>
  715.             <xs:sequence>
  716.               <xs:element name="BookID" msprop:Generator_UserColumnName="BookID" msprop:Generator_ColumnPropNameInRow="BookID" msprop:Generator_ColumnVarNameInTable="columnBookID" msprop:Generator_ColumnPropNameInTable="BookIDColumn" type="xs:int" />
  717.               <xs:element name="ISBN" msprop:Generator_UserColumnName="ISBN" msprop:Generator_ColumnPropNameInRow="ISBN" msprop:Generator_ColumnVarNameInTable="columnISBN" msprop:Generator_ColumnPropNameInTable="ISBNColumn">
  718.                 <xs:simpleType>
  719.                   <xs:restriction base="xs:string">
  720.                     <xs:maxLength value="10" />
  721.                   </xs:restriction>
  722.                 </xs:simpleType>
  723.               </xs:element>
  724.               <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
  725.                 <xs:simpleType>
  726.                   <xs:restriction base="xs:string">
  727.                     <xs:maxLength value="256" />
  728.                   </xs:restriction>
  729.                 </xs:simpleType>
  730.               </xs:element>
  731.               <xs:element name="Price" msprop:Generator_UserColumnName="Price" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInTable="PriceColumn" type="xs:decimal" />
  732.               <xs:element name="Number" msprop:Generator_UserColumnName="Number" msprop:Generator_ColumnPropNameInRow="Number" msprop:Generator_ColumnVarNameInTable="columnNumber" msprop:Generator_ColumnPropNameInTable="NumberColumn" type="xs:int" />
  733.               <xs:element name="Discount" msprop:Generator_UserColumnName="Discount" msprop:Generator_ColumnPropNameInRow="Discount" msprop:Generator_ColumnVarNameInTable="columnDiscount" msprop:Generator_ColumnPropNameInTable="DiscountColumn" type="xs:double" />
  734.               <xs:element name="Sum" msprop:Generator_UserColumnName="Sum" msprop:Generator_ColumnPropNameInRow="Sum" msprop:Generator_ColumnVarNameInTable="columnSum" msprop:Generator_ColumnPropNameInTable="SumColumn" type="xs:decimal" minOccurs="0" />
  735.             </xs:sequence>
  736.           </xs:complexType>
  737.         </xs:element>
  738.       </xs:choice>
  739.     </xs:complexType>
  740.     <xs:unique name="Constraint1" msdata:PrimaryKey="true">
  741.       <xs:selector xpath=".//mstns:Book" />
  742.       <xs:field xpath="mstns:ID" />
  743.     </xs:unique>
  744.     <xs:unique name="Customer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  745.       <xs:selector xpath=".//mstns:Customer" />
  746.       <xs:field xpath="mstns:ID" />
  747.     </xs:unique>
  748.     <xs:unique name="Sell_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  749.       <xs:selector xpath=".//mstns:Sell" />
  750.       <xs:field xpath="mstns:ID" />
  751.     </xs:unique>
  752.     <xs:unique name="SellItem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  753.       <xs:selector xpath=".//mstns:SellItem" />
  754.       <xs:field xpath="mstns:ID" />
  755.     </xs:unique>
  756.     <xs:unique name="V_BookSell_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
  757.       <xs:selector xpath=".//mstns:V_BookSell" />
  758.       <xs:field xpath="mstns:ID" />
  759.     </xs:unique>
  760.   </xs:element>
  761.   <xs:annotation>
  762.     <xs:appinfo>
  763.       <msdata:Relationship name="FK_SellItem_Book" msdata:parent="Book" msdata:child="SellItem" msdata:parentkey="ID" msdata:childkey="BookID" msprop:Generator_UserRelationName="FK_SellItem_Book" msprop:Generator_RelationVarName="relationFK_SellItem_Book" msprop:Generator_UserChildTable="SellItem" msprop:Generator_UserParentTable="Book" msprop:Generator_ParentPropName="BookRow" msprop:Generator_ChildPropName="GetSellItemRows" />
  764.       <msdata:Relationship name="FK_SellItem_Sell" msdata:parent="Sell" msdata:child="SellItem" msdata:parentkey="ID" msdata:childkey="SellID" msprop:Generator_UserRelationName="FK_SellItem_Sell" msprop:Generator_RelationVarName="relationFK_SellItem_Sell" msprop:Generator_UserChildTable="SellItem" msprop:Generator_UserParentTable="Sell" msprop:Generator_ParentPropName="SellRow" msprop:Generator_ChildPropName="GetSellItemRows" />
  765.       <msdata:Relationship name="Customer_Sell" msdata:parent="Customer" msdata:child="Sell" msdata:parentkey="ID" msdata:childkey="CustomerID" msprop:Generator_UserRelationName="Customer_Sell" msprop:Generator_RelationVarName="relationCustomer_Sell" msprop:Generator_UserChildTable="Sell" msprop:Generator_UserParentTable="Customer" msprop:Generator_ParentPropName="CustomerRow" msprop:Generator_ChildPropName="GetSellRows" />
  766.     </xs:appinfo>
  767.   </xs:annotation>
  768. </xs:schema>