如何获得datasource(SQL Server)返回的信息200分

[SherryLiu]

我想不用COM+,实现一个客户端dataset更新数据库(例如数据库的table中insert一条记录),由数据库出发事件,其它客户端能作出反应?
问题包括两方面:如何触发事件,如何接收?不用COM+,用SqlConnection保持连接时InfoMessage事件行吗?如何用?

using System;
using System.Data.SqlClient ;
using System.Data ;
namespace mysqlclass
{
/// <summary>
/// Summary description for Class1.
/// </summary>
public class Class1
{
private SqlConnection cn;
public Class1(string connstr)
{ cn=this.openconnection(connstr);
this.conn.InfoMessage += new SqlInfoMessageEventHandler(OnInfoMessage);

}
(OnInfoMessage);


protected static void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
foreach (SqlError err in args.Errors )
{
Console.WriteLine("The {0} has received a severity {1}\n" , err.Source, err.Class);
}
}
public SqlConnection openconnection(string connstr)
{
SqlConnection xcn =new SqlConnection(connstr);
xcn.Open ();

return xcn;
}
public void exeproc( )
{
SqlCommand cmd=new SqlCommand();
cmd.Connection =this.conn;

cmd.CommandText ="insert into Projects(id,name,connection)values(1,'default')";

cmd.ExecuteNonQuery();




}

public SqlConnection conn
{
get
{
return cn;
}
set
{
cn=value;
}
}


}
}


//test 程序代码段:
private void Form1_Load(object sender, System.EventArgs e)
{
mysqlclass.Class1 obj=new mysqlclass.Class1(@"server=ect-sherry\sherry;uid=sa;pwd=ectect;database=SherryApp");
obj.exeproc();



}