得到的是
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://127.0.0.1:10001">
<string>铅笔</string>
<string>13</string>
<string>钢笔</string>
<string>3</string>
<string>A4纸</string>
<string>3</string>
</ArrayOfString>
我想要的是每一组数据都是序号,每一组里面要是分类。如第一组物料名称是铅笔,数量是13.有标记组别、有分类,以便后面提取数据。下面是我在网上找的示例。
下面是webserver 方法:
public class DBOperation:IDisposable
{
public static SqlConnection sqlCon; //用于连接数据库
//将下面的引号之间的内容换成上面记录下的属性中的连接字符串
//dfasdlfasdfsad
private String ConServerStr = @"Data Source=127.0.0.1;Initial Catalog=Data1; User ID=sa;Password=sa";
//默认构造函数
public DBOperation()
{
if (sqlCon == null)
{
sqlCon = new SqlConnection();
sqlCon.ConnectionString = ConServerStr;
sqlCon.Open();
}
}
//关闭/销毁函数,相当于Close()
public void Dispose()
{
if (sqlCon != null)
{
sqlCon.Close();
sqlCon = null;
}
}
/// <summary>
/// 获取所有货物的信息
/// </summary>
/// <returns>所有货物信息</returns>
public List<string> selectAllCargoInfor()
{
List<string> list = new List<string>();
try
{
string sql = "select ProdDesc,Stock from StockMange where Stock>0";
SqlCommand cmd = new SqlCommand(sql,sqlCon);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
//将结果集信息添加到返回向量中
list.Add(reader[0].ToString());
list.Add(reader[1].ToString());
}
reader.Close();
cmd.Dispose();
}
catch(Exception)
{
}
return list;
}
}
}
下面是调用:
public class Service1 : System.Web.Services.WebService
{
DBOperation dbOperation = new DBOperation();
[WebMethod]
[WebMethod(Description = "获取所有货物的信息")]
public string[] selectAllCargoInfor()
{
return dbOperation.selectAllCargoInfor().ToArray();
}
------解决思路----------------------
public Product() 就是 无参数的构造函数