<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.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="clubConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="clubConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.video_club.Properties.Settings.GlobalReference.Default.clubConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblfilmTableAdapter" GeneratorDataComponentClassName="tblfilmTableAdapter" Name="tblfilm" UserDataComponentName="tblfilmTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblfilm" 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 [tblfilm] WHERE (([fid] = @Original_fid) AND ([title] = @Original_title) AND ([contry] = @Original_contry) AND ([filmtype] = @Original_filmtype) AND ((@IsNull_year = 1 AND [year] IS NULL) OR ([year] = @Original_year)) AND ([count] = @Original_count))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <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" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_contry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_filmtype" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filmtype" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_year" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="count" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblfilm] ([title], [contry], [filmtype], [year], [count]) VALUES (@title, @contry, @filmtype, @year, @count)</CommandText>
                    <Parameters>
                      <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" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@filmtype" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filmtype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@year" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="count" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        fid, title, contry, filmtype, year, count
FROM            tblfilm</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblfilm] SET [title] = @title, [contry] = @contry, [filmtype] = @filmtype, [year] = @year, [count] = @count WHERE (([fid] = @Original_fid) AND ([title] = @Original_title) AND ([contry] = @Original_contry) AND ([filmtype] = @Original_filmtype) AND ((@IsNull_year = 1 AND [year] IS NULL) OR ([year] = @Original_year)) AND ([count] = @Original_count))</CommandText>
                    <Parameters>
                      <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" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@contry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@filmtype" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filmtype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@year" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <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" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_contry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="contry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_filmtype" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="filmtype" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_year" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_count" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="count" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="contry" DataSetColumn="contry" />
              <Mapping SourceColumn="filmtype" DataSetColumn="filmtype" />
              <Mapping SourceColumn="year" DataSetColumn="year" />
              <Mapping SourceColumn="fid" DataSetColumn="fid" />
              <Mapping SourceColumn="count" DataSetColumn="count" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM tblfilm
WHERE        (fid = @fid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fid" ColumnName="fid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblfilm" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBytitle" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="FillBytitle" GetMethodModifier="Public" GetMethodName="GetDataBy2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillBytitle">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT contry, count, fid, filmtype, title, year FROM tblfilm WHERE (title LIKE '%' + @title + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="title" ColumnName="title" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO tblfilm
                         (title, contry, filmtype, year, count)
VALUES        (@title,@contry,@filmtype,@year,@count)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="title" ColumnName="title" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="contry" ColumnName="contry" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@contry" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="contry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="filmtype" ColumnName="filmtype" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@filmtype" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="filmtype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="year" ColumnName="year" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@year" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="count" ColumnName="count" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@count" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="count" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="Updatecount" Modifier="Public" Name="Updatecount" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="Updatecount">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblfilm
SET                count = count + 1
WHERE        (fid = @fid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fid" ColumnName="fid" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="Updatecount1" Modifier="Public" Name="Updatecount1" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="Updatecount1">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>update tblfilm set count= (count - 1)
where fid = @fid</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fid" ColumnName="fid" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblfilm
SET                title = @title, contry = @contry, filmtype = @filmtype, year = @year, count = @count
WHERE        (fid = @fid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="title" ColumnName="title" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@title" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="contry" ColumnName="contry" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@contry" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="contry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="filmtype" ColumnName="filmtype" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@filmtype" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="filmtype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="year" ColumnName="year" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="nvarchar(20)" DbType="String" Direction="Input" ParameterName="@year" Precision="0" ProviderType="NVarChar" Scale="0" Size="20" SourceColumn="year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="count" ColumnName="count" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@count" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="count" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="fid" ColumnName="fid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblfilm" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblmoshtariTableAdapter" GeneratorDataComponentClassName="tblmoshtariTableAdapter" Name="tblmoshtari" UserDataComponentName="tblmoshtariTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblmoshtari" 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 [tblmoshtari] ([fname], [lname], [tell]) VALUES (@fname, @lname, @tell)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@fname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="fname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@lname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="lname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@tell" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="tell" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblmoshtari.*
FROM            tblmoshtari</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="fname" DataSetColumn="fname" />
              <Mapping SourceColumn="lname" DataSetColumn="lname" />
              <Mapping SourceColumn="tell" DataSetColumn="tell" />
              <Mapping SourceColumn="mid" DataSetColumn="mid" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM tblmoshtari
WHERE        (mid = @mid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="mid" ColumnName="mid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblmoshtari" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByfname" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="FillByfname" GetMethodModifier="Public" GetMethodName="GetDataBy2" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByfname">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        mid, fname, lname, tell
FROM            tblmoshtari
WHERE        (fname LIKE '%'+ @fname + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fname" ColumnName="fname" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@fname" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="fname" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [tblmoshtari] ( [fname], [lname], [tell]) VALUES ( @fname, @lname, @tell)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fname" ColumnName="fname" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@fname" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="fname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="lname" ColumnName="lname" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@lname" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="lname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tell" ColumnName="tell" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@tell" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="tell" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblmoshtari
SET                fname = @fname, lname = @lname, tell = @tell
WHERE        (mid = @mid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fname" ColumnName="fname" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@fname" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="fname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="lname" ColumnName="lname" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@lname" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="lname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="tell" ColumnName="tell" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@tell" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="tell" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="mid" ColumnName="mid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblkerayeTableAdapter" GeneratorDataComponentClassName="tblkerayeTableAdapter" Name="tblkeraye" UserDataComponentName="tblkerayeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblkeraye.adddatefa, tblmoshtari.fname, tblmoshtari.lname, tblfilm.title, tblkeraye.price, tblfilm.contry, tblkeraye.adddatemi, tblkeraye.kid, tblfilm.filmtype, 
                         tblfilm.fid
FROM            tblkeraye INNER JOIN
                         tblfilm ON tblkeraye.fid = tblfilm.fid INNER JOIN
                         tblmoshtari ON tblkeraye.mid = tblmoshtari.mid</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="adddatefa" DataSetColumn="adddatefa" />
              <Mapping SourceColumn="price" DataSetColumn="price" />
              <Mapping SourceColumn="fname" DataSetColumn="fname" />
              <Mapping SourceColumn="lname" DataSetColumn="lname" />
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="contry" DataSetColumn="contry" />
              <Mapping SourceColumn="filmtype" DataSetColumn="filmtype" />
              <Mapping SourceColumn="adddatemi" DataSetColumn="adddatemi" />
              <Mapping SourceColumn="sum" DataSetColumn="sum" />
              <Mapping SourceColumn="kid" DataSetColumn="kid" />
              <Mapping SourceColumn="fid" DataSetColumn="fid" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblkeraye" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBydate" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="FillBydate" GetMethodModifier="Public" GetMethodName="GetDataBy3" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="FillBydate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT tblkeraye.sum, tblkeraye.kid, tblkeraye.adddatemi FROM tblkeraye INNER JOIN tblfilm ON tblkeraye.fid = tblfilm.fid INNER JOIN tblmoshtari ON tblkeraye.mid = tblmoshtari.mid WHERE (tblkeraye.adddatemi BETWEEN @from AND @to)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="from" ColumnName="adddatemi" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@from" Precision="0" ProviderType="DateTime" Scale="0" Size="3" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="to" ColumnName="adddatemi" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@to" Precision="0" ProviderType="DateTime" Scale="0" Size="3" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBymid" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="FillBymid" GetMethodModifier="Public" GetMethodName="GetDataBy1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillBymid">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblkeraye.adddatefa, tblmoshtari.fname, tblmoshtari.lname, tblfilm.title, tblkeraye.price, tblfilm.contry, tblfilm.filmtype, tblkeraye.adddatemi, tblkeraye.kid, 
                         tblkeraye.sum, tblfilm.fid
FROM            tblkeraye INNER JOIN
                         tblfilm ON tblkeraye.fid = tblfilm.fid INNER JOIN
                         tblmoshtari ON tblkeraye.mid = tblmoshtari.mid
WHERE        (tblmoshtari.mid = @mid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="mid" ColumnName="mid" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.tblmoshtari" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [tblkeraye] ([fid], [mid], [adddatefa], [adddatemi], [price]) VALUES (@fid, @mid, @adddatefa, @adddatemi, @price);</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fid" ColumnName="fid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="mid" ColumnName="mid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="adddatefa" ColumnName="adddatefa" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@adddatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="adddatefa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="adddatemi" ColumnName="adddatemi" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@adddatemi" Precision="0" ProviderType="DateTime" Scale="0" Size="3" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="price" ColumnName="price" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@price" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblkeraye
SET                jarime = @jarime, sum = @sum, duedatefa = @duedatefa, duedatemi = @duedatemi
WHERE        (kid = @kid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="jarime" ColumnName="jarime" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@jarime" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="jarime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="sum" ColumnName="sum" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="decimal(18, 0)" DbType="Decimal" Direction="Input" ParameterName="@sum" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumn="sum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="duedatefa" ColumnName="duedatefa" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="nvarchar(10)" DbType="String" Direction="Input" ParameterName="@duedatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="duedatefa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="duedatemi" ColumnName="duedatemi" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@duedatemi" Precision="0" ProviderType="DateTime" Scale="0" Size="3" SourceColumn="duedatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="kid" ColumnName="kid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@kid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="kid" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblkeraye1TableAdapter" GeneratorDataComponentClassName="tblkeraye1TableAdapter" Name="tblkeraye1" UserDataComponentName="tblkeraye1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblkeraye" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fillbydae" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fillbydae" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fillbydae">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblkeraye] WHERE (([kid] = @Original_kid) AND ([fid] = @Original_fid) AND ([mid] = @Original_mid) AND ([adddatefa] = @Original_adddatefa) AND ([adddatemi] = @Original_adddatemi) AND ((@IsNull_duedatefa = 1 AND [duedatefa] IS NULL) OR ([duedatefa] = @Original_duedatefa)) AND ((@IsNull_duedatemi = 1 AND [duedatemi] IS NULL) OR ([duedatemi] = @Original_duedatemi)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_jarime = 1 AND [jarime] IS NULL) OR ([jarime] = @Original_jarime)) AND ((@IsNull_sum = 1 AND [sum] IS NULL) OR ([sum] = @Original_sum)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_kid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_adddatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adddatefa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_adddatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_duedatefa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="duedatefa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_duedatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="duedatefa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_duedatemi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="duedatemi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_duedatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="duedatemi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jarime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="jarime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_jarime" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="jarime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_sum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="sum" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblkeraye] ([fid], [mid], [adddatefa], [adddatemi], [duedatefa], [duedatemi], [price], [jarime], [sum]) VALUES (@fid, @mid, @adddatefa, @adddatemi, @duedatefa, @duedatemi, @price, @jarime, @sum);
SELECT kid, fid, mid, adddatefa, adddatemi, duedatefa, duedatemi, price, jarime, sum FROM tblkeraye WHERE (kid = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@adddatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adddatefa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@adddatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@duedatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="duedatefa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@duedatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="duedatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@jarime" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="jarime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@sum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="sum" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblkeraye.*
FROM            tblkeraye
WHERE        (adddatemi BETWEEN @from AND @to)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="from" ColumnName="adddatemi" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@from" Precision="0" ProviderType="DateTime" Scale="0" Size="3" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="to" ColumnName="adddatemi" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="date" DbType="Date" Direction="Input" ParameterName="@to" Precision="0" ProviderType="DateTime" Scale="0" Size="3" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblkeraye] SET [fid] = @fid, [mid] = @mid, [adddatefa] = @adddatefa, [adddatemi] = @adddatemi, [duedatefa] = @duedatefa, [duedatemi] = @duedatemi, [price] = @price, [jarime] = @jarime, [sum] = @sum WHERE (([kid] = @Original_kid) AND ([fid] = @Original_fid) AND ([mid] = @Original_mid) AND ([adddatefa] = @Original_adddatefa) AND ([adddatemi] = @Original_adddatemi) AND ((@IsNull_duedatefa = 1 AND [duedatefa] IS NULL) OR ([duedatefa] = @Original_duedatefa)) AND ((@IsNull_duedatemi = 1 AND [duedatemi] IS NULL) OR ([duedatemi] = @Original_duedatemi)) AND ((@IsNull_price = 1 AND [price] IS NULL) OR ([price] = @Original_price)) AND ((@IsNull_jarime = 1 AND [jarime] IS NULL) OR ([jarime] = @Original_jarime)) AND ((@IsNull_sum = 1 AND [sum] IS NULL) OR ([sum] = @Original_sum)));
SELECT kid, fid, mid, adddatefa, adddatemi, duedatefa, duedatemi, price, jarime, sum FROM tblkeraye WHERE (kid = @kid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@fid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@adddatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adddatefa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@adddatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@duedatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="duedatefa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@duedatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="duedatemi" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@jarime" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="jarime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@sum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="sum" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_kid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="kid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_fid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_adddatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="adddatefa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_adddatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="adddatemi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_duedatefa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="duedatefa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_duedatefa" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="duedatefa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_duedatemi" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="duedatemi" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_duedatemi" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="duedatemi" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_price" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_jarime" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="jarime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_jarime" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="jarime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_sum" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="sum" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_sum" Precision="18" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="sum" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="kid" ColumnName="kid" DataSourceName="[C:\USERS\KOVERDON\DOCUMENTS\CLUB.MDF].dbo.tblkeraye" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@kid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="kid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="kid" DataSetColumn="kid" />
              <Mapping SourceColumn="fid" DataSetColumn="fid" />
              <Mapping SourceColumn="mid" DataSetColumn="mid" />
              <Mapping SourceColumn="adddatefa" DataSetColumn="adddatefa" />
              <Mapping SourceColumn="adddatemi" DataSetColumn="adddatemi" />
              <Mapping SourceColumn="duedatefa" DataSetColumn="duedatefa" />
              <Mapping SourceColumn="duedatemi" DataSetColumn="duedatemi" />
              <Mapping SourceColumn="price" DataSetColumn="price" />
              <Mapping SourceColumn="jarime" DataSetColumn="jarime" />
              <Mapping SourceColumn="sum" DataSetColumn="sum" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="View1TableAdapter" GeneratorDataComponentClassName="View1TableAdapter" Name="View1" UserDataComponentName="View1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.View1" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" 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">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        View1.*
FROM            View1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="title" DataSetColumn="title" />
              <Mapping SourceColumn="kid" DataSetColumn="kid" />
              <Mapping SourceColumn="fid" DataSetColumn="fid" />
              <Mapping SourceColumn="mid" DataSetColumn="mid" />
              <Mapping SourceColumn="adddatefa" DataSetColumn="adddatefa" />
              <Mapping SourceColumn="adddatemi" DataSetColumn="adddatemi" />
              <Mapping SourceColumn="duedatefa" DataSetColumn="duedatefa" />
              <Mapping SourceColumn="duedatemi" DataSetColumn="duedatemi" />
              <Mapping SourceColumn="price" DataSetColumn="price" />
              <Mapping SourceColumn="jarime" DataSetColumn="jarime" />
              <Mapping SourceColumn="sum" DataSetColumn="sum" />
              <Mapping SourceColumn="fname" DataSetColumn="fname" />
              <Mapping SourceColumn="lname" DataSetColumn="lname" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.View1" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByfname" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="FillByfname" GetMethodModifier="Public" GetMethodName="GetDataBy1" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByfname">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        title, kid, fid, mid, adddatefa, adddatemi, duedatefa, duedatemi, price, jarime, sum, fname, lname
FROM            View1
WHERE        (fname LIKE '%' + @fname + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="fname" ColumnName="fname" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.View1" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@fname" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="fname" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.View1" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillBymid" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBymid" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBymid">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        title, kid, fid, mid, adddatefa, adddatemi, duedatefa, duedatemi, price, jarime, sum, fname, lname
FROM            View1
WHERE        (mid = @mid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="mid" ColumnName="mid" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.View1" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@mid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="mid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblusersTableAdapter" GeneratorDataComponentClassName="tblusersTableAdapter" Name="tblusers" UserDataComponentName="tblusersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblusers" 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 [tblusers] ([uname], [pass]) VALUES (@uname, @pass)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@uname" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="uname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@pass" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="pass" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT uname, pass FROM tblusers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="uname" DataSetColumn="uname" />
              <Mapping SourceColumn="pass" DataSetColumn="pass" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="dbo.tblusers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        uname, pass
FROM            tblusers
WHERE        (uname = @uname) AND (pass = @pass)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="uname" ColumnName="uname" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.tblusers" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@uname" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="uname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="pass" ColumnName="pass" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.tblusers" DataTypeServer="nvarchar(50)" DbType="Binary" Direction="Input" ParameterName="@pass" Precision="0" ProviderType="VarBinary" Scale="0" Size="50" SourceColumn="pass" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="clubConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       tblusers
SET                pass = @pass
WHERE        (pass = @pass)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="pass" ColumnName="pass" DataSourceName="[C:\USERS\KOVERDON1\DOCUMENTS\CLUB.MDF].dbo.tblusers" DataTypeServer="binary(16)" DbType="Binary" Direction="Input" ParameterName="@pass" Precision="0" ProviderType="Binary" Scale="0" Size="16" SourceColumn="pass" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet1" msprop:Generator_UserDSName="DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblfilm" msprop:Generator_TableClassName="tblfilmDataTable" msprop:Generator_TableVarName="tabletblfilm" msprop:Generator_RowChangedName="tblfilmRowChanged" msprop:Generator_TablePropName="tblfilm" msprop:Generator_RowDeletingName="tblfilmRowDeleting" msprop:Generator_RowChangingName="tblfilmRowChanging" msprop:Generator_RowEvHandlerName="tblfilmRowChangeEventHandler" msprop:Generator_RowDeletedName="tblfilmRowDeleted" msprop:Generator_RowClassName="tblfilmRow" msprop:Generator_UserTableName="tblfilm" msprop:Generator_RowEvArgName="tblfilmRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contry" msprop:Generator_ColumnVarNameInTable="columncontry" msprop:Generator_ColumnPropNameInRow="contry" msprop:Generator_ColumnPropNameInTable="contryColumn" msprop:Generator_UserColumnName="contry">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="filmtype" msprop:Generator_ColumnVarNameInTable="columnfilmtype" msprop:Generator_ColumnPropNameInRow="filmtype" msprop:Generator_ColumnPropNameInTable="filmtypeColumn" msprop:Generator_UserColumnName="filmtype">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="year" msprop:Generator_ColumnVarNameInTable="columnyear" msprop:Generator_ColumnPropNameInRow="year" msprop:Generator_ColumnPropNameInTable="yearColumn" msprop:Generator_UserColumnName="year" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnfid" msprop:Generator_ColumnPropNameInRow="fid" msprop:Generator_ColumnPropNameInTable="fidColumn" msprop:Generator_UserColumnName="fid" type="xs:int" />
              <xs:element name="count" msprop:Generator_ColumnVarNameInTable="columncount" msprop:Generator_ColumnPropNameInRow="count" msprop:Generator_ColumnPropNameInTable="countColumn" msprop:Generator_UserColumnName="count" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblmoshtari" msprop:Generator_TableClassName="tblmoshtariDataTable" msprop:Generator_TableVarName="tabletblmoshtari" msprop:Generator_RowChangedName="tblmoshtariRowChanged" msprop:Generator_TablePropName="tblmoshtari" msprop:Generator_RowDeletingName="tblmoshtariRowDeleting" msprop:Generator_RowChangingName="tblmoshtariRowChanging" msprop:Generator_RowEvHandlerName="tblmoshtariRowChangeEventHandler" msprop:Generator_RowDeletedName="tblmoshtariRowDeleted" msprop:Generator_RowClassName="tblmoshtariRow" msprop:Generator_UserTableName="tblmoshtari" msprop:Generator_RowEvArgName="tblmoshtariRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="fname" msprop:Generator_ColumnVarNameInTable="columnfname" msprop:Generator_ColumnPropNameInRow="fname" msprop:Generator_ColumnPropNameInTable="fnameColumn" msprop:Generator_UserColumnName="fname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lname" msprop:Generator_ColumnVarNameInTable="columnlname" msprop:Generator_ColumnPropNameInRow="lname" msprop:Generator_ColumnPropNameInTable="lnameColumn" msprop:Generator_UserColumnName="lname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="tell" msprop:Generator_ColumnVarNameInTable="columntell" msprop:Generator_ColumnPropNameInRow="tell" msprop:Generator_ColumnPropNameInTable="tellColumn" msprop:Generator_UserColumnName="tell">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnmid" msprop:Generator_ColumnPropNameInRow="mid" msprop:Generator_ColumnPropNameInTable="midColumn" msprop:Generator_UserColumnName="mid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblkeraye" msprop:Generator_TableClassName="tblkerayeDataTable" msprop:Generator_TableVarName="tabletblkeraye" msprop:Generator_RowChangedName="tblkerayeRowChanged" msprop:Generator_TablePropName="tblkeraye" msprop:Generator_RowDeletingName="tblkerayeRowDeleting" msprop:Generator_RowChangingName="tblkerayeRowChanging" msprop:Generator_RowEvHandlerName="tblkerayeRowChangeEventHandler" msprop:Generator_RowDeletedName="tblkerayeRowDeleted" msprop:Generator_RowClassName="tblkerayeRow" msprop:Generator_UserTableName="tblkeraye" msprop:Generator_RowEvArgName="tblkerayeRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="adddatefa" msprop:Generator_ColumnVarNameInTable="columnadddatefa" msprop:Generator_ColumnPropNameInRow="adddatefa" msprop:Generator_ColumnPropNameInTable="adddatefaColumn" msprop:Generator_UserColumnName="adddatefa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </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" minOccurs="0" />
              <xs:element name="fname" msprop:Generator_ColumnVarNameInTable="columnfname" msprop:Generator_ColumnPropNameInRow="fname" msprop:Generator_ColumnPropNameInTable="fnameColumn" msprop:Generator_UserColumnName="fname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lname" msprop:Generator_ColumnVarNameInTable="columnlname" msprop:Generator_ColumnPropNameInRow="lname" msprop:Generator_ColumnPropNameInTable="lnameColumn" msprop:Generator_UserColumnName="lname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="contry" msprop:Generator_ColumnVarNameInTable="columncontry" msprop:Generator_ColumnPropNameInRow="contry" msprop:Generator_ColumnPropNameInTable="contryColumn" msprop:Generator_UserColumnName="contry">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="filmtype" msprop:Generator_ColumnVarNameInTable="columnfilmtype" msprop:Generator_ColumnPropNameInRow="filmtype" msprop:Generator_ColumnPropNameInTable="filmtypeColumn" msprop:Generator_UserColumnName="filmtype">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="adddatemi" msprop:Generator_ColumnVarNameInTable="columnadddatemi" msprop:Generator_ColumnPropNameInRow="adddatemi" msprop:Generator_ColumnPropNameInTable="adddatemiColumn" msprop:Generator_UserColumnName="adddatemi" type="xs:dateTime" />
              <xs:element name="sum" msprop:Generator_ColumnVarNameInTable="columnsum" msprop:Generator_ColumnPropNameInRow="sum" msprop:Generator_ColumnPropNameInTable="sumColumn" msprop:Generator_UserColumnName="sum" type="xs:decimal" minOccurs="0" />
              <xs:element name="kid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnkid" msprop:Generator_ColumnPropNameInRow="kid" msprop:Generator_ColumnPropNameInTable="kidColumn" msprop:Generator_UserColumnName="kid" type="xs:int" />
              <xs:element name="fid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnfid" msprop:Generator_ColumnPropNameInRow="fid" msprop:Generator_ColumnPropNameInTable="fidColumn" msprop:Generator_UserColumnName="fid" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblkeraye1" msprop:Generator_TableClassName="tblkeraye1DataTable" msprop:Generator_TableVarName="tabletblkeraye1" msprop:Generator_RowChangedName="tblkeraye1RowChanged" msprop:Generator_TablePropName="tblkeraye1" msprop:Generator_RowDeletingName="tblkeraye1RowDeleting" msprop:Generator_RowChangingName="tblkeraye1RowChanging" msprop:Generator_RowEvHandlerName="tblkeraye1RowChangeEventHandler" msprop:Generator_RowDeletedName="tblkeraye1RowDeleted" msprop:Generator_RowClassName="tblkeraye1Row" msprop:Generator_UserTableName="tblkeraye1" msprop:Generator_RowEvArgName="tblkeraye1RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="kid" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnkid" msprop:Generator_ColumnPropNameInRow="kid" msprop:Generator_ColumnPropNameInTable="kidColumn" msprop:Generator_UserColumnName="kid" type="xs:int" />
              <xs:element name="fid" msprop:Generator_ColumnVarNameInTable="columnfid" msprop:Generator_ColumnPropNameInRow="fid" msprop:Generator_ColumnPropNameInTable="fidColumn" msprop:Generator_UserColumnName="fid" type="xs:int" />
              <xs:element name="mid" msprop:Generator_ColumnVarNameInTable="columnmid" msprop:Generator_ColumnPropNameInRow="mid" msprop:Generator_ColumnPropNameInTable="midColumn" msprop:Generator_UserColumnName="mid" type="xs:int" />
              <xs:element name="adddatefa" msprop:Generator_ColumnVarNameInTable="columnadddatefa" msprop:Generator_ColumnPropNameInRow="adddatefa" msprop:Generator_ColumnPropNameInTable="adddatefaColumn" msprop:Generator_UserColumnName="adddatefa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="adddatemi" msprop:Generator_ColumnVarNameInTable="columnadddatemi" msprop:Generator_ColumnPropNameInRow="adddatemi" msprop:Generator_ColumnPropNameInTable="adddatemiColumn" msprop:Generator_UserColumnName="adddatemi" type="xs:dateTime" />
              <xs:element name="duedatefa" msprop:Generator_ColumnVarNameInTable="columnduedatefa" msprop:Generator_ColumnPropNameInRow="duedatefa" msprop:Generator_ColumnPropNameInTable="duedatefaColumn" msprop:Generator_UserColumnName="duedatefa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="duedatemi" msprop:Generator_ColumnVarNameInTable="columnduedatemi" msprop:Generator_ColumnPropNameInRow="duedatemi" msprop:Generator_ColumnPropNameInTable="duedatemiColumn" msprop:Generator_UserColumnName="duedatemi" type="xs:dateTime" minOccurs="0" />
              <xs:element name="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" type="xs:decimal" minOccurs="0" />
              <xs:element name="jarime" msprop:Generator_ColumnVarNameInTable="columnjarime" msprop:Generator_ColumnPropNameInRow="jarime" msprop:Generator_ColumnPropNameInTable="jarimeColumn" msprop:Generator_UserColumnName="jarime" type="xs:decimal" minOccurs="0" />
              <xs:element name="sum" msprop:Generator_ColumnVarNameInTable="columnsum" msprop:Generator_ColumnPropNameInRow="sum" msprop:Generator_ColumnPropNameInTable="sumColumn" msprop:Generator_UserColumnName="sum" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="View1" msprop:Generator_TableClassName="View1DataTable" msprop:Generator_TableVarName="tableView1" msprop:Generator_TablePropName="View1" msprop:Generator_RowDeletingName="View1RowDeleting" msprop:Generator_RowChangingName="View1RowChanging" msprop:Generator_RowEvHandlerName="View1RowChangeEventHandler" msprop:Generator_RowDeletedName="View1RowDeleted" msprop:Generator_UserTableName="View1" msprop:Generator_RowChangedName="View1RowChanged" msprop:Generator_RowEvArgName="View1RowChangeEvent" msprop:Generator_RowClassName="View1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="title" msprop:Generator_ColumnVarNameInTable="columntitle" msprop:Generator_ColumnPropNameInRow="title" msprop:Generator_ColumnPropNameInTable="titleColumn" msprop:Generator_UserColumnName="title">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="kid" msprop:Generator_ColumnVarNameInTable="columnkid" msprop:Generator_ColumnPropNameInRow="kid" msprop:Generator_ColumnPropNameInTable="kidColumn" msprop:Generator_UserColumnName="kid" type="xs:int" />
              <xs:element name="fid" msprop:Generator_ColumnVarNameInTable="columnfid" msprop:Generator_ColumnPropNameInRow="fid" msprop:Generator_ColumnPropNameInTable="fidColumn" msprop:Generator_UserColumnName="fid" type="xs:int" />
              <xs:element name="mid" msprop:Generator_ColumnVarNameInTable="columnmid" msprop:Generator_ColumnPropNameInRow="mid" msprop:Generator_ColumnPropNameInTable="midColumn" msprop:Generator_UserColumnName="mid" type="xs:int" />
              <xs:element name="adddatefa" msprop:Generator_ColumnVarNameInTable="columnadddatefa" msprop:Generator_ColumnPropNameInRow="adddatefa" msprop:Generator_ColumnPropNameInTable="adddatefaColumn" msprop:Generator_UserColumnName="adddatefa">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="adddatemi" msprop:Generator_ColumnVarNameInTable="columnadddatemi" msprop:Generator_ColumnPropNameInRow="adddatemi" msprop:Generator_ColumnPropNameInTable="adddatemiColumn" msprop:Generator_UserColumnName="adddatemi" type="xs:dateTime" />
              <xs:element name="duedatefa" msprop:Generator_ColumnVarNameInTable="columnduedatefa" msprop:Generator_ColumnPropNameInRow="duedatefa" msprop:Generator_ColumnPropNameInTable="duedatefaColumn" msprop:Generator_UserColumnName="duedatefa" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="duedatemi" msprop:Generator_ColumnVarNameInTable="columnduedatemi" msprop:Generator_ColumnPropNameInRow="duedatemi" msprop:Generator_ColumnPropNameInTable="duedatemiColumn" msprop:Generator_UserColumnName="duedatemi" type="xs:dateTime" minOccurs="0" />
              <xs:element name="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnPropNameInTable="priceColumn" msprop:Generator_UserColumnName="price" type="xs:decimal" minOccurs="0" />
              <xs:element name="jarime" msprop:Generator_ColumnVarNameInTable="columnjarime" msprop:Generator_ColumnPropNameInRow="jarime" msprop:Generator_ColumnPropNameInTable="jarimeColumn" msprop:Generator_UserColumnName="jarime" type="xs:decimal" minOccurs="0" />
              <xs:element name="sum" msprop:Generator_ColumnVarNameInTable="columnsum" msprop:Generator_ColumnPropNameInRow="sum" msprop:Generator_ColumnPropNameInTable="sumColumn" msprop:Generator_UserColumnName="sum" type="xs:decimal" minOccurs="0" />
              <xs:element name="fname" msprop:Generator_ColumnVarNameInTable="columnfname" msprop:Generator_ColumnPropNameInRow="fname" msprop:Generator_ColumnPropNameInTable="fnameColumn" msprop:Generator_UserColumnName="fname">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lname" msprop:Generator_ColumnVarNameInTable="columnlname" msprop:Generator_ColumnPropNameInRow="lname" msprop:Generator_ColumnPropNameInTable="lnameColumn" msprop:Generator_UserColumnName="lname">
                <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="tblusers" msprop:Generator_TableClassName="tblusersDataTable" msprop:Generator_TableVarName="tabletblusers" msprop:Generator_TablePropName="tblusers" msprop:Generator_RowDeletingName="tblusersRowDeleting" msprop:Generator_RowChangingName="tblusersRowChanging" msprop:Generator_RowEvHandlerName="tblusersRowChangeEventHandler" msprop:Generator_RowDeletedName="tblusersRowDeleted" msprop:Generator_UserTableName="tblusers" msprop:Generator_RowChangedName="tblusersRowChanged" msprop:Generator_RowEvArgName="tblusersRowChangeEvent" msprop:Generator_RowClassName="tblusersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="uname" msprop:Generator_ColumnVarNameInTable="columnuname" msprop:Generator_ColumnPropNameInRow="uname" msprop:Generator_ColumnPropNameInTable="unameColumn" msprop:Generator_UserColumnName="uname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pass" msprop:Generator_ColumnVarNameInTable="columnpass" msprop:Generator_ColumnPropNameInRow="pass" msprop:Generator_ColumnPropNameInTable="passColumn" msprop:Generator_UserColumnName="pass" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblfilm" />
      <xs:field xpath="mstns:fid" />
    </xs:unique>
    <xs:unique name="tblkeraye_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblkeraye" />
      <xs:field xpath="mstns:kid" />
    </xs:unique>
    <xs:unique name="tblkeraye1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblkeraye1" />
      <xs:field xpath="mstns:kid" />
    </xs:unique>
    <xs:unique name="View1_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:View1" />
      <xs:field xpath="mstns:kid" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblkeraye_tblfilm" msdata:parent="tblfilm" msdata:child="tblkeraye1" msdata:parentkey="fid" msdata:childkey="fid" msprop:Generator_UserChildTable="tblkeraye1" msprop:Generator_ChildPropName="Gettblkeraye1Rows" msprop:Generator_UserRelationName="FK_tblkeraye_tblfilm" msprop:Generator_RelationVarName="relationFK_tblkeraye_tblfilm" msprop:Generator_UserParentTable="tblfilm" msprop:Generator_ParentPropName="tblfilmRow" />
      <msdata:Relationship name="FK_tblkeraye_tblfilm1" msdata:parent="tblkeraye" msdata:child="tblkeraye1" msdata:parentkey="fid" msdata:childkey="fid" msprop:Generator_UserChildTable="tblkeraye1" msprop:Generator_ChildPropName="Gettblkeraye1Rows" msprop:Generator_UserRelationName="FK_tblkeraye_tblfilm1" msprop:Generator_RelationVarName="relationFK_tblkeraye_tblfilm1" msprop:Generator_UserParentTable="tblkeraye" msprop:Generator_ParentPropName="tblkerayeRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>