C#

<br />
public interface DeptInterface<br />
{<br />
bool ExecuteSelectCommand(string selcommand);<br />
string GetRow();<br />
void Init();<br />
}<br />
<br />
2. Server.cs // which implements ClassLibrary Methods<br />
<code><br />
public partial class Form1 : Form<br />
{<br />
public Form1()<br />
{<br />
InitializeComponent();<br />
}<br />
public class CustServer : MarshalByRefObject, DeptInterface<br />
{<br />
private SqlConnection myConnection = null;<br />
private SqlDataReader myReader;<br />
<br />
public CustServer() { }<br />
<br />
public void Init()<br />
{<br />
try<br />
{<br />
String strConn = "Data Source=KPTEST1;Initial Catalog=Store;Integrated Security=SSPI";<br />
myConnection = new SqlConnection(strConn);<br />
myConnection.Open();<br />
if (myConnection == null)<br />
{<br />
MessageBox.Show("OPEN NULL VALUE =====================");<br />
return;<br />
}<br />
}<br />
catch (Exception es)<br />
{<br />
MessageBox.Show("[Error WITH DB CONNECT...] " + es.Message);<br />
}<br />
}<br />
public bool ExecuteSelectCommand(String selCommand)<br />
{<br />
try<br />
{<br />
MessageBox.Show("EXECUTING .. " + selCommand);<br />
SqlCommand myCommand = new SqlCommand(selCommand);<br />
if (myConnection == null)<br />
{<br />
MessageBox.Show("NULL VALUE =====================");<br />
return false;<br />
}<br />
myCommand.Connection = myConnection;<br />
myCommand.ExecuteNonQuery();<br />
myReader = myCommand.ExecuteReader();<br />
return true;<br />
}<br />
public string GetRow()<br />
{<br />
if (!myReader.Read())<br />
{<br />
myReader.Close();<br />
return "";<br />
}<br />
int nCol = myReader.FieldCount;<br />
string outstr = "";<br />
object[] values = new Object[nCol];<br />
myReader.GetValues(values);<br />
for (int i = 0; i < values.Length; i++)<br />
{<br />
string coldata = values[i].ToString();<br />
coldata = coldata.TrimEnd();<br />
outstr += coldata + ",";<br />
}<br />
return outstr;<br />
}<br />

<br />
private void Form1_Load(object sender, EventArgs e)<br />
{<br />
MessageBox.Show("TEST1");<br />
bool ensureSecurity = true;<br />
ChannelServices.RegisterChannel(new TcpClientChannel(), ensureSecurity);<br />
dept = (DeptInterface)Activator.GetObject(typeof(DeptInterface), "tcp://KPTEST1:8080/CustServer");<br />
if (dept == null)<br />
{<br />
MessageBox.Show("TCP SERVER OFFLINE ...PLEASE TRY LATER");<br />
return;<br />
}<br />
dept.Init(); // Exception Error<br />
MessageBox.Show("TEST2");<br />
}<br />

System.Collections.Generic.List<Employee> employees= new System.Collections.Generic.List<Employee>();

EmployeeId
EmployeeName
Department
JobTitle
etc.