Prev: hello
Next: Please help me !
From: Thien on 29 Apr 2010 14:29
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
Crypto Obfuscator for .NET - Product Review
http://www.eggheadcafe.com/tutorials/aspnet/bf15c41b-6510-403e-9af8-f5fd987fafb1/crypto-obfuscator-for-ne.aspx
 | 
Pages: 1
Prev: hello
Next: Please help me !