Please help me !

I have a solution.

in HTS.Server.Data

DBConntion.cs

public class DBConnection
    {
        public static SqlConnection Conn;
        public DBConnection()
        {
            try
            {
                string strSQL = "server=localhost\\SQLEXPRESS; Initial Catalog=QLNS;Integrated security = True";
                Conn = new SqlConnection(strSQL);
                Conn.Open();
            }
            catch (System.Exception ex)
            {
                throw ex;
            }
        }
    }

AccountDAL.cs I coded :

 public DataTable GetAllAccount()
        {
            DataTable dtAccount = new DataTable();
            string strsql = "select * from tblTaiKhoan";
            SqlDataAdapter daAccount = new SqlDataAdapter(strsql,DBConnection.Conn);
            daAccount.Fill(dtAccount);
            return dtAccount;

        }

in HTS.Server.DBService
NhanVienService.cs I coded :

 public System.Data.DataTable GetAllAccount()
      {
          System.Data.DataTable dtAccount = new System.Data.DataTable();
          dtAccount = accountdal.GetAllAccount();
          return dtAccount;
      }
INhanvienService.cs I coded :

 [OperationContract]
        System.Data.DataTable GetAllAccount();

HTS.Server
App.config :
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>

    <connectionStrings>
        <add name="HTS.Server.Data.Properties.Settings.QLNhanSuConnectionString"
            connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=QLNhanSu;Integrated Security=True"
            providerName="System.Data.SqlClient" />
        <add name ="QLNhanSuConnectionString"
             connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=QLNhanSu;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

    <system.serviceModel>
        <services>
            <!-- List of services -->
      <!-- TienCocService -->
      <service name="HTS.Server.DBService.NhanVienService"
                     behaviorConfiguration="SimpleServiceBehavior">
        <host>
          <baseAddresses>
            <add baseAddress="net.tcp://localhost:8686/DBService/"/>
          </baseAddresses>
        </host>
        <endpoint name="NetTcpBinding_IDBService"
                          contract="HTS.Server.DBService.INhanVienService"
                          binding="netTcpBinding"
                          address="NhanVien"/>
        <endpoint address="NhanVien/mex"
                      binding="mexTcpBinding"
                      contract="IMetadataExchange" />
      </service>
      
        </services>
        <bindings>
            <netTcpBinding>
                <binding name="NetTcpBinding_IDBService">
                    <readerQuotas maxStringContentLength="2147483647"/>
                </binding>
            </netTcpBinding>
        </bindings>
        <behaviors>
            <serviceBehaviors>
                <behavior name="SimpleServiceBehavior">
                    <serviceMetadata httpGetEnabled="False" policyVersion="Policy15" />
                </behavior>
            </serviceBehaviors>
        </behaviors>
    </system.serviceModel>
</configuration>

In HTS.Client

Form1.cs I coded :

DataTable dtAccount = new DataTable();
            dtAccount = _clientNhanvien.GetAllAccount();
            this.dataGridView2.DataSource = dtAccount;
app.config :
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <system.serviceModel>
        <bindings>
            <netTcpBinding>
                <binding name="NetTcpBinding_IDBService" closeTimeout="00:01:00"
                    openTimeout="00:20:00" receiveTimeout="00:30:00" sendTimeout="00:03:00"
                    transactionFlow="false" transferMode="Buffered" transactionProtocol="OleTransactions"
                    hostNameComparisonMode="StrongWildcard" listenBacklog="10"
                    maxBufferPoolSize="2147483647" maxBufferSize="2147483647" maxConnections="100"
                    maxReceivedMessageSize="2147483647">
                    <readerQuotas maxDepth="32" maxStringContentLength="8192" maxArrayLength="16384"
                        maxBytesPerRead="4096" maxNameTableCharCount="16384" />
                    <reliableSession ordered="true" inactivityTimeout="00:10:00"
                        enabled="false" />
                    <security mode="Transport">
                        <transport clientCredentialType="Windows" protectionLevel="EncryptAndSign">
                            <extendedProtectionPolicy policyEnforcement="Never" />
                        </transport>
                        <message clientCredentialType="Windows" />
                    </security>
                </binding>
            </netTcpBinding>
        </bindings>
        <client>
            <endpoint address="net.tcp://localhost:8686/DBService/NhanVien"
                binding="netTcpBinding" bindingConfiguration="NetTcpBinding_IDBService"
                contract="NhanVienService.INhanVienService" name="NetTcpBinding_IDBService">
                <identity>
                    <userPrincipalName value="TranNgocHau-PC\TranNgocHau" />
                </identity>
            </endpoint>
        </client>
    </system.serviceModel>
</configuration>

Error : The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '00:04:59.7830000'.

I take much time for this exercise.I try to config file app.config closeTimeout="00:01:00"
                    openTimeout="00:20:00" receiveTimeout="00:30:00" sendTimeout="00:03:00" but It does not work, please help me...

Thien Tran wrote:

hello
29-Apr-10

I want to register

Previous Posts In This Thread:

Submitted via EggHeadCafe - Software Developer Portal of Choice
C# And The Little Iterator That Could
http://www.eggheadcafe.com/tutorials/aspnet/f0cfca12-7398-4b84-a232-0ae26adaa533/c-and-the-little-iterato.aspx