Quản lý điểm sinh viên CNTT
177.549 lượt xem;
- QuanlydiemDataSet17.xsd
- Quản lý điểm sinh vien CNTT /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="QuanlydiemDataSet17" targetNamespace="http://tempuri.org/QuanlydiemDataSet17.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet17.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet17.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="tblKET_QUATableAdapter" GeneratorDataComponentClassName="tblKET_QUATableAdapter" Name="tblKET_QUA" UserDataComponentName="tblKET_QUATableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblKET_QUA" 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].[tblKET_QUA] WHERE (([MaSV] = @Original_MaSV) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)) AND ([MaMon] = @Original_MaMon) AND ((@IsNull_DiemTB = 1 AND [DiemTB] IS NULL) OR ([DiemTB] = @Original_DiemTB)) AND ((@IsNull_DiemThiLan1 = 1 AND [DiemThiLan1] IS NULL) OR ([DiemThiLan1] = @Original_DiemThiLan1)) AND ((@IsNull_DiemThiLan2 = 1 AND [DiemThiLan2] IS NULL) OR ([DiemThiLan2] = @Original_DiemThiLan2)) AND ((@IsNull_DiemTongKet = 1 AND [DiemTongKet] IS NULL) OR ([DiemTongKet] = @Original_DiemTongKet)) AND ((@IsNull_HanhKiem = 1 AND [HanhKiem] IS NULL) OR ([HanhKiem] = @Original_HanhKiem)) AND ((@IsNull_HocKi = 1 AND [HocKi] IS NULL) OR ([HocKi] = @Original_HocKi)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)))</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_MaLop" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <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" />
22 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="true" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="true" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="true" SourceVersion="Original" />
28 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Original" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTongKet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="true" SourceVersion="Original" />
30 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Original" />
31 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HanhKiem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="true" SourceVersion="Original" />
32 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Original" />
33 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="true" SourceVersion="Original" />
34 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Original" />
35 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
36 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
37 </Parameters>
38 </DbCommand>
39 </DeleteCommand>
40 <InsertCommand>
41 <DbCommand CommandType="Text" ModifiedByUser="false">
42 <CommandText>INSERT INTO [dbo].[tblKET_QUA] ([MaSV], [HoTen], [MaLop], [MaMon], [DiemTB], [DiemThiLan1], [DiemThiLan2], [DiemTongKet], [HanhKiem], [HocKi], [GhiChu]) VALUES (@MaSV, @HoTen, @MaLop, @MaMon, @DiemTB, @DiemThiLan1, @DiemThiLan2, @DiemTongKet, @HanhKiem, @HocKi, @GhiChu);
43 SELECT MaSV, HoTen, MaLop, MaMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM tblKET_QUA WHERE (MaMon = @MaMon) AND (MaSV = @MaSV)</CommandText>
44 <Parameters>
45 <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" />
46 <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" />
47 <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" />
48 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Current" />
49 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Current" />
50 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Current" />
51 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Current" />
52 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Current" />
53 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Current" />
54 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Current" />
55 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
56 </Parameters>
57 </DbCommand>
58 </InsertCommand>
59 <SelectCommand>
60 <DbCommand CommandType="Text" ModifiedByUser="false">
61 <CommandText>SELECT MaSV, HoTen, MaLop, MaMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM dbo.tblKET_QUA</CommandText>
62 <Parameters />
63 </DbCommand>
64 </SelectCommand>
65 <UpdateCommand>
66 <DbCommand CommandType="Text" ModifiedByUser="false">
67 <CommandText>UPDATE [dbo].[tblKET_QUA] SET [MaSV] = @MaSV, [HoTen] = @HoTen, [MaLop] = @MaLop, [MaMon] = @MaMon, [DiemTB] = @DiemTB, [DiemThiLan1] = @DiemThiLan1, [DiemThiLan2] = @DiemThiLan2, [DiemTongKet] = @DiemTongKet, [HanhKiem] = @HanhKiem, [HocKi] = @HocKi, [GhiChu] = @GhiChu WHERE (([MaSV] = @Original_MaSV) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)) AND ([MaMon] = @Original_MaMon) AND ((@IsNull_DiemTB = 1 AND [DiemTB] IS NULL) OR ([DiemTB] = @Original_DiemTB)) AND ((@IsNull_DiemThiLan1 = 1 AND [DiemThiLan1] IS NULL) OR ([DiemThiLan1] = @Original_DiemThiLan1)) AND ((@IsNull_DiemThiLan2 = 1 AND [DiemThiLan2] IS NULL) OR ([DiemThiLan2] = @Original_DiemThiLan2)) AND ((@IsNull_DiemTongKet = 1 AND [DiemTongKet] IS NULL) OR ([DiemTongKet] = @Original_DiemTongKet)) AND ((@IsNull_HanhKiem = 1 AND [HanhKiem] IS NULL) OR ([HanhKiem] = @Original_HanhKiem)) AND ((@IsNull_HocKi = 1 AND [HocKi] IS NULL) OR ([HocKi] = @Original_HocKi)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)));
68 SELECT MaSV, HoTen, MaLop, MaMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM tblKET_QUA WHERE (MaMon = @MaMon) AND (MaSV = @MaSV)</CommandText>
69 <Parameters>
70 <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" />
71 <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" />
72 <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" />
73 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Current" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Current" />
75 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Current" />
76 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Current" />
77 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Current" />
78 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Current" />
79 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Current" />
80 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
81 <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" />
82 <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" />
83 <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" />
84 <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" />
85 <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" />
86 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Original" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="true" SourceVersion="Original" />
88 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Original" />
89 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="true" SourceVersion="Original" />
90 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Original" />
91 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="true" SourceVersion="Original" />
92 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Original" />
93 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTongKet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="true" SourceVersion="Original" />
94 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Original" />
95 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HanhKiem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="true" SourceVersion="Original" />
96 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Original" />
97 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="true" SourceVersion="Original" />
98 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Original" />
99 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
100 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
101 </Parameters>
102 </DbCommand>
103 </UpdateCommand>
104 </DbSource>
105 </MainSource>
106 <Mappings>
107 <Mapping SourceColumn="MaSV" DataSetColumn="MaSV" />
108 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
109 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
110 <Mapping SourceColumn="MaMon" DataSetColumn="MaMon" />
111 <Mapping SourceColumn="DiemTB" DataSetColumn="DiemTB" />
112 <Mapping SourceColumn="DiemThiLan1" DataSetColumn="DiemThiLan1" />
113 <Mapping SourceColumn="DiemThiLan2" DataSetColumn="DiemThiLan2" />
114 <Mapping SourceColumn="DiemTongKet" DataSetColumn="DiemTongKet" />
115 <Mapping SourceColumn="HanhKiem" DataSetColumn="HanhKiem" />
116 <Mapping SourceColumn="HocKi" DataSetColumn="HocKi" />
117 <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
118 </Mappings>
119 <Sources />
120 </TableAdapter>
121 </Tables>
122 <Sources />
123 </DataSource>
124 </xs:appinfo>
125 </xs:annotation>
126 <xs:element name="QuanlydiemDataSet17" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet17" msprop:Generator_UserDSName="QuanlydiemDataSet17" msprop:EnableTableAdapterManager="True">
127 <xs:complexType>
128 <xs:choice minOccurs="0" maxOccurs="unbounded">
129 <xs:element name="tblKET_QUA" msprop:Generator_UserTableName="tblKET_QUA" msprop:Generator_RowDeletedName="tblKET_QUARowDeleted" msprop:Generator_TableClassName="tblKET_QUADataTable" msprop:Generator_RowChangedName="tblKET_QUARowChanged" msprop:Generator_RowClassName="tblKET_QUARow" msprop:Generator_RowChangingName="tblKET_QUARowChanging" msprop:Generator_RowEvArgName="tblKET_QUARowChangeEvent" msprop:Generator_RowEvHandlerName="tblKET_QUARowChangeEventHandler" msprop:Generator_TablePropName="tblKET_QUA" msprop:Generator_TableVarName="tabletblKET_QUA" msprop:Generator_RowDeletingName="tblKET_QUARowDeleting">
130 <xs:complexType>
131 <xs:sequence>
132 <xs:element name="MaSV" msprop:Generator_UserColumnName="MaSV" msprop:Generator_ColumnPropNameInRow="MaSV" msprop:Generator_ColumnVarNameInTable="columnMaSV" msprop:Generator_ColumnPropNameInTable="MaSVColumn">
133 <xs:simpleType>
134 <xs:restriction base="xs:string">
135 <xs:maxLength value="10" />
136 </xs:restriction>
137 </xs:simpleType>
138 </xs:element>
139 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
140 <xs:simpleType>
141 <xs:restriction base="xs:string">
142 <xs:maxLength value="30" />
143 </xs:restriction>
144 </xs:simpleType>
145 </xs:element>
146 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
147 <xs:simpleType>
148 <xs:restriction base="xs:string">
149 <xs:maxLength value="10" />
150 </xs:restriction>
151 </xs:simpleType>
152 </xs:element>
153 <xs:element name="MaMon" msprop:Generator_UserColumnName="MaMon" msprop:Generator_ColumnPropNameInRow="MaMon" msprop:Generator_ColumnVarNameInTable="columnMaMon" msprop:Generator_ColumnPropNameInTable="MaMonColumn">
154 <xs:simpleType>
155 <xs:restriction base="xs:string">
156 <xs:maxLength value="20" />
157 </xs:restriction>
158 </xs:simpleType>
159 </xs:element>
160 <xs:element name="DiemTB" msprop:Generator_UserColumnName="DiemTB" msprop:Generator_ColumnPropNameInRow="DiemTB" msprop:Generator_ColumnVarNameInTable="columnDiemTB" msprop:Generator_ColumnPropNameInTable="DiemTBColumn" minOccurs="0">
161 <xs:simpleType>
162 <xs:restriction base="xs:string">
163 <xs:maxLength value="10" />
164 </xs:restriction>
165 </xs:simpleType>
166 </xs:element>
167 <xs:element name="DiemThiLan1" msprop:Generator_UserColumnName="DiemThiLan1" msprop:Generator_ColumnPropNameInRow="DiemThiLan1" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan1" msprop:Generator_ColumnPropNameInTable="DiemThiLan1Column" type="xs:double" minOccurs="0" />
168 <xs:element name="DiemThiLan2" msprop:Generator_UserColumnName="DiemThiLan2" msprop:Generator_ColumnPropNameInRow="DiemThiLan2" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan2" msprop:Generator_ColumnPropNameInTable="DiemThiLan2Column" type="xs:double" minOccurs="0" />
169 <xs:element name="DiemTongKet" msprop:Generator_UserColumnName="DiemTongKet" msprop:Generator_ColumnPropNameInRow="DiemTongKet" msprop:Generator_ColumnVarNameInTable="columnDiemTongKet" msprop:Generator_ColumnPropNameInTable="DiemTongKetColumn" type="xs:double" minOccurs="0" />
170 <xs:element name="HanhKiem" msprop:Generator_UserColumnName="HanhKiem" msprop:Generator_ColumnPropNameInRow="HanhKiem" msprop:Generator_ColumnVarNameInTable="columnHanhKiem" msprop:Generator_ColumnPropNameInTable="HanhKiemColumn" minOccurs="0">
171 <xs:simpleType>
172 <xs:restriction base="xs:string">
173 <xs:maxLength value="10" />
174 </xs:restriction>
175 </xs:simpleType>
176 </xs:element>
177 <xs:element name="HocKi" msprop:Generator_UserColumnName="HocKi" msprop:Generator_ColumnPropNameInRow="HocKi" msprop:Generator_ColumnVarNameInTable="columnHocKi" msprop:Generator_ColumnPropNameInTable="HocKiColumn" type="xs:int" minOccurs="0" />
178 <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
179 <xs:simpleType>
180 <xs:restriction base="xs:string">
181 <xs:maxLength value="200" />
182 </xs:restriction>
183 </xs:simpleType>
184 </xs:element>
185 </xs:sequence>
186 </xs:complexType>
187 </xs:element>
188 </xs:choice>
189 </xs:complexType>
190 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
191 <xs:selector xpath=".//mstns:tblKET_QUA" />
192 <xs:field xpath="mstns:MaSV" />
193 <xs:field xpath="mstns:MaMon" />
194 </xs:unique>
195 </xs:element>
196 </xs:schema>
2 <xs:schema id="QuanlydiemDataSet17" targetNamespace="http://tempuri.org/QuanlydiemDataSet17.xsd" xmlns:mstns="http://tempuri.org/QuanlydiemDataSet17.xsd" xmlns="http://tempuri.org/QuanlydiemDataSet17.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="tblKET_QUATableAdapter" GeneratorDataComponentClassName="tblKET_QUATableAdapter" Name="tblKET_QUA" UserDataComponentName="tblKET_QUATableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanlydiemConnectionString2 (Settings)" DbObjectName="Quanlydiem.dbo.tblKET_QUA" 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].[tblKET_QUA] WHERE (([MaSV] = @Original_MaSV) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)) AND ([MaMon] = @Original_MaMon) AND ((@IsNull_DiemTB = 1 AND [DiemTB] IS NULL) OR ([DiemTB] = @Original_DiemTB)) AND ((@IsNull_DiemThiLan1 = 1 AND [DiemThiLan1] IS NULL) OR ([DiemThiLan1] = @Original_DiemThiLan1)) AND ((@IsNull_DiemThiLan2 = 1 AND [DiemThiLan2] IS NULL) OR ([DiemThiLan2] = @Original_DiemThiLan2)) AND ((@IsNull_DiemTongKet = 1 AND [DiemTongKet] IS NULL) OR ([DiemTongKet] = @Original_DiemTongKet)) AND ((@IsNull_HanhKiem = 1 AND [HanhKiem] IS NULL) OR ([HanhKiem] = @Original_HanhKiem)) AND ((@IsNull_HocKi = 1 AND [HocKi] IS NULL) OR ([HocKi] = @Original_HocKi)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)))</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_MaLop" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MaLop" SourceColumnNullMapping="true" SourceVersion="Original" />
21 <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" />
22 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Original" />
23 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="true" SourceVersion="Original" />
24 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Original" />
25 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="true" SourceVersion="Original" />
26 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Original" />
27 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="true" SourceVersion="Original" />
28 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Original" />
29 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTongKet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="true" SourceVersion="Original" />
30 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Original" />
31 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HanhKiem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="true" SourceVersion="Original" />
32 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Original" />
33 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="true" SourceVersion="Original" />
34 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Original" />
35 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
36 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
37 </Parameters>
38 </DbCommand>
39 </DeleteCommand>
40 <InsertCommand>
41 <DbCommand CommandType="Text" ModifiedByUser="false">
42 <CommandText>INSERT INTO [dbo].[tblKET_QUA] ([MaSV], [HoTen], [MaLop], [MaMon], [DiemTB], [DiemThiLan1], [DiemThiLan2], [DiemTongKet], [HanhKiem], [HocKi], [GhiChu]) VALUES (@MaSV, @HoTen, @MaLop, @MaMon, @DiemTB, @DiemThiLan1, @DiemThiLan2, @DiemTongKet, @HanhKiem, @HocKi, @GhiChu);
43 SELECT MaSV, HoTen, MaLop, MaMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM tblKET_QUA WHERE (MaMon = @MaMon) AND (MaSV = @MaSV)</CommandText>
44 <Parameters>
45 <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" />
46 <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" />
47 <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" />
48 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Current" />
49 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Current" />
50 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Current" />
51 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Current" />
52 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Current" />
53 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Current" />
54 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Current" />
55 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
56 </Parameters>
57 </DbCommand>
58 </InsertCommand>
59 <SelectCommand>
60 <DbCommand CommandType="Text" ModifiedByUser="false">
61 <CommandText>SELECT MaSV, HoTen, MaLop, MaMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM dbo.tblKET_QUA</CommandText>
62 <Parameters />
63 </DbCommand>
64 </SelectCommand>
65 <UpdateCommand>
66 <DbCommand CommandType="Text" ModifiedByUser="false">
67 <CommandText>UPDATE [dbo].[tblKET_QUA] SET [MaSV] = @MaSV, [HoTen] = @HoTen, [MaLop] = @MaLop, [MaMon] = @MaMon, [DiemTB] = @DiemTB, [DiemThiLan1] = @DiemThiLan1, [DiemThiLan2] = @DiemThiLan2, [DiemTongKet] = @DiemTongKet, [HanhKiem] = @HanhKiem, [HocKi] = @HocKi, [GhiChu] = @GhiChu WHERE (([MaSV] = @Original_MaSV) AND ((@IsNull_HoTen = 1 AND [HoTen] IS NULL) OR ([HoTen] = @Original_HoTen)) AND ((@IsNull_MaLop = 1 AND [MaLop] IS NULL) OR ([MaLop] = @Original_MaLop)) AND ([MaMon] = @Original_MaMon) AND ((@IsNull_DiemTB = 1 AND [DiemTB] IS NULL) OR ([DiemTB] = @Original_DiemTB)) AND ((@IsNull_DiemThiLan1 = 1 AND [DiemThiLan1] IS NULL) OR ([DiemThiLan1] = @Original_DiemThiLan1)) AND ((@IsNull_DiemThiLan2 = 1 AND [DiemThiLan2] IS NULL) OR ([DiemThiLan2] = @Original_DiemThiLan2)) AND ((@IsNull_DiemTongKet = 1 AND [DiemTongKet] IS NULL) OR ([DiemTongKet] = @Original_DiemTongKet)) AND ((@IsNull_HanhKiem = 1 AND [HanhKiem] IS NULL) OR ([HanhKiem] = @Original_HanhKiem)) AND ((@IsNull_HocKi = 1 AND [HocKi] IS NULL) OR ([HocKi] = @Original_HocKi)) AND ((@IsNull_GhiChu = 1 AND [GhiChu] IS NULL) OR ([GhiChu] = @Original_GhiChu)));
68 SELECT MaSV, HoTen, MaLop, MaMon, DiemTB, DiemThiLan1, DiemThiLan2, DiemTongKet, HanhKiem, HocKi, GhiChu FROM tblKET_QUA WHERE (MaMon = @MaMon) AND (MaSV = @MaSV)</CommandText>
69 <Parameters>
70 <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" />
71 <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" />
72 <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" />
73 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Current" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Current" />
75 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Current" />
76 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Current" />
77 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Current" />
78 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Current" />
79 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Current" />
80 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Current" />
81 <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" />
82 <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" />
83 <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" />
84 <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" />
85 <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" />
86 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_MaMon" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="MaMon" SourceColumnNullMapping="false" SourceVersion="Original" />
87 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTB" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="true" SourceVersion="Original" />
88 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_DiemTB" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DiemTB" SourceColumnNullMapping="false" SourceVersion="Original" />
89 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="true" SourceVersion="Original" />
90 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan1" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan1" SourceColumnNullMapping="false" SourceVersion="Original" />
91 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemThiLan2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="true" SourceVersion="Original" />
92 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemThiLan2" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemThiLan2" SourceColumnNullMapping="false" SourceVersion="Original" />
93 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DiemTongKet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="true" SourceVersion="Original" />
94 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_DiemTongKet" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="DiemTongKet" SourceColumnNullMapping="false" SourceVersion="Original" />
95 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HanhKiem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="true" SourceVersion="Original" />
96 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_HanhKiem" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="HanhKiem" SourceColumnNullMapping="false" SourceVersion="Original" />
97 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="true" SourceVersion="Original" />
98 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HocKi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HocKi" SourceColumnNullMapping="false" SourceVersion="Original" />
99 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GhiChu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="true" SourceVersion="Original" />
100 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_GhiChu" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="GhiChu" SourceColumnNullMapping="false" SourceVersion="Original" />
101 </Parameters>
102 </DbCommand>
103 </UpdateCommand>
104 </DbSource>
105 </MainSource>
106 <Mappings>
107 <Mapping SourceColumn="MaSV" DataSetColumn="MaSV" />
108 <Mapping SourceColumn="HoTen" DataSetColumn="HoTen" />
109 <Mapping SourceColumn="MaLop" DataSetColumn="MaLop" />
110 <Mapping SourceColumn="MaMon" DataSetColumn="MaMon" />
111 <Mapping SourceColumn="DiemTB" DataSetColumn="DiemTB" />
112 <Mapping SourceColumn="DiemThiLan1" DataSetColumn="DiemThiLan1" />
113 <Mapping SourceColumn="DiemThiLan2" DataSetColumn="DiemThiLan2" />
114 <Mapping SourceColumn="DiemTongKet" DataSetColumn="DiemTongKet" />
115 <Mapping SourceColumn="HanhKiem" DataSetColumn="HanhKiem" />
116 <Mapping SourceColumn="HocKi" DataSetColumn="HocKi" />
117 <Mapping SourceColumn="GhiChu" DataSetColumn="GhiChu" />
118 </Mappings>
119 <Sources />
120 </TableAdapter>
121 </Tables>
122 <Sources />
123 </DataSource>
124 </xs:appinfo>
125 </xs:annotation>
126 <xs:element name="QuanlydiemDataSet17" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="QuanlydiemDataSet17" msprop:Generator_UserDSName="QuanlydiemDataSet17" msprop:EnableTableAdapterManager="True">
127 <xs:complexType>
128 <xs:choice minOccurs="0" maxOccurs="unbounded">
129 <xs:element name="tblKET_QUA" msprop:Generator_UserTableName="tblKET_QUA" msprop:Generator_RowDeletedName="tblKET_QUARowDeleted" msprop:Generator_TableClassName="tblKET_QUADataTable" msprop:Generator_RowChangedName="tblKET_QUARowChanged" msprop:Generator_RowClassName="tblKET_QUARow" msprop:Generator_RowChangingName="tblKET_QUARowChanging" msprop:Generator_RowEvArgName="tblKET_QUARowChangeEvent" msprop:Generator_RowEvHandlerName="tblKET_QUARowChangeEventHandler" msprop:Generator_TablePropName="tblKET_QUA" msprop:Generator_TableVarName="tabletblKET_QUA" msprop:Generator_RowDeletingName="tblKET_QUARowDeleting">
130 <xs:complexType>
131 <xs:sequence>
132 <xs:element name="MaSV" msprop:Generator_UserColumnName="MaSV" msprop:Generator_ColumnPropNameInRow="MaSV" msprop:Generator_ColumnVarNameInTable="columnMaSV" msprop:Generator_ColumnPropNameInTable="MaSVColumn">
133 <xs:simpleType>
134 <xs:restriction base="xs:string">
135 <xs:maxLength value="10" />
136 </xs:restriction>
137 </xs:simpleType>
138 </xs:element>
139 <xs:element name="HoTen" msprop:Generator_UserColumnName="HoTen" msprop:Generator_ColumnPropNameInRow="HoTen" msprop:Generator_ColumnVarNameInTable="columnHoTen" msprop:Generator_ColumnPropNameInTable="HoTenColumn" minOccurs="0">
140 <xs:simpleType>
141 <xs:restriction base="xs:string">
142 <xs:maxLength value="30" />
143 </xs:restriction>
144 </xs:simpleType>
145 </xs:element>
146 <xs:element name="MaLop" msprop:Generator_UserColumnName="MaLop" msprop:Generator_ColumnPropNameInRow="MaLop" msprop:Generator_ColumnVarNameInTable="columnMaLop" msprop:Generator_ColumnPropNameInTable="MaLopColumn" minOccurs="0">
147 <xs:simpleType>
148 <xs:restriction base="xs:string">
149 <xs:maxLength value="10" />
150 </xs:restriction>
151 </xs:simpleType>
152 </xs:element>
153 <xs:element name="MaMon" msprop:Generator_UserColumnName="MaMon" msprop:Generator_ColumnPropNameInRow="MaMon" msprop:Generator_ColumnVarNameInTable="columnMaMon" msprop:Generator_ColumnPropNameInTable="MaMonColumn">
154 <xs:simpleType>
155 <xs:restriction base="xs:string">
156 <xs:maxLength value="20" />
157 </xs:restriction>
158 </xs:simpleType>
159 </xs:element>
160 <xs:element name="DiemTB" msprop:Generator_UserColumnName="DiemTB" msprop:Generator_ColumnPropNameInRow="DiemTB" msprop:Generator_ColumnVarNameInTable="columnDiemTB" msprop:Generator_ColumnPropNameInTable="DiemTBColumn" minOccurs="0">
161 <xs:simpleType>
162 <xs:restriction base="xs:string">
163 <xs:maxLength value="10" />
164 </xs:restriction>
165 </xs:simpleType>
166 </xs:element>
167 <xs:element name="DiemThiLan1" msprop:Generator_UserColumnName="DiemThiLan1" msprop:Generator_ColumnPropNameInRow="DiemThiLan1" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan1" msprop:Generator_ColumnPropNameInTable="DiemThiLan1Column" type="xs:double" minOccurs="0" />
168 <xs:element name="DiemThiLan2" msprop:Generator_UserColumnName="DiemThiLan2" msprop:Generator_ColumnPropNameInRow="DiemThiLan2" msprop:Generator_ColumnVarNameInTable="columnDiemThiLan2" msprop:Generator_ColumnPropNameInTable="DiemThiLan2Column" type="xs:double" minOccurs="0" />
169 <xs:element name="DiemTongKet" msprop:Generator_UserColumnName="DiemTongKet" msprop:Generator_ColumnPropNameInRow="DiemTongKet" msprop:Generator_ColumnVarNameInTable="columnDiemTongKet" msprop:Generator_ColumnPropNameInTable="DiemTongKetColumn" type="xs:double" minOccurs="0" />
170 <xs:element name="HanhKiem" msprop:Generator_UserColumnName="HanhKiem" msprop:Generator_ColumnPropNameInRow="HanhKiem" msprop:Generator_ColumnVarNameInTable="columnHanhKiem" msprop:Generator_ColumnPropNameInTable="HanhKiemColumn" minOccurs="0">
171 <xs:simpleType>
172 <xs:restriction base="xs:string">
173 <xs:maxLength value="10" />
174 </xs:restriction>
175 </xs:simpleType>
176 </xs:element>
177 <xs:element name="HocKi" msprop:Generator_UserColumnName="HocKi" msprop:Generator_ColumnPropNameInRow="HocKi" msprop:Generator_ColumnVarNameInTable="columnHocKi" msprop:Generator_ColumnPropNameInTable="HocKiColumn" type="xs:int" minOccurs="0" />
178 <xs:element name="GhiChu" msprop:Generator_UserColumnName="GhiChu" msprop:Generator_ColumnPropNameInRow="GhiChu" msprop:Generator_ColumnVarNameInTable="columnGhiChu" msprop:Generator_ColumnPropNameInTable="GhiChuColumn" minOccurs="0">
179 <xs:simpleType>
180 <xs:restriction base="xs:string">
181 <xs:maxLength value="200" />
182 </xs:restriction>
183 </xs:simpleType>
184 </xs:element>
185 </xs:sequence>
186 </xs:complexType>
187 </xs:element>
188 </xs:choice>
189 </xs:complexType>
190 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
191 <xs:selector xpath=".//mstns:tblKET_QUA" />
192 <xs:field xpath="mstns:MaSV" />
193 <xs:field xpath="mstns:MaMon" />
194 </xs:unique>
195 </xs:element>
196 </xs:schema>