Quản lý điểm sinh viên CNTT
180.091 lượt xem;
- QuanlydiemDataSet20.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanlydiemDataSet20" targetNamespace="http://tempuri.org/QuanlydiemDataSet20.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet20.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet20.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="QuanlydiemConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanlydiemConnectionString2 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanlydiemConnectionString2" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblGIANG_VIENTableAdapter" GeneratorDataComponentClassName="tblGIANG_VIENTableAdapter" Name="tblGIANG_VIEN" UserDataComponentName="tblGIANG_VIENTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblGIANG_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].[tblGIANG_VIEN] WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <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" />
21 <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" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhanLoaiGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Original" />
28 </Parameters>
29 </DbCommand>
30 </DeleteCommand>
31 <InsertCommand>
32 <DbCommand CommandType="Text" ModifiedByUser="false">
33 <CommandText>INSERT INTO [dbo].[tblGIANG_VIEN] ([MaGV], [TenGV], [GioiTinh], [Phone], [Email], [PhanLoaiGV], [Anh]) VALUES (@MaGV, @TenGV, @GioiTinh, @Phone, @Email, @PhanLoaiGV, @Anh);
34 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)</CommandText>
35 <Parameters>
36 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Current" />
38 <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" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
40 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
41 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Current" />
42 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Anh" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Anh" SourceColumnNullMapping="false" SourceVersion="Current" />
43 </Parameters>
44 </DbCommand>
45 </InsertCommand>
46 <SelectCommand>
47 <DbCommand CommandType="Text" ModifiedByUser="false">
48 <CommandText>SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM dbo.tblGIANG_VIEN</CommandText>
49 <Parameters />
50 </DbCommand>
51 </SelectCommand>
52 <UpdateCommand>
53 <DbCommand CommandType="Text" ModifiedByUser="false">
54 <CommandText>UPDATE [dbo].[tblGIANG_VIEN] SET [MaGV] = @MaGV, [TenGV] = @TenGV, [GioiTinh] = @GioiTinh, [Phone] = @Phone, [Email] = @Email, [PhanLoaiGV] = @PhanLoaiGV, [Anh] = @Anh WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)));
55 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)</CommandText>
56 <Parameters>
57 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" 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="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
62 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Current" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Anh" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Anh" SourceColumnNullMapping="false" SourceVersion="Current" />
64 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
66 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" 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_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
70 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
71 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
72 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
73 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhanLoaiGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="true" SourceVersion="Original" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Original" />
75 </Parameters>
76 </DbCommand>
77 </UpdateCommand>
78 </DbSource>
79 </MainSource>
80 <Mappings>
81 <Mapping SourceColumn="MaGV" DataSetColumn="MaGV" />
82 <Mapping SourceColumn="TenGV" DataSetColumn="TenGV" />
83 <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
84 <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
85 <Mapping SourceColumn="Email" DataSetColumn="Email" />
86 <Mapping SourceColumn="PhanLoaiGV" DataSetColumn="PhanLoaiGV" />
87 <Mapping SourceColumn="Anh" DataSetColumn="Anh" />
88 </Mappings>
89 <Sources />
90 </TableAdapter>
91 </Tables>
92 <Sources />
93 </DataSource>
94 </xs:appinfo>
95 </xs:annotation>
96 <xs:element name="QuanlydiemDataSet20" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet20" msprop:Generator_UserDSName="QuanlydiemDataSet20" msprop:EnableTableAdapterManager="True">
97 <xs:complexType>
98 <xs:choice minOccurs="0" maxOccurs="unbounded">
99 <xs:element name="tblGIANG_VIEN" msprop:Generator_UserTableName="tblGIANG_VIEN" msprop:Generator_RowDeletedName="tblGIANG_VIENRowDeleted" msprop:Generator_TableClassName="tblGIANG_VIENDataTable" msprop:Generator_RowChangedName="tblGIANG_VIENRowChanged" msprop:Generator_RowClassName="tblGIANG_VIENRow" msprop:Generator_RowChangingName="tblGIANG_VIENRowChanging" msprop:Generator_RowEvArgName="tblGIANG_VIENRowChangeEvent" msprop:Generator_RowEvHandlerName="tblGIANG_VIENRowChangeEventHandler" msprop:Generator_TablePropName="tblGIANG_VIEN" msprop:Generator_TableVarName="tabletblGIANG_VIEN" msprop:Generator_RowDeletingName="tblGIANG_VIENRowDeleting">
100 <xs:complexType>
101 <xs:sequence>
102 <xs:element name="MaGV" msprop:Generator_UserColumnName="MaGV" msprop:Generator_ColumnPropNameInRow="MaGV" msprop:Generator_ColumnVarNameInTable="columnMaGV" msprop:Generator_ColumnPropNameInTable="MaGVColumn">
103 <xs:simpleType>
104 <xs:restriction base="xs:string">
105 <xs:maxLength value="10" />
106 </xs:restriction>
107 </xs:simpleType>
108 </xs:element>
109 <xs:element name="TenGV" msprop:Generator_UserColumnName="TenGV" msprop:Generator_ColumnPropNameInRow="TenGV" msprop:Generator_ColumnVarNameInTable="columnTenGV" msprop:Generator_ColumnPropNameInTable="TenGVColumn" minOccurs="0">
110 <xs:simpleType>
111 <xs:restriction base="xs:string">
112 <xs:maxLength value="30" />
113 </xs:restriction>
114 </xs:simpleType>
115 </xs:element>
116 <xs:element name="GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
117 <xs:simpleType>
118 <xs:restriction base="xs:string">
119 <xs:maxLength value="10" />
120 </xs:restriction>
121 </xs:simpleType>
122 </xs:element>
123 <xs:element name="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" minOccurs="0">
124 <xs:simpleType>
125 <xs:restriction base="xs:string">
126 <xs:maxLength value="12" />
127 </xs:restriction>
128 </xs:simpleType>
129 </xs:element>
130 <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
131 <xs:simpleType>
132 <xs:restriction base="xs:string">
133 <xs:maxLength value="20" />
134 </xs:restriction>
135 </xs:simpleType>
136 </xs:element>
137 <xs:element name="PhanLoaiGV" msprop:Generator_UserColumnName="PhanLoaiGV" msprop:Generator_ColumnPropNameInRow="PhanLoaiGV" msprop:Generator_ColumnVarNameInTable="columnPhanLoaiGV" msprop:Generator_ColumnPropNameInTable="PhanLoaiGVColumn" minOccurs="0">
138 <xs:simpleType>
139 <xs:restriction base="xs:string">
140 <xs:maxLength value="10" />
141 </xs:restriction>
142 </xs:simpleType>
143 </xs:element>
144 <xs:element name="Anh" msprop:Generator_UserColumnName="Anh" msprop:Generator_ColumnPropNameInRow="Anh" msprop:Generator_ColumnVarNameInTable="columnAnh" msprop:Generator_ColumnPropNameInTable="AnhColumn" type="xs:base64Binary" minOccurs="0" />
145 </xs:sequence>
146 </xs:complexType>
147 </xs:element>
148 </xs:choice>
149 </xs:complexType>
150 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
151 <xs:selector xpath=".//mstns:tblGIANG_VIEN" />
152 <xs:field xpath="mstns:MaGV" />
153 </xs:unique>
154 </xs:element>
155 </xs:schema>
2 <xs:schema id="QuanlydiemDataSet20" targetNamespace="http://tempuri.org/QuanlydiemDataSet20.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet20.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet20.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="QuanlydiemConnectionString2" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanlydiemConnectionString2 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Quản_lý_điểm_sinh_vien_CNTT.Properties.Settings.GlobalReference.Default.QuanlydiemConnectionString2" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblGIANG_VIENTableAdapter" GeneratorDataComponentClassName="tblGIANG_VIENTableAdapter" Name="tblGIANG_VIEN" UserDataComponentName="tblGIANG_VIENTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblGIANG_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].[tblGIANG_VIEN] WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)))</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
19 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Original" />
20 <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" />
21 <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" />
22 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhanLoaiGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="true" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Original" />
28 </Parameters>
29 </DbCommand>
30 </DeleteCommand>
31 <InsertCommand>
32 <DbCommand CommandType="Text" ModifiedByUser="false">
33 <CommandText>INSERT INTO [dbo].[tblGIANG_VIEN] ([MaGV], [TenGV], [GioiTinh], [Phone], [Email], [PhanLoaiGV], [Anh]) VALUES (@MaGV, @TenGV, @GioiTinh, @Phone, @Email, @PhanLoaiGV, @Anh);
34 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)</CommandText>
35 <Parameters>
36 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
37 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="false" SourceVersion="Current" />
38 <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" />
39 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
40 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
41 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Current" />
42 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Anh" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Anh" SourceColumnNullMapping="false" SourceVersion="Current" />
43 </Parameters>
44 </DbCommand>
45 </InsertCommand>
46 <SelectCommand>
47 <DbCommand CommandType="Text" ModifiedByUser="false">
48 <CommandText>SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM dbo.tblGIANG_VIEN</CommandText>
49 <Parameters />
50 </DbCommand>
51 </SelectCommand>
52 <UpdateCommand>
53 <DbCommand CommandType="Text" ModifiedByUser="false">
54 <CommandText>UPDATE [dbo].[tblGIANG_VIEN] SET [MaGV] = @MaGV, [TenGV] = @TenGV, [GioiTinh] = @GioiTinh, [Phone] = @Phone, [Email] = @Email, [PhanLoaiGV] = @PhanLoaiGV, [Anh] = @Anh WHERE (([MaGV] = @Original_MaGV) AND ((@IsNull_TenGV = 1 AND [TenGV] IS NULL) OR ([TenGV] = @Original_TenGV)) AND ((@IsNull_GioiTinh = 1 AND [GioiTinh] IS NULL) OR ([GioiTinh] = @Original_GioiTinh)) AND ((@IsNull_Phone = 1 AND [Phone] IS NULL) OR ([Phone] = @Original_Phone)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_PhanLoaiGV = 1 AND [PhanLoaiGV] IS NULL) OR ([PhanLoaiGV] = @Original_PhanLoaiGV)));
55 SELECT MaGV, TenGV, GioiTinh, Phone, Email, PhanLoaiGV, Anh FROM tblGIANG_VIEN WHERE (MaGV = @MaGV)</CommandText>
56 <Parameters>
57 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Current" />
58 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" 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="@Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
61 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
62 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Current" />
63 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Anh" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="Anh" SourceColumnNullMapping="false" SourceVersion="Current" />
64 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaGV" SourceColumnNullMapping="false" SourceVersion="Original" />
65 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TenGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TenGV" SourceColumnNullMapping="true" SourceVersion="Original" />
66 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_TenGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="TenGV" 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_Phone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
70 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Phone" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
71 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
72 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
73 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhanLoaiGV" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="true" SourceVersion="Original" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_PhanLoaiGV" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="PhanLoaiGV" SourceColumnNullMapping="false" SourceVersion="Original" />
75 </Parameters>
76 </DbCommand>
77 </UpdateCommand>
78 </DbSource>
79 </MainSource>
80 <Mappings>
81 <Mapping SourceColumn="MaGV" DataSetColumn="MaGV" />
82 <Mapping SourceColumn="TenGV" DataSetColumn="TenGV" />
83 <Mapping SourceColumn="GioiTinh" DataSetColumn="GioiTinh" />
84 <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
85 <Mapping SourceColumn="Email" DataSetColumn="Email" />
86 <Mapping SourceColumn="PhanLoaiGV" DataSetColumn="PhanLoaiGV" />
87 <Mapping SourceColumn="Anh" DataSetColumn="Anh" />
88 </Mappings>
89 <Sources />
90 </TableAdapter>
91 </Tables>
92 <Sources />
93 </DataSource>
94 </xs:appinfo>
95 </xs:annotation>
96 <xs:element name="QuanlydiemDataSet20" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet20" msprop:Generator_UserDSName="QuanlydiemDataSet20" msprop:EnableTableAdapterManager="True">
97 <xs:complexType>
98 <xs:choice minOccurs="0" maxOccurs="unbounded">
99 <xs:element name="tblGIANG_VIEN" msprop:Generator_UserTableName="tblGIANG_VIEN" msprop:Generator_RowDeletedName="tblGIANG_VIENRowDeleted" msprop:Generator_TableClassName="tblGIANG_VIENDataTable" msprop:Generator_RowChangedName="tblGIANG_VIENRowChanged" msprop:Generator_RowClassName="tblGIANG_VIENRow" msprop:Generator_RowChangingName="tblGIANG_VIENRowChanging" msprop:Generator_RowEvArgName="tblGIANG_VIENRowChangeEvent" msprop:Generator_RowEvHandlerName="tblGIANG_VIENRowChangeEventHandler" msprop:Generator_TablePropName="tblGIANG_VIEN" msprop:Generator_TableVarName="tabletblGIANG_VIEN" msprop:Generator_RowDeletingName="tblGIANG_VIENRowDeleting">
100 <xs:complexType>
101 <xs:sequence>
102 <xs:element name="MaGV" msprop:Generator_UserColumnName="MaGV" msprop:Generator_ColumnPropNameInRow="MaGV" msprop:Generator_ColumnVarNameInTable="columnMaGV" msprop:Generator_ColumnPropNameInTable="MaGVColumn">
103 <xs:simpleType>
104 <xs:restriction base="xs:string">
105 <xs:maxLength value="10" />
106 </xs:restriction>
107 </xs:simpleType>
108 </xs:element>
109 <xs:element name="TenGV" msprop:Generator_UserColumnName="TenGV" msprop:Generator_ColumnPropNameInRow="TenGV" msprop:Generator_ColumnVarNameInTable="columnTenGV" msprop:Generator_ColumnPropNameInTable="TenGVColumn" minOccurs="0">
110 <xs:simpleType>
111 <xs:restriction base="xs:string">
112 <xs:maxLength value="30" />
113 </xs:restriction>
114 </xs:simpleType>
115 </xs:element>
116 <xs:element name="GioiTinh" msprop:Generator_UserColumnName="GioiTinh" msprop:Generator_ColumnPropNameInRow="GioiTinh" msprop:Generator_ColumnVarNameInTable="columnGioiTinh" msprop:Generator_ColumnPropNameInTable="GioiTinhColumn" minOccurs="0">
117 <xs:simpleType>
118 <xs:restriction base="xs:string">
119 <xs:maxLength value="10" />
120 </xs:restriction>
121 </xs:simpleType>
122 </xs:element>
123 <xs:element name="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" minOccurs="0">
124 <xs:simpleType>
125 <xs:restriction base="xs:string">
126 <xs:maxLength value="12" />
127 </xs:restriction>
128 </xs:simpleType>
129 </xs:element>
130 <xs:element name="Email" msprop:Generator_UserColumnName="Email" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInTable="EmailColumn" minOccurs="0">
131 <xs:simpleType>
132 <xs:restriction base="xs:string">
133 <xs:maxLength value="20" />
134 </xs:restriction>
135 </xs:simpleType>
136 </xs:element>
137 <xs:element name="PhanLoaiGV" msprop:Generator_UserColumnName="PhanLoaiGV" msprop:Generator_ColumnPropNameInRow="PhanLoaiGV" msprop:Generator_ColumnVarNameInTable="columnPhanLoaiGV" msprop:Generator_ColumnPropNameInTable="PhanLoaiGVColumn" minOccurs="0">
138 <xs:simpleType>
139 <xs:restriction base="xs:string">
140 <xs:maxLength value="10" />
141 </xs:restriction>
142 </xs:simpleType>
143 </xs:element>
144 <xs:element name="Anh" msprop:Generator_UserColumnName="Anh" msprop:Generator_ColumnPropNameInRow="Anh" msprop:Generator_ColumnVarNameInTable="columnAnh" msprop:Generator_ColumnPropNameInTable="AnhColumn" type="xs:base64Binary" minOccurs="0" />
145 </xs:sequence>
146 </xs:complexType>
147 </xs:element>
148 </xs:choice>
149 </xs:complexType>
150 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
151 <xs:selector xpath=".//mstns:tblGIANG_VIEN" />
152 <xs:field xpath="mstns:MaGV" />
153 </xs:unique>
154 </xs:element>
155 </xs:schema>