using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.OleDb;

namespace?Remoteobject
{
????public?class?CRemoteAccess?:?MarshalByRefobject
????{
????????public?static?string?m_ConnString;
????????private?string?m_sqlQuery;
????????private?OleDbConnection?m_connection;
????????private?OleDbCommand?m_command;
????????private?OleDbDataAdapter?m_adapter;
????????private?OleDbCommandBuilder?m_builder;
????????private?DataSet?m_ds;
????????private?DataTable?m_userTable;

????????public?CRemoteAccess（）
		{
		}

????????public?void?SetRemoteAccessConnString（string?Connstr）
????????{
????????????m_ConnString?=?Connstr;
????????}

????????public?string?GetRemoteAccessConnString（）
????????{
????????????return?m_ConnString;
????????}?????

????????private?void?SetDataobjects（）
????????{
????????????m_connection?=?new?OleDbConnection（m_ConnString）;
????????????m_command?=?new?OleDbCommand（m_sqlQuery?m_connection）;
????????????m_adapter?=?new?OleDbDataAdapter（m_command）;
????????????m_builder?=?new?OleDbCommandBuilder（m_adapter）;
????????????m_ds?=?new?DataSet（“MainDataSet“）;
????????}

????????public?bool?TestConnectionIsOK（string?connstr）
????????{
????????????OleDbConnection?testconn?=?null;
????????????try
????????????{
????????????????testconn?=?new?OleDbConnection（connstr）;
????????????????testconn.Open（）;
????????????????return?true;
????????????}
????????????catch
????????????{
????????????????return?false;
????????????}
????????????finally
????????????{
????????????????testconn.Close（）;
????????????}????????????
????????}

????????private?void?LoadData（string?SqlStr?string?TableName）
????????{
????????????try
????????????{
????????????????if?（m_userTable?!=?null）
????????????????{
????????????????????m_userTable.Clear（）;
????????????????}
????????????????m_sqlQuery?=?SqlStr;//?“select?*?from?Test“;
????????????????SetDataobjects（）;
????????????????m_connection.Open（）;

????????????????m_adapter.Fill（m_ds?TableName）;
????????????????m_userTable?=?m_ds.Tables[TableName];
????????????}
????????????catch?//（Exception?ex）
????????????{

????????????}
????????????finally
????????????{
????????????????m_connection.Close（）;
????????????}
????????}

????????public?void?SaveData（DataTable?ClientDataTable）
????????{
????????????try
????????????{
????????????????m_connection.Open（）;
????????????????m_adapter.Update（ClientDataTable）;
????????????}
????????????catch?//（Exception?ex）
????????????{

????????????}
????????????finally
????????????{
????????????????m_connection.Close（）;
????????????}
????????}

????????public?DataTable?GetUserTable（string?SqlStr?string?TableName）
????????{
????????????LoadData（SqlStr?TableName）;
????????????return?m_userTable;
????????}

????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????143360??2007-06-21?12:13??TestRemoteAccess\Demo\db.mdb

?????文件??????16384??2007-07-31?20:09??TestRemoteAccess\Demo\Remoteobject.dll

?????文件??????24576??2007-07-31?20:38??TestRemoteAccess\Demo\TestClient.exe

?????文件??????24576??2007-07-31?20:38??TestRemoteAccess\Demo\TestServer.exe

?????文件???????2873??2007-07-29?20:17??TestRemoteAccess\Remoteobject\CRemoteAccess.cs

?????文件??????16384??2007-07-31?20:32??TestRemoteAccess\Remoteobject\obj\Debug\Refactor\Remoteobject.dll

?????文件??????16384??2007-07-31?20:09??TestRemoteAccess\Remoteobject\obj\Debug\Remoteobject.dll

?????文件??????15872??2007-07-31?20:09??TestRemoteAccess\Remoteobject\obj\Debug\Remoteobject.pdb

?????文件??????16384??2007-07-28?17:22??TestRemoteAccess\Remoteobject\obj\Release\Remoteobject.dll

?????文件??????13824??2007-07-28?17:22??TestRemoteAccess\Remoteobject\obj\Release\Remoteobject.pdb

?????文件????????372??2007-07-31?20:38??TestRemoteAccess\Remoteobject\obj\Remoteobject.csproj.FileList.txt

?????文件???????1374??2007-07-28?17:05??TestRemoteAccess\Remoteobject\Properties\AssemblyInfo.cs

?????文件???????1967??2007-07-28?16:51??TestRemoteAccess\Remoteobject\Remoteobject.csproj

?????文件???????2232??2007-07-31?20:38??TestRemoteAccess\TestClient\frmTestClient.cs

?????文件???????7683??2007-07-31?20:32??TestRemoteAccess\TestClient\frmTestClient.Designer.cs

?????文件???????7742??2007-07-31?20:32??TestRemoteAccess\TestClient\frmTestClient.resx

?????文件????????908??2007-07-31?20:38??TestRemoteAccess\TestClient\obj\Debug\TestClient.csproj.GenerateResource.Cache

?????文件??????24576??2007-07-31?20:38??TestRemoteAccess\TestClient\obj\Debug\TestClient.exe

?????文件????????180??2007-07-31?20:38??TestRemoteAccess\TestClient\obj\Debug\TestClient.frmTestClient.resources

?????文件??????32256??2007-07-31?20:38??TestRemoteAccess\TestClient\obj\Debug\TestClient.pdb

?????文件????????180??2007-07-31?20:09??TestRemoteAccess\TestClient\obj\Debug\TestClient.Properties.Resources.resources

?????文件????????850??2007-07-28?17:22??TestRemoteAccess\TestClient\obj\Release\TestClient.csproj.GenerateResource.Cache

?????文件??????20480??2007-07-28?17:22??TestRemoteAccess\TestClient\obj\Release\TestClient.exe

?????文件????????180??2007-07-28?17:22??TestRemoteAccess\TestClient\obj\Release\TestClient.frmTestClient.resources

?????文件??????19968??2007-07-28?17:22??TestRemoteAccess\TestClient\obj\Release\TestClient.pdb

?????文件????????180??2007-07-28?17:22??TestRemoteAccess\TestClient\obj\Release\TestClient.Properties.Resources.resources

?????文件????????668??2007-07-31?20:38??TestRemoteAccess\TestClient\obj\TestClient.csproj.FileList.txt

?????文件????????477??2007-07-28?17:12??TestRemoteAccess\TestClient\Program.cs

?????文件???????1225??2007-07-28?17:05??TestRemoteAccess\TestClient\Properties\AssemblyInfo.cs

?????文件???????2875??2007-07-28?16:48??TestRemoteAccess\TestClient\Properties\Resources.Designer.cs

............此處省略113個文件信息