一、相关表格构
* 创建username表并插入一些数据
create table userinfo(用户名 c(10),密码 c(10),年龄 i)
insert into userinfo values('胡书宾','1234576',24)
insert into userinfo values('费青春','7777333',25)
insert into userinfo values('孙守用','8887333',26)
insert into userinfo values('彥丙良','8887766',24)
insert into userinfo values('闵小波','8287766',25)
insert into userinfo values('张忠文','8288822',24)
insert into userinfo values('代方明','8282232',23)
* 将userinfo转换成xml 512+16为gb2312编码
cursortoxml("userinfo","userinfo.xml",1,512 + 16,0,"userinfo.xsd")
* 将xml转换临时表会发现字段宽度和类型均未改变
xmltocursor("userinfo.xml","userinfo_",512+16)
--在SQL Server中删除原表重新创建userinfo
drop table userinfo
create table userinfo (用户名 char(10) primary key,密码 char(10) not null,年龄 int)
insert into userinfo values('潘万飞','123234',18)
二、Web Service代码
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
[WebService(Namespace = "http://tempuri.org/")]