类文件
--------------
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;
}
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();
}
客户端代码 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();
}