Silverlight调用WebService

在silverlight中调用webservice实现从数据库读取数据源并绑定datagrid控件

步骤一：向webservice所在的项目根目录添加2个xml文件clientaccesspolicy.xml和crossdomain.xml

clientaccesspolicy.xml文件内容:

<?xml version="1.0" encoding="utf-8"?>
<access-policy>
  <cross-domain-access>
    <policy>
      <allow-from http-request-headers="*">
        <domain uri="*"/>  <!--此处也可以填写silverlight的url-->
      </allow-from>
      <grant-to>
        <resource path="/" include-subpaths="true"/>
      </grant-to>
    </policy>
  </cross-domain-access>
</access-policy>
crossdomain.xml文件内容：

<?xml version="1.0" encoding="utf-8" ?>
<cross-domain-policy>
  <allow-access-from domain="*" /> <!--此处也可以填写silverlight的url-->
</cross-domain-policy>
步骤二：新建webservice文件，编写获取产品列表的方法

       /// <summary>
        /// 功能描述：得到产品列表
        /// </summary>
        /// <returns></returns>
        [WebMethod]
        public List<Product> GetProductList()
        {
            List<Product> oo_ProductList = new List<Product>();
            string ss_Sql="SELECT * FROM Products";
            using (SqlConnection sqlCon=new SqlConnection(DataBase.ss_Constr))
            {
                sqlCon.Open();
                using (SqlCommand sqlCmd=new SqlCommand(ss_Sql,sqlCon))
                {
                    SqlDataReader dr = sqlCmd.ExecuteReader(CommandBehavior.CloseConnection);
                    while (dr.Read())
                    {
                        Product oo_Product = new Product();
                        oo_Product.ProductID = Convert.ToInt32(dr["ProductID"]);
                        oo_Product.ProductName = dr["ProductName"].ToString();
                        oo_Product.UnitPrice = Convert.ToDecimal(dr["UnitPrice"]);
                        oo_ProductList.Add(oo_Product);
                    }
                    return oo_ProductList;
                }

            }

        }

步骤三：设置webservice所在项目的端口为指定端口

右击项目，选择属性>web

 

步骤四：给Silverlight所在的项目添加web引用

步骤五：Silverlight页面调用webservice方法

.xaml.cs 代码：

        private void LayoutRoot_Loaded(object sender, RoutedEventArgs e)
        {
            WebServiceForSLSoapClient oo_WebServiceForSLSoapClient = new WebServiceForSLSoapClient();
            oo_WebServiceForSLSoapClient.GetProductListCompleted += new EventHandler<GetProductListCompletedEventArgs>(OnGetBooksCompleted);
            oo_WebServiceForSLSoapClient.GetProductListAsync();

        }

        private void OnGetBooksCompleted(object server, GetProductListCompletedEventArgs e)
        {
            //调用是否成功
            if (e.Error!=null)
            {
                return;
            }
            this.dgProduct.ItemsSource = e.Result;

        }

.xaml 代码：

    <Grid x:Name="LayoutRoot" Loaded="LayoutRoot_Loaded">
<data:DataGrid x:Name="dgProduct" AutoGenerateColumns="True"></data:DataGrid>
    </Grid>