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 ";
}
}
}
------------------------------------------