Hệ thống quản lý phòng tập trong C#
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="GymDataSet" targetNamespace="http://tempuri.org/GymDataSet.xsd" xmlns:mstns="http://tempuri.org/GymDataSet.xsd" xmlns="http://tempuri.org/GymDataSet.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="GymConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="GymConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.GymManagementSystem.Properties.Settings.GlobalReference.Default.GymConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="membersTableAdapter" GeneratorDataComponentClassName="membersTableAdapter" Name="members" UserDataComponentName="membersTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="GymConnectionString (Settings)" DbObjectName="dbo.members" 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].[members] ([f_name], [l_name], [gender], [dob], [mobile], [email], [jod], [time], [address], [mem_time]) VALUES (@f_name, @l_name, @gender, @dob, @mobile, @email, @jod, @time, @address, @mem_time)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@f_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="f_name" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@l_name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="l_name" SourceColumnNullMapping="false" SourceVersion="Current" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@gender" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="gender" SourceColumnNullMapping="false" SourceVersion="Current" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@dob" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="dob" SourceColumnNullMapping="false" SourceVersion="Current" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mobile" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mobile" SourceColumnNullMapping="false" SourceVersion="Current" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@jod" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="jod" SourceColumnNullMapping="false" SourceVersion="Current" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@time" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="time" SourceColumnNullMapping="false" SourceVersion="Current" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@mem_time" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="mem_time" SourceColumnNullMapping="false" SourceVersion="Current" />
27 </Parameters>
28 </DbCommand>
29 </InsertCommand>
30 <SelectCommand>
31 <DbCommand CommandType="Text" ModifiedByUser="false">
32 <CommandText>SELECT m_id, f_name, l_name, gender, dob, mobile, email, jod, time, address, mem_time FROM dbo.members</CommandText>
33 <Parameters />
34 </DbCommand>
35 </SelectCommand>
36 </DbSource>
37 </MainSource>
38 <Mappings>
39 <Mapping SourceColumn="m_id" DataSetColumn="m_id" />
40 <Mapping SourceColumn="f_name" DataSetColumn="f_name" />
41 <Mapping SourceColumn="l_name" DataSetColumn="l_name" />
42 <Mapping SourceColumn="gender" DataSetColumn="gender" />
43 <Mapping SourceColumn="dob" DataSetColumn="dob" />
44 <Mapping SourceColumn="mobile" DataSetColumn="mobile" />
45 <Mapping SourceColumn="email" DataSetColumn="email" />
46 <Mapping SourceColumn="jod" DataSetColumn="jod" />
47 <Mapping SourceColumn="time" DataSetColumn="time" />
48 <Mapping SourceColumn="address" DataSetColumn="address" />
49 <Mapping SourceColumn="mem_time" DataSetColumn="mem_time" />
50 </Mappings>
51 <Sources />
52 </TableAdapter>
53 </Tables>
54 <Sources />
55 </DataSource>
56 </xs:appinfo>
57 </xs:annotation>
58 <xs:element name="GymDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="GymDataSet" msprop:Generator_UserDSName="GymDataSet">
59 <xs:complexType>
60 <xs:choice minOccurs="0" maxOccurs="unbounded">
61 <xs:element name="members" msprop:Generator_TableClassName="membersDataTable" msprop:Generator_TableVarName="tablemembers" msprop:Generator_TablePropName="members" msprop:Generator_RowDeletingName="membersRowDeleting" msprop:Generator_RowChangingName="membersRowChanging" msprop:Generator_RowEvHandlerName="membersRowChangeEventHandler" msprop:Generator_RowDeletedName="membersRowDeleted" msprop:Generator_UserTableName="members" msprop:Generator_RowChangedName="membersRowChanged" msprop:Generator_RowEvArgName="membersRowChangeEvent" msprop:Generator_RowClassName="membersRow">
62 <xs:complexType>
63 <xs:sequence>
64 <xs:element name="m_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnm_id" msprop:Generator_ColumnPropNameInRow="m_id" msprop:Generator_ColumnPropNameInTable="m_idColumn" msprop:Generator_UserColumnName="m_id" type="xs:int" />
65 <xs:element name="f_name" msprop:Generator_ColumnVarNameInTable="columnf_name" msprop:Generator_ColumnPropNameInRow="f_name" msprop:Generator_ColumnPropNameInTable="f_nameColumn" msprop:Generator_UserColumnName="f_name" minOccurs="0">
66 <xs:simpleType>
67 <xs:restriction base="xs:string">
68 <xs:maxLength value="50" />
69 </xs:restriction>
70 </xs:simpleType>
71 </xs:element>
72 <xs:element name="l_name" msprop:Generator_ColumnVarNameInTable="columnl_name" msprop:Generator_ColumnPropNameInRow="l_name" msprop:Generator_ColumnPropNameInTable="l_nameColumn" msprop:Generator_UserColumnName="l_name" minOccurs="0">
73 <xs:simpleType>
74 <xs:restriction base="xs:string">
75 <xs:maxLength value="50" />
76 </xs:restriction>
77 </xs:simpleType>
78 </xs:element>
79 <xs:element name="gender" msprop:Generator_ColumnVarNameInTable="columngender" msprop:Generator_ColumnPropNameInRow="gender" msprop:Generator_ColumnPropNameInTable="genderColumn" msprop:Generator_UserColumnName="gender" minOccurs="0">
80 <xs:simpleType>
81 <xs:restriction base="xs:string">
82 <xs:maxLength value="50" />
83 </xs:restriction>
84 </xs:simpleType>
85 </xs:element>
86 <xs:element name="dob" msprop:Generator_ColumnVarNameInTable="columndob" msprop:Generator_ColumnPropNameInRow="dob" msprop:Generator_ColumnPropNameInTable="dobColumn" msprop:Generator_UserColumnName="dob" minOccurs="0">
87 <xs:simpleType>
88 <xs:restriction base="xs:string">
89 <xs:maxLength value="50" />
90 </xs:restriction>
91 </xs:simpleType>
92 </xs:element>
93 <xs:element name="mobile" msprop:Generator_ColumnVarNameInTable="columnmobile" msprop:Generator_ColumnPropNameInRow="mobile" msprop:Generator_ColumnPropNameInTable="mobileColumn" msprop:Generator_UserColumnName="mobile" minOccurs="0">
94 <xs:simpleType>
95 <xs:restriction base="xs:string">
96 <xs:maxLength value="50" />
97 </xs:restriction>
98 </xs:simpleType>
99 </xs:element>
100 <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
101 <xs:simpleType>
102 <xs:restriction base="xs:string">
103 <xs:maxLength value="50" />
104 </xs:restriction>
105 </xs:simpleType>
106 </xs:element>
107 <xs:element name="jod" msprop:Generator_ColumnVarNameInTable="columnjod" msprop:Generator_ColumnPropNameInRow="jod" msprop:Generator_ColumnPropNameInTable="jodColumn" msprop:Generator_UserColumnName="jod" minOccurs="0">
108 <xs:simpleType>
109 <xs:restriction base="xs:string">
110 <xs:maxLength value="50" />
111 </xs:restriction>
112 </xs:simpleType>
113 </xs:element>
114 <xs:element name="time" msprop:Generator_ColumnVarNameInTable="columntime" msprop:Generator_ColumnPropNameInRow="time" msprop:Generator_ColumnPropNameInTable="timeColumn" msprop:Generator_UserColumnName="time" minOccurs="0">
115 <xs:simpleType>
116 <xs:restriction base="xs:string">
117 <xs:maxLength value="50" />
118 </xs:restriction>
119 </xs:simpleType>
120 </xs:element>
121 <xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address" minOccurs="0">
122 <xs:simpleType>
123 <xs:restriction base="xs:string">
124 <xs:maxLength value="50" />
125 </xs:restriction>
126 </xs:simpleType>
127 </xs:element>
128 <xs:element name="mem_time" msprop:Generator_ColumnVarNameInTable="columnmem_time" msprop:Generator_ColumnPropNameInRow="mem_time" msprop:Generator_ColumnPropNameInTable="mem_timeColumn" msprop:Generator_UserColumnName="mem_time" minOccurs="0">
129 <xs:simpleType>
130 <xs:restriction base="xs:string">
131 <xs:maxLength value="50" />
132 </xs:restriction>
133 </xs:simpleType>
134 </xs:element>
135 </xs:sequence>
136 </xs:complexType>
137 </xs:element>
138 </xs:choice>
139 </xs:complexType>
140 </xs:element>
141 </xs:schema>
