<StackPanel Orientation="Vertical">        
            <data:DataGrid x:Name="dataGrid"  HorizontalAlignment="Stretch" VerticalAlignment="Top" Margin="4"   AutoGenerateColumns="False" HeadersVisibility="Column" GridLinesVisibility="Horizontal" RowBackground="Cornsilk" AlternatingRowBackground="LemonChiffon" RowHeight="30" IsReadOnly="True" CanUserResizeColumns="False">
                <data:DataGrid.Columns>
                    <data:DataGridTextColumn Header="标题"  Binding="{Binding Title}"  Width="350" ></data:DataGridTextColumn>
                    <data:DataGridTextColumn Header="作者" Binding="{Binding Author}" Width="150" ></data:DataGridTextColumn>   
                </data:DataGrid.Columns>
            </data:DataGrid>
        <data:DataPager x:Name="datapager1" Height="24" Margin="8,0,8,40" VerticalAlignment="Bottom" Background="#FFD7E2EE" FontSize="13.333" Width="304" PageIndexChanged="datapager1_PageIndexChanged"/></StackPanel>

 int PageSize = 10;//设定分页大小
        List<int> itemCount = new List<int>();//用于DataPager的数据提供
        public DataBaseOperate()
        {
            InitializeComponent();
        }private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            BlogServiceSoapClient webClient = new BlogServiceSoapClient();            
            webClient.GetsimpleListAsync("",PageSize, 1);
            webClient.GetsimpleListCompleted+=new EventHandler<GetsimpleListCompletedEventArgs>(webClient_GetsimpleListCompleted);
            GeneralDataPagerContent();//生成DataPager的数据提供
        }
        void webClient_GetsimpleListCompleted(object sender, GetsimpleListCompletedEventArgs e)
        {
            if (e.Error == null)
            {
                dataGrid.ItemsSource = e.Result;
            }
        }
        void GeneralDataPagerContent()
        {
            BlogServiceSoapClient webClient = new BlogServiceSoapClient();
            webClient.GetTotalPagersAsync("",PageSize);
            webClient.GetTotalPagersCompleted +=
            new EventHandler<GetTotalPagersCompletedEventArgs>(webClient_GetTotalPagersCompleted);
        }
        void webClient_GetTotalPagersCompleted(object sender, GetTotalPagersCompletedEventArgs e)
        {
            int totalpagers = e.Result;
            for (int i = 1; i <= totalpagers; i++) itemCount.Add(i);
            PagedCollectionView pcv = new PagedCollectionView(itemCount);
            pcv.PageSize = 1;
            datapager1.Source = pcv;

        }

 [WebMethod]
        public List<m_article> GetsimpleList(string strWhere, int PageSize, int CurrentPage)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  ");
            if (PageSize != 0)
                strSql.Append(" top " + PageSize);
            strSql.Append("  * ");
            strSql.Append(" from  (");
            strSql.Append(" SELECT ROW_NUMBER() OVER (ORDER BY publishdate desc) AS RowNo, ");

            strSql.Append(