ARABOSIK/Школа_языковDataSet.xsd

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Школа_языковDataSet" targetNamespace="http://tempuri.org/Школа_языковDataSet.xsd" xmlns:mstns="http://tempuri.org/Школа_языковDataSet.xsd" xmlns="http://tempuri.org/Школа_языковDataSet.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="Школа_языковConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Школа_языковConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Демо.Properties.Settings.GlobalReference.Default.Школа_языковConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="АдминистраторыTableAdapter" GeneratorDataComponentClassName="АдминистраторыTableAdapter" Name="Администраторы" UserDataComponentName="АдминистраторыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Школа_языковConnectionString (Settings)" DbObjectName="[Школа языков].dbo.Администраторы" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Администраторы] WHERE (([Фамилия] = @Original_Фамилия) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Почта = 1 AND [Почта] IS NULL) OR ([Почта] = @Original_Почта)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Почта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Почта" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Почта" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Почта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Администраторы] ([Фамилия], [Имя], [Отчество], [Почта], [Пароль]) VALUES (@Фамилия, @Имя, @Отчество, @Почта, @Пароль);
SELECT Фамилия, Имя, Отчество, Почта, Пароль FROM Администраторы WHERE (Фамилия = @Фамилия)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Почта" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Почта" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Фамилия, Имя, Отчество, Почта, Пароль FROM dbo.Администраторы</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Администраторы] SET [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [Почта] = @Почта, [Пароль] = @Пароль WHERE (([Фамилия] = @Original_Фамилия) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Почта = 1 AND [Почта] IS NULL) OR ([Почта] = @Original_Почта)) AND ((@IsNull_Пароль = 1 AND [Пароль] IS NULL) OR ([Пароль] = @Original_Пароль)));
SELECT Фамилия, Имя, Отчество, Почта, Пароль FROM Администраторы WHERE (Фамилия = @Фамилия)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Почта" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Почта" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Пароль" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Почта" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Почта" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Почта" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Почта" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пароль" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Пароль" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пароль" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Почта" DataSetColumn="Почта" />
              <Mapping SourceColumn="Пароль" DataSetColumn="Пароль" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ЗаписиTableAdapter" GeneratorDataComponentClassName="ЗаписиTableAdapter" Name="Записи" UserDataComponentName="ЗаписиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Школа_языковConnectionString (Settings)" DbObjectName="[Школа языков].dbo.Записи" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Записи] ([Клиент], [Услуга], [Время]) VALUES (@Клиент, @Услуга, @Время)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Клиент" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Клиент" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Услуга" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Услуга" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Время" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Время" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Клиент, Услуга, Время FROM dbo.Записи</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Клиент" DataSetColumn="Клиент" />
              <Mapping SourceColumn="Услуга" DataSetColumn="Услуга" />
              <Mapping SourceColumn="Время" DataSetColumn="Время" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="КлиентыTableAdapter" GeneratorDataComponentClassName="КлиентыTableAdapter" Name="Клиенты" UserDataComponentName="КлиентыTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Школа_языковConnectionString (Settings)" DbObjectName="[Школа языков].dbo.Клиенты" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Клиенты] WHERE (([Фамилия] = @Original_Фамилия) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Дата_рождения = 1 AND [Дата_рождения] IS NULL) OR ([Дата_рождения] = @Original_Дата_рождения)) AND ((@IsNull_Дата_регистрации = 1 AND [Дата_регистрации] IS NULL) OR ([Дата_регистрации] = @Original_Дата_регистрации)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)) AND ((@IsNull_Пол = 1 AND [Пол] IS NULL) OR ([Пол] = @Original_Пол)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_рождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_регистрации" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_регистрации" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_регистрации" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_регистрации" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Телефон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пол" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пол" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Пол" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пол" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Клиенты] ([Фамилия], [Имя], [Отчество], [Дата_рождения], [Дата_регистрации], [Email], [Телефон], [Пол]) VALUES (@Фамилия, @Имя, @Отчество, @Дата_рождения, @Дата_регистрации, @Email, @Телефон, @Пол);
SELECT Фамилия, Имя, Отчество, Дата_рождения, Дата_регистрации, Email, Телефон, Пол FROM Клиенты WHERE (Фамилия = @Фамилия)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_регистрации" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_регистрации" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Пол" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пол" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Фамилия, Имя, Отчество, Дата_рождения, Дата_регистрации, Email, Телефон, Пол FROM dbo.Клиенты</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Клиенты] SET [Фамилия] = @Фамилия, [Имя] = @Имя, [Отчество] = @Отчество, [Дата_рождения] = @Дата_рождения, [Дата_регистрации] = @Дата_регистрации, [Email] = @Email, [Телефон] = @Телефон, [Пол] = @Пол WHERE (([Фамилия] = @Original_Фамилия) AND ((@IsNull_Имя = 1 AND [Имя] IS NULL) OR ([Имя] = @Original_Имя)) AND ((@IsNull_Отчество = 1 AND [Отчество] IS NULL) OR ([Отчество] = @Original_Отчество)) AND ((@IsNull_Дата_рождения = 1 AND [Дата_рождения] IS NULL) OR ([Дата_рождения] = @Original_Дата_рождения)) AND ((@IsNull_Дата_регистрации = 1 AND [Дата_регистрации] IS NULL) OR ([Дата_регистрации] = @Original_Дата_регистрации)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_Телефон = 1 AND [Телефон] IS NULL) OR ([Телефон] = @Original_Телефон)) AND ((@IsNull_Пол = 1 AND [Пол] IS NULL) OR ([Пол] = @Original_Пол)));
SELECT Фамилия, Имя, Отчество, Дата_рождения, Дата_регистрации, Email, Телефон, Пол FROM Клиенты WHERE (Фамилия = @Фамилия)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Дата_регистрации" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_регистрации" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Телефон" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Пол" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пол" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Фамилия" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Фамилия" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Имя" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Имя" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Имя" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Отчество" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Отчество" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Отчество" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_рождения" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_рождения" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_рождения" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Дата_регистрации" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Дата_регистрации" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_Дата_регистрации" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="Дата_регистрации" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Телефон" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Телефон" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Телефон" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Пол" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Пол" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Пол" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Пол" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Фамилия" DataSetColumn="Фамилия" />
              <Mapping SourceColumn="Имя" DataSetColumn="Имя" />
              <Mapping SourceColumn="Отчество" DataSetColumn="Отчество" />
              <Mapping SourceColumn="Дата_рождения" DataSetColumn="Дата_рождения" />
              <Mapping SourceColumn="Дата_регистрации" DataSetColumn="Дата_регистрации" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Телефон" DataSetColumn="Телефон" />
              <Mapping SourceColumn="Пол" DataSetColumn="Пол" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="УслугиTableAdapter" GeneratorDataComponentClassName="УслугиTableAdapter" Name="Услуги" UserDataComponentName="УслугиTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="Школа_языковConnectionString (Settings)" DbObjectName="[Школа языков].dbo.Услуги" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Услуги] WHERE (([Наименование] = @Original_Наименование) AND ((@IsNull_Длительность_мин = 1 AND [Длительность_мин] IS NULL) OR ([Длительность_мин] = @Original_Длительность_мин)) AND ((@IsNull_Стоимость_руб = 1 AND [Стоимость_руб] IS NULL) OR ([Стоимость_руб] = @Original_Стоимость_руб)) AND ((@IsNull_Скидка = 1 AND [Скидка] IS NULL) OR ([Скидка] = @Original_Скидка)) AND ((@IsNull_Изображение = 1 AND [Изображение] IS NULL) OR ([Изображение] = @Original_Изображение)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Длительность_мин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длительность_мин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Длительность_мин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длительность_мин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Стоимость_руб" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость_руб" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Стоимость_руб" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость_руб" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Скидка" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Скидка" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Скидка" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Изображение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Изображение" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Услуги] ([Наименование], [Длительность_мин], [Стоимость_руб], [Скидка], [Изображение]) VALUES (@Наименование, @Длительность_мин, @Стоимость_руб, @Скидка, @Изображение);
SELECT Наименование, Длительность_мин, Стоимость_руб, Скидка, Изображение FROM Услуги WHERE (Наименование = @Наименование)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Длительность_мин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длительность_мин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Стоимость_руб" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость_руб" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Скидка" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Скидка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Наименование, Длительность_мин, Стоимость_руб, Скидка, Изображение FROM dbo.Услуги</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Услуги] SET [Наименование] = @Наименование, [Длительность_мин] = @Длительность_мин, [Стоимость_руб] = @Стоимость_руб, [Скидка] = @Скидка, [Изображение] = @Изображение WHERE (([Наименование] = @Original_Наименование) AND ((@IsNull_Длительность_мин = 1 AND [Длительность_мин] IS NULL) OR ([Длительность_мин] = @Original_Длительность_мин)) AND ((@IsNull_Стоимость_руб = 1 AND [Стоимость_руб] IS NULL) OR ([Стоимость_руб] = @Original_Стоимость_руб)) AND ((@IsNull_Скидка = 1 AND [Скидка] IS NULL) OR ([Скидка] = @Original_Скидка)) AND ((@IsNull_Изображение = 1 AND [Изображение] IS NULL) OR ([Изображение] = @Original_Изображение)));
SELECT Наименование, Длительность_мин, Стоимость_руб, Скидка, Изображение FROM Услуги WHERE (Наименование = @Наименование)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Наименование" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Длительность_мин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длительность_мин" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Стоимость_руб" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость_руб" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Скидка" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Скидка" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Изображение" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Наименование" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Наименование" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Длительность_мин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длительность_мин" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Длительность_мин" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Длительность_мин" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Стоимость_руб" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость_руб" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Стоимость_руб" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Стоимость_руб" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Скидка" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Скидка" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Скидка" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Скидка" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Изображение" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Изображение" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Изображение" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Наименование" DataSetColumn="Наименование" />
              <Mapping SourceColumn="Длительность_мин" DataSetColumn="Длительность_мин" />
              <Mapping SourceColumn="Стоимость_руб" DataSetColumn="Стоимость_руб" />
              <Mapping SourceColumn="Скидка" DataSetColumn="Скидка" />
              <Mapping SourceColumn="Изображение" DataSetColumn="Изображение" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="Школа_языковConnectionString (Settings)" DbObjectName="[Школа языков].dbo.Услуги" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Наименование, Длительность_мин, Стоимость_руб, Скидка, Изображение FROM dbo.Услуги</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Школа_языковDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="Школа_языковDataSet" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="Школа_языковDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Администраторы" msprop:Generator_RowClassName="АдминистраторыRow" msprop:Generator_RowEvHandlerName="АдминистраторыRowChangeEventHandler" msprop:Generator_RowDeletedName="АдминистраторыRowDeleted" msprop:Generator_RowDeletingName="АдминистраторыRowDeleting" msprop:Generator_RowEvArgName="АдминистраторыRowChangeEvent" msprop:Generator_TablePropName="Администраторы" msprop:Generator_RowChangedName="АдминистраторыRowChanged" msprop:Generator_UserTableName="Администраторы" msprop:Generator_RowChangingName="АдминистраторыRowChanging" msprop:Generator_TableClassName="АдминистраторыDataTable" msprop:Generator_TableVarName="tableАдминистраторы">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Фамилия" msprop:Generator_UserColumnName="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Имя" msprop:Generator_UserColumnName="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Отчество" msprop:Generator_UserColumnName="Отчество" msprop:Generator_ColumnPropNameInTable="ОтчествоColumn" msprop:Generator_ColumnPropNameInRow="Отчество" msprop:Generator_ColumnVarNameInTable="columnОтчество" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Почта" msprop:Generator_UserColumnName="Почта" msprop:Generator_ColumnPropNameInTable="ПочтаColumn" msprop:Generator_ColumnPropNameInRow="Почта" msprop:Generator_ColumnVarNameInTable="columnПочта" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Пароль" msprop:Generator_UserColumnName="Пароль" msprop:Generator_ColumnPropNameInTable="ПарольColumn" msprop:Generator_ColumnPropNameInRow="Пароль" msprop:Generator_ColumnVarNameInTable="columnПароль" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Записи" msprop:Generator_RowClassName="ЗаписиRow" msprop:Generator_RowEvHandlerName="ЗаписиRowChangeEventHandler" msprop:Generator_RowDeletedName="ЗаписиRowDeleted" msprop:Generator_RowDeletingName="ЗаписиRowDeleting" msprop:Generator_RowEvArgName="ЗаписиRowChangeEvent" msprop:Generator_TablePropName="Записи" msprop:Generator_RowChangedName="ЗаписиRowChanged" msprop:Generator_UserTableName="Записи" msprop:Generator_RowChangingName="ЗаписиRowChanging" msprop:Generator_TableClassName="ЗаписиDataTable" msprop:Generator_TableVarName="tableЗаписи">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Клиент" msprop:Generator_UserColumnName="Клиент" msprop:Generator_ColumnPropNameInTable="КлиентColumn" msprop:Generator_ColumnPropNameInRow="Клиент" msprop:Generator_ColumnVarNameInTable="columnКлиент" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Услуга" msprop:Generator_UserColumnName="Услуга" msprop:Generator_ColumnPropNameInTable="УслугаColumn" msprop:Generator_ColumnPropNameInRow="Услуга" msprop:Generator_ColumnVarNameInTable="columnУслуга" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Время" msprop:Generator_UserColumnName="Время" msprop:Generator_ColumnPropNameInTable="ВремяColumn" msprop:Generator_ColumnPropNameInRow="Время" msprop:Generator_ColumnVarNameInTable="columnВремя" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Клиенты" msprop:Generator_RowClassName="КлиентыRow" msprop:Generator_RowEvHandlerName="КлиентыRowChangeEventHandler" msprop:Generator_RowDeletedName="КлиентыRowDeleted" msprop:Generator_RowDeletingName="КлиентыRowDeleting" msprop:Generator_RowEvArgName="КлиентыRowChangeEvent" msprop:Generator_TablePropName="Клиенты" msprop:Generator_RowChangedName="КлиентыRowChanged" msprop:Generator_UserTableName="Клиенты" msprop:Generator_RowChangingName="КлиентыRowChanging" msprop:Generator_TableClassName="КлиентыDataTable" msprop:Generator_TableVarName="tableКлиенты">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Фамилия" msprop:Generator_UserColumnName="Фамилия" msprop:Generator_ColumnPropNameInTable="ФамилияColumn" msprop:Generator_ColumnPropNameInRow="Фамилия" msprop:Generator_ColumnVarNameInTable="columnФамилия">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Имя" msprop:Generator_UserColumnName="Имя" msprop:Generator_ColumnPropNameInTable="ИмяColumn" msprop:Generator_ColumnPropNameInRow="Имя" msprop:Generator_ColumnVarNameInTable="columnИмя" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Отчество" msprop:Generator_UserColumnName="Отчество" msprop:Generator_ColumnPropNameInTable="ОтчествоColumn" msprop:Generator_ColumnPropNameInRow="Отчество" msprop:Generator_ColumnVarNameInTable="columnОтчество" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Дата_рождения" msprop:Generator_UserColumnName="Дата_рождения" msprop:Generator_ColumnPropNameInTable="Дата_рожденияColumn" msprop:Generator_ColumnPropNameInRow="Дата_рождения" msprop:Generator_ColumnVarNameInTable="columnДата_рождения" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Дата_регистрации" msprop:Generator_UserColumnName="Дата_регистрации" msprop:Generator_ColumnPropNameInTable="Дата_регистрацииColumn" msprop:Generator_ColumnPropNameInRow="Дата_регистрации" msprop:Generator_ColumnVarNameInTable="columnДата_регистрации" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Телефон" msprop:Generator_UserColumnName="Телефон" msprop:Generator_ColumnPropNameInTable="ТелефонColumn" msprop:Generator_ColumnPropNameInRow="Телефон" msprop:Generator_ColumnVarNameInTable="columnТелефон" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Пол" msprop:Generator_UserColumnName="Пол" msprop:Generator_ColumnPropNameInTable="ПолColumn" msprop:Generator_ColumnPropNameInRow="Пол" msprop:Generator_ColumnVarNameInTable="columnПол" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Услуги" msprop:Generator_RowClassName="УслугиRow" msprop:Generator_RowEvHandlerName="УслугиRowChangeEventHandler" msprop:Generator_RowDeletedName="УслугиRowDeleted" msprop:Generator_RowDeletingName="УслугиRowDeleting" msprop:Generator_RowEvArgName="УслугиRowChangeEvent" msprop:Generator_TablePropName="Услуги" msprop:Generator_RowChangedName="УслугиRowChanged" msprop:Generator_UserTableName="Услуги" msprop:Generator_RowChangingName="УслугиRowChanging" msprop:Generator_TableClassName="УслугиDataTable" msprop:Generator_TableVarName="tableУслуги">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Наименование" msprop:Generator_UserColumnName="Наименование" msprop:Generator_ColumnPropNameInTable="НаименованиеColumn" msprop:Generator_ColumnPropNameInRow="Наименование" msprop:Generator_ColumnVarNameInTable="columnНаименование">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Длительность_мин" msprop:Generator_UserColumnName="Длительность_мин" msprop:Generator_ColumnPropNameInTable="Длительность_минColumn" msprop:Generator_ColumnPropNameInRow="Длительность_мин" msprop:Generator_ColumnVarNameInTable="columnДлительность_мин" type="xs:int" minOccurs="0" />
              <xs:element name="Стоимость_руб" msprop:Generator_UserColumnName="Стоимость_руб" msprop:Generator_ColumnPropNameInTable="Стоимость_рубColumn" msprop:Generator_ColumnPropNameInRow="Стоимость_руб" msprop:Generator_ColumnVarNameInTable="columnСтоимость_руб" type="xs:int" minOccurs="0" />
              <xs:element name="Скидка" msprop:Generator_UserColumnName="Скидка" msprop:Generator_ColumnPropNameInTable="СкидкаColumn" msprop:Generator_ColumnPropNameInRow="Скидка" msprop:Generator_ColumnVarNameInTable="columnСкидка" type="xs:double" minOccurs="0" />
              <xs:element name="Изображение" msprop:Generator_UserColumnName="Изображение" msprop:Generator_ColumnPropNameInTable="ИзображениеColumn" msprop:Generator_ColumnPropNameInRow="Изображение" msprop:Generator_ColumnVarNameInTable="columnИзображение" 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:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Администраторы" />
      <xs:field xpath="mstns:Фамилия" />
    </xs:unique>
    <xs:unique name="Клиенты_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Клиенты" />
      <xs:field xpath="mstns:Фамилия" />
    </xs:unique>
    <xs:unique name="Услуги_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Услуги" />
      <xs:field xpath="mstns:Наименование" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Записи_Клиенты" msdata:parent="Клиенты" msdata:child="Записи" msdata:parentkey="Фамилия" msdata:childkey="Клиент" msprop:Generator_UserParentTable="Клиенты" msprop:Generator_UserChildTable="Записи" msprop:Generator_RelationVarName="relationFK_Записи_Клиенты" msprop:Generator_ChildPropName="GetЗаписиRows" msprop:Generator_ParentPropName="КлиентыRow" msprop:Generator_UserRelationName="FK_Записи_Клиенты" />
      <msdata:Relationship name="FK_Записи_Услуги" msdata:parent="Услуги" msdata:child="Записи" msdata:parentkey="Наименование" msdata:childkey="Услуга" msprop:Generator_UserParentTable="Услуги" msprop:Generator_UserChildTable="Записи" msprop:Generator_RelationVarName="relationFK_Записи_Услуги" msprop:Generator_ChildPropName="GetЗаписиRows" msprop:Generator_ParentPropName="УслугиRow" msprop:Generator_UserRelationName="FK_Записи_Услуги" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>