问题描述
(1)以sql2000为例建立TestUser数据库。表的sql脚本(在查询分析器中执行即可):/******Object:Table[dbo].[Customers]ScriptDate:2004-01-080:46:35******/CREATETABLE[dbo].[Customers]([CustomerID][int]IDENTITY(1,1)NOTNULL,[CustomerName][char](20)NOTNULL,[addr][varchar](50)NULL,[city][char](20)NULL,[phone][char](20)NULL,[fax][char](10)NULL)ON[PRIMARY]GO/******Object:Table[dbo].[Users]ScriptDate:2004-01-080:46:36******/CREATETABLE[dbo].[Users]([ID][int]IDENTITY(1,1)NOTNULL,[TrueName][char](20)NOTNULL,[RegName][char](20)NOTNULL,[Pwd][char](10)NOTNULL,[Sex][char](2)NULL,[Email][char](20)NULL)ON[PRIMARY]GOALTERTABLE[dbo].[Customers]WITHNOCHECKADDCONSTRAINT[PK_Customers]PRIMARYKEYNONCLUSTERED([CustomerID])ON[PRIMARY]GOALTERTABLE[dbo].[Users]WITHNOCHECKADDCONSTRAINT[PK_Users]PRIMARYKEYNONCLUSTERED([ID])ON[PRIMARY]GO(2)创建业务实体层1.打开vs.net2002,新建一个项目,选ASP.NETWeb服务,位置是:http://localhost/mydotnet/tiner/WebData/2.WebService的代码usingSystem;usingSystem.Collections;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Diagnostics;usingSystem.Web;usingSystem.Web.Services;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.HtmlControls;namespaceWebData{///<summary>///Service1的摘要说明。///</summary>[WebService(Namespace="http://www.ourfly.com",Description="<fontsize=4color=#FF6633><b><br><center>使用C#写的三层架构的程序。</center></b><br><br></font>")]publicclassService1:System.Web.Services.WebService{SqlDataAdapterMyAdapter;stringstrConn="datasource=localhost;initialcatalog=TestUser;uid=sa;pwd=";publicService1(){//CODEGEN:该调用是ASP.NETWeb服务设计器所必需的InitializeComponent();}#regionComponentDesignergeneratedcode//Web服务设计器所必需的privateIContainercomponents=null;///<summary>///设计器支持所需的方法-不要使用代码编辑器修改///此方法的内容。///</summary>privatevoidInitializeComponent(){}///<summary>///清理所有正在使用的资源。///</summary>protectedoverridevoidDispose(booldisposing){if(disposing&&components!=null){components.Dispose();}base.Dispose(disposing);}#endregion//定义一个私有方法,用来判断用户是否存在privateBooleanBoolReg(stringstrRegName){BooleanstrResult;SqlConnectioncn;SqlCommandcmd;stringstrSQL;cn=newSqlConnection(strConn);cn.Open();strSQL="selectcount(*)fromUserswhereRegName="+strRegName+"";cmd=newSqlCommand(strSQL,cn);SqlDataReaderreader=cmd.ExecuteReader();reader.Read();inti=reader.GetInt32(0);if(i>0){reader.Close();cn.Close();strResult=true;}else{reader.Close();cn.Close();strResult=false;}returnstrResult;}[WebMethod(Description="完成用户注册功能.")]publicstringRegUser(stringstrTrueName,stringstrRegName,stringstrPwd,stringstrSex,stringstrEmail){stringstrResult;SqlConnectioncn;SqlCommandcmd;//判断用户是否存在if(BoolReg(strRegName)){strResult="这个用户已经存在,请重新注册";returnstrResult;}else{stringstrSQL;cn=newSqlConnection(strConn);cn.Open();strSQL="insertintoUsers(TrueName,RegName,Pwd,Sex,Email)values(";strSQL+=strTrueName+",";strSQL+=strRegName+",";strSQL+=strPwd+",";strSQL+=strSex+",";strSQL+=strEmail+")";cmd=newSqlCommand(strSQL,cn);try{cmd.ExecuteNonQuery();cn.Close();strResult="用户注册成功";}catch(Exceptione){cn.Close();strResult="请仔细检查你的输入项";}}returnstrResult;}[WebMethod(Description="用户登录")]publicstringLogin(stringstrRegName,stringstrPwd){SqlConnectioncn;SqlDataAdapterda;DataSetds;stringstrSQL,strResult;strSQL="selectTrueName,RegName,PwdfromUserswhereRegName="+strRegName+"andPwd="+strPwd+"";cn=newSqlConnection(strConn);cn.Open();da=newSqlDataAdapter(strSQL,cn);ds=newDataSet();da.Fill(ds,"Users");if(ds.Tables["Users"].Rows.Count>0){strResult="登录成功";}else{strResult="用户名或口令有误或者没有这个用户!请重新输入!";}cn.Close();returnstrResult;}[WebMethod(Description="得到数据集.")]publicDataSetGetDataSet(){SqlConnectioncn;cn=newSqlConnection(strConn);stringstrSel="select*fromCustomers";cn.Open();MyAdapter=newSqlDataAdapter(strSel,strConn);DataSetds=newDataSet();MyAdapter.Fill(ds,"Customers");returnds;}}}后面一部分再http://topic.csdn.net/u/20080516/22/cdfe884b-503b-49a3-b60b-e6b2918c9fb5.html
解决方案
解决方案二:
路过帮顶=============11月6日,论坛升级公告,积分已经做了调整!http://topic.csdn.net/u/20081107/11/b27dc75f-14b1-4594-9de3-5b18d9e36a11.html此次调整增加了两个新的可用分获取渠道:1:帖子被推荐(加精)后,帖主可以获得88分的可用分奖励;2:帖子结帖后会返还帖主50%的悬赏分,无满意结帖不返还分数;3:接下来会不断增加新的可用分获取途径,比如参与活动赠送等,请大家多关注;