PageRenderTime 54ms CodeModel.GetById 13ms app.highlight 30ms RepoModel.GetById 1ms app.codeStats 1ms

/Visual Studio 2008/VBVstoExcelWorkbook/SchoolDataSet.xsd

#
XML Schema | 895 lines | 895 code | 0 blank | 0 comment | 0 complexity | e621543b46f373c07dc5bc137bf890e9 MD5 | raw file

Large files files are truncated, but you can click here to view the full file

  1<?xml version="1.0" encoding="utf-8"?>
  2<xs:schema id="SchoolDataSet" targetNamespace="http://tempuri.org/SchoolDataSet.xsd" xmlns:mstns="http://tempuri.org/SchoolDataSet.xsd" xmlns="http://tempuri.org/SchoolDataSet.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" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
  6        <Connections>
  7          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="SchoolConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SchoolConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.VBVstoExcelWorkbook.MySettings.GlobalReference.Default.SchoolConnectionString" Provider="System.Data.SqlClient" />
  8        </Connections>
  9        <Tables>
 10          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseTableAdapter" GeneratorDataComponentClassName="CourseTableAdapter" Name="Course" UserDataComponentName="CourseTableAdapter">
 11            <MainSource>
 12              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.Course" 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].[Course] WHERE (([CourseID] = @Original_CourseID) AND ([Title] = @Original_Title) AND ([Credits] = @Original_Credits) AND ([DepartmentID] = @Original_DepartmentID))</CommandText>
 16                    <Parameters>
 17                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
 18                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
 19                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Original" />
 20                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 21                    </Parameters>
 22                  </DbCommand>
 23                </DeleteCommand>
 24                <InsertCommand>
 25                  <DbCommand CommandType="Text" ModifiedByUser="false">
 26                    <CommandText>INSERT INTO [dbo].[Course] ([CourseID], [Title], [Credits], [DepartmentID]) VALUES (@CourseID, @Title, @Credits, @DepartmentID);
 27SELECT CourseID, Title, Credits, DepartmentID FROM Course WHERE (CourseID = @CourseID)</CommandText>
 28                    <Parameters>
 29                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
 30                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
 31                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Current" />
 32                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
 33                    </Parameters>
 34                  </DbCommand>
 35                </InsertCommand>
 36                <SelectCommand>
 37                  <DbCommand CommandType="Text" ModifiedByUser="false">
 38                    <CommandText>SELECT CourseID, Title, Credits, DepartmentID FROM dbo.Course</CommandText>
 39                    <Parameters />
 40                  </DbCommand>
 41                </SelectCommand>
 42                <UpdateCommand>
 43                  <DbCommand CommandType="Text" ModifiedByUser="false">
 44                    <CommandText>UPDATE [dbo].[Course] SET [CourseID] = @CourseID, [Title] = @Title, [Credits] = @Credits, [DepartmentID] = @DepartmentID WHERE (([CourseID] = @Original_CourseID) AND ([Title] = @Original_Title) AND ([Credits] = @Original_Credits) AND ([DepartmentID] = @Original_DepartmentID));
 45SELECT CourseID, Title, Credits, DepartmentID FROM Course WHERE (CourseID = @CourseID)</CommandText>
 46                    <Parameters>
 47                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
 48                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
 49                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Current" />
 50                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
 51                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
 52                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
 53                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Credits" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Credits" SourceColumnNullMapping="false" SourceVersion="Original" />
 54                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 55                    </Parameters>
 56                  </DbCommand>
 57                </UpdateCommand>
 58              </DbSource>
 59            </MainSource>
 60            <Mappings>
 61              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
 62              <Mapping SourceColumn="Title" DataSetColumn="Title" />
 63              <Mapping SourceColumn="Credits" DataSetColumn="Credits" />
 64              <Mapping SourceColumn="DepartmentID" DataSetColumn="DepartmentID" />
 65            </Mappings>
 66            <Sources />
 67          </TableAdapter>
 68          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseGradeTableAdapter" GeneratorDataComponentClassName="CourseGradeTableAdapter" Name="CourseGrade" UserDataComponentName="CourseGradeTableAdapter">
 69            <MainSource>
 70              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.CourseGrade" 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">
 71                <DeleteCommand>
 72                  <DbCommand CommandType="Text" ModifiedByUser="false">
 73                    <CommandText>DELETE FROM [dbo].[CourseGrade] WHERE (([EnrollmentID] = @Original_EnrollmentID) AND ([CourseID] = @Original_CourseID) AND ([StudentID] = @Original_StudentID) AND ((@IsNull_Grade = 1 AND [Grade] IS NULL) OR ([Grade] = @Original_Grade)))</CommandText>
 74                    <Parameters>
 75                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnrollmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 76                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
 77                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Original" />
 78                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grade" SourceColumnNullMapping="true" SourceVersion="Original" />
 79                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Original" />
 80                    </Parameters>
 81                  </DbCommand>
 82                </DeleteCommand>
 83                <InsertCommand>
 84                  <DbCommand CommandType="Text" ModifiedByUser="false">
 85                    <CommandText>INSERT INTO [dbo].[CourseGrade] ([CourseID], [StudentID], [Grade]) VALUES (@CourseID, @StudentID, @Grade);
 86SELECT EnrollmentID, CourseID, StudentID, Grade FROM CourseGrade WHERE (EnrollmentID = SCOPE_IDENTITY())</CommandText>
 87                    <Parameters>
 88                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
 89                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
 90                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Current" />
 91                    </Parameters>
 92                  </DbCommand>
 93                </InsertCommand>
 94                <SelectCommand>
 95                  <DbCommand CommandType="Text" ModifiedByUser="false">
 96                    <CommandText>SELECT EnrollmentID, CourseID, StudentID, Grade FROM dbo.CourseGrade</CommandText>
 97                    <Parameters />
 98                  </DbCommand>
 99                </SelectCommand>
100                <UpdateCommand>
101                  <DbCommand CommandType="Text" ModifiedByUser="false">
102                    <CommandText>UPDATE [dbo].[CourseGrade] SET [CourseID] = @CourseID, [StudentID] = @StudentID, [Grade] = @Grade WHERE (([EnrollmentID] = @Original_EnrollmentID) AND ([CourseID] = @Original_CourseID) AND ([StudentID] = @Original_StudentID) AND ((@IsNull_Grade = 1 AND [Grade] IS NULL) OR ([Grade] = @Original_Grade)));
103SELECT EnrollmentID, CourseID, StudentID, Grade FROM CourseGrade WHERE (EnrollmentID = @EnrollmentID)</CommandText>
104                    <Parameters>
105                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
106                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Current" />
107                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Current" />
108                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnrollmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnrollmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
109                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
110                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StudentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StudentID" SourceColumnNullMapping="false" SourceVersion="Original" />
111                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Grade" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Grade" SourceColumnNullMapping="true" SourceVersion="Original" />
112                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Grade" Precision="3" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="Grade" SourceColumnNullMapping="false" SourceVersion="Original" />
113                      <Parameter AllowDbNull="false" AutogeneratedName="EnrollmentID" ColumnName="EnrollmentID" DataSourceName="SQLServer2005DB.dbo.CourseGrade" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EnrollmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EnrollmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
114                    </Parameters>
115                  </DbCommand>
116                </UpdateCommand>
117              </DbSource>
118            </MainSource>
119            <Mappings>
120              <Mapping SourceColumn="EnrollmentID" DataSetColumn="EnrollmentID" />
121              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
122              <Mapping SourceColumn="StudentID" DataSetColumn="StudentID" />
123              <Mapping SourceColumn="Grade" DataSetColumn="Grade" />
124            </Mappings>
125            <Sources />
126          </TableAdapter>
127          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseInstructorTableAdapter" GeneratorDataComponentClassName="CourseInstructorTableAdapter" Name="CourseInstructor" UserDataComponentName="CourseInstructorTableAdapter">
128            <MainSource>
129              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.CourseInstructor" 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">
130                <DeleteCommand>
131                  <DbCommand CommandType="Text" ModifiedByUser="false">
132                    <CommandText>DELETE FROM [dbo].[CourseInstructor] WHERE (([CourseID] = @Original_CourseID) AND ([PersonID] = @Original_PersonID))</CommandText>
133                    <Parameters>
134                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
135                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Original" />
136                    </Parameters>
137                  </DbCommand>
138                </DeleteCommand>
139                <InsertCommand>
140                  <DbCommand CommandType="Text" ModifiedByUser="false">
141                    <CommandText>INSERT INTO [dbo].[CourseInstructor] ([CourseID], [PersonID]) VALUES (@CourseID, @PersonID);
142SELECT CourseID, PersonID FROM CourseInstructor WHERE (CourseID = @CourseID) AND (PersonID = @PersonID)</CommandText>
143                    <Parameters>
144                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
145                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Current" />
146                    </Parameters>
147                  </DbCommand>
148                </InsertCommand>
149                <SelectCommand>
150                  <DbCommand CommandType="Text" ModifiedByUser="false">
151                    <CommandText>SELECT CourseID, PersonID FROM dbo.CourseInstructor</CommandText>
152                    <Parameters />
153                  </DbCommand>
154                </SelectCommand>
155                <UpdateCommand>
156                  <DbCommand CommandType="Text" ModifiedByUser="false">
157                    <CommandText>UPDATE [dbo].[CourseInstructor] SET [CourseID] = @CourseID, [PersonID] = @PersonID WHERE (([CourseID] = @Original_CourseID) AND ([PersonID] = @Original_PersonID));
158SELECT CourseID, PersonID FROM CourseInstructor WHERE (CourseID = @CourseID) AND (PersonID = @PersonID)</CommandText>
159                    <Parameters>
160                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
161                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Current" />
162                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
163                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PersonID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PersonID" SourceColumnNullMapping="false" SourceVersion="Original" />
164                    </Parameters>
165                  </DbCommand>
166                </UpdateCommand>
167              </DbSource>
168            </MainSource>
169            <Mappings>
170              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
171              <Mapping SourceColumn="PersonID" DataSetColumn="PersonID" />
172            </Mappings>
173            <Sources />
174          </TableAdapter>
175          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DepartmentTableAdapter" GeneratorDataComponentClassName="DepartmentTableAdapter" Name="Department" UserDataComponentName="DepartmentTableAdapter">
176            <MainSource>
177              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.Department" 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">
178                <DeleteCommand>
179                  <DbCommand CommandType="Text" ModifiedByUser="false">
180                    <CommandText>DELETE FROM [dbo].[Department] WHERE (([DepartmentID] = @Original_DepartmentID) AND ([Name] = @Original_Name) AND ([Budget] = @Original_Budget) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_Administrator = 1 AND [Administrator] IS NULL) OR ([Administrator] = @Original_Administrator)))</CommandText>
181                    <Parameters>
182                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
183                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
184                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Original" />
185                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
186                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="true" SourceVersion="Original" />
187                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Original" />
188                    </Parameters>
189                  </DbCommand>
190                </DeleteCommand>
191                <InsertCommand>
192                  <DbCommand CommandType="Text" ModifiedByUser="false">
193                    <CommandText>INSERT INTO [dbo].[Department] ([DepartmentID], [Name], [Budget], [StartDate], [Administrator]) VALUES (@DepartmentID, @Name, @Budget, @StartDate, @Administrator);
194SELECT DepartmentID, Name, Budget, StartDate, Administrator FROM Department WHERE (DepartmentID = @DepartmentID)</CommandText>
195                    <Parameters>
196                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
197                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
198                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Current" />
199                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
200                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Current" />
201                    </Parameters>
202                  </DbCommand>
203                </InsertCommand>
204                <SelectCommand>
205                  <DbCommand CommandType="Text" ModifiedByUser="false">
206                    <CommandText>SELECT DepartmentID, Name, Budget, StartDate, Administrator FROM dbo.Department</CommandText>
207                    <Parameters />
208                  </DbCommand>
209                </SelectCommand>
210                <UpdateCommand>
211                  <DbCommand CommandType="Text" ModifiedByUser="false">
212                    <CommandText>UPDATE [dbo].[Department] SET [DepartmentID] = @DepartmentID, [Name] = @Name, [Budget] = @Budget, [StartDate] = @StartDate, [Administrator] = @Administrator WHERE (([DepartmentID] = @Original_DepartmentID) AND ([Name] = @Original_Name) AND ([Budget] = @Original_Budget) AND ([StartDate] = @Original_StartDate) AND ((@IsNull_Administrator = 1 AND [Administrator] IS NULL) OR ([Administrator] = @Original_Administrator)));
213SELECT DepartmentID, Name, Budget, StartDate, Administrator FROM Department WHERE (DepartmentID = @DepartmentID)</CommandText>
214                    <Parameters>
215                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
216                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
217                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Current" />
218                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
219                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Current" />
220                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DepartmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DepartmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
221                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
222                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Original_Budget" Precision="0" ProviderType="Money" Scale="0" Size="0" SourceColumn="Budget" SourceColumnNullMapping="false" SourceVersion="Original" />
223                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
224                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="true" SourceVersion="Original" />
225                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Administrator" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Administrator" SourceColumnNullMapping="false" SourceVersion="Original" />
226                    </Parameters>
227                  </DbCommand>
228                </UpdateCommand>
229              </DbSource>
230            </MainSource>
231            <Mappings>
232              <Mapping SourceColumn="DepartmentID" DataSetColumn="DepartmentID" />
233              <Mapping SourceColumn="Name" DataSetColumn="Name" />
234              <Mapping SourceColumn="Budget" DataSetColumn="Budget" />
235              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
236              <Mapping SourceColumn="Administrator" DataSetColumn="Administrator" />
237            </Mappings>
238            <Sources />
239          </TableAdapter>
240          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OfficeAssignmentTableAdapter" GeneratorDataComponentClassName="OfficeAssignmentTableAdapter" Name="OfficeAssignment" UserDataComponentName="OfficeAssignmentTableAdapter">
241            <MainSource>
242              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.OfficeAssignment" 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">
243                <DeleteCommand>
244                  <DbCommand CommandType="Text" ModifiedByUser="false">
245                    <CommandText>DELETE FROM [dbo].[OfficeAssignment] WHERE (([InstructorID] = @Original_InstructorID) AND ([Timestamp] = @Original_Timestamp))</CommandText>
246                    <Parameters>
247                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Original" />
248                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
249                    </Parameters>
250                  </DbCommand>
251                </DeleteCommand>
252                <InsertCommand>
253                  <DbCommand CommandType="Text" ModifiedByUser="false">
254                    <CommandText>INSERT INTO [dbo].[OfficeAssignment] ([InstructorID], [Location]) VALUES (@InstructorID, @Location);
255SELECT InstructorID, Location, Timestamp FROM OfficeAssignment WHERE (InstructorID = @InstructorID)</CommandText>
256                    <Parameters>
257                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Current" />
258                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
259                    </Parameters>
260                  </DbCommand>
261                </InsertCommand>
262                <SelectCommand>
263                  <DbCommand CommandType="Text" ModifiedByUser="false">
264                    <CommandText>SELECT InstructorID, Location, Timestamp FROM dbo.OfficeAssignment</CommandText>
265                    <Parameters />
266                  </DbCommand>
267                </SelectCommand>
268                <UpdateCommand>
269                  <DbCommand CommandType="Text" ModifiedByUser="false">
270                    <CommandText>UPDATE [dbo].[OfficeAssignment] SET [InstructorID] = @InstructorID, [Location] = @Location WHERE (([InstructorID] = @Original_InstructorID) AND ([Timestamp] = @Original_Timestamp));
271SELECT InstructorID, Location, Timestamp FROM OfficeAssignment WHERE (InstructorID = @InstructorID)</CommandText>
272                    <Parameters>
273                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Current" />
274                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
275                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_InstructorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InstructorID" SourceColumnNullMapping="false" SourceVersion="Original" />
276                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="Timestamp" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="false" SourceVersion="Original" />
277                    </Parameters>
278                  </DbCommand>
279                </UpdateCommand>
280              </DbSource>
281            </MainSource>
282            <Mappings>
283              <Mapping SourceColumn="InstructorID" DataSetColumn="InstructorID" />
284              <Mapping SourceColumn="Location" DataSetColumn="Location" />
285              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
286            </Mappings>
287            <Sources />
288          </TableAdapter>
289          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnlineCourseTableAdapter" GeneratorDataComponentClassName="OnlineCourseTableAdapter" Name="OnlineCourse" UserDataComponentName="OnlineCourseTableAdapter">
290            <MainSource>
291              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.OnlineCourse" 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">
292                <DeleteCommand>
293                  <DbCommand CommandType="Text" ModifiedByUser="false">
294                    <CommandText>DELETE FROM [dbo].[OnlineCourse] WHERE (([CourseID] = @Original_CourseID) AND ([URL] = @Original_URL))</CommandText>
295                    <Parameters>
296                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
297                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
298                    </Parameters>
299                  </DbCommand>
300                </DeleteCommand>
301                <InsertCommand>
302                  <DbCommand CommandType="Text" ModifiedByUser="false">
303                    <CommandText>INSERT INTO [dbo].[OnlineCourse] ([CourseID], [URL]) VALUES (@CourseID, @URL);
304SELECT CourseID, URL FROM OnlineCourse WHERE (CourseID = @CourseID)</CommandText>
305                    <Parameters>
306                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
307                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
308                    </Parameters>
309                  </DbCommand>
310                </InsertCommand>
311                <SelectCommand>
312                  <DbCommand CommandType="Text" ModifiedByUser="false">
313                    <CommandText>SELECT CourseID, URL FROM dbo.OnlineCourse</CommandText>
314                    <Parameters />
315                  </DbCommand>
316                </SelectCommand>
317                <UpdateCommand>
318                  <DbCommand CommandType="Text" ModifiedByUser="false">
319                    <CommandText>UPDATE [dbo].[OnlineCourse] SET [CourseID] = @CourseID, [URL] = @URL WHERE (([CourseID] = @Original_CourseID) AND ([URL] = @Original_URL));
320SELECT CourseID, URL FROM OnlineCourse WHERE (CourseID = @CourseID)</CommandText>
321                    <Parameters>
322                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
323                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
324                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
325                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Original" />
326                    </Parameters>
327                  </DbCommand>
328                </UpdateCommand>
329              </DbSource>
330            </MainSource>
331            <Mappings>
332              <Mapping SourceColumn="CourseID" DataSetColumn="CourseID" />
333              <Mapping SourceColumn="URL" DataSetColumn="URL" />
334            </Mappings>
335            <Sources />
336          </TableAdapter>
337          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OnsiteCourseTableAdapter" GeneratorDataComponentClassName="OnsiteCourseTableAdapter" Name="OnsiteCourse" UserDataComponentName="OnsiteCourseTableAdapter">
338            <MainSource>
339              <DbSource ConnectionRef="SchoolConnectionString (MySettings)" DbObjectName="SQLServer2005DB.dbo.OnsiteCourse" 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">
340                <DeleteCommand>
341                  <DbCommand CommandType="Text" ModifiedByUser="false">
342                    <CommandText>DELETE FROM [dbo].[OnsiteCourse] WHERE (([CourseID] = @Original_CourseID) AND ([Location] = @Original_Location) AND ([Days] = @Original_Days) AND ([Time] = @Original_Time))</CommandText>
343                    <Parameters>
344                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Original" />
345                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
346                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Days" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Days" SourceColumnNullMapping="false" SourceVersion="Original" />
347                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Original" />
348                    </Parameters>
349                  </DbCommand>
350                </DeleteCommand>
351                <InsertCommand>
352                  <DbCommand CommandType="Text" ModifiedByUser="false">
353                    <CommandText>INSERT INTO [dbo].[OnsiteCourse] ([CourseID], [Location], [Days], [Time]) VALUES (@CourseID, @Location, @Days, @Time);
354SELECT CourseID, Location, Days, Time FROM OnsiteCourse WHERE (CourseID = @CourseID)</CommandText>
355                    <Parameters>
356                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
357                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
358                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Days" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Days" SourceColumnNullMapping="false" SourceVersion="Current" />
359                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" />
360                    </Parameters>
361                  </DbCommand>
362                </InsertCommand>
363                <SelectCommand>
364                  <DbCommand CommandType="Text" ModifiedByUser="false">
365                    <CommandText>SELECT CourseID, Location, Days, Time FROM dbo.OnsiteCourse</CommandText>
366                    <Parameters />
367                  </DbCommand>
368                </SelectCommand>
369                <UpdateCommand>
370                  <DbCommand CommandType="Text" ModifiedByUser="false">
371                    <CommandText>UPDATE [dbo].[OnsiteCourse] SET [CourseID] = @CourseID, [Location] = @Location, [Days] = @Days, [Time] = @Time WHERE (([CourseID] = @Original_CourseID) AND ([Location] = @Original_Location) AND ([Days] = @Original_Days) AND ([Time] = @Original_Time));
372SELECT CourseID, Location, Days, Time FROM OnsiteCourse WHERE (CourseID = @CourseID)</CommandText>
373                    <Parameters>
374                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CourseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CourseID" SourceColumnNullMapping="false" SourceVersion="Current" />
375                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
376                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Days" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Days" SourceColumnNullMapping="false" SourceVersion="Current" />
377                      <Parameter

Large files files are truncated, but you can click here to view the full file