Quản lý điểm sinh viên CNTT
181.544 lượt xem;
- QuanlydiemDataSet31.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanlydiemDataSet3" targetNamespace="http://tempuri.org/QuanlydiemDataSet31.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet31.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet31.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="QuanlydiemConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanlydiemConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanlydiemConnectionString" 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="QuanlydiemConnectionString (Settings)" DbObjectName="Quanlydiem.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 ([MaLop] = @Original_MaLop))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
27 </Parameters>
28 </DbCommand>
29 </DeleteCommand>
30 <InsertCommand>
31 <DbCommand CommandType="Text" ModifiedByUser="false">
32 <CommandText>INSERT INTO [dbo].[tblSINH_VIEN] ([MaSv], [HoTen], [NgaySinh], [GioiTinh], [DiaChi], [MaLop]) VALUES (@MaSv, @HoTen, @NgaySinh, @GioiTinh, @DiaChi, @MaLop);
33 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
34 <Parameters>
35 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
36 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
38 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
40 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
41 </Parameters>
42 </DbCommand>
43 </InsertCommand>
44 <SelectCommand>
45 <DbCommand CommandType="Text" ModifiedByUser="false">
46 <CommandText>SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM dbo.tblSINH_VIEN</CommandText>
47 <Parameters />
48 </DbCommand>
49 </SelectCommand>
50 <UpdateCommand>
51 <DbCommand CommandType="Text" ModifiedByUser="false">
52 <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 ([MaLop] = @Original_MaLop));
53 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
54 <Parameters>
55 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
60 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
62 <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" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
64 <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" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
66 <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" />
67 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
68 <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" />
69 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
70 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
71 </Parameters>
72 </DbCommand>
73 </UpdateCommand>
74 </DbSource>
75 </MainSource>
76 <Mappings>
77 <Mapping SourceColumn="MaSv" DataSetColumn="MaSv" />
78 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
79 <Mapping SourceColumn="NgaySinh" DataSetColumn="NgaySinh" />
80 <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
81 <Mapping SourceColumn="DiaChi" DataSetColumn="DiaChi" />
82 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
83 </Mappings>
84 <Sources />
85 </TableAdapter>
86 </Tables>
87 <Sources />
88 </DataSource>
89 </xs:appinfo>
90 </xs:annotation>
91 <xs:element name="QuanlydiemDataSet3" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet3" msprop:Generator_UserDSName="QuanlydiemDataSet3" msprop:EnableTableAdapterManager="True">
92 <xs:complexType>
93 <xs:choice minOccurs="0" maxOccurs="unbounded">
94 <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">
95 <xs:complexType>
96 <xs:sequence>
97 <xs:element name="MaSv" msprop:Generator_UserColumnName="MaSv" msprop:Generator_ColumnPropNameInRow="MaSv" msprop:Generator_ColumnVarNameInTable="columnMaSv" msprop:Generator_ColumnPropNameInTable="MaSvColumn">
98 <xs:simpleType>
99 <xs:restriction base="xs:string">
100 <xs:maxLength value="50" />
101 </xs:restriction>
102 </xs:simpleType>
103 </xs:element>
104 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
105 <xs:simpleType>
106 <xs:restriction base="xs:string">
107 <xs:maxLength value="50" />
108 </xs:restriction>
109 </xs:simpleType>
110 </xs:element>
111 <xs:element name="NgaySinh" msprop:Generator_UserColumnName="NgaySinh" msprop:Generator_ColumnPropNameInRow="NgaySinh" msprop:Generator_ColumnVarNameInTable="columnNgaySinh" msprop:Generator_ColumnPropNameInTable="NgaySinhColumn" minOccurs="0">
112 <xs:simpleType>
113 <xs:restriction base="xs:string">
114 <xs:maxLength value="50" />
115 </xs:restriction>
116 </xs:simpleType>
117 </xs:element>
118 <xs:element name="GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
119 <xs:simpleType>
120 <xs:restriction base="xs:string">
121 <xs:maxLength value="50" />
122 </xs:restriction>
123 </xs:simpleType>
124 </xs:element>
125 <xs:element name="DiaChi" msprop:Generator_UserColumnName="DiaChi" msprop:Generator_ColumnPropNameInRow="DiaChi" msprop:Generator_ColumnVarNameInTable="columnDiaChi" msprop:Generator_ColumnPropNameInTable="DiaChiColumn" minOccurs="0">
126 <xs:simpleType>
127 <xs:restriction base="xs:string">
128 <xs:maxLength value="50" />
129 </xs:restriction>
130 </xs:simpleType>
131 </xs:element>
132 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn">
133 <xs:simpleType>
134 <xs:restriction base="xs:string">
135 <xs:maxLength value="5" />
136 </xs:restriction>
137 </xs:simpleType>
138 </xs:element>
139 </xs:sequence>
140 </xs:complexType>
141 </xs:element>
142 </xs:choice>
143 </xs:complexType>
144 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
145 <xs:selector xpath=".//mstns:tblSINH_VIEN" />
146 <xs:field xpath="mstns:MaSv" />
147 </xs:unique>
148 </xs:element>
149 </xs:schema>
2 <xs:schema id="QuanlydiemDataSet3" targetNamespace="http://tempuri.org/QuanlydiemDataSet31.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet31.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet31.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="QuanlydiemConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanlydiemConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanlydiemConnectionString" 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="QuanlydiemConnectionString (Settings)" DbObjectName="Quanlydiem.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 ([MaLop] = @Original_MaLop))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NVarChar" 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="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
27 </Parameters>
28 </DbCommand>
29 </DeleteCommand>
30 <InsertCommand>
31 <DbCommand CommandType="Text" ModifiedByUser="false">
32 <CommandText>INSERT INTO [dbo].[tblSINH_VIEN] ([MaSv], [HoTen], [NgaySinh], [GioiTinh], [DiaChi], [MaLop]) VALUES (@MaSv, @HoTen, @NgaySinh, @GioiTinh, @DiaChi, @MaLop);
33 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
34 <Parameters>
35 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
36 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
38 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
40 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
41 </Parameters>
42 </DbCommand>
43 </InsertCommand>
44 <SelectCommand>
45 <DbCommand CommandType="Text" ModifiedByUser="false">
46 <CommandText>SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM dbo.tblSINH_VIEN</CommandText>
47 <Parameters />
48 </DbCommand>
49 </SelectCommand>
50 <UpdateCommand>
51 <DbCommand CommandType="Text" ModifiedByUser="false">
52 <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 ([MaLop] = @Original_MaLop));
53 SELECT MaSv, HoTen, NgaySinh, GioiTinh, DiaChi, MaLop FROM tblSINH_VIEN WHERE (MaSv = @MaSv)</CommandText>
54 <Parameters>
55 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Current" />
59 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Current" />
60 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaSv" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaSv" SourceColumnNullMapping="false" SourceVersion="Original" />
62 <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" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_HoTen" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HoTen" SourceColumnNullMapping="false" SourceVersion="Original" />
64 <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" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NgaySinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NgaySinh" SourceColumnNullMapping="false" SourceVersion="Original" />
66 <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" />
67 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_GioiTinh" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="GioiTinh" SourceColumnNullMapping="false" SourceVersion="Original" />
68 <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" />
69 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DiaChi" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DiaChi" SourceColumnNullMapping="false" SourceVersion="Original" />
70 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MaLop" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="false" SourceVersion="Original" />
71 </Parameters>
72 </DbCommand>
73 </UpdateCommand>
74 </DbSource>
75 </MainSource>
76 <Mappings>
77 <Mapping SourceColumn="MaSv" DataSetColumn="MaSv" />
78 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
79 <Mapping SourceColumn="NgaySinh" DataSetColumn="NgaySinh" />
80 <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
81 <Mapping SourceColumn="DiaChi" DataSetColumn="DiaChi" />
82 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
83 </Mappings>
84 <Sources />
85 </TableAdapter>
86 </Tables>
87 <Sources />
88 </DataSource>
89 </xs:appinfo>
90 </xs:annotation>
91 <xs:element name="QuanlydiemDataSet3" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet3" msprop:Generator_UserDSName="QuanlydiemDataSet3" msprop:EnableTableAdapterManager="True">
92 <xs:complexType>
93 <xs:choice minOccurs="0" maxOccurs="unbounded">
94 <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">
95 <xs:complexType>
96 <xs:sequence>
97 <xs:element name="MaSv" msprop:Generator_UserColumnName="MaSv" msprop:Generator_ColumnPropNameInRow="MaSv" msprop:Generator_ColumnVarNameInTable="columnMaSv" msprop:Generator_ColumnPropNameInTable="MaSvColumn">
98 <xs:simpleType>
99 <xs:restriction base="xs:string">
100 <xs:maxLength value="50" />
101 </xs:restriction>
102 </xs:simpleType>
103 </xs:element>
104 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
105 <xs:simpleType>
106 <xs:restriction base="xs:string">
107 <xs:maxLength value="50" />
108 </xs:restriction>
109 </xs:simpleType>
110 </xs:element>
111 <xs:element name="NgaySinh" msprop:Generator_UserColumnName="NgaySinh" msprop:Generator_ColumnPropNameInRow="NgaySinh" msprop:Generator_ColumnVarNameInTable="columnNgaySinh" msprop:Generator_ColumnPropNameInTable="NgaySinhColumn" minOccurs="0">
112 <xs:simpleType>
113 <xs:restriction base="xs:string">
114 <xs:maxLength value="50" />
115 </xs:restriction>
116 </xs:simpleType>
117 </xs:element>
118 <xs:element name="GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
119 <xs:simpleType>
120 <xs:restriction base="xs:string">
121 <xs:maxLength value="50" />
122 </xs:restriction>
123 </xs:simpleType>
124 </xs:element>
125 <xs:element name="DiaChi" msprop:Generator_UserColumnName="DiaChi" msprop:Generator_ColumnPropNameInRow="DiaChi" msprop:Generator_ColumnVarNameInTable="columnDiaChi" msprop:Generator_ColumnPropNameInTable="DiaChiColumn" minOccurs="0">
126 <xs:simpleType>
127 <xs:restriction base="xs:string">
128 <xs:maxLength value="50" />
129 </xs:restriction>
130 </xs:simpleType>
131 </xs:element>
132 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn">
133 <xs:simpleType>
134 <xs:restriction base="xs:string">
135 <xs:maxLength value="5" />
136 </xs:restriction>
137 </xs:simpleType>
138 </xs:element>
139 </xs:sequence>
140 </xs:complexType>
141 </xs:element>
142 </xs:choice>
143 </xs:complexType>
144 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
145 <xs:selector xpath=".//mstns:tblSINH_VIEN" />
146 <xs:field xpath="mstns:MaSv" />
147 </xs:unique>
148 </xs:element>
149 </xs:schema>
