Quản lý điểm sinh viên CNTT
180.059 lượt xem;
- QuanLyDiemDataSet11.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanLyDiemDataSet1" targetNamespace="http://tempuri.org/QuanLyDiemDataSet11.xsd" xmlns:mstns="http://tempuri.org/QuanLyDiemDataSet11.xsd" xmlns="http://tempuri.org/QuanLyDiemDataSet11.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="QuanLyDiemConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanLyDiemConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanLyDiemConnectionString1" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblSINH_VIENTableAdapter" GeneratorDataComponentClassName="tblSINH_VIENTableAdapter" Name="tblSINH_VIEN" UserDataComponentName="tblSINH_VIENTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanLyDiemConnectionString1 (Settings)" DbObjectName="dbo.tblSINH_VIEN" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[tblSINH_VIEN] WHERE (([MaSv] = @Original_MaSv) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HoTen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MaLop" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
28 </Parameters>
29 </DbCommand>
30 </DeleteCommand>
31 <InsertCommand>
32 <DbCommand CommandType="Text" ModifiedByUser="false">
33 <CommandText>INSERT INTO [dbo].[tblSINH_VIEN] ([MaSv], [HoTen], [NgaySinh], [GioiTinh], [DiaChi], [MaLop]) VALUES (@MaSv, @HoTen, @NgaySinh, @GioiTinh, @DiaChi, @MaLop);
34 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
35 <Parameters>
36 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
38 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
40 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
41 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
42 </Parameters>
43 </DbCommand>
44 </InsertCommand>
45 <SelectCommand>
46 <DbCommand CommandType="Text" ModifiedByUser="false">
47 <CommandText>SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM dbo.tblSINH_VIEN</CommandText>
48 <Parameters />
49 </DbCommand>
50 </SelectCommand>
51 <UpdateCommand>
52 <DbCommand CommandType="Text" ModifiedByUser="false">
53 <CommandText>UPDATE [dbo].[tblSINH_VIEN] SET [MaSv] = @MaSv, [HoTen] = @HoTen, [NgaySinh] = @NgaySinh, [GioiTinh] = @GioiTinh, [DiaChi] = @DiaChi, [MaLop] = @MaLop WHERE (([MaSv] = @Original_MaSv) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)));
54 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
55 <Parameters>
56 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
60 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
62 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HoTen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="true" SourceVersion="Original" />
64 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
66 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
67 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
68 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
69 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
70 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
71 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MaLop" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="true" SourceVersion="Original" />
72 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
73 </Parameters>
74 </DbCommand>
75 </UpdateCommand>
76 </DbSource>
77 </MainSource>
78 <Mappings>
79 <Mapping SourceColumn="MaSv" DataSetColumn="MaSv" />
80 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
81 <Mapping SourceColumn="NgaySinh" DataSetColumn="NgaySinh" />
82 <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
83 <Mapping SourceColumn="DiaChi" DataSetColumn="DiaChi" />
84 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
85 </Mappings>
86 <Sources />
87 </TableAdapter>
88 </Tables>
89 <Sources />
90 </DataSource>
91 </xs:appinfo>
92 </xs:annotation>
93 <xs:element name="QuanLyDiemDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanLyDiemDataSet1" msprop:Generator_UserDSName="QuanLyDiemDataSet1" msprop:EnableTableAdapterManager="True">
94 <xs:complexType>
95 <xs:choice minOccurs="0" maxOccurs="unbounded">
96 <xs:element name="tblSINH_VIEN" msprop:Generator_UserTableName="tblSINH_VIEN" msprop:Generator_RowDeletedName="tblSINH_VIENRowDeleted" msprop:Generator_TableClassName="tblSINH_VIENDataTable" msprop:Generator_RowChangedName="tblSINH_VIENRowChanged" msprop:Generator_RowClassName="tblSINH_VIENRow" msprop:Generator_RowChangingName="tblSINH_VIENRowChanging" msprop:Generator_RowEvArgName="tblSINH_VIENRowChangeEvent" msprop:Generator_RowEvHandlerName="tblSINH_VIENRowChangeEventHandler" msprop:Generator_TablePropName="tblSINH_VIEN" msprop:Generator_TableVarName="tabletblSINH_VIEN" msprop:Generator_RowDeletingName="tblSINH_VIENRowDeleting">
97 <xs:complexType>
98 <xs:sequence>
99 <xs:element name="MaSv" msprop:Generator_UserColumnName="MaSv" msprop:Generator_ColumnPropNameInRow="MaSv" msprop:Generator_ColumnVarNameInTable="columnMaSv" msprop:Generator_ColumnPropNameInTable="MaSvColumn">
100 <xs:simpleType>
101 <xs:restriction base="xs:string">
102 <xs:maxLength value="10" />
103 </xs:restriction>
104 </xs:simpleType>
105 </xs:element>
106 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
107 <xs:simpleType>
108 <xs:restriction base="xs:string">
109 <xs:maxLength value="30" />
110 </xs:restriction>
111 </xs:simpleType>
112 </xs:element>
113 <xs:element name="NgaySinh" msprop:Generator_UserColumnName="NgaySinh" msprop:Generator_ColumnPropNameInRow="NgaySinh" msprop:Generator_ColumnVarNameInTable="columnNgaySinh" msprop:Generator_ColumnPropNameInTable="NgaySinhColumn" minOccurs="0">
114 <xs:simpleType>
115 <xs:restriction base="xs:string">
116 <xs:maxLength value="10" />
117 </xs:restriction>
118 </xs:simpleType>
119 </xs:element>
120 <xs:element name="GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
121 <xs:simpleType>
122 <xs:restriction base="xs:string">
123 <xs:maxLength value="3" />
124 </xs:restriction>
125 </xs:simpleType>
126 </xs:element>
127 <xs:element name="DiaChi" msprop:Generator_UserColumnName="DiaChi" msprop:Generator_ColumnPropNameInRow="DiaChi" msprop:Generator_ColumnVarNameInTable="columnDiaChi" msprop:Generator_ColumnPropNameInTable="DiaChiColumn" minOccurs="0">
128 <xs:simpleType>
129 <xs:restriction base="xs:string">
130 <xs:maxLength value="30" />
131 </xs:restriction>
132 </xs:simpleType>
133 </xs:element>
134 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
135 <xs:simpleType>
136 <xs:restriction base="xs:string">
137 <xs:maxLength value="5" />
138 </xs:restriction>
139 </xs:simpleType>
140 </xs:element>
141 </xs:sequence>
142 </xs:complexType>
143 </xs:element>
144 </xs:choice>
145 </xs:complexType>
146 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
147 <xs:selector xpath=".//mstns:tblSINH_VIEN" />
148 <xs:field xpath="mstns:MaSv" />
149 </xs:unique>
150 </xs:element>
151 </xs:schema>
2 <xs:schema id="QuanLyDiemDataSet1" targetNamespace="http://tempuri.org/QuanLyDiemDataSet11.xsd" xmlns:mstns="http://tempuri.org/QuanLyDiemDataSet11.xsd" xmlns="http://tempuri.org/QuanLyDiemDataSet11.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="QuanLyDiemConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanLyDiemConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanLyDiemConnectionString1" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblSINH_VIENTableAdapter" GeneratorDataComponentClassName="tblSINH_VIENTableAdapter" Name="tblSINH_VIEN" UserDataComponentName="tblSINH_VIENTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanLyDiemConnectionString1 (Settings)" DbObjectName="dbo.tblSINH_VIEN" 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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <DeleteCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>DELETE FROM [dbo].[tblSINH_VIEN] WHERE (([MaSv] = @Original_MaSv) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HoTen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MaLop" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
28 </Parameters>
29 </DbCommand>
30 </DeleteCommand>
31 <InsertCommand>
32 <DbCommand CommandType="Text" ModifiedByUser="false">
33 <CommandText>INSERT INTO [dbo].[tblSINH_VIEN] ([MaSv], [HoTen], [NgaySinh], [GioiTinh], [DiaChi], [MaLop]) VALUES (@MaSv, @HoTen, @NgaySinh, @GioiTinh, @DiaChi, @MaLop);
34 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
35 <Parameters>
36 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
38 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
40 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
41 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
42 </Parameters>
43 </DbCommand>
44 </InsertCommand>
45 <SelectCommand>
46 <DbCommand CommandType="Text" ModifiedByUser="false">
47 <CommandText>SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM dbo.tblSINH_VIEN</CommandText>
48 <Parameters />
49 </DbCommand>
50 </SelectCommand>
51 <UpdateCommand>
52 <DbCommand CommandType="Text" ModifiedByUser="false">
53 <CommandText>UPDATE [dbo].[tblSINH_VIEN] SET [MaSv] = @MaSv, [HoTen] = @HoTen, [NgaySinh] = @NgaySinh, [GioiTinh] = @GioiTinh, [DiaChi] = @DiaChi, [MaLop] = @MaLop WHERE (([MaSv] = @Original_MaSv) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_NgaySinh = 1 AND [NgaySinh] IS NULL) OR ([NgaySinh] = @Original_NgaySinh)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_DiaChi = 1 AND [DiaChi] IS NULL) OR ([DiaChi] = @Original_DiaChi)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)));
54 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
55 <Parameters>
56 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
60 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
62 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HoTen" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="true" SourceVersion="Original" />
64 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NgaySinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="true" SourceVersion="Original" />
66 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
67 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GioiTinh" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="true" SourceVersion="Original" />
68 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
69 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiaChi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="true" SourceVersion="Original" />
70 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
71 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MaLop" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="true" SourceVersion="Original" />
72 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
73 </Parameters>
74 </DbCommand>
75 </UpdateCommand>
76 </DbSource>
77 </MainSource>
78 <Mappings>
79 <Mapping SourceColumn="MaSv" DataSetColumn="MaSv" />
80 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
81 <Mapping SourceColumn="NgaySinh" DataSetColumn="NgaySinh" />
82 <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
83 <Mapping SourceColumn="DiaChi" DataSetColumn="DiaChi" />
84 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
85 </Mappings>
86 <Sources />
87 </TableAdapter>
88 </Tables>
89 <Sources />
90 </DataSource>
91 </xs:appinfo>
92 </xs:annotation>
93 <xs:element name="QuanLyDiemDataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanLyDiemDataSet1" msprop:Generator_UserDSName="QuanLyDiemDataSet1" msprop:EnableTableAdapterManager="True">
94 <xs:complexType>
95 <xs:choice minOccurs="0" maxOccurs="unbounded">
96 <xs:element name="tblSINH_VIEN" msprop:Generator_UserTableName="tblSINH_VIEN" msprop:Generator_RowDeletedName="tblSINH_VIENRowDeleted" msprop:Generator_TableClassName="tblSINH_VIENDataTable" msprop:Generator_RowChangedName="tblSINH_VIENRowChanged" msprop:Generator_RowClassName="tblSINH_VIENRow" msprop:Generator_RowChangingName="tblSINH_VIENRowChanging" msprop:Generator_RowEvArgName="tblSINH_VIENRowChangeEvent" msprop:Generator_RowEvHandlerName="tblSINH_VIENRowChangeEventHandler" msprop:Generator_TablePropName="tblSINH_VIEN" msprop:Generator_TableVarName="tabletblSINH_VIEN" msprop:Generator_RowDeletingName="tblSINH_VIENRowDeleting">
97 <xs:complexType>
98 <xs:sequence>
99 <xs:element name="MaSv" msprop:Generator_UserColumnName="MaSv" msprop:Generator_ColumnPropNameInRow="MaSv" msprop:Generator_ColumnVarNameInTable="columnMaSv" msprop:Generator_ColumnPropNameInTable="MaSvColumn">
100 <xs:simpleType>
101 <xs:restriction base="xs:string">
102 <xs:maxLength value="10" />
103 </xs:restriction>
104 </xs:simpleType>
105 </xs:element>
106 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
107 <xs:simpleType>
108 <xs:restriction base="xs:string">
109 <xs:maxLength value="30" />
110 </xs:restriction>
111 </xs:simpleType>
112 </xs:element>
113 <xs:element name="NgaySinh" msprop:Generator_UserColumnName="NgaySinh" msprop:Generator_ColumnPropNameInRow="NgaySinh" msprop:Generator_ColumnVarNameInTable="columnNgaySinh" msprop:Generator_ColumnPropNameInTable="NgaySinhColumn" minOccurs="0">
114 <xs:simpleType>
115 <xs:restriction base="xs:string">
116 <xs:maxLength value="10" />
117 </xs:restriction>
118 </xs:simpleType>
119 </xs:element>
120 <xs:element name="GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
121 <xs:simpleType>
122 <xs:restriction base="xs:string">
123 <xs:maxLength value="3" />
124 </xs:restriction>
125 </xs:simpleType>
126 </xs:element>
127 <xs:element name="DiaChi" msprop:Generator_UserColumnName="DiaChi" msprop:Generator_ColumnPropNameInRow="DiaChi" msprop:Generator_ColumnVarNameInTable="columnDiaChi" msprop:Generator_ColumnPropNameInTable="DiaChiColumn" minOccurs="0">
128 <xs:simpleType>
129 <xs:restriction base="xs:string">
130 <xs:maxLength value="30" />
131 </xs:restriction>
132 </xs:simpleType>
133 </xs:element>
134 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
135 <xs:simpleType>
136 <xs:restriction base="xs:string">
137 <xs:maxLength value="5" />
138 </xs:restriction>
139 </xs:simpleType>
140 </xs:element>
141 </xs:sequence>
142 </xs:complexType>
143 </xs:element>
144 </xs:choice>
145 </xs:complexType>
146 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
147 <xs:selector xpath=".//mstns:tblSINH_VIEN" />
148 <xs:field xpath="mstns:MaSv" />
149 </xs:unique>
150 </xs:element>
151 </xs:schema>