日期:2014-05-19  浏览次数:20762 次

remoting 操作数据库的例子
请问有什么做remoting   操作数据库吗,能否提供共享简单源码,小弟想学学,谢谢

------解决方案--------------------
你是为了学习,网上也有很多C#源码呀
------解决方案--------------------
刚刚才写的一个!

服务器和客户端需要引用“类文件” 和System.Runtime.Remoting;

类文件
--------------
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;


namespace db
{
public class DBAccess:MarshalByRefObject
{
private SqlConnection con;
private SqlDataAdapter da;
private DataSet ds;
public DBAccess()
{
Console.Write( "构造方法 ");
}

public DataSet GetDateSet(string strSql,string tabName)
{
con = new SqlConnection( "server=(local); " + "integrated security=SSPI; " + "database=henry ");
da = new SqlDataAdapter(strSql, con);
SqlCommandBuilder builder = new SqlCommandBuilder(da);
ds = new DataSet();
da.Fill(ds,tabName);
return ds;
}

public override object InitializeLifetimeService()
{
return null;
}
}
}
--------------------------------------

服务器文件
--------------------------------------
using System;
using System.Collections.Generic;
using System.Text;
using System.Runtime;
using System.Runtime.Remoting;
using System.Runtime.Remoting.Channels;
using System.Runtime.Remoting.Channels.Tcp;


namespace db
{
class Program
{
static void Main(string[] args)
{
TcpServerChannel channel = new TcpServerChannel(8888);
ChannelServices.RegisterChannel(channel, false);
RemotingConfiguration.RegisterWellKnownServiceType(typeof(DBAccess), "Hi ", WellKnownObjectMode.Singleton);
Console.WriteLine( "回车退出 ");
Console.ReadLine();
}
}
}
------------------------------------------------------

客户端代码 form1
---------------------------------------------------
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Runtime;
using System.Runtime.Remoting;
using System.Runtime.Remoting.Channels;
using System.Runtime.Remoting.Channels.Tcp;


namespace db
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private DBAccess obj;
private void Form1_Load(object sender, EventArgs e)
{
TcpClientChannel channle = new TcpClientChannel();
obj = (DBAccess)Activator.GetObject(typeof(DBAccess), "tcp://localhost:8888/Hi ");
dataGrid1.DataSource = obj.GetDateSet( "select * from login ", "login ");
dataGrid1.DataMember = "login ";

}
}
}
------------------------------------------