学步园

服务器端：

public DataSet selectuserpwd(string exec)
  {
   this.sqlConnection1.Open();
   this.sqlDataAdapter1.SelectCommand.CommandText=exec;
   DataSet ds1=new DataSet();
   this.sqlDataAdapter1.Fill(ds1,"userpwd");

  return ds1

}

客户端：

mbi=new TableWebApplication1.localhost.Service1();
   mbi.Credentials=System.Net.CredentialCache.DefaultCredentials;
   ds=new DataSet();
   ds=mbi.selectuserpwd("select * from userpwd");
   this.DataGrid1.DataSource=ds;
   this.DataGrid1.DataBind();
   this.DataGrid1.PageIndexChanged+=new DataGridPageChangedEventHandler(DataGrid1_PageIndexChanged);

private void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
  {
   this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
   this.DataGrid1.DataBind();
  }

客户端页面的html：

<asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 200px; POSITION: absolute; TOP: 72px" runat="server" Width="376px" Height="184px" PageSize="3" AllowSorting="True" AllowPaging="True" AutoGenerateColumns=False>

?Columns>
     ?asp:BoundColumn DataField="name" HeaderText="姓名"></asp:BoundColumn>
     ?asp:BoundColumn DataField="address"  HeaderText="地址"></asp:BoundColumn>
     ?asp:BoundColumn DataField="tel"  HeaderText="电话"></asp:BoundColumn>
     ?/Columns>

</asp:DataGrid>