关于remoting和sql的一点问题，怎样实现在server端访问数据库，然后将结果返回client端？

[staryoung]

以下是在client端直接访问数据库的代码

//数据库访问类
namespace RemotingClass
{
    public partial class FarClass : Form
    {
        SqlConnection conn;
        public FarClass()
        {
            InitializeComponent();
            conn = new SqlConnection();
            conn.ConnectionString = "Data Source=localhost;Database=test;User ID=sa;Password=";
        }
        public DataTable GetDataTable(string TableName)
        {
            SqlDataAdapter sda = new SqlDataAdapter("select * from  " + TableName, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds,TableName);
            return ds.Tables[TableName];
        }
    }
}

//服务端
namespace RemotingServer
{
    public partial class RemotingServerForm : Form
    {
        public RemotingServerForm()
        {
            InitializeComponent();
        }

        private void RemotingServerForm_Load(object sender, EventArgs e)
        {
            RemotingConfiguration.Configure("RemotingServer.exe.Config", false);
            this.label1.Text = "服务端已启动";
        }
    }
}

//客户端
namespace RemotingClient
{
    public partial class RemotingClientForm : Form
    {
        FarClass fc;
        DataTable table;
        public RemotingClientForm()
        {
            InitializeComponent();
        }

        private void RemotingClientForm_Load(object sender, EventArgs e)
        {
            //ChannelServices.RegisterChannel(new TcpChannel());
            //WellKnownClientTypeEntry RemotingConfing = new WellKnownClientTypeEntry(typeof(FarClass), "tcp://localhost:9999/TcpService");
            //RemotingConfiguration.RegisterWellKnownClientType(RemotingConfing);
            RemotingConfiguration.Configure("RemotingClient.exe.Config",false);
            fc = new FarClass();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            table = new DataTable();
            table = fc.GetDataTable("student");
            this.dataGridView1.DataSource = table;
        }

[Lemon2050]

使用脚本吧，先在SERVER上得到结果，然后发送到CLIENT端。
或者， 先在SERVER上得到结果，存放在本地。然后client端需要的时候去制定的remote文件夹取。

[staryoung]

对的，我就是希望在server上得到结果，然后发送到client端
但以前没用过remoting，所以想问下方法，谢谢！

[zcfzcf001]

使用webservice吧，也挺好的