在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>