代码拉取完成，页面将自动刷新
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="jobDBDataSet" targetNamespace="http://tempuri.org/jobDBDataSet.xsd" xmlns:mstns="http://tempuri.org/jobDBDataSet.xsd" xmlns="http://tempuri.org/jobDBDataSet.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">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="jobDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="jobDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.job.Properties.Settings.GlobalReference.Default.jobDBConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="company_adminTableAdapter" GeneratorDataComponentClassName="company_adminTableAdapter" Name="company_admin" UserDataComponentName="company_adminTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.company_admin" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[company_admin] WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_sex = 1 AND [sex] IS NULL) OR ([sex] = @Original_sex)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[company_admin] ([id], [name], [sex], [password]) VALUES (@id, @name, @sex, @password);
SELECT id, name, sex, password FROM company_admin WHERE (id = @id)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT id, name, sex, password FROM dbo.company_admin</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[company_admin] SET [id] = @id, [name] = @name, [sex] = @sex, [password] = @password WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_sex = 1 AND [sex] IS NULL) OR ([sex] = @Original_sex)) AND ((@IsNull_password = 1 AND [password] IS NULL) OR ([password] = @Original_password)));
SELECT id, name, sex, password FROM company_admin WHERE (id = @id)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_sex" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="sex" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_password" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="id" DataSetColumn="id" />
<Mapping SourceColumn="name" DataSetColumn="name" />
<Mapping SourceColumn="sex" DataSetColumn="sex" />
<Mapping SourceColumn="password" DataSetColumn="password" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="company_newTableAdapter" GeneratorDataComponentClassName="company_newTableAdapter" Name="company_new" UserDataComponentName="company_newTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.company_new" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[company_new] WHERE (([Ccno] = @Original_Ccno) AND ((@IsNull_Ccname = 1 AND [Ccname] IS NULL) OR ([Ccname] = @Original_Ccname)) AND ((@IsNull_Cnumber = 1 AND [Cnumber] IS NULL) OR ([Cnumber] = @Original_Cnumber)) AND ((@IsNull_Cjob = 1 AND [Cjob] IS NULL) OR ([Cjob] = @Original_Cjob)) AND ((@IsNull_Cemploy = 1 AND [Cemploy] IS NULL) OR ([Cemploy] = @Original_Cemploy)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ccname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cnumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cjob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[company_new] ([Ccno], [Ccname], [Cnumber], [Cjob], [Cemploy]) VALUES (@Ccno, @Ccname, @Cnumber, @Cjob, @Cemploy);
SELECT Ccno, Ccname, Cnumber, Cjob, Cemploy FROM company_new WHERE (Ccno = @Ccno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT Ccno, Ccname, Cnumber, Cjob, Cemploy FROM dbo.company_new</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[company_new] SET [Ccno] = @Ccno, [Ccname] = @Ccname, [Cnumber] = @Cnumber, [Cjob] = @Cjob, [Cemploy] = @Cemploy WHERE (([Ccno] = @Original_Ccno) AND ((@IsNull_Ccname = 1 AND [Ccname] IS NULL) OR ([Ccname] = @Original_Ccname)) AND ((@IsNull_Cnumber = 1 AND [Cnumber] IS NULL) OR ([Cnumber] = @Original_Cnumber)) AND ((@IsNull_Cjob = 1 AND [Cjob] IS NULL) OR ([Cjob] = @Original_Cjob)) AND ((@IsNull_Cemploy = 1 AND [Cemploy] IS NULL) OR ([Cemploy] = @Original_Cemploy)));
SELECT Ccno, Ccname, Cnumber, Cjob, Cemploy FROM company_new WHERE (Ccno = @Ccno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ccname" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Ccname" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Ccname" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cnumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cnumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cnumber" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cjob" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Cjob" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Cjob" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Cemploy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cemploy" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Ccno" DataSetColumn="Ccno" />
<Mapping SourceColumn="Ccname" DataSetColumn="Ccname" />
<Mapping SourceColumn="Cnumber" DataSetColumn="Cnumber" />
<Mapping SourceColumn="Cjob" DataSetColumn="Cjob" />
<Mapping SourceColumn="Cemploy" DataSetColumn="Cemploy" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="job_adminTableAdapter" GeneratorDataComponentClassName="job_adminTableAdapter" Name="job_admin" UserDataComponentName="job_adminTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.job_admin" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[job_admin] ([id], [password]) VALUES (@id, @password)</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@password" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT id, password FROM dbo.job_admin</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="id" DataSetColumn="id" />
<Mapping SourceColumn="password" DataSetColumn="password" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="student_newsTableAdapter" GeneratorDataComponentClassName="student_newsTableAdapter" Name="student_news" UserDataComponentName="student_newsTableAdapter">
<MainSource>
<DbSource ConnectionRef="jobDBConnectionString (Settings)" DbObjectName="jobDB.dbo.student_news" 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=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>DELETE FROM [dbo].[student_news] WHERE (([sno] = @Original_sno) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[student_news] ([sno], [name]) VALUES (@sno, @name);
SELECT sno, name FROM student_news WHERE (sno = @sno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT sno, name FROM dbo.student_news</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[student_news] SET [sno] = @sno, [name] = @name WHERE (([sno] = @Original_sno) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)));
SELECT sno, name FROM student_news WHERE (sno = @sno)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_sno" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="sno" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="name" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="sno" DataSetColumn="sno" />
<Mapping SourceColumn="name" DataSetColumn="name" />
</Mappings>
<Sources />
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="jobDBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="jobDBDataSet" msprop:Generator_UserDSName="jobDBDataSet">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="company_admin" msprop:Generator_TableClassName="company_adminDataTable" msprop:Generator_TableVarName="tablecompany_admin" msprop:Generator_TablePropName="company_admin" msprop:Generator_RowDeletingName="company_adminRowDeleting" msprop:Generator_RowChangingName="company_adminRowChanging" msprop:Generator_RowEvHandlerName="company_adminRowChangeEventHandler" msprop:Generator_RowDeletedName="company_adminRowDeleted" msprop:Generator_UserTableName="company_admin" msprop:Generator_RowChangedName="company_adminRowChanged" msprop:Generator_RowEvArgName="company_adminRowChangeEvent" msprop:Generator_RowClassName="company_adminRow">
<xs:complexType>
<xs:sequence>
<xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="sex" msprop:Generator_ColumnVarNameInTable="columnsex" msprop:Generator_ColumnPropNameInRow="sex" msprop:Generator_ColumnPropNameInTable="sexColumn" msprop:Generator_UserColumnName="sex" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="2" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="company_new" msprop:Generator_TableClassName="company_newDataTable" msprop:Generator_TableVarName="tablecompany_new" msprop:Generator_TablePropName="company_new" msprop:Generator_RowDeletingName="company_newRowDeleting" msprop:Generator_RowChangingName="company_newRowChanging" msprop:Generator_RowEvHandlerName="company_newRowChangeEventHandler" msprop:Generator_RowDeletedName="company_newRowDeleted" msprop:Generator_UserTableName="company_new" msprop:Generator_RowChangedName="company_newRowChanged" msprop:Generator_RowEvArgName="company_newRowChangeEvent" msprop:Generator_RowClassName="company_newRow">
<xs:complexType>
<xs:sequence>
<xs:element name="Ccno" msprop:Generator_ColumnVarNameInTable="columnCcno" msprop:Generator_ColumnPropNameInRow="Ccno" msprop:Generator_ColumnPropNameInTable="CcnoColumn" msprop:Generator_UserColumnName="Ccno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Ccname" msprop:Generator_ColumnVarNameInTable="columnCcname" msprop:Generator_ColumnPropNameInRow="Ccname" msprop:Generator_ColumnPropNameInTable="CcnameColumn" msprop:Generator_UserColumnName="Ccname" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cnumber" msprop:Generator_ColumnVarNameInTable="columnCnumber" msprop:Generator_ColumnPropNameInRow="Cnumber" msprop:Generator_ColumnPropNameInTable="CnumberColumn" msprop:Generator_UserColumnName="Cnumber" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cjob" msprop:Generator_ColumnVarNameInTable="columnCjob" msprop:Generator_ColumnPropNameInRow="Cjob" msprop:Generator_ColumnPropNameInTable="CjobColumn" msprop:Generator_UserColumnName="Cjob" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Cemploy" msprop:Generator_ColumnVarNameInTable="columnCemploy" msprop:Generator_ColumnPropNameInRow="Cemploy" msprop:Generator_ColumnPropNameInTable="CemployColumn" msprop:Generator_UserColumnName="Cemploy" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="job_admin" msprop:Generator_TableClassName="job_adminDataTable" msprop:Generator_TableVarName="tablejob_admin" msprop:Generator_TablePropName="job_admin" msprop:Generator_RowDeletingName="job_adminRowDeleting" msprop:Generator_RowChangingName="job_adminRowChanging" msprop:Generator_RowEvHandlerName="job_adminRowChangeEventHandler" msprop:Generator_RowDeletedName="job_adminRowDeleted" msprop:Generator_UserTableName="job_admin" msprop:Generator_RowChangedName="job_adminRowChanged" msprop:Generator_RowEvArgName="job_adminRowChangeEvent" msprop:Generator_RowClassName="job_adminRow">
<xs:complexType>
<xs:sequence>
<xs:element name="id" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="student_news" msprop:Generator_TableClassName="student_newsDataTable" msprop:Generator_TableVarName="tablestudent_news" msprop:Generator_TablePropName="student_news" msprop:Generator_RowDeletingName="student_newsRowDeleting" msprop:Generator_RowChangingName="student_newsRowChanging" msprop:Generator_RowEvHandlerName="student_newsRowChangeEventHandler" msprop:Generator_RowDeletedName="student_newsRowDeleted" msprop:Generator_UserTableName="student_news" msprop:Generator_RowChangedName="student_newsRowChanged" msprop:Generator_RowEvArgName="student_newsRowChangeEvent" msprop:Generator_RowClassName="student_newsRow">
<xs:complexType>
<xs:sequence>
<xs:element name="sno" msprop:Generator_ColumnVarNameInTable="columnsno" msprop:Generator_ColumnPropNameInRow="sno" msprop:Generator_ColumnPropNameInTable="snoColumn" msprop:Generator_UserColumnName="sno">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="name" msprop:Generator_ColumnVarNameInTable="columnname" msprop:Generator_ColumnPropNameInRow="name" msprop:Generator_ColumnPropNameInTable="nameColumn" msprop:Generator_UserColumnName="name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:company_admin" />
<xs:field xpath="mstns:id" />
</xs:unique>
<xs:unique name="company_new_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:company_new" />
<xs:field xpath="mstns:Ccno" />
</xs:unique>
<xs:unique name="student_news_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:student_news" />
<xs:field xpath="mstns:sno" />
</xs:unique>
</xs:element>
</xs:schema>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手