如何在标签上显示转发器的总记录 [英] How to display total records of repeater on a label

问题描述

我正在使用转发器在sql数据库的页面中显示记录，我想在转发器顶部的标签上显示我从数据库中取出的记录总数。这样用户就可以看到他有这么多的记录。下面是我绑定转发器数据的代码。

  protected   void  BindRepeaterData（）
 {
 con.Open（）; 
的SqlCommand CMD = <跨度类= 代码关键字>新的SqlCommand（<跨度类= 代码串>  <跨度类= 代码串> sps_searchresult ，con）; 
 cmd.CommandType = CommandType.StoredProcedure; 
 cmd.Parameters.AddWithValue（  @ country， 1 ）; 
 cmd.Parameters.AddWithValue（  @ state，state）; 
 cmd.Parameters.AddWithValue（  @ pincode，pincode）; 
 cmd.Parameters.AddWithValue（  @ category，category）; 
 cmd.Parameters.AddWithValue（  @ subcategory，subcategory）; 
 con.Close（）; 
 
  //  将结果保存在数据表中 
 DataTable dt =  new  DataTable（）; 
 SqlDataAdapter adp =  new  SqlDataAdapter（cmd）; 
 adp.Fill（dt）; 
 PagedDataSource pgitems =  new  PagedDataSource（）; 
 DataView dv =  new  DataView（dt）; 
 pgitems.DataSource = dv; 
 pgitems.AllowPaging =  true ; 
 pgitems.PageSize =  5 ; 
 pgitems.CurrentPageIndex = PageNumber; 
  if （pgitems.PageCount >   1 ）
 {
 rptPaging.Visible =  true ; 
 ArrayList pages =  new  ArrayList（）; 
  for （ int  i =  0 ; i <  pgitems.PageCount; i ++）
 pages.Add（（i +  1 ）的ToString（））; 
 rptPaging.DataSource = pages; 
 rptPaging.DataBind（）; 
} 
  else  
 {
 rptPaging.Visible =  false ; 
} 
 rep_results.DataSource = pgitems; 
 rep_results.DataBind（）; 
 
  //  更改文本现在查看文本 
 lblCurrentPage。 Text =   Page： +（PageNumber +  1 ）。ToString（）+   of + pgitems.PageCount.ToString（）; 
} 

解决方案

您可以从 DataTable 本身获取计数by ...

  int  noOfRows = dt.Rows.Count; 

I am using repeater to display records in a page from sql database, I want to display total number of records i am fetching from database on a label at the top of repeater. So that user can see he has this number of records. Below is my code to bind repeater data.

protected void BindRepeaterData()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("sps_searchresult", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@country", 1);
        cmd.Parameters.AddWithValue("@state", state);
        cmd.Parameters.AddWithValue("@pincode", pincode);
        cmd.Parameters.AddWithValue("@category", category);
        cmd.Parameters.AddWithValue("@subcategory", subcategory);
        con.Close();
        
        //save the result in data table
        DataTable dt = new DataTable();
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        adp.Fill(dt);
        PagedDataSource pgitems = new PagedDataSource();
        DataView dv = new DataView(dt);
        pgitems.DataSource = dv;
        pgitems.AllowPaging = true;
        pgitems.PageSize = 5;
        pgitems.CurrentPageIndex = PageNumber;
        if (pgitems.PageCount > 1)
        {
            rptPaging.Visible = true;
            ArrayList pages = new ArrayList();
            for (int i = 0; i < pgitems.PageCount; i++)
                pages.Add((i + 1).ToString());
            rptPaging.DataSource = pages;
            rptPaging.DataBind();
        }
        else
        {
            rptPaging.Visible = false;
        }
        rep_results.DataSource = pgitems;
        rep_results.DataBind();

        //Change the text Now viewing text
        lblCurrentPage.Text = "Page : " + (PageNumber + 1).ToString() + " of " + pgitems.PageCount.ToString();
    }

解决方案

You can get the count from DataTable itself by...

int noOfRows = dt.Rows.Count;

这篇关于如何在标签上显示转发器的总记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！