public void TestSQLServer() { DbAccessor dbAccessor = null; //带构造函数不带参数 dbAccessor = (DbAccessor)Assembly.Load("HBG.Data.Common").CreateInstance("HBG.Data.Common.SQLServerDbAccessorAdapter", false); //带构造函数带参数 Type t = Assembly.Load("HBG.Data.Common").GetType("HBG.Data.Common.SQLServerDbAccessorAdapter"); string connString = ConfigurationManager.ConnectionStrings["SqlServer.主数据库"].ToString(); dbAccessor = (SQLServerDbAccessorAdapter)Activator.CreateInstance(t, new object[] { connString, 180 }); //增 string insertCmdText = "insert into T_USER(UserId,UserName,UserPwd) values('3','hbg','123');"; int insertResult = dbAccessor.ExecuteNonQuery(insertCmdText); //删 string delCmdText = "delete from T_USER where UserId='3';"; int delResult = dbAccessor.ExecuteNonQuery(delCmdText); //改 string updateCmdText = "update T_USER set UserPwd='123456' where UserId='2';"; int updateResult = dbAccessor.ExecuteNonQuery(updateCmdText); //查 string selectCmdText = "select * from T_USER;"; DataSet ds = dbAccessor.ExecuteDataSet(selectCmdText); }