سلام
یک برنامه asp نوشته ام و اتصال به دیتابیس را با استفاده از TableAdapters انجام داده ام
اکنون این پیغام ارور را می دهند.
مشکل در نمونه سازی است
ولی از این ارور نمیشه متوجه مشکل شد
از چه رفرنسی استفاده کردید ؟ این نام برام آشنا نیست
از بخش add new item گزینه dataset را انتخاب کردم.
وقتی که dataset را add کردم. فایل آن را باز کردم و از Toolbox یک tableAdapter ساختم که به صورت اتوماتیک به table ها متصل میشود و توابعی را برای کار بر روی داده ها نیز آماده می کند.
اکنون در localhost به مشکل بر خوردم
محتویات فایل dataset
<?xml version="1.0" encoding="utf-8"?> <xs:schema id="TajgolData" targetNamespace="http://tempuri.org/TajgolData.xsd" xmlns:mstns="http://tempuri.org/TajgolData.xsd" xmlns="http://tempuri.org/TajgolData.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="Web.config" AppSettingsPropertyName="tajgolConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="tajgolConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.tajgolConnectionString.ConnectionString" Provider="System.Data.SqlClient" /> </Connections> <Tables> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DriverTableAdapter" GeneratorDataComponentClassName="DriverTableAdapter" Name="Driver" UserDataComponentName="DriverTableAdapter"> <MainSource> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="tajgol.dbo.Driver" 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="false" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [Driver] WHERE (([NoRow] = @Original_NoRow))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [Driver] ([NoRow], [Driver1], [Driver2], [Driver3], [Driver4], [HelpDriver1], [Helpdriver2], [TimeStart], [TimeEnd]) VALUES (@NoRow, @Driver1, @Driver2, @Driver3, @Driver4, @HelpDriver1, @Helpdriver2, @TimeStart, @TimeEnd)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver1" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver2" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver3" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver4" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HelpDriver1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HelpDriver1" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Helpdriver2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Helpdriver2" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TimeStart" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TimeStart" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TimeEnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TimeEnd" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>SELECT Driver.* FROM Driver</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [Driver] SET [NoRow] = @NoRow, [Driver1] = @Driver1, [Driver2] = @Driver2, [Driver3] = @Driver3, [Driver4] = @Driver4, [HelpDriver1] = @HelpDriver1, [Helpdriver2] = @Helpdriver2, [TimeStart] = @TimeStart, [TimeEnd] = @TimeEnd WHERE (([NoRow] = @Original_NoRow))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver1" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver2" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver3" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Driver4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Driver4" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@HelpDriver1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="HelpDriver1" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Helpdriver2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Helpdriver2" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TimeStart" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TimeStart" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TimeEnd" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TimeEnd" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="NoRow" DataSetColumn="NoRow" /> <Mapping SourceColumn="Driver1" DataSetColumn="Driver1" /> <Mapping SourceColumn="Driver2" DataSetColumn="Driver2" /> <Mapping SourceColumn="Driver3" DataSetColumn="Driver3" /> <Mapping SourceColumn="Driver4" DataSetColumn="Driver4" /> <Mapping SourceColumn="HelpDriver1" DataSetColumn="HelpDriver1" /> <Mapping SourceColumn="Helpdriver2" DataSetColumn="Helpdriver2" /> <Mapping SourceColumn="TimeStart" DataSetColumn="TimeStart" /> <Mapping SourceColumn="TimeEnd" DataSetColumn="TimeEnd" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SefareshTableAdapter" GeneratorDataComponentClassName="SefareshTableAdapter" Name="Sefaresh" UserDataComponentName="SefareshTableAdapter"> <MainSource> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="tajgol.dbo.Sefaresh" 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="false" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [Sefaresh] WHERE (([NoRow] = @Original_NoRow))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [Sefaresh] ([NoRow], [Year], [Month], [Day], [NoOneFloors], [NoTwoFloors], [NoBig], [FullName], [Phone], [Address], [Time], [SendTo], [SendFrom], [Price]) VALUES (@NoRow, @Year, @Month, @Day, @NoOneFloors, @NoTwoFloors, @NoBig, @FullName, @Phone, @Address, @Time, @SendTo, @SendFrom, @Price)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Year" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Month" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Month" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Day" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Day" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoOneFloors" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoOneFloors" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoTwoFloors" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoTwoFloors" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoBig" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoBig" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Phone" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SendTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SendTo" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SendFrom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SendFrom" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>SELECT Sefaresh.* FROM Sefaresh</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [Sefaresh] SET [NoRow] = @NoRow, [Year] = @Year, [Month] = @Month, [Day] = @Day, [NoOneFloors] = @NoOneFloors, [NoTwoFloors] = @NoTwoFloors, [NoBig] = @NoBig, [FullName] = @FullName, [Phone] = @Phone, [Address] = @Address, [Time] = @Time, [SendTo] = @SendTo, [SendFrom] = @SendFrom, [Price] = @Price WHERE (([NoRow] = @Original_NoRow))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Year" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Month" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Month" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Day" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Day" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoOneFloors" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoOneFloors" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoTwoFloors" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoTwoFloors" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoBig" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoBig" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FullName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="FullName" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Phone" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SendTo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SendTo" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SendFrom" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SendFrom" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="NoRow" DataSetColumn="NoRow" /> <Mapping SourceColumn="Year" DataSetColumn="Year" /> <Mapping SourceColumn="Month" DataSetColumn="Month" /> <Mapping SourceColumn="Day" DataSetColumn="Day" /> <Mapping SourceColumn="NoOneFloors" DataSetColumn="NoOneFloors" /> <Mapping SourceColumn="NoTwoFloors" DataSetColumn="NoTwoFloors" /> <Mapping SourceColumn="NoBig" DataSetColumn="NoBig" /> <Mapping SourceColumn="FullName" DataSetColumn="FullName" /> <Mapping SourceColumn="Phone" DataSetColumn="Phone" /> <Mapping SourceColumn="Address" DataSetColumn="Address" /> <Mapping SourceColumn="Time" DataSetColumn="Time" /> <Mapping SourceColumn="SendTo" DataSetColumn="SendTo" /> <Mapping SourceColumn="SendFrom" DataSetColumn="SendFrom" /> <Mapping SourceColumn="Price" DataSetColumn="Price" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LastRowSefareshTableAdapter" GeneratorDataComponentClassName="LastRowSefareshTableAdapter" Name="LastRowSefaresh" UserDataComponentName="LastRowSefareshTableAdapter"> <MainSource> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="tajgol.dbo.LastRowSefaresh" 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="false" UserGetMethodName="GetData" UserSourceName="Fill"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [LastRowSefaresh] ([LastRowSefaresh]) VALUES (@LastRowSefaresh)</CommandText> <Parameters> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@LastRowSefaresh" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="LastRowSefaresh" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>SELECT LastRowSefaresh FROM LastRowSefaresh</CommandText> <Parameters /> </DbCommand> </SelectCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="LastRowSefaresh" DataSetColumn="LastRowSefaresh" /> </Mappings> <Sources> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="tajgol.dbo.LastRowSefaresh" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="LastNoSefaresh" Modifier="Public" Name="LastNoSefaresh" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="LastNoSefaresh"> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>SELECT LastRowSefaresh FROM LastRowSefaresh WHERE (row = 1)</CommandText> <Parameters /> </DbCommand> </SelectCommand> </DbSource> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateSefaresh" Modifier="Public" Name="UpdateSefaresh" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateSefaresh"> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>UPDATE LastRowSefaresh SET LastRowSefaresh = @LastRowSefaresh WHERE (row = 1)</CommandText> <Parameters> <Parameter AllowDbNull="true" AutogeneratedName="LastRowSefaresh" ColumnName="LastRowSefaresh" DataSourceName="tajgol.dbo.LastRowSefaresh" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@LastRowSefaresh" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="LastRowSefaresh" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </Sources> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LastRowDriverTableAdapter" GeneratorDataComponentClassName="LastRowDriverTableAdapter" Name="LastRowSefaresh1" UserDataComponentName="LastRowDriverTableAdapter"> <MainSource> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="tajgol.dbo.LastRowSefaresh" 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="false" UserGetMethodName="GetData" UserSourceName="Fill"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [LastRowSefaresh] ([LastRawDriver]) VALUES (@LastRawDriver)</CommandText> <Parameters> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@LastRawDriver" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="LastRawDriver" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>SELECT LastRawDriver FROM LastRowSefaresh</CommandText> <Parameters /> </DbCommand> </SelectCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="LastRawDriver" DataSetColumn="LastRawDriver" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LastRowHesabdaryTableAdapter" GeneratorDataComponentClassName="LastRowHesabdaryTableAdapter" Name="LastRowSefaresh2" UserDataComponentName="LastRowHesabdaryTableAdapter"> <MainSource> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="tajgol.dbo.LastRowSefaresh" 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="false" UserGetMethodName="GetData" UserSourceName="Fill"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [LastRowSefaresh] ([LastRawHesabdari]) VALUES (@LastRawHesabdari)</CommandText> <Parameters> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@LastRawHesabdari" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="LastRawHesabdari" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>SELECT LastRawHesabdari FROM LastRowSefaresh</CommandText> <Parameters /> </DbCommand> </SelectCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="LastRawHesabdari" DataSetColumn="LastRawHesabdari" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="HesabdaryTableAdapter" GeneratorDataComponentClassName="HesabdaryTableAdapter" Name="Hesabdary" UserDataComponentName="HesabdaryTableAdapter"> <MainSource> <DbSource ConnectionRef="tajgolConnectionString (Web.config)" DbObjectName="tajgol.dbo.Hesabdary" 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="false" UserGetMethodName="GetData" UserSourceName="Fill"> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [Hesabdary] ([NoRow], [Price], [TypePay], [NoVariz], [PricePay], [MandehPrice], [YearPay], [MonthPay], [DayPay]) VALUES (@NoRow, @Price, @TypePay, @NoVariz, @PricePay, @MandehPrice, @YearPay, @MonthPay, @DayPay)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoRow" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoRow" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TypePay" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TypePay" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NoVariz" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NoVariz" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@PricePay" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="PricePay" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MandehPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="MandehPrice" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@YearPay" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="YearPay" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MonthPay" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="MonthPay" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@DayPay" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="DayPay" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="true"> <CommandText>SELECT Hesabdary.* FROM Hesabdary</CommandText> <Parameters /> </DbCommand> </SelectCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="NoRow" DataSetColumn="NoRow" /> <Mapping SourceColumn="Price" DataSetColumn="Price" /> <Mapping SourceColumn="TypePay" DataSetColumn="TypePay" /> <Mapping SourceColumn="NoVariz" DataSetColumn="NoVariz" /> <Mapping SourceColumn="PricePay" DataSetColumn="PricePay" /> <Mapping SourceColumn="MandehPrice" DataSetColumn="MandehPrice" /> <Mapping SourceColumn="YearPay" DataSetColumn="YearPay" /> <Mapping SourceColumn="MonthPay" DataSetColumn="MonthPay" /> <Mapping SourceColumn="DayPay" DataSetColumn="DayPay" /> </Mappings> <Sources /> </TableAdapter> </Tables> <Sources /> </DataSource> </xs:appinfo> </xs:annotation> <xs:element name="TajgolData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="TajgolData" msprop:Generator_UserDSName="TajgolData"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Driver" msprop:Generator_TableClassName="DriverDataTable" msprop:Generator_TableVarName="tableDriver" msprop:Generator_TablePropName="Driver" msprop:Generator_RowDeletingName="DriverRowDeleting" msprop:Generator_RowChangingName="DriverRowChanging" msprop:Generator_RowEvHandlerName="DriverRowChangeEventHandler" msprop:Generator_RowDeletedName="DriverRowDeleted" msprop:Generator_UserTableName="Driver" msprop:Generator_RowChangedName="DriverRowChanged" msprop:Generator_RowEvArgName="DriverRowChangeEvent" msprop:Generator_RowClassName="DriverRow"> <xs:complexType> <xs:sequence> <xs:element name="NoRow" msprop:Generator_ColumnVarNameInTable="columnNoRow" msprop:Generator_ColumnPropNameInRow="NoRow" msprop:Generator_ColumnPropNameInTable="NoRowColumn" msprop:Generator_UserColumnName="NoRow" type="xs:decimal" /> <xs:element name="Driver1" msprop:Generator_ColumnVarNameInTable="columnDriver1" msprop:Generator_ColumnPropNameInRow="Driver1" msprop:Generator_ColumnPropNameInTable="Driver1Column" msprop:Generator_UserColumnName="Driver1"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Driver2" msprop:Generator_ColumnVarNameInTable="columnDriver2" msprop:Generator_ColumnPropNameInRow="Driver2" msprop:Generator_ColumnPropNameInTable="Driver2Column" msprop:Generator_UserColumnName="Driver2" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Driver3" msprop:Generator_ColumnVarNameInTable="columnDriver3" msprop:Generator_ColumnPropNameInRow="Driver3" msprop:Generator_ColumnPropNameInTable="Driver3Column" msprop:Generator_UserColumnName="Driver3" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Driver4" msprop:Generator_ColumnVarNameInTable="columnDriver4" msprop:Generator_ColumnPropNameInRow="Driver4" msprop:Generator_ColumnPropNameInTable="Driver4Column" msprop:Generator_UserColumnName="Driver4" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="HelpDriver1" msprop:Generator_ColumnVarNameInTable="columnHelpDriver1" msprop:Generator_ColumnPropNameInRow="HelpDriver1" msprop:Generator_ColumnPropNameInTable="HelpDriver1Column" msprop:Generator_UserColumnName="HelpDriver1" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Helpdriver2" msprop:Generator_ColumnVarNameInTable="columnHelpdriver2" msprop:Generator_ColumnPropNameInRow="Helpdriver2" msprop:Generator_ColumnPropNameInTable="Helpdriver2Column" msprop:Generator_UserColumnName="Helpdriver2" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="TimeStart" msprop:Generator_ColumnVarNameInTable="columnTimeStart" msprop:Generator_ColumnPropNameInRow="TimeStart" msprop:Generator_ColumnPropNameInTable="TimeStartColumn" msprop:Generator_UserColumnName="TimeStart"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="TimeEnd" msprop:Generator_ColumnVarNameInTable="columnTimeEnd" msprop:Generator_ColumnPropNameInRow="TimeEnd" msprop:Generator_ColumnPropNameInTable="TimeEndColumn" msprop:Generator_UserColumnName="TimeEnd" 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="Sefaresh" msprop:Generator_TableClassName="SefareshDataTable" msprop:Generator_TableVarName="tableSefaresh" msprop:Generator_RowChangedName="SefareshRowChanged" msprop:Generator_TablePropName="Sefaresh" msprop:Generator_RowDeletingName="SefareshRowDeleting" msprop:Generator_RowChangingName="SefareshRowChanging" msprop:Generator_RowEvHandlerName="SefareshRowChangeEventHandler" msprop:Generator_RowDeletedName="SefareshRowDeleted" msprop:Generator_RowClassName="SefareshRow" msprop:Generator_UserTableName="Sefaresh" msprop:Generator_RowEvArgName="SefareshRowChangeEvent"> <xs:complexType> <xs:sequence> <xs:element name="NoRow" msprop:Generator_ColumnVarNameInTable="columnNoRow" msprop:Generator_ColumnPropNameInRow="NoRow" msprop:Generator_ColumnPropNameInTable="NoRowColumn" msprop:Generator_UserColumnName="NoRow" type="xs:decimal" /> <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" type="xs:decimal" /> <xs:element name="Month" msprop:Generator_ColumnVarNameInTable="columnMonth" msprop:Generator_ColumnPropNameInRow="Month" msprop:Generator_ColumnPropNameInTable="MonthColumn" msprop:Generator_UserColumnName="Month" type="xs:decimal" /> <xs:element name="Day" msprop:Generator_ColumnVarNameInTable="columnDay" msprop:Generator_ColumnPropNameInRow="Day" msprop:Generator_ColumnPropNameInTable="DayColumn" msprop:Generator_UserColumnName="Day" type="xs:decimal" /> <xs:element name="NoOneFloors" msprop:Generator_ColumnVarNameInTable="columnNoOneFloors" msprop:Generator_ColumnPropNameInRow="NoOneFloors" msprop:Generator_ColumnPropNameInTable="NoOneFloorsColumn" msprop:Generator_UserColumnName="NoOneFloors" type="xs:decimal" minOccurs="0" /> <xs:element name="NoTwoFloors" msprop:Generator_ColumnVarNameInTable="columnNoTwoFloors" msprop:Generator_ColumnPropNameInRow="NoTwoFloors" msprop:Generator_ColumnPropNameInTable="NoTwoFloorsColumn" msprop:Generator_UserColumnName="NoTwoFloors" type="xs:decimal" minOccurs="0" /> <xs:element name="NoBig" msprop:Generator_ColumnVarNameInTable="columnNoBig" msprop:Generator_ColumnPropNameInRow="NoBig" msprop:Generator_ColumnPropNameInTable="NoBigColumn" msprop:Generator_UserColumnName="NoBig" type="xs:decimal" minOccurs="0" /> <xs:element name="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" msprop:Generator_UserColumnName="FullName"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" msprop:Generator_UserColumnName="Phone" type="xs:decimal" minOccurs="0" /> <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnPropNameInTable="TimeColumn" msprop:Generator_UserColumnName="Time"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="SendTo" msprop:Generator_ColumnVarNameInTable="columnSendTo" msprop:Generator_ColumnPropNameInRow="SendTo" msprop:Generator_ColumnPropNameInTable="SendToColumn" msprop:Generator_UserColumnName="SendTo"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="SendFrom" msprop:Generator_ColumnVarNameInTable="columnSendFrom" msprop:Generator_ColumnPropNameInRow="SendFrom" msprop:Generator_ColumnPropNameInTable="SendFromColumn" msprop:Generator_UserColumnName="SendFrom"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="2147483647" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:decimal" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="LastRowSefaresh" msprop:Generator_TableClassName="LastRowSefareshDataTable" msprop:Generator_TableVarName="tableLastRowSefaresh" msprop:Generator_RowChangedName="LastRowSefareshRowChanged" msprop:Generator_TablePropName="LastRowSefaresh" msprop:Generator_RowDeletingName="LastRowSefareshRowDeleting" msprop:Generator_RowChangingName="LastRowSefareshRowChanging" msprop:Generator_RowEvHandlerName="LastRowSefareshRowChangeEventHandler" msprop:Generator_RowDeletedName="LastRowSefareshRowDeleted" msprop:Generator_RowClassName="LastRowSefareshRow" msprop:Generator_UserTableName="LastRowSefaresh" msprop:Generator_RowEvArgName="LastRowSefareshRowChangeEvent"> <xs:complexType> <xs:sequence> <xs:element name="LastRowSefaresh" msprop:Generator_ColumnVarNameInTable="columnLastRowSefaresh" msprop:Generator_ColumnPropNameInRow="LastRowSefaresh" msprop:Generator_ColumnPropNameInTable="LastRowSefareshColumn" msprop:Generator_UserColumnName="LastRowSefaresh" type="xs:decimal" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="LastRowSefaresh1" msprop:Generator_TableClassName="LastRowSefaresh1DataTable" msprop:Generator_TableVarName="tableLastRowSefaresh1" msprop:Generator_TablePropName="LastRowSefaresh1" msprop:Generator_RowDeletingName="LastRowSefaresh1RowDeleting" msprop:Generator_RowChangingName="LastRowSefaresh1RowChanging" msprop:Generator_RowEvHandlerName="LastRowSefaresh1RowChangeEventHandler" msprop:Generator_RowDeletedName="LastRowSefaresh1RowDeleted" msprop:Generator_UserTableName="LastRowSefaresh1" msprop:Generator_RowChangedName="LastRowSefaresh1RowChanged" msprop:Generator_RowEvArgName="LastRowSefaresh1RowChangeEvent" msprop:Generator_RowClassName="LastRowSefaresh1Row"> <xs:complexType> <xs:sequence> <xs:element name="LastRawDriver" msprop:Generator_ColumnVarNameInTable="columnLastRawDriver" msprop:Generator_ColumnPropNameInRow="LastRawDriver" msprop:Generator_ColumnPropNameInTable="LastRawDriverColumn" msprop:Generator_UserColumnName="LastRawDriver" type="xs:decimal" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="LastRowSefaresh2" msprop:Generator_TableClassName="LastRowSefaresh2DataTable" msprop:Generator_TableVarName="tableLastRowSefaresh2" msprop:Generator_TablePropName="LastRowSefaresh2" msprop:Generator_RowDeletingName="LastRowSefaresh2RowDeleting" msprop:Generator_RowChangingName="LastRowSefaresh2RowChanging" msprop:Generator_RowEvHandlerName="LastRowSefaresh2RowChangeEventHandler" msprop:Generator_RowDeletedName="LastRowSefaresh2RowDeleted" msprop:Generator_UserTableName="LastRowSefaresh2" msprop:Generator_RowChangedName="LastRowSefaresh2RowChanged" msprop:Generator_RowEvArgName="LastRowSefaresh2RowChangeEvent" msprop:Generator_RowClassName="LastRowSefaresh2Row"> <xs:complexType> <xs:sequence> <xs:element name="LastRawHesabdari" msprop:Generator_ColumnVarNameInTable="columnLastRawHesabdari" msprop:Generator_ColumnPropNameInRow="LastRawHesabdari" msprop:Generator_ColumnPropNameInTable="LastRawHesabdariColumn" msprop:Generator_UserColumnName="LastRawHesabdari" type="xs:decimal" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Hesabdary" msprop:Generator_TableClassName="HesabdaryDataTable" msprop:Generator_TableVarName="tableHesabdary" msprop:Generator_TablePropName="Hesabdary" msprop:Generator_RowDeletingName="HesabdaryRowDeleting" msprop:Generator_RowChangingName="HesabdaryRowChanging" msprop:Generator_RowEvHandlerName="HesabdaryRowChangeEventHandler" msprop:Generator_RowDeletedName="HesabdaryRowDeleted" msprop:Generator_UserTableName="Hesabdary" msprop:Generator_RowChangedName="HesabdaryRowChanged" msprop:Generator_RowEvArgName="HesabdaryRowChangeEvent" msprop:Generator_RowClassName="HesabdaryRow"> <xs:complexType> <xs:sequence> <xs:element name="NoRow" msprop:Generator_ColumnVarNameInTable="columnNoRow" msprop:Generator_ColumnPropNameInRow="NoRow" msprop:Generator_ColumnPropNameInTable="NoRowColumn" msprop:Generator_UserColumnName="NoRow" type="xs:decimal" /> <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:decimal" /> <xs:element name="TypePay" msprop:Generator_ColumnVarNameInTable="columnTypePay" msprop:Generator_ColumnPropNameInRow="TypePay" msprop:Generator_ColumnPropNameInTable="TypePayColumn" msprop:Generator_UserColumnName="TypePay"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="NoVariz" msprop:Generator_ColumnVarNameInTable="columnNoVariz" msprop:Generator_ColumnPropNameInRow="NoVariz" msprop:Generator_ColumnPropNameInTable="NoVarizColumn" msprop:Generator_UserColumnName="NoVariz" type="xs:decimal" minOccurs="0" /> <xs:element name="PricePay" msprop:Generator_ColumnVarNameInTable="columnPricePay" msprop:Generator_ColumnPropNameInRow="PricePay" msprop:Generator_ColumnPropNameInTable="PricePayColumn" msprop:Generator_UserColumnName="PricePay" type="xs:decimal" /> <xs:element name="MandehPrice" msprop:Generator_ColumnVarNameInTable="columnMandehPrice" msprop:Generator_ColumnPropNameInRow="MandehPrice" msprop:Generator_ColumnPropNameInTable="MandehPriceColumn" msprop:Generator_UserColumnName="MandehPrice" type="xs:decimal" /> <xs:element name="YearPay" msprop:Generator_ColumnVarNameInTable="columnYearPay" msprop:Generator_ColumnPropNameInRow="YearPay" msprop:Generator_ColumnPropNameInTable="YearPayColumn" msprop:Generator_UserColumnName="YearPay" type="xs:decimal" /> <xs:element name="MonthPay" msprop:Generator_ColumnVarNameInTable="columnMonthPay" msprop:Generator_ColumnPropNameInRow="MonthPay" msprop:Generator_ColumnPropNameInTable="MonthPayColumn" msprop:Generator_UserColumnName="MonthPay" type="xs:decimal" /> <xs:element name="DayPay" msprop:Generator_ColumnVarNameInTable="columnDayPay" msprop:Generator_ColumnPropNameInRow="DayPay" msprop:Generator_ColumnPropNameInTable="DayPayColumn" msprop:Generator_UserColumnName="DayPay"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="10" /> </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:Driver" /> <xs:field xpath="mstns:NoRow" /> </xs:unique> <xs:unique name="Sefaresh_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Sefaresh" /> <xs:field xpath="mstns:NoRow" /> </xs:unique> </xs:element> </xs:schema>
هیچ کاربری تا کنون از این پست تشکر نکرده است
با ما تماس بگیرید تا در این مسیر همراهتان باشیم :)