You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
16 lines
2.9 KiB
16 lines
2.9 KiB
<?xml version="1.0" encoding="utf-8"?>
|
|
<xs:schema id="databaseDataSet" targetNamespace="http://tempuri.org/databaseDataSet.xsd" xmlns:mstns="http://tempuri.org/databaseDataSet.xsd" xmlns="http://tempuri.org/databaseDataSet.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="databaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="databaseConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.HFReader.Properties.Settings.GlobalReference.Default.databaseConnectionString" Provider="System.Data.SqlClient" />
|
|
</Connections>
|
|
<Tables>
|
|
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbl_UserInfoTableAdapter" GeneratorDataComponentClassName="tbl_UserInfoTableAdapter" Name="tbl_UserInfo" UserDataComponentName="tbl_UserInfoTableAdapter">
|
|
<MainSource>
|
|
<DbSource ConnectionRef="databaseConnectionString (Settings)" DbObjectName="dbo.tbl_UserInfo" 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].[tbl_UserInfo] WHERE (([TagNumber] = @Original_TagNumber) AND ((@IsNull_UserName = 1 AND [UserName] IS NULL) OR ([UserName] = @Original_UserName)) AND ((@IsNull_UserCompany = 1 AND [UserCompany] IS NULL) OR ([UserCompany] = @Original_UserCompany)) AND ((@IsNull_UserDepartment = 1 AND [UserDepartment] IS NULL) OR ([UserDepartment] = @Original_UserDepartment)) AND ((@IsNull_UserAppellative = 1 AND [UserAppellative] IS NULL) OR ([UserAppellative] = @Original_UserAppellative)) AND ((@IsNull_UserTitle = 1 AND [UserTitle] IS NULL) OR ([UserTitle] = @Original_UserTitle)) AND ((@IsNull_UserTelephone = 1 AND [UserTelephone] IS NULL) OR ([UserTelephone] = @Original_UserTelephone)))</CommandText>
|