1<?xml version="1.0" encoding="utf-8"?>
 2<xs:schema id="HotelDataSet" targetNamespace="http://tempuri.org/HotelDataSet.xsd" xmlns:mstns="http://tempuri.org/HotelDataSet.xsd" xmlns="http://tempuri.org/HotelDataSet.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="Web.config" AppSettingsPropertyName="HotelConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HotelConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.HotelConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
 8        </Connections>
 9        <Tables>
10          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="view_reportTableAdapter" Name="view_report">
11            <MainSource>
12              <DbSource ConnectionRef="HotelConnectionString (Web.config)" DbObjectName="Hotel.dbo.view_report" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false">
13                <SelectCommand>
14                  <DbCommand CommandType="Text" ModifiedByUser="false">
15                    <CommandText>SELECT UserName, Number, TypeName, TypePrice, AddBedPrice, tatal FROM dbo.view_report</CommandText>
16                    <Parameters />
17                  </DbCommand>
18                </SelectCommand>
19              </DbSource>
20            </MainSource>
21            <Mappings>
22              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
23              <Mapping SourceColumn="Number" DataSetColumn="Number" />
24              <Mapping SourceColumn="TypeName" DataSetColumn="TypeName" />
25              <Mapping SourceColumn="TypePrice" DataSetColumn="TypePrice" />
26              <Mapping SourceColumn="AddBedPrice" DataSetColumn="AddBedPrice" />
27              <Mapping SourceColumn="tatal" DataSetColumn="tatal" />
28            </Mappings>
29            <Sources />
30          </TableAdapter>
31        </Tables>
32        <Sources />
33      </DataSource>
34    </xs:appinfo>
35  </xs:annotation>
36  <xs:element name="HotelDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="False">
37    <xs:complexType>
38      <xs:choice minOccurs="0" maxOccurs="unbounded">
39        <xs:element name="view_report">
40          <xs:complexType>
41            <xs:sequence>
42              <xs:element name="UserName">
43                <xs:simpleType>
44                  <xs:restriction base="xs:string">
45                    <xs:maxLength value="50" />
46                  </xs:restriction>
47                </xs:simpleType>
48              </xs:element>
49              <xs:element name="Number">
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="TypeName">
57                <xs:simpleType>
58                  <xs:restriction base="xs:string">
59                    <xs:maxLength value="50" />
60                  </xs:restriction>
61                </xs:simpleType>
62              </xs:element>
63              <xs:element name="TypePrice" type="xs:decimal" />
64              <xs:element name="AddBedPrice" type="xs:decimal" />
65              <xs:element name="tatal" msdata:ReadOnly="true" type="xs:decimal" minOccurs="0" />
66            </xs:sequence>
67          </xs:complexType>
68        </xs:element>
69      </xs:choice>
70    </xs:complexType>
71  </xs:element>
72</xs:schema>