12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- <?xml version="1.0" encoding="utf-8"?>
- <xs:schema id="_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9" targetNamespace="http://tempuri.org/_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9.xsd" xmlns:mstns="http://tempuri.org/_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9.xsd" xmlns="http://tempuri.org/_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9.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="Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Юсову_Владислав_ИСП_11._18._3.Properties.Settings.GlobalReference.Default.Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString" Provider="System.Data.SqlClient" />
- </Connections>
- <Tables>
- <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Yusov3TableAdapter" GeneratorDataComponentClassName="Yusov3TableAdapter" Name="Yusov3" UserDataComponentName="Yusov3TableAdapter">
- <MainSource>
- <DbSource ConnectionRef="Юсов_Владислав_Сергеевич_ИСП_11_18_3ConnectionString (Settings)" DbObjectName="[Юсов Владислав Сергеевич ИСП 11.18.3].dbo.Yusov3" 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].[Yusov3] ([Услуга], [Начало_оказания_услуги], [Клиент]) VALUES (@Услуга, @Начало_оказания_услуги, @Клиент)</CommandText>
- <Parameters>
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Услуга" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Услуга" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Начало_оказания_услуги" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="Начало_оказания_услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
- <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Клиент" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Клиент" SourceColumnNullMapping="false" SourceVersion="Current" />
- </Parameters>
- </DbCommand>
- </InsertCommand>
- <SelectCommand>
- <DbCommand CommandType="Text" ModifiedByUser="false">
- <CommandText>SELECT Услуга, Начало_оказания_услуги, Клиент FROM dbo.Yusov3</CommandText>
- <Parameters />
- </DbCommand>
- </SelectCommand>
- </DbSource>
- </MainSource>
- <Mappings>
- <Mapping SourceColumn="Услуга" DataSetColumn="Услуга" />
- <Mapping SourceColumn="Начало_оказания_услуги" DataSetColumn="Начало_оказания_услуги" />
- <Mapping SourceColumn="Клиент" DataSetColumn="Клиент" />
- </Mappings>
- <Sources />
- </TableAdapter>
- </Tables>
- <Sources />
- </DataSource>
- </xs:appinfo>
- </xs:annotation>
- <xs:element name="_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9" msprop:Generator_UserDSName="_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="Yusov3" msprop:Generator_TableClassName="Yusov3DataTable" msprop:Generator_TableVarName="tableYusov3" msprop:Generator_TablePropName="Yusov3" msprop:Generator_RowDeletingName="Yusov3RowDeleting" msprop:Generator_RowChangingName="Yusov3RowChanging" msprop:Generator_RowEvHandlerName="Yusov3RowChangeEventHandler" msprop:Generator_RowDeletedName="Yusov3RowDeleted" msprop:Generator_UserTableName="Yusov3" msprop:Generator_RowChangedName="Yusov3RowChanged" msprop:Generator_RowEvArgName="Yusov3RowChangeEvent" msprop:Generator_RowClassName="Yusov3Row">
- <xs:complexType>
- <xs:sequence>
- <xs:element name="Услуга" msprop:Generator_ColumnVarNameInTable="columnУслуга" msprop:Generator_ColumnPropNameInRow="Услуга" msprop:Generator_ColumnPropNameInTable="УслугаColumn" msprop:Generator_UserColumnName="Услуга" minOccurs="0">
- <xs:simpleType>
- <xs:restriction base="xs:string">
- <xs:maxLength value="50" />
- </xs:restriction>
- </xs:simpleType>
- </xs:element>
- <xs:element name="Начало_оказания_услуги" msprop:Generator_ColumnVarNameInTable="columnНачало_оказания_услуги" msprop:Generator_ColumnPropNameInRow="Начало_оказания_услуги" msprop:Generator_ColumnPropNameInTable="Начало_оказания_услугиColumn" msprop:Generator_UserColumnName="Начало_оказания_услуги" type="xs:dateTime" minOccurs="0" />
- <xs:element name="Клиент" msprop:Generator_ColumnVarNameInTable="columnКлиент" msprop:Generator_ColumnPropNameInRow="Клиент" msprop:Generator_ColumnPropNameInTable="КлиентColumn" msprop:Generator_UserColumnName="Клиент" 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:element>
- </xs:schema>
|