.NET WebService的创建、部署、运用

?????????????????????? -------最先要解决的问题是你要阅读和了解WebService相关的知识------
第一步：创建你的webservice，打开VS2005---新建网站----Asp.Net Web服务---确定
第二步：网站自动给你生成了一个asmx文件----现在你就可以运行这个简单的webservice，之后你就可以看到那个"Hello World"。
????????????????
第一步：创建你的WebSite，就是asp.net站点
//当然开发前,你可以先不新建asp.net站点，我就直接在webservice本地操作，我觉得这样比较好。

1：【上传功能】
第一步：在你的web站点拖入一个上传控件FileUpload，这个控件的作用就是选择本地的xml文件，在本地转化为dataset，你要传给webservice的是dataset。具体代码如下：
//=================客户端上传Xml文件====================
???? protected void btnUpload_Click(object sender,EventArgs e)
???? {
???????? //fullfileName获得全路径
???????? string fullfileName = this.fileUpload.PostedFile.FileName;
???????? //获得文件名
???????? fileName = fullfileName.Substring(fullfileName.LastIndexOf("") + 1);
???????? //文件类型
???????? string fileType = fullfileName.Substring(fullfileName.LastIndexOf(".") + 1);
???????? if (this.fileUpload.PostedFile.FileName != null)
???????? {
???????????? if (fileType.ToLower() == "xml")
???????????? {
???????????????? DataSet ds = new DataSet();
???????????????? ds.ReadXml(fullfileName);

????????????????//调用webService中的方法.
???????????????? myService.getXml(ds);

???????????????? //成功后提示，代码省略
??????????????? }
???????????? else
???????????? {
???????????????? //失败后提示，代码省略??
????????????? }
???????? }
???????? else
???????? {
???????????? this.lblMessage.Text = "请选择你要上传的文件,谢谢!";
???????? }
?? }
你在站点上上传了一个dataset，所以webservice就要有一个方法来接收它，代码如下：
//================上传XML文件===================
???? [WebMethod]
???? public bool getXml(DataSet dataSet)
???? //public DataSet getXml(DataSet dataSet)
???? {
??????? //连接数据库，这里面随你怎么连接数据库，只要能连上就可以了。
????????DB db = new DB();
???????? SqlConnection con = db.sqlCon();
???????? con.Open();

???????? DataSet c_dataSet = new DataSet();
????????
???????? //将用户传过来的dataSet赋值给c_dataSet.
???????? c_dataSet = dataSet;
????????
???????? //这里调用了存储过程.
????????//读者只要将sp_MVP改为select * from MVP,其它的照例,不用存储管理的话把蓝色那行都删掉.
???????? SqlDataAdapter sda = new SqlDataAdapter("sp_MVP",con);
????????sda.SelectCommand.CommandType = CommandType.StoredProcedure;
???????? SqlCommandBuilder mysqlcommand = new SqlCommandBuilder(sda);
???????? sda.Update(c_dataSet,"MVP");

???????? SqlDataAdapter sda1 = new SqlDataAdapter("sp_OtherCompetencies",con);
????????sda1.SelectCommand.CommandType = CommandType.StoredProcedure;
???????? SqlCommandBuilder mysqlcommand1 = new SqlCommandBuilder(sda1);
???????? sda1.Update(c_dataSet,"OtherCompetencies");

???????? SqlDataAdapter sda2 = new SqlDataAdapter("sp_OtherCompetency",con);
????????sda2.SelectCommand.CommandType = CommandType.StoredProcedure;
???????? SqlCommandBuilder mysqlcommand2 = new SqlCommandBuilder(sda2);
???????? sda2.Update(c_dataSet,"OtherCompetency");

???????? SqlDataAdapter sda3 = new SqlDataAdapter("sp_Publications",con);
????????sda3.SelectCommand.CommandType = CommandType.StoredProcedure;
???????? SqlCommandBuilder mysqlcommand3 = new SqlCommandBuilder(sda3);
???????? sda3.Update(c_dataSet,"Publications");

???????? SqlDataAdapter sda4 = new SqlDataAdapter("sp_Publication",con);
????????sda4.SelectCommand.CommandType = CommandType.StoredProcedure;
???????? SqlCommandBuilder mysqlcommand4 = new SqlCommandBuilder(sda4);
???????? sda4.Update(c_dataSet,"Publication");

???????? //处理所以的请求(更新).
???????? c_dataSet.AcceptChanges();

???????? con.Close();
???????? return true;
??? }
首先要在webservice服务器建立数据库，有五张表MVP,OtherCompetencies......这里webservice要连接数据库了，这里是连接sql2005，o(∩_∩)o...哈哈，我相信这里连接数据库会让你很郁闷的，实在没辙了来找我,^_^
现在就可以试试效果了！当然不可以一下就能成功，多调试！

2：[查询功能]
查询是在webservice里面实现的，代码如下：
???? //=================用户查询=====================
???? [WebMethod]
???? //public DataSet searchData(string mvpguid,string fristname,string lastname)
???? public DataSet searchData(string mvpguid)
???? {
???????? //连接数据库
???????? DB dataBase = new DB();
???????? SqlConnection con = dataBase.sqlCon();
???????? con.Open();

???????? //用户查询得到的将是myDataSet.
???????? DataSet myDataSet = new DataSet();
???????? try
???????? {
???????????? SqlDataAdapter myAdapter = new SqlDataAdapter();

???????????? if (mvpguid != "")
???????????? {
???????????????? //按照用户输入的mvpguid进行查询.
???????????????? myAdapter.SelectCommand = new SqlCommand("select * from MVP where MVPGUID='"+mvpguid+"'",con);
???????????????? SqlCommandBuilder myCB = new SqlCommandBuilder(myAdapter);
???????????????? myAdapter.Fill(myDataSet,"MVP");

???????????????? //建立表间关系.
???????????????? SqlDataAdapter myAdapter1 = new SqlDataAdapter("select OtherCompetencies.OtherCompetencies_Id,OtherCompetencies.MVP_Id from MVP,OtherCompetencies where MVP.MVP_Id=OtherCompetencies.MVP_Id and MVP.MVPGUID='" + mvpguid + "'",con);
???????????????? SqlCommandBuilder myCB1 = new SqlCommandBuilder(myAdapter1);
???????????????? myAdapter1.Fill(myDataSet,"OtherCompetencies");

???????????????? SqlDataAdapter myAdapter2 = new SqlDataAdapter("select OtherCompetency.OtherCompetencies_Id,OtherCompetency.OtherCompetency_Text from MVP,OtherCompetencies,OtherCompetency where MVP.MVP_Id=OtherCompetencies.MVP_Id and OtherCompetencies.OtherCompetencies_Id=OtherCompetency.OtherCompetencies_Id and MVP.MVPGUID='" + mvpguid + "'",con);
???????????????? SqlCommandBuilder myCB2 = new SqlCommandBuilder(myAdapter2);
???????????????? myAdapter2.Fill(myDataSet,"OtherCompetency");

???????????????? SqlDataAdapter myAdapter3 = new SqlDataAdapter("select Publications.Publications_Id,Publications.MVP_Id from Publications,MVP where MVP.MVP_Id=Publications.MVP_Id and MVP.MVPGUID='" + mvpguid + "'",con);
???????????????? SqlCommandBuilder myCB3 = new SqlCommandBuilder(myAdapter3);
???????????????? myAdapter3.Fill(myDataSet,"Publications");

???????????????? SqlDataAdapter myAdapter4 = new SqlDataAdapter("select Publication.Publications_Id,Publication.Id,Publication.Title,Publication.Publisher,Publication.DatePublished,Publication.Abstract,Publication.UrlLink from MVP,Publications,Publication where MVP.MVP_Id=Publications.MVP_Id and Publications.Publications_Id=Publication.Publications_Id and MVP.MVPGUID='" + mvpguid + "'",con);
???????????????? SqlCommandBuilder myCB4 = new SqlCommandBuilder(myAdapter4);
???????????????? myAdapter4.Fill(myDataSet,"Publication");

???????????????? //Create DataRelation,and add it to the DataSet.
???????????????? DataRelation dr = new DataRelation("MVPToOtherCompetencies",myDataSet.Tables["MVP"].Columns["MVP_Id"],

myDataSet.Tables["OtherCompetencies"].Columns["MVP_Id"]);
???????????????? DataRelation dr1 = new DataRelation("OtherCompetenciesToOtherCompetency",myDataSet.Tables["OtherCompetencies"].Columns

["OtherCompetencies_Id"],myDataSet.Tables["OtherCompetency"].Columns["OtherCompetencies_Id"]);
???????????????? DataRelation dr2 = new DataRelation("MVPToPublications",myDataSet.Tables

["Publications"].Columns["MVP_Id"]);
???????????????? DataRelation dr3 = new DataRelation("PublicationsToPublication",myDataSet.Tables["Publications"].Columns["Publications_Id"],

myDataSet.Tables["Publication"].Columns["Publications_Id"]);
????????????????
???????????????? //获取或设置一个指示DataRelation对象是否嵌套的值.
???????????????? dr.Nested = true;
???????????????? dr1.Nested = true;
???????????????? dr2.Nested = true;
???????????????? dr3.Nested = true;
????????????????
???????????????? //创建关系到集合中
???????????????? myDataSet.Relations.Add(dr);
???????????????? myDataSet.Relations.Add(dr1);
???????????????? myDataSet.Relations.Add(dr2);
???????????????? myDataSet.Relations.Add(dr3);
???????????? }
???????? }
???????? catch (SqlException exception)
???????? {
???????????? return DataError(exception);
???????? }
???????? return myDataSet;
???? }
???? //====================错误信息=======================
???? public DataSet DataError(Exception ex)
???? {
???????? DataSet errDS = new DataSet("Errors");
???????? DataTable errTable = errDS.Tables.Add("Error");
???????? errTable.Columns.Add("Message");
???????? errTable.Rows.Add(new Object[] { ex.Message });
???????? return errDS;
???? }
代码有点多，呵呵，然后你在客户端只要引用它的接口就可以了，这样会更好理解一点，代码如下：
//====================客户端查询函数=====================
???? protected void btnSearch_Click1(object sender,EventArgs e)
???? {
???????? string c_mvpGuid = "";
????????try
???????? {
???????????? c_mvpGuid = this.txtByMVPGUID.Text.ToString();