InversionesDEVDataSet3.xsd 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <xs:schema id="InversionesDEVDataSet3" targetNamespace="http://tempuri.org/InversionesDEVDataSet3.xsd" xmlns:mstns="http://tempuri.org/InversionesDEVDataSet3.xsd" xmlns="http://tempuri.org/InversionesDEVDataSet3.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="MySettings" AppSettingsPropertyName="InversionesConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="InversionesConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Inversiones.My.MySettings.GlobalReference.Default.InversionesConnectionString" Provider="System.Data.SqlClient" />
  8. </Connections>
  9. <Tables>
  10. <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BAN1TableAdapter" GeneratorDataComponentClassName="BAN1TableAdapter" Name="BAN1" UserDataComponentName="BAN1TableAdapter">
  11. <MainSource>
  12. <DbSource ConnectionRef="InversionesConnectionString (MySettings)" DbObjectName="InversionesDEV.dbo.BAN1" 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].[BAN1] ([CodBanco], [CodEmpr], [NumCuenta], [Activo], [NombreCuenta], [TipoCuenta]) VALUES (@CodBanco, @CodEmpr, @NumCuenta, @Activo, @NombreCuenta, @TipoCuenta)</CommandText>
  16. <Parameters>
  17. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodBanco" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodBanco" SourceColumnNullMapping="false" SourceVersion="Current" />
  18. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodEmpr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodEmpr" SourceColumnNullMapping="false" SourceVersion="Current" />
  19. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
  20. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Activo" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Activo" SourceColumnNullMapping="false" SourceVersion="Current" />
  21. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NombreCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NombreCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
  22. <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipoCuenta" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipoCuenta" SourceColumnNullMapping="false" SourceVersion="Current" />
  23. </Parameters>
  24. </DbCommand>
  25. </InsertCommand>
  26. <SelectCommand>
  27. <DbCommand CommandType="Text" ModifiedByUser="false">
  28. <CommandText>SELECT Id, CodBanco, CodEmpr, NumCuenta, Activo, NombreCuenta, TipoCuenta FROM dbo.BAN1</CommandText>
  29. <Parameters />
  30. </DbCommand>
  31. </SelectCommand>
  32. </DbSource>
  33. </MainSource>
  34. <Mappings>
  35. <Mapping SourceColumn="Id" DataSetColumn="Id" />
  36. <Mapping SourceColumn="CodBanco" DataSetColumn="CodBanco" />
  37. <Mapping SourceColumn="CodEmpr" DataSetColumn="CodEmpr" />
  38. <Mapping SourceColumn="NumCuenta" DataSetColumn="NumCuenta" />
  39. <Mapping SourceColumn="Activo" DataSetColumn="Activo" />
  40. <Mapping SourceColumn="NombreCuenta" DataSetColumn="NombreCuenta" />
  41. <Mapping SourceColumn="TipoCuenta" DataSetColumn="TipoCuenta" />
  42. </Mappings>
  43. <Sources />
  44. </TableAdapter>
  45. </Tables>
  46. <Sources />
  47. </DataSource>
  48. </xs:appinfo>
  49. </xs:annotation>
  50. <xs:element name="InversionesDEVDataSet3" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="InversionesDEVDataSet3" msprop:Generator_UserDSName="InversionesDEVDataSet3">
  51. <xs:complexType>
  52. <xs:choice minOccurs="0" maxOccurs="unbounded">
  53. <xs:element name="BAN1" msprop:Generator_TableClassName="BAN1DataTable" msprop:Generator_TableVarName="tableBAN1" msprop:Generator_TablePropName="BAN1" msprop:Generator_RowDeletingName="BAN1RowDeleting" msprop:Generator_RowChangingName="BAN1RowChanging" msprop:Generator_RowEvHandlerName="BAN1RowChangeEventHandler" msprop:Generator_RowDeletedName="BAN1RowDeleted" msprop:Generator_UserTableName="BAN1" msprop:Generator_RowChangedName="BAN1RowChanged" msprop:Generator_RowEvArgName="BAN1RowChangeEvent" msprop:Generator_RowClassName="BAN1Row">
  54. <xs:complexType>
  55. <xs:sequence>
  56. <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
  57. <xs:element name="CodBanco" msprop:Generator_ColumnVarNameInTable="columnCodBanco" msprop:Generator_ColumnPropNameInRow="CodBanco" msprop:Generator_ColumnPropNameInTable="CodBancoColumn" msprop:Generator_UserColumnName="CodBanco" minOccurs="0">
  58. <xs:simpleType>
  59. <xs:restriction base="xs:string">
  60. <xs:maxLength value="30" />
  61. </xs:restriction>
  62. </xs:simpleType>
  63. </xs:element>
  64. <xs:element name="CodEmpr" msprop:Generator_ColumnVarNameInTable="columnCodEmpr" msprop:Generator_ColumnPropNameInRow="CodEmpr" msprop:Generator_ColumnPropNameInTable="CodEmprColumn" msprop:Generator_UserColumnName="CodEmpr" minOccurs="0">
  65. <xs:simpleType>
  66. <xs:restriction base="xs:string">
  67. <xs:maxLength value="10" />
  68. </xs:restriction>
  69. </xs:simpleType>
  70. </xs:element>
  71. <xs:element name="NumCuenta" msprop:Generator_ColumnVarNameInTable="columnNumCuenta" msprop:Generator_ColumnPropNameInRow="NumCuenta" msprop:Generator_ColumnPropNameInTable="NumCuentaColumn" msprop:Generator_UserColumnName="NumCuenta" minOccurs="0">
  72. <xs:simpleType>
  73. <xs:restriction base="xs:string">
  74. <xs:maxLength value="50" />
  75. </xs:restriction>
  76. </xs:simpleType>
  77. </xs:element>
  78. <xs:element name="Activo" msprop:Generator_ColumnVarNameInTable="columnActivo" msprop:Generator_ColumnPropNameInRow="Activo" msprop:Generator_ColumnPropNameInTable="ActivoColumn" msprop:Generator_UserColumnName="Activo" type="xs:boolean" minOccurs="0" />
  79. <xs:element name="NombreCuenta" msprop:Generator_ColumnVarNameInTable="columnNombreCuenta" msprop:Generator_ColumnPropNameInRow="NombreCuenta" msprop:Generator_ColumnPropNameInTable="NombreCuentaColumn" msprop:Generator_UserColumnName="NombreCuenta" minOccurs="0">
  80. <xs:simpleType>
  81. <xs:restriction base="xs:string">
  82. <xs:maxLength value="100" />
  83. </xs:restriction>
  84. </xs:simpleType>
  85. </xs:element>
  86. <xs:element name="TipoCuenta" msprop:Generator_ColumnVarNameInTable="columnTipoCuenta" msprop:Generator_ColumnPropNameInRow="TipoCuenta" msprop:Generator_ColumnPropNameInTable="TipoCuentaColumn" msprop:Generator_UserColumnName="TipoCuenta" minOccurs="0">
  87. <xs:simpleType>
  88. <xs:restriction base="xs:string">
  89. <xs:maxLength value="10" />
  90. </xs:restriction>
  91. </xs:simpleType>
  92. </xs:element>
  93. </xs:sequence>
  94. </xs:complexType>
  95. </xs:element>
  96. </xs:choice>
  97. </xs:complexType>
  98. </xs:element>
  99. </xs:schema>