Silverlight边学边写之一“Silverlight+Webservice+Dataset”综合应用

本文链接：https://blog.youkuaiyun.com/jake_jrc/article/details/3989574

学SL有一段时间了，可是总感觉缺少点什么，那就是实际应用，怎么能把SL应用到我的项目中呢？一直是一个难题，我是个懒人喜欢用Dataset来帮我做一些底层数据访问的工作，SL毕竟是表示层的技术，对数据访问是门外汉，只能用过wcf或webservice来实现异步调用，今天把我的学习笔记给大家看看，没有太高深的技术，只是共享而已，大家如果有别的方法欢迎指教！

新建一个Silverlight应用程序，再选择web应用程序

在webapplication中添加一个数据集（Dataset），我用的是“NORTHWND.MDF”大家可以去ms网站去下载。

在查询里面添加一个

SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax FROM Customers WHERE (City LIKE '%' + @City + '%')

新建一个“CustomersClass.cs” 实体类

public class CustomersClass
    {

        public string CustomerID { get; set; }

        public string CompanyName { get; set; }

        public string ContactName { get; set; }

        public string ContactTitle { get; set; }

        public string Address { get; set; }

        public string City { get; set; }

    }

为了操作方便，我只选择其中几个字段内容，大家有需要可以自己添加；

下面开始添加webservice，这个是重点：

public class SLWebService : System.Web.Services.WebService
    {

        //实例化Dataset

        SLDataSetTableAdapters.CustomersTableAdapter Dal =

new SilverlightCnblogs.Web.SLDataSetTableAdapters.CustomersTableAdapter();
         
        [WebMethod]
        public CustomersClass[] GetCustomersByCity(string City)
        {
            List<CustomersClass> CustomersC = new List<CustomersClass>();
            SLDataSet.CustomersDataTable DT = new SLDataSet.CustomersDataTable();

            DT = Dal.GetDataByCity(City);

            //foreach循环将dataset中数据取出
            foreach (SLDataSet.CustomersRow DD in DT.Rows)
            {
                CustomersClass CC = new CustomersClass();

                CC.Address = DD.Address.ToString();

                CC.City = DD.City.ToString();

                CC.CompanyName = DD.CompanyName.ToString();

                CC.ContactName = DD.ContactName.ToString();

                CC.ContactTitle = DD.ContactTitle.ToString();

                CC.CustomerID = DD.CustomerID.ToString();

                CustomersC.Add(CC);

            }

            System.Threading.Thread.Sleep(2000);  //延时一下为了看效果

            return CustomersC.ToArray();
        }

        [WebMethod]  
        public string HelloWorld()
        {
            return "Hello World";
        }

    }

最后别忘了把动态端口改成固定的！！

下面我来Silverlight，添加“服务引用”“发现”，这些大家都很熟了，不详细说了！

在Page.xaml文件中添加

<Grid x:Name="LayoutRoot" Background="White">
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width="*"/>
        </Grid.ColumnDefinitions>

        <StackPanel Height="Auto" Margin="0,13,0,0" VerticalAlignment="Top" Orientation="Horizontal"

HorizontalAlignment="Right" Width="385">
            <TextBlock Height="21" Width="27" Text="City:" TextWrapping="Wrap" d:LayoutOverrides="Width, Height"

HorizontalAlignment="Center" VerticalAlignment="Center" Margin="0,0,20,0"/>
            <TextBox x:Name="CityText" Height="21" Width="86" Text="" TextWrapping="Wrap"

HorizontalAlignment="Stretch" VerticalAlignment="Center" Margin="0,0,22,0"/>
            <Button x:Name="Seach"  Height="Auto" HorizontalAlignment="Right" Margin="0,0,14,0"

VerticalAlignment="Center" Width="95" Content=" Seach" Click="Seach_Click"/>
            <ProgressBar x:Name="PBar" Height="13" Width="108" IsIndeterminate="True" Visibility="Collapsed"/>
        </StackPanel>
        <data:DataGrid  x:Name="DataGrid" HorizontalAlignment="Stretch" AutoGenerateColumns="False"

Margin="8,49,8,20" Width="Auto" IsReadOnly="True">
            <data:DataGrid.Columns  >
                <data:DataGridTextColumn Header="CustomerID" Width="auto"  Binding="{Binding CustomerID}">

</data:DataGridTextColumn>
                <data:DataGridTextColumn Header="CompanyName" Width="auto" Binding="{Binding CompanyName}">

</data:DataGridTextColumn>
                <data:DataGridTextColumn Header="ContactName" Width="auto" Binding="{Binding ContactName}">

</data:DataGridTextColumn>
                <data:DataGridTextColumn Header="ContactTitle" Width="auto" Binding="{Binding ContactTitle}">

</data:DataGridTextColumn>
                <data:DataGridTextColumn Header="Address" Width="auto" Binding="{Binding Address}">

</data:DataGridTextColumn>
                <data:DataGridTextColumn Header="City" Width="auto" Binding="{Binding City}">

</data:DataGridTextColumn>
            </data:DataGrid.Columns>
        </data:DataGrid>

    </Grid>

编写C#代码：

        private void Seach_Click(object sender, RoutedEventArgs e)
        {
            this.Seach.IsEnabled = false;
            this.PBar.Visibility = Visibility.Visible;//显示进度条
            this.DataGrid.Opacity = 0.5;   //修改透明度
            //异步调用
            SC.GetCustomersByCityAsync(this.CityText.Text.ToString());
            SC.GetCustomersByCityCompleted +=

new EventHandler<SilverlightCnblogs.ServiceReference1.GetCustomersByCityCompletedEventArgs>(SC_GetCustomersByCityCompleted);
        }

        void SC_GetCustomersByCityCompleted(object sender, SilverlightCnblogs.ServiceReference1.GetCustomersByCityCompletedEventArgs e)
        {   //异步调用完毕
              this.DataGrid.ItemsSource = e.Result;
            this.Seach.IsEnabled = true;
            this.PBar.Visibility = Visibility.Collapsed;
            this.DataGrid.Opacity = 1;
        }

现存问题:当用"DataGrid"是,不知道怎么控制

字体及对齐,请高手指教
源代码下载