c#下调用webservice在客户端利用datagrid本身功能分页

最新推荐文章于 2021-02-28 03:03:48 发布

wthorse

最新推荐文章于 2021-02-28 03:03:48 发布

阅读量1.4k

点赞数

分类专栏： c# 文章标签： datagrid webservice c# dataset object string

本文链接：https://blog.csdn.net/wthorse/article/details/671585

版权

c# 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

服务器端：

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>