| 发表于:2008-01-02 15:07:2512楼 得分:0 |
//webservice中的方法 public dataset getuserinfo(string username) { //compress compress=new compress(); dataset ds = new dataset(); sqlconnection cn = new sqlconnection(system.configuration.configurationsettings.appsettings["connectionstring"]); if(cn.state==system.data.connectionstate.closed) { cn.open(); } string sql = "select roleid,username,realname,passwd,unitname from users where username='"+username+"'"; system.data.sqlclient.sqldataadapter adp = new sqldataadapter(sql,cn); try { adp.fill(ds); } catch { } finally { cn.dispose(); } return ds; } //调用 localhost.service1 service=new simceretecia.localhost.service1(); dataset ds=new dataset(); ds=service.getuserinfo(this.tbxusername.text.trim()); | | |
|