<Window x:Class="Ch12Sample_03.Window4"        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"        Title="Window4" Height="307" Width="454" FontSize="14" >    <Grid>        <DataGrid AutoGenerateColumns="False" Height="148" HorizontalAlignment="Left" Margin="27,21,0,0" Name="dataGrid1" VerticalAlignment="Top" Width="380" IsReadOnly="True" CanUserAddRows="False" VerticalScrollBarVisibility="Auto" SelectionMode="Single"  EnableRowVirtualization="False">            <DataGrid.Columns>                <DataGridTextColumn Header="编号" Binding="{Binding Path=title_id}" />                <DataGridTextColumn Header="书名" Binding="{Binding Path=title}" />                <DataGridTextColumn Header="价格" Binding="{Binding Path=price}" />            </DataGrid.Columns>        </DataGrid>        <Button Content="上一页" Height="23" HorizontalAlignment="Left" Margin="37,185,0,0" Name="button7" VerticalAlignment="Top" Width="65" Click="button7_Click" />        <Button Content="下一页" Height="23" HorizontalAlignment="Left" Margin="108,185,0,0" Name="button8" VerticalAlignment="Top" Width="59" Click="button8_Click" />        <Label Content="转到" Height="28" HorizontalAlignment="Left" Margin="173,186,0,0" Name="label6" VerticalAlignment="Top" />        <TextBox Height="23" HorizontalAlignment="Left" Margin="212,187,0,0" Name="textBox1" VerticalAlignment="Top" Width="53" />        <Button Content="GO" Height="23" HorizontalAlignment="Left" Margin="298,185,0,0" Name="button9" VerticalAlignment="Top" Width="96" Click="button9_Click" />        <Label Content="页" Height="28" HorizontalAlignment="Left" Margin="269,185,0,0" Name="label7" VerticalAlignment="Top" />        <Label Height="28" HorizontalAlignment="Left" Margin="120,228,0,0" Name="label8" VerticalAlignment="Top" Content="【第" />        <Label Content="1" Height="28" HorizontalAlignment="Left" Margin="157,228,0,0" Name="label1" VerticalAlignment="Top" />        <Label Content="页】" Height="28" HorizontalAlignment="Left" Margin="176,228,0,0" Name="label10" VerticalAlignment="Top" />        <Label Content="【共" Height="28" HorizontalAlignment="Left" Margin="242,228,0,0" Name="label11" VerticalAlignment="Top" />        <Label Content="1" Height="28" HorizontalAlignment="Left" Margin="280,228,0,0" Name="label2" VerticalAlignment="Top" />        <Label Content="页】" Height="28" HorizontalAlignment="Left" Margin="298,228,0,0" Name="label13" VerticalAlignment="Top" />    </Grid></Window>

namespace Ch12Sample_03{    /// <summary>    /// MainWindow.xaml 的交互逻辑    /// </summary>    public partial class Window4 : Window    {        public Window4()        {            InitializeComponent();            DataGridBind(Convert.ToInt32(label1.Content));            //label11.Content的初值为1，即显示第1页        }        //每页显示5条记录        public const int pageSize = 5;        private void DataGridBind(int pageIndex)        {            //pageIndex 当前页的序号            int recordsum=0;   //表中记录总数            int PageSum=0;     //总页数                                 PubsDataContext pubs = new PubsDataContext();            var query = from title in pubs.titles                        select title;            recordsum = query.Count();            //判断总页数            if (recordsum % pageSize == 0)                PageSum = recordsum / pageSize;            else                PageSum = recordsum / pageSize + 1;            dataGrid1.ItemsSource = query.Skip((pageIndex - 1) * pageSize).Take(pageSize);            label1.Content = Convert.ToString(pageIndex);            label2.Content = Convert.ToString(PageSum);        }        private void button7_Click(object sender, RoutedEventArgs e)        {            //上一页            if (Convert.ToInt32(label1.Content) > 1)                DataGridBind(Convert.ToInt32(label1.Content)-1);        }        private void button8_Click(object sender, RoutedEventArgs e)        {            //下一页            if (Convert.ToInt32(label1.Content) < Convert.ToInt32(label2.Content))                DataGridBind(Convert.ToInt32(label1.Content) + 1);        }        private void button9_Click(object sender, RoutedEventArgs e)        {            //调转到第n页            if(Convert.ToInt32(textBox1.Text)>=1 && Convert.ToInt32(textBox1.Text)<=Convert.ToInt32(label2.Content))                DataGridBind(Convert.ToInt32(textBox1.Text));                    }    }}