<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet2" targetNamespace="http://tempuri.org/DataSet2.xsd" xmlns:mstns="http://tempuri.org/DataSet2.xsd" xmlns="http://tempuri.org/DataSet2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="cbbankConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="cbbankConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WindowsApplication2.Properties.Settings.GlobalReference.Default.cbbankConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="cdTableAdapter" GeneratorDataComponentClassName="cdTableAdapter" Name="cd" UserDataComponentName="cdTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[cd] WHERE (([idCd] = @Original_idCd) AND ([nameCd] = @Original_nameCd) AND ([typeCd] = @Original_typeCd) AND ([rateCd] = @Original_rateCd) AND ([numberCd] = @Original_numberCd) AND ((@IsNull_discription = 1 AND [discription] IS NULL) OR ([discription] = @Original_discription)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_typeCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="typeCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rateCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numberCd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numberCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_discription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="discription" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_discription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="discription" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[cd] ([idCd], [nameCd], [typeCd], [rateCd], [numberCd], [discription]) VALUES (@idCd, @nameCd, @typeCd, @rateCd, @numberCd, @discription);
SELECT idCd, nameCd, typeCd, rateCd, numberCd, discription FROM cd WHERE (idCd = @idCd)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nameCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@typeCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="typeCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rateCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numberCd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numberCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@discription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="discription" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT idCd, nameCd, typeCd, rateCd, numberCd, discription FROM dbo.cd</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[cd] SET [idCd] = @idCd, [nameCd] = @nameCd, [typeCd] = @typeCd, [rateCd] = @rateCd, [numberCd] = @numberCd, [discription] = @discription WHERE (([idCd] = @Original_idCd) AND ([nameCd] = @Original_nameCd) AND ([typeCd] = @Original_typeCd) AND ([rateCd] = @Original_rateCd) AND ([numberCd] = @Original_numberCd) AND ((@IsNull_discription = 1 AND [discription] IS NULL) OR ([discription] = @Original_discription)));
SELECT idCd, nameCd, typeCd, rateCd, numberCd, discription FROM cd WHERE (idCd = @idCd)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nameCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@typeCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="typeCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rateCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@numberCd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numberCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@discription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="discription" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_typeCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="typeCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rateCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_numberCd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numberCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_discription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="discription" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_discription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="discription" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idCd" DataSetColumn="idCd" />
              <Mapping SourceColumn="nameCd" DataSetColumn="nameCd" />
              <Mapping SourceColumn="typeCd" DataSetColumn="typeCd" />
              <Mapping SourceColumn="rateCd" DataSetColumn="rateCd" />
              <Mapping SourceColumn="numberCd" DataSetColumn="numberCd" />
              <Mapping SourceColumn="discription" DataSetColumn="discription" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where nameCd = @name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="nameCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy1" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="FillBy1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where idCd=@id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="idCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy2" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="FillBy2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where nameCd=@name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="nameCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy3" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy3" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="FillBy3">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where typeCd=@type</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="type" ColumnName="typeCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@type" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="typeCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy4" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy4" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="FillBy4">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where numberCd&lt;2</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy5" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy5" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy5" UserSourceName="FillBy5">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where nameCd=@name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="nameCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy6" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy6" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy6" UserSourceName="FillBy6">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where nameCd=@name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="nameCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy7" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy7" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy7" UserSourceName="FillBy7">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idCd, nameCd, typeCd, rateCd, numberCd, discription
FROM         cd
where nameCd=@name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="nameCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy8" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy8" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy8" UserSourceName="FillBy8">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT idCd, nameCd, typeCd, rateCd, numberCd, discription FROM dbo.cd
where nameCd= @n</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="n" ColumnName="nameCd" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@n" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy9" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy9" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy9" UserSourceName="FillBy9">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT idCd, nameCd, typeCd, rateCd, numberCd, discription 
FROM dbo.cd
where discription = @dis</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="dis" ColumnName="discription" DataSourceName="cbbank.dbo.cd" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@dis" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="discription" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="remembersTableAdapter" GeneratorDataComponentClassName="remembersTableAdapter" Name="remembers" UserDataComponentName="remembersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[remembers] WHERE (([idRemember] = @Original_idRemember) AND ([nameRemember] = @Original_nameRemember) AND ([familyRemember] = @Original_familyRemember) AND ((@IsNull_fatherName = 1 AND [fatherName] IS NULL) OR ([fatherName] = @Original_fatherName)) AND ([dateRemember] = @Original_dateRemember) AND ((@IsNull_addressRemember = 1 AND [addressRemember] IS NULL) OR ([addressRemember] = @Original_addressRemember)) AND ((@IsNull_telRemember = 1 AND [telRemember] IS NULL) OR ([telRemember] = @Original_telRemember)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_familyRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fatherName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fatherName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fatherName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fatherName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addressRemember" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addressRemember" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addressRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telRemember" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telRemember" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_telRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[remembers] ([idRemember], [nameRemember], [familyRemember], [fatherName], [dateRemember], [addressRemember], [telRemember]) VALUES (@idRemember, @nameRemember, @familyRemember, @fatherName, @dateRemember, @addressRemember, @telRemember);
SELECT idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember FROM remembers WHERE (idRemember = @idRemember)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nameRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@familyRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fatherName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fatherName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addressRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@telRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember FROM dbo.remembers</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[remembers] SET [idRemember] = @idRemember, [nameRemember] = @nameRemember, [familyRemember] = @familyRemember, [fatherName] = @fatherName, [dateRemember] = @dateRemember, [addressRemember] = @addressRemember, [telRemember] = @telRemember WHERE (([idRemember] = @Original_idRemember) AND ([nameRemember] = @Original_nameRemember) AND ([familyRemember] = @Original_familyRemember) AND ((@IsNull_fatherName = 1 AND [fatherName] IS NULL) OR ([fatherName] = @Original_fatherName)) AND ([dateRemember] = @Original_dateRemember) AND ((@IsNull_addressRemember = 1 AND [addressRemember] IS NULL) OR ([addressRemember] = @Original_addressRemember)) AND ((@IsNull_telRemember = 1 AND [telRemember] IS NULL) OR ([telRemember] = @Original_telRemember)));
SELECT idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember FROM remembers WHERE (idRemember = @idRemember)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nameRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@familyRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fatherName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fatherName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addressRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@telRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_familyRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fatherName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fatherName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_fatherName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fatherName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addressRemember" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addressRemember" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addressRemember" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telRemember" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telRemember" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_telRemember" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="telRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idRemember" DataSetColumn="idRemember" />
              <Mapping SourceColumn="nameRemember" DataSetColumn="nameRemember" />
              <Mapping SourceColumn="familyRemember" DataSetColumn="familyRemember" />
              <Mapping SourceColumn="fatherName" DataSetColumn="fatherName" />
              <Mapping SourceColumn="dateRemember" DataSetColumn="dateRemember" />
              <Mapping SourceColumn="addressRemember" DataSetColumn="addressRemember" />
              <Mapping SourceColumn="telRemember" DataSetColumn="telRemember" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember
FROM         remembers
where idRemember = @id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="idRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy1" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="FillBy1">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember
FROM         remembers
where familyRemember = @family</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="family" ColumnName="familyRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@family" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy2" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="FillBy2">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember
FROM         remembers
where (nameRemember=@name and familyRemember=@family)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="name" ColumnName="nameRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="family" ColumnName="familyRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@family" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy3" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy3" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="FillBy3">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember
FROM         remembers
where idRemember=@id
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="idRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy4" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy4" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy4" UserSourceName="FillBy4">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember
FROM         remembers
where( nameRemember=@n and familyRemember=@f)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="n" ColumnName="nameRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@n" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="f" ColumnName="familyRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@f" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy5" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy5" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy5" UserSourceName="FillBy5">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember
FROM         remembers
where idRemember=@id</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="id" ColumnName="idRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@id" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.remembers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy6" GenerateMethods="Fill" GenerateShortCommands="True" GeneratorSourceName="FillBy6" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy6" UserSourceName="FillBy6">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT     idRemember, nameRemember, familyRemember, fatherName, dateRemember, addressRemember, telRemember
FROM         remembers
where (nameRemember=@n and familyRemember=@f and fatherName=@fn)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="n" ColumnName="nameRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@n" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="nameRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="f" ColumnName="familyRemember" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@f" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="familyRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="fn" ColumnName="fatherName" DataSourceName="cbbank.dbo.remembers" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@fn" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="fatherName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="sellerTableAdapter" GeneratorDataComponentClassName="sellerTableAdapter" Name="seller" UserDataComponentName="sellerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.seller" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[seller] WHERE (([idSeller] = @Original_idSeller) AND ([nameSeller] = @Original_nameSeller) AND ([familySeller] = @Original_familySeller) AND ((@IsNull_telSeller = 1 AND [telSeller] IS NULL) OR ([telSeller] = @Original_telSeller)) AND ((@IsNull_addressSeller = 1 AND [addressSeller] IS NULL) OR ([addressSeller] = @Original_addressSeller)) AND ([dateEmployee] = @Original_dateEmployee))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_familySeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familySeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telSeller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telSeller" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addressSeller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addressSeller" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addressSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateEmployee" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateEmployee" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[seller] ([idSeller], [nameSeller], [familySeller], [telSeller], [addressSeller], [dateEmployee]) VALUES (@idSeller, @nameSeller, @familySeller, @telSeller, @addressSeller, @dateEmployee);
SELECT idSeller, nameSeller, familySeller, telSeller, addressSeller, dateEmployee FROM seller WHERE (idSeller = @idSeller)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nameSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@familySeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familySeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addressSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateEmployee" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateEmployee" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT idSeller, nameSeller, familySeller, telSeller, addressSeller, dateEmployee FROM dbo.seller</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[seller] SET [idSeller] = @idSeller, [nameSeller] = @nameSeller, [familySeller] = @familySeller, [telSeller] = @telSeller, [addressSeller] = @addressSeller, [dateEmployee] = @dateEmployee WHERE (([idSeller] = @Original_idSeller) AND ([nameSeller] = @Original_nameSeller) AND ([familySeller] = @Original_familySeller) AND ((@IsNull_telSeller = 1 AND [telSeller] IS NULL) OR ([telSeller] = @Original_telSeller)) AND ((@IsNull_addressSeller = 1 AND [addressSeller] IS NULL) OR ([addressSeller] = @Original_addressSeller)) AND ([dateEmployee] = @Original_dateEmployee));
SELECT idSeller, nameSeller, familySeller, telSeller, addressSeller, dateEmployee FROM seller WHERE (idSeller = @idSeller)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nameSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@familySeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familySeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@addressSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateEmployee" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateEmployee" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_familySeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="familySeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telSeller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telSeller" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_addressSeller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="addressSeller" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_addressSeller" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="addressSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateEmployee" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateEmployee" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idSeller" DataSetColumn="idSeller" />
              <Mapping SourceColumn="nameSeller" DataSetColumn="nameSeller" />
              <Mapping SourceColumn="familySeller" DataSetColumn="familySeller" />
              <Mapping SourceColumn="telSeller" DataSetColumn="telSeller" />
              <Mapping SourceColumn="addressSeller" DataSetColumn="addressSeller" />
              <Mapping SourceColumn="dateEmployee" DataSetColumn="dateEmployee" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="integrityTableAdapter" GeneratorDataComponentClassName="integrityTableAdapter" Name="integrity" UserDataComponentName="integrityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.integrity" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[integrity] WHERE (([rank] = @Original_rank) AND ([idCd] = @Original_idCd) AND ([idRemember] = @Original_idRemember) AND ([dateIntegrity] = @Original_dateIntegrity) AND ([rateIntergrity] = @Original_rateIntergrity) AND ([idSeller] = @Original_idSeller))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateIntegrity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateIntegrity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rateIntergrity" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateIntergrity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[integrity] ([rank], [idCd], [idRemember], [dateIntegrity], [rateIntergrity], [idSeller]) VALUES (@rank, @idCd, @idRemember, @dateIntegrity, @rateIntergrity, @idSeller);
SELECT rank, idCd, idRemember, dateIntegrity, rateIntergrity, idSeller FROM integrity WHERE (rank = @rank)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateIntegrity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateIntegrity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rateIntergrity" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateIntergrity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT rank, idCd, idRemember, dateIntegrity, rateIntergrity, idSeller FROM dbo.integrity</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[integrity] SET [rank] = @rank, [idCd] = @idCd, [idRemember] = @idRemember, [dateIntegrity] = @dateIntegrity, [rateIntergrity] = @rateIntergrity, [idSeller] = @idSeller WHERE (([rank] = @Original_rank) AND ([idCd] = @Original_idCd) AND ([idRemember] = @Original_idRemember) AND ([dateIntegrity] = @Original_dateIntegrity) AND ([rateIntergrity] = @Original_rateIntergrity) AND ([idSeller] = @Original_idSeller));
SELECT rank, idCd, idRemember, dateIntegrity, rateIntergrity, idSeller FROM integrity WHERE (rank = @rank)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateIntegrity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateIntegrity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rateIntergrity" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateIntergrity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateIntegrity" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateIntegrity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rateIntergrity" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateIntergrity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="rank" DataSetColumn="rank" />
              <Mapping SourceColumn="idCd" DataSetColumn="idCd" />
              <Mapping SourceColumn="idRemember" DataSetColumn="idRemember" />
              <Mapping SourceColumn="dateIntegrity" DataSetColumn="dateIntegrity" />
              <Mapping SourceColumn="rateIntergrity" DataSetColumn="rateIntergrity" />
              <Mapping SourceColumn="idSeller" DataSetColumn="idSeller" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable1TableAdapter" GeneratorDataComponentClassName="DataTable1TableAdapter" Name="DataTable1" UserDataComponentName="DataTable1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectType="Unknown" 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="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     integrity.dateIntegrity, seller.familySeller, cd.nameCd, remembers.nameRemember, remembers.familyRemember, remembers.telRemember, 
                      remembers.addressRemember
FROM         cd INNER JOIN
                      integrity ON cd.idCd = integrity.idCd INNER JOIN
                      seller ON integrity.idSeller = seller.idSeller INNER JOIN
                      remembers ON integrity.idRemember = remembers.idRemember</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="dateIntegrity" DataSetColumn="dateIntegrity" />
              <Mapping SourceColumn="familySeller" DataSetColumn="familySeller" />
              <Mapping SourceColumn="nameCd" DataSetColumn="nameCd" />
              <Mapping SourceColumn="nameRemember" DataSetColumn="nameRemember" />
              <Mapping SourceColumn="familyRemember" DataSetColumn="familyRemember" />
              <Mapping SourceColumn="telRemember" DataSetColumn="telRemember" />
              <Mapping SourceColumn="addressRemember" DataSetColumn="addressRemember" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="penaltyTableAdapter" GeneratorDataComponentClassName="penaltyTableAdapter" Name="penalty" UserDataComponentName="penaltyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.penalty" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[penalty] WHERE (([rank] = @Original_rank) AND ([idRemember] = @Original_idRemember) AND ([datePenalty] = @Original_datePenalty) AND ([ratePenelty] = @Original_ratePenelty))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_datePenalty" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="datePenalty" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ratePenelty" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ratePenelty" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[penalty] ([rank], [idRemember], [datePenalty], [ratePenelty]) VALUES (@rank, @idRemember, @datePenalty, @ratePenelty);
SELECT rank, idRemember, datePenalty, ratePenelty FROM penalty WHERE (rank = @rank)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@datePenalty" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="datePenalty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ratePenelty" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ratePenelty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT rank, idRemember, datePenalty, ratePenelty FROM dbo.penalty</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[penalty] SET [rank] = @rank, [idRemember] = @idRemember, [datePenalty] = @datePenalty, [ratePenelty] = @ratePenelty WHERE (([rank] = @Original_rank) AND ([idRemember] = @Original_idRemember) AND ([datePenalty] = @Original_datePenalty) AND ([ratePenelty] = @Original_ratePenelty));
SELECT rank, idRemember, datePenalty, ratePenelty FROM penalty WHERE (rank = @rank)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@datePenalty" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="datePenalty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ratePenelty" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ratePenelty" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRemember" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRemember" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_datePenalty" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="datePenalty" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ratePenelty" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ratePenelty" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="rank" DataSetColumn="rank" />
              <Mapping SourceColumn="idRemember" DataSetColumn="idRemember" />
              <Mapping SourceColumn="datePenalty" DataSetColumn="datePenalty" />
              <Mapping SourceColumn="ratePenelty" DataSetColumn="ratePenelty" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="salecdTableAdapter" GeneratorDataComponentClassName="salecdTableAdapter" Name="salecd" UserDataComponentName="salecdTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.salecd" 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">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[salecd] WHERE (([rank] = @Original_rank) AND ([idCd] = @Original_idCd) AND ((@IsNull_number = 1 AND [number] IS NULL) OR ([number] = @Original_number)) AND ((@IsNull_idRememmber = 1 AND [idRememmber] IS NULL) OR ([idRememmber] = @Original_idRememmber)) AND ([dateSale] = @Original_dateSale) AND ((@IsNull_idSeller = 1 AND [idSeller] IS NULL) OR ([idSeller] = @Original_idSeller)) AND ([rateSale] = @Original_rateSale))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idRememmber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idRememmber" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRememmber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRememmber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateSale" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateSale" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idSeller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rateSale" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateSale" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[salecd] ([rank], [idCd], [number], [idRememmber], [dateSale], [idSeller], [rateSale]) VALUES (@rank, @idCd, @number, @idRememmber, @dateSale, @idSeller, @rateSale);
SELECT rank, idCd, number, idRememmber, dateSale, idSeller, rateSale FROM salecd WHERE (rank = @rank)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRememmber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRememmber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateSale" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateSale" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rateSale" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateSale" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT rank, idCd, number, idRememmber, dateSale, idSeller, rateSale FROM dbo.salecd</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[salecd] SET [rank] = @rank, [idCd] = @idCd, [number] = @number, [idRememmber] = @idRememmber, [dateSale] = @dateSale, [idSeller] = @idSeller, [rateSale] = @rateSale WHERE (([rank] = @Original_rank) AND ([idCd] = @Original_idCd) AND ((@IsNull_number = 1 AND [number] IS NULL) OR ([number] = @Original_number)) AND ((@IsNull_idRememmber = 1 AND [idRememmber] IS NULL) OR ([idRememmber] = @Original_idRememmber)) AND ([dateSale] = @Original_dateSale) AND ((@IsNull_idSeller = 1 AND [idSeller] IS NULL) OR ([idSeller] = @Original_idSeller)) AND ([rateSale] = @Original_rateSale));
SELECT rank, idCd, number, idRememmber, dateSale, idSeller, rateSale FROM salecd WHERE (rank = @rank)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idRememmber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRememmber" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@dateSale" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateSale" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@rateSale" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateSale" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rank" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rank" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_number" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="number" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idRememmber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idRememmber" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idRememmber" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idRememmber" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_dateSale" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="dateSale" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idSeller" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idSeller" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idSeller" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_rateSale" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="rateSale" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="rank" DataSetColumn="rank" />
              <Mapping SourceColumn="idCd" DataSetColumn="idCd" />
              <Mapping SourceColumn="number" DataSetColumn="number" />
              <Mapping SourceColumn="idRememmber" DataSetColumn="idRememmber" />
              <Mapping SourceColumn="dateSale" DataSetColumn="dateSale" />
              <Mapping SourceColumn="idSeller" DataSetColumn="idSeller" />
              <Mapping SourceColumn="rateSale" DataSetColumn="rateSale" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="cd2TableAdapter" GeneratorDataComponentClassName="cd2TableAdapter" Name="cd2" UserDataComponentName="cd2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="cbbankConnectionString (Settings)" DbObjectName="cbbank.dbo.cd" DbObjectType="Table" 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="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [cd] WHERE (([idCd] = @Original_idCd) AND ([nameCd] = @Original_nameCd))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     idCd, nameCd
FROM         cd</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [cd] SET [idCd] = @idCd, [nameCd] = @nameCd WHERE (([idCd] = @Original_idCd) AND ([nameCd] = @Original_nameCd));
SELECT idCd, nameCd FROM cd WHERE (idCd = @idCd)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nameCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_idCd" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="idCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nameCd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nameCd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="idCd" DataSetColumn="idCd" />
              <Mapping SourceColumn="nameCd" DataSetColumn="nameCd" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DataSet2" msprop:Generator_DataSetName="DataSet2">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="cd" msprop:Generator_UserTableName="cd" msprop:Generator_RowDeletedName="cdRowDeleted" msprop:Generator_RowChangedName="cdRowChanged" msprop:Generator_RowClassName="cdRow" msprop:Generator_RowChangingName="cdRowChanging" msprop:Generator_RowEvArgName="cdRowChangeEvent" msprop:Generator_RowEvHandlerName="cdRowChangeEventHandler" msprop:Generator_TableClassName="cdDataTable" msprop:Generator_TableVarName="tablecd" msprop:Generator_RowDeletingName="cdRowDeleting" msprop:Generator_TablePropName="cd">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idCd" msprop:Generator_UserColumnName="idCd" msprop:Generator_ColumnVarNameInTable="columnidCd" msprop:Generator_ColumnPropNameInRow="idCd" msprop:Generator_ColumnPropNameInTable="idCdColumn" type="xs:long" />
              <xs:element name="nameCd" msprop:Generator_UserColumnName="nameCd" msprop:Generator_ColumnVarNameInTable="columnnameCd" msprop:Generator_ColumnPropNameInRow="nameCd" msprop:Generator_ColumnPropNameInTable="nameCdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="typeCd" msprop:Generator_UserColumnName="typeCd" msprop:Generator_ColumnVarNameInTable="columntypeCd" msprop:Generator_ColumnPropNameInRow="typeCd" msprop:Generator_ColumnPropNameInTable="typeCdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="rateCd" msprop:Generator_UserColumnName="rateCd" msprop:Generator_ColumnVarNameInTable="columnrateCd" msprop:Generator_ColumnPropNameInRow="rateCd" msprop:Generator_ColumnPropNameInTable="rateCdColumn" type="xs:long" />
              <xs:element name="numberCd" msprop:Generator_UserColumnName="numberCd" msprop:Generator_ColumnVarNameInTable="columnnumberCd" msprop:Generator_ColumnPropNameInRow="numberCd" msprop:Generator_ColumnPropNameInTable="numberCdColumn" type="xs:int" />
              <xs:element name="discription" msprop:Generator_UserColumnName="discription" msprop:Generator_ColumnVarNameInTable="columndiscription" msprop:Generator_ColumnPropNameInRow="discription" msprop:Generator_ColumnPropNameInTable="discriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="remembers" msprop:Generator_UserTableName="remembers" msprop:Generator_RowDeletedName="remembersRowDeleted" msprop:Generator_RowChangedName="remembersRowChanged" msprop:Generator_RowClassName="remembersRow" msprop:Generator_RowChangingName="remembersRowChanging" msprop:Generator_RowEvArgName="remembersRowChangeEvent" msprop:Generator_RowEvHandlerName="remembersRowChangeEventHandler" msprop:Generator_TableClassName="remembersDataTable" msprop:Generator_TableVarName="tableremembers" msprop:Generator_RowDeletingName="remembersRowDeleting" msprop:Generator_TablePropName="remembers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idRemember" msprop:Generator_UserColumnName="idRemember" msprop:Generator_ColumnVarNameInTable="columnidRemember" msprop:Generator_ColumnPropNameInRow="idRemember" msprop:Generator_ColumnPropNameInTable="idRememberColumn" type="xs:long" />
              <xs:element name="nameRemember" msprop:Generator_UserColumnName="nameRemember" msprop:Generator_ColumnVarNameInTable="columnnameRemember" msprop:Generator_ColumnPropNameInRow="nameRemember" msprop:Generator_ColumnPropNameInTable="nameRememberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="familyRemember" msprop:Generator_UserColumnName="familyRemember" msprop:Generator_ColumnVarNameInTable="columnfamilyRemember" msprop:Generator_ColumnPropNameInRow="familyRemember" msprop:Generator_ColumnPropNameInTable="familyRememberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fatherName" msprop:Generator_UserColumnName="fatherName" msprop:Generator_ColumnVarNameInTable="columnfatherName" msprop:Generator_ColumnPropNameInRow="fatherName" msprop:Generator_ColumnPropNameInTable="fatherNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateRemember" msprop:Generator_UserColumnName="dateRemember" msprop:Generator_ColumnVarNameInTable="columndateRemember" msprop:Generator_ColumnPropNameInRow="dateRemember" msprop:Generator_ColumnPropNameInTable="dateRememberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="addressRemember" msprop:Generator_UserColumnName="addressRemember" msprop:Generator_ColumnVarNameInTable="columnaddressRemember" msprop:Generator_ColumnPropNameInRow="addressRemember" msprop:Generator_ColumnPropNameInTable="addressRememberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telRemember" msprop:Generator_UserColumnName="telRemember" msprop:Generator_ColumnVarNameInTable="columntelRemember" msprop:Generator_ColumnPropNameInRow="telRemember" msprop:Generator_ColumnPropNameInTable="telRememberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="seller" msprop:Generator_UserTableName="seller" msprop:Generator_RowDeletedName="sellerRowDeleted" msprop:Generator_RowChangedName="sellerRowChanged" msprop:Generator_RowClassName="sellerRow" msprop:Generator_RowChangingName="sellerRowChanging" msprop:Generator_RowEvArgName="sellerRowChangeEvent" msprop:Generator_RowEvHandlerName="sellerRowChangeEventHandler" msprop:Generator_TableClassName="sellerDataTable" msprop:Generator_TableVarName="tableseller" msprop:Generator_RowDeletingName="sellerRowDeleting" msprop:Generator_TablePropName="seller">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idSeller" msprop:Generator_UserColumnName="idSeller" msprop:Generator_ColumnVarNameInTable="columnidSeller" msprop:Generator_ColumnPropNameInRow="idSeller" msprop:Generator_ColumnPropNameInTable="idSellerColumn" type="xs:long" />
              <xs:element name="nameSeller" msprop:Generator_UserColumnName="nameSeller" msprop:Generator_ColumnVarNameInTable="columnnameSeller" msprop:Generator_ColumnPropNameInRow="nameSeller" msprop:Generator_ColumnPropNameInTable="nameSellerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="familySeller" msprop:Generator_UserColumnName="familySeller" msprop:Generator_ColumnVarNameInTable="columnfamilySeller" msprop:Generator_ColumnPropNameInRow="familySeller" msprop:Generator_ColumnPropNameInTable="familySellerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telSeller" msprop:Generator_UserColumnName="telSeller" msprop:Generator_ColumnVarNameInTable="columntelSeller" msprop:Generator_ColumnPropNameInRow="telSeller" msprop:Generator_ColumnPropNameInTable="telSellerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="addressSeller" msprop:Generator_UserColumnName="addressSeller" msprop:Generator_ColumnVarNameInTable="columnaddressSeller" msprop:Generator_ColumnPropNameInRow="addressSeller" msprop:Generator_ColumnPropNameInTable="addressSellerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dateEmployee" msprop:Generator_UserColumnName="dateEmployee" msprop:Generator_ColumnVarNameInTable="columndateEmployee" msprop:Generator_ColumnPropNameInRow="dateEmployee" msprop:Generator_ColumnPropNameInTable="dateEmployeeColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="integrity" msprop:Generator_UserTableName="integrity" msprop:Generator_RowDeletedName="integrityRowDeleted" msprop:Generator_RowChangedName="integrityRowChanged" msprop:Generator_RowClassName="integrityRow" msprop:Generator_RowChangingName="integrityRowChanging" msprop:Generator_RowEvArgName="integrityRowChangeEvent" msprop:Generator_RowEvHandlerName="integrityRowChangeEventHandler" msprop:Generator_TableClassName="integrityDataTable" msprop:Generator_TableVarName="tableintegrity" msprop:Generator_RowDeletingName="integrityRowDeleting" msprop:Generator_TablePropName="integrity">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="rank" msprop:Generator_UserColumnName="rank" msprop:Generator_ColumnPropNameInRow="rank" msprop:Generator_ColumnVarNameInTable="columnrank" msprop:Generator_ColumnPropNameInTable="rankColumn" type="xs:long" />
              <xs:element name="idCd" msprop:Generator_UserColumnName="idCd" msprop:Generator_ColumnPropNameInRow="idCd" msprop:Generator_ColumnVarNameInTable="columnidCd" msprop:Generator_ColumnPropNameInTable="idCdColumn" type="xs:long" />
              <xs:element name="idRemember" msprop:Generator_UserColumnName="idRemember" msprop:Generator_ColumnPropNameInRow="idRemember" msprop:Generator_ColumnVarNameInTable="columnidRemember" msprop:Generator_ColumnPropNameInTable="idRememberColumn" type="xs:long" />
              <xs:element name="dateIntegrity" msprop:Generator_UserColumnName="dateIntegrity" msprop:Generator_ColumnPropNameInRow="dateIntegrity" msprop:Generator_ColumnVarNameInTable="columndateIntegrity" msprop:Generator_ColumnPropNameInTable="dateIntegrityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="rateIntergrity" msprop:Generator_UserColumnName="rateIntergrity" msprop:Generator_ColumnPropNameInRow="rateIntergrity" msprop:Generator_ColumnVarNameInTable="columnrateIntergrity" msprop:Generator_ColumnPropNameInTable="rateIntergrityColumn" type="xs:long" />
              <xs:element name="idSeller" msprop:Generator_UserColumnName="idSeller" msprop:Generator_ColumnPropNameInRow="idSeller" msprop:Generator_ColumnVarNameInTable="columnidSeller" msprop:Generator_ColumnPropNameInTable="idSellerColumn" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DataTable1" msprop:Generator_UserTableName="DataTable1" msprop:Generator_RowDeletedName="DataTable1RowDeleted" msprop:Generator_RowChangedName="DataTable1RowChanged" msprop:Generator_RowClassName="DataTable1Row" msprop:Generator_RowChangingName="DataTable1RowChanging" msprop:Generator_RowEvArgName="DataTable1RowChangeEvent" msprop:Generator_RowEvHandlerName="DataTable1RowChangeEventHandler" msprop:Generator_TableClassName="DataTable1DataTable" msprop:Generator_TableVarName="tableDataTable1" msprop:Generator_RowDeletingName="DataTable1RowDeleting" msprop:Generator_TablePropName="DataTable1">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="dateIntegrity" msprop:Generator_UserColumnName="dateIntegrity" msprop:Generator_ColumnPropNameInRow="dateIntegrity" msprop:Generator_ColumnVarNameInTable="columndateIntegrity" msprop:Generator_ColumnPropNameInTable="dateIntegrityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="familySeller" msprop:Generator_UserColumnName="familySeller" msprop:Generator_ColumnPropNameInRow="familySeller" msprop:Generator_ColumnVarNameInTable="columnfamilySeller" msprop:Generator_ColumnPropNameInTable="familySellerColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nameCd" msprop:Generator_UserColumnName="nameCd" msprop:Generator_ColumnPropNameInRow="nameCd" msprop:Generator_ColumnVarNameInTable="columnnameCd" msprop:Generator_ColumnPropNameInTable="nameCdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nameRemember" msprop:Generator_UserColumnName="nameRemember" msprop:Generator_ColumnPropNameInRow="nameRemember" msprop:Generator_ColumnVarNameInTable="columnnameRemember" msprop:Generator_ColumnPropNameInTable="nameRememberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="familyRemember" msprop:Generator_UserColumnName="familyRemember" msprop:Generator_ColumnPropNameInRow="familyRemember" msprop:Generator_ColumnVarNameInTable="columnfamilyRemember" msprop:Generator_ColumnPropNameInTable="familyRememberColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="telRemember" msprop:Generator_UserColumnName="telRemember" msprop:Generator_ColumnPropNameInRow="telRemember" msprop:Generator_ColumnVarNameInTable="columntelRemember" msprop:Generator_ColumnPropNameInTable="telRememberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="addressRemember" msprop:Generator_UserColumnName="addressRemember" msprop:Generator_ColumnPropNameInRow="addressRemember" msprop:Generator_ColumnVarNameInTable="columnaddressRemember" msprop:Generator_ColumnPropNameInTable="addressRememberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="penalty" msprop:Generator_UserTableName="penalty" msprop:Generator_RowDeletedName="penaltyRowDeleted" msprop:Generator_RowChangedName="penaltyRowChanged" msprop:Generator_RowClassName="penaltyRow" msprop:Generator_RowChangingName="penaltyRowChanging" msprop:Generator_RowEvArgName="penaltyRowChangeEvent" msprop:Generator_RowEvHandlerName="penaltyRowChangeEventHandler" msprop:Generator_TableClassName="penaltyDataTable" msprop:Generator_TableVarName="tablepenalty" msprop:Generator_RowDeletingName="penaltyRowDeleting" msprop:Generator_TablePropName="penalty">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="rank" msprop:Generator_UserColumnName="rank" msprop:Generator_ColumnPropNameInRow="rank" msprop:Generator_ColumnVarNameInTable="columnrank" msprop:Generator_ColumnPropNameInTable="rankColumn" type="xs:long" />
              <xs:element name="idRemember" msprop:Generator_UserColumnName="idRemember" msprop:Generator_ColumnPropNameInRow="idRemember" msprop:Generator_ColumnVarNameInTable="columnidRemember" msprop:Generator_ColumnPropNameInTable="idRememberColumn" type="xs:long" />
              <xs:element name="datePenalty" msprop:Generator_UserColumnName="datePenalty" msprop:Generator_ColumnPropNameInRow="datePenalty" msprop:Generator_ColumnVarNameInTable="columndatePenalty" msprop:Generator_ColumnPropNameInTable="datePenaltyColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ratePenelty" msprop:Generator_UserColumnName="ratePenelty" msprop:Generator_ColumnPropNameInRow="ratePenelty" msprop:Generator_ColumnVarNameInTable="columnratePenelty" msprop:Generator_ColumnPropNameInTable="ratePeneltyColumn" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="salecd" msprop:Generator_UserTableName="salecd" msprop:Generator_RowDeletedName="salecdRowDeleted" msprop:Generator_RowChangedName="salecdRowChanged" msprop:Generator_RowClassName="salecdRow" msprop:Generator_RowChangingName="salecdRowChanging" msprop:Generator_RowEvArgName="salecdRowChangeEvent" msprop:Generator_RowEvHandlerName="salecdRowChangeEventHandler" msprop:Generator_TableClassName="salecdDataTable" msprop:Generator_TableVarName="tablesalecd" msprop:Generator_RowDeletingName="salecdRowDeleting" msprop:Generator_TablePropName="salecd">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="rank" msprop:Generator_UserColumnName="rank" msprop:Generator_ColumnPropNameInRow="rank" msprop:Generator_ColumnVarNameInTable="columnrank" msprop:Generator_ColumnPropNameInTable="rankColumn" type="xs:long" />
              <xs:element name="idCd" msprop:Generator_UserColumnName="idCd" msprop:Generator_ColumnPropNameInRow="idCd" msprop:Generator_ColumnVarNameInTable="columnidCd" msprop:Generator_ColumnPropNameInTable="idCdColumn" type="xs:long" />
              <xs:element name="number" msprop:Generator_UserColumnName="number" msprop:Generator_ColumnPropNameInRow="number" msprop:Generator_ColumnVarNameInTable="columnnumber" msprop:Generator_ColumnPropNameInTable="numberColumn" type="xs:int" minOccurs="0" />
              <xs:element name="idRememmber" msprop:Generator_UserColumnName="idRememmber" msprop:Generator_ColumnPropNameInRow="idRememmber" msprop:Generator_ColumnVarNameInTable="columnidRememmber" msprop:Generator_ColumnPropNameInTable="idRememmberColumn" type="xs:long" minOccurs="0" />
              <xs:element name="dateSale" msprop:Generator_UserColumnName="dateSale" msprop:Generator_ColumnPropNameInRow="dateSale" msprop:Generator_ColumnVarNameInTable="columndateSale" msprop:Generator_ColumnPropNameInTable="dateSaleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="idSeller" msprop:Generator_UserColumnName="idSeller" msprop:Generator_ColumnPropNameInRow="idSeller" msprop:Generator_ColumnVarNameInTable="columnidSeller" msprop:Generator_ColumnPropNameInTable="idSellerColumn" type="xs:long" minOccurs="0" />
              <xs:element name="rateSale" msprop:Generator_UserColumnName="rateSale" msprop:Generator_ColumnPropNameInRow="rateSale" msprop:Generator_ColumnVarNameInTable="columnrateSale" msprop:Generator_ColumnPropNameInTable="rateSaleColumn" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="cd2" msprop:Generator_UserTableName="cd2" msprop:Generator_RowDeletedName="cd2RowDeleted" msprop:Generator_RowChangedName="cd2RowChanged" msprop:Generator_RowClassName="cd2Row" msprop:Generator_RowChangingName="cd2RowChanging" msprop:Generator_RowEvArgName="cd2RowChangeEvent" msprop:Generator_RowEvHandlerName="cd2RowChangeEventHandler" msprop:Generator_TableClassName="cd2DataTable" msprop:Generator_TableVarName="tablecd2" msprop:Generator_RowDeletingName="cd2RowDeleting" msprop:Generator_TablePropName="cd2">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="idCd" msprop:Generator_UserColumnName="idCd" msprop:Generator_ColumnVarNameInTable="columnidCd" msprop:Generator_ColumnPropNameInRow="idCd" msprop:Generator_ColumnPropNameInTable="idCdColumn" type="xs:long" />
              <xs:element name="nameCd" msprop:Generator_UserColumnName="nameCd" msprop:Generator_ColumnVarNameInTable="columnnameCd" msprop:Generator_ColumnPropNameInRow="nameCd" msprop:Generator_ColumnPropNameInTable="nameCdColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:cd" />
      <xs:field xpath="mstns:idCd" />
    </xs:unique>
    <xs:unique name="remembers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:remembers" />
      <xs:field xpath="mstns:idRemember" />
    </xs:unique>
    <xs:unique name="seller_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:seller" />
      <xs:field xpath="mstns:idSeller" />
    </xs:unique>
    <xs:unique name="integrity_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:integrity" />
      <xs:field xpath="mstns:rank" />
    </xs:unique>
    <xs:unique name="penalty_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:penalty" />
      <xs:field xpath="mstns:rank" />
    </xs:unique>
    <xs:unique name="salecd_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:salecd" />
      <xs:field xpath="mstns:rank" />
    </xs:unique>
    <xs:unique name="cd2_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:cd2" />
      <xs:field xpath="mstns:idCd" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_integrity_cd" msdata:parent="cd" msdata:child="integrity" msdata:parentkey="idCd" msdata:childkey="idCd" msprop:Generator_UserRelationName="FK_integrity_cd" msprop:Generator_RelationVarName="relationFK_integrity_cd" msprop:Generator_UserChildTable="integrity" msprop:Generator_UserParentTable="cd" msprop:Generator_ParentPropName="cdRow" msprop:Generator_ChildPropName="GetintegrityRows" />
      <msdata:Relationship name="FK_integrity_remembers" msdata:parent="remembers" msdata:child="integrity" msdata:parentkey="idRemember" msdata:childkey="idRemember" msprop:Generator_UserRelationName="FK_integrity_remembers" msprop:Generator_RelationVarName="relationFK_integrity_remembers" msprop:Generator_UserChildTable="integrity" msprop:Generator_UserParentTable="remembers" msprop:Generator_ParentPropName="remembersRow" msprop:Generator_ChildPropName="GetintegrityRows" />
      <msdata:Relationship name="FK_integrity_seller" msdata:parent="seller" msdata:child="integrity" msdata:parentkey="idSeller" msdata:childkey="idSeller" msprop:Generator_UserRelationName="FK_integrity_seller" msprop:Generator_RelationVarName="relationFK_integrity_seller" msprop:Generator_UserChildTable="integrity" msprop:Generator_UserParentTable="seller" msprop:Generator_ParentPropName="sellerRow" msprop:Generator_ChildPropName="GetintegrityRows" />
      <msdata:Relationship name="FK_penalty_remembers" msdata:parent="remembers" msdata:child="penalty" msdata:parentkey="idRemember" msdata:childkey="idRemember" msprop:Generator_UserRelationName="FK_penalty_remembers" msprop:Generator_RelationVarName="relationFK_penalty_remembers" msprop:Generator_UserChildTable="penalty" msprop:Generator_UserParentTable="remembers" msprop:Generator_ParentPropName="remembersRow" msprop:Generator_ChildPropName="GetpenaltyRows" />
      <msdata:Relationship name="FK_salecd_cd" msdata:parent="cd" msdata:child="salecd" msdata:parentkey="idCd" msdata:childkey="idCd" msprop:Generator_UserRelationName="FK_salecd_cd" msprop:Generator_RelationVarName="relationFK_salecd_cd" msprop:Generator_UserChildTable="salecd" msprop:Generator_UserParentTable="cd" msprop:Generator_ParentPropName="cdRow" msprop:Generator_ChildPropName="GetsalecdRows" />
      <msdata:Relationship name="FK_salecd_remembers" msdata:parent="remembers" msdata:child="salecd" msdata:parentkey="idRemember" msdata:childkey="idRememmber" msprop:Generator_UserRelationName="FK_salecd_remembers" msprop:Generator_RelationVarName="relationFK_salecd_remembers" msprop:Generator_UserChildTable="salecd" msprop:Generator_UserParentTable="remembers" msprop:Generator_ParentPropName="remembersRow" msprop:Generator_ChildPropName="GetsalecdRows" />
      <msdata:Relationship name="FK_salecd_seller" msdata:parent="seller" msdata:child="salecd" msdata:parentkey="idSeller" msdata:childkey="idSeller" msprop:Generator_UserRelationName="FK_salecd_seller" msprop:Generator_RelationVarName="relationFK_salecd_seller" msprop:Generator_UserChildTable="salecd" msprop:Generator_UserParentTable="seller" msprop:Generator_ParentPropName="sellerRow" msprop:Generator_ChildPropName="GetsalecdRows" />
      <msdata:Relationship name="FK_integrity_cd2" msdata:parent="cd2" msdata:child="integrity" msdata:parentkey="idCd" msdata:childkey="idCd" msprop:Generator_UserRelationName="FK_integrity_cd2" msprop:Generator_RelationVarName="relationFK_integrity_cd2" msprop:Generator_UserChildTable="integrity" msprop:Generator_UserParentTable="cd2" msprop:Generator_ParentPropName="cd2Row" msprop:Generator_ChildPropName="GetintegrityRows" />
      <msdata:Relationship name="FK_salecd_cd2" msdata:parent="cd2" msdata:child="salecd" msdata:parentkey="idCd" msdata:childkey="idCd" msprop:Generator_UserRelationName="FK_salecd_cd2" msprop:Generator_RelationVarName="relationFK_salecd_cd2" msprop:Generator_UserChildTable="salecd" msprop:Generator_UserParentTable="cd2" msprop:Generator_ParentPropName="cd2Row" msprop:Generator_ChildPropName="GetsalecdRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>