_Юсов_Владислав_Сергеевич_ИСП_11_18_3DataSet9.xsd 7.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <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">
  3. <xs:annotation>
  4. <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
  5. <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6. <Connections>
  7. <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="Юсов_Владислав_Сергеевич_ИСП_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" />
  8. </Connections>
  9. <Tables>
  10. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Yusov3TableAdapter" GeneratorDataComponentClassName="Yusov3TableAdapter" Name="Yusov3" UserDataComponentName="Yusov3TableAdapter">
  11. <MainSource>
  12. <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">
  13. <InsertCommand>
  14. <DbCommand CommandType="Text" ModifiedByUser="false">
  15. <CommandText>INSERT INTO [dbo].[Yusov3] ([Услуга], [Начало_оказания_услуги], [Клиент]) VALUES (@Услуга, @Начало_оказания_услуги, @Клиент)</CommandText>
  16. <Parameters>
  17. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Услуга" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Услуга" SourceColumnNullMapping="false" SourceVersion="Current" />
  18. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime2" Direction="Input" ParameterName="@Начало_оказания_услуги" Precision="0" ProviderType="DateTime2" Scale="0" Size="0" SourceColumn="Начало_оказания_услуги" SourceColumnNullMapping="false" SourceVersion="Current" />
  19. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Клиент" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Клиент" SourceColumnNullMapping="false" SourceVersion="Current" />
  20. </Parameters>
  21. </DbCommand>
  22. </InsertCommand>
  23. <SelectCommand>
  24. <DbCommand CommandType="Text" ModifiedByUser="false">
  25. <CommandText>SELECT Услуга, Начало_оказания_услуги, Клиент FROM dbo.Yusov3</CommandText>
  26. <Parameters />
  27. </DbCommand>
  28. </SelectCommand>
  29. </DbSource>
  30. </MainSource>
  31. <Mappings>
  32. <Mapping SourceColumn="Услуга" DataSetColumn="Услуга" />
  33. <Mapping SourceColumn="Начало_оказания_услуги" DataSetColumn="Начало_оказания_услуги" />
  34. <Mapping SourceColumn="Клиент" DataSetColumn="Клиент" />
  35. </Mappings>
  36. <Sources />
  37. </TableAdapter>
  38. </Tables>
  39. <Sources />
  40. </DataSource>
  41. </xs:appinfo>
  42. </xs:annotation>
  43. <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">
  44. <xs:complexType>
  45. <xs:choice minOccurs="0" maxOccurs="unbounded">
  46. <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">
  47. <xs:complexType>
  48. <xs:sequence>
  49. <xs:element name="Услуга" msprop:Generator_ColumnVarNameInTable="columnУслуга" msprop:Generator_ColumnPropNameInRow="Услуга" msprop:Generator_ColumnPropNameInTable="УслугаColumn" msprop:Generator_UserColumnName="Услуга" minOccurs="0">
  50. <xs:simpleType>
  51. <xs:restriction base="xs:string">
  52. <xs:maxLength value="50" />
  53. </xs:restriction>
  54. </xs:simpleType>
  55. </xs:element>
  56. <xs:element name="Начало_оказания_услуги" msprop:Generator_ColumnVarNameInTable="columnНачало_оказания_услуги" msprop:Generator_ColumnPropNameInRow="Начало_оказания_услуги" msprop:Generator_ColumnPropNameInTable="Начало_оказания_услугиColumn" msprop:Generator_UserColumnName="Начало_оказания_услуги" type="xs:dateTime" minOccurs="0" />
  57. <xs:element name="Клиент" msprop:Generator_ColumnVarNameInTable="columnКлиент" msprop:Generator_ColumnPropNameInRow="Клиент" msprop:Generator_ColumnPropNameInTable="КлиентColumn" msprop:Generator_UserColumnName="Клиент" minOccurs="0">
  58. <xs:simpleType>
  59. <xs:restriction base="xs:string">
  60. <xs:maxLength value="50" />
  61. </xs:restriction>
  62. </xs:simpleType>
  63. </xs:element>
  64. </xs:sequence>
  65. </xs:complexType>
  66. </xs:element>
  67. </xs:choice>
  68. </xs:complexType>
  69. </xs:element>
  70. </xs:schema>