Auto Sequence Number in Grid Control with Paging

- 

we are going to see how to generate sequence number (row number) in DataGrid.
To generate sequence number, we will use the DataGridItem’s ItemIndex property. 

But For example if we are  going to second page with Pagesize 3, then sequence
number  should start from 4. Code snippet for implementing this method is... 

<asp:DataGrid id="DataGrid1" runat="server" PagerStyle-Mode="NumericPages"   
PageSize="10" AutoGenerateColumns="False" AllowPaging="True">
      <Columns>
           <asp:templatecolumn headertext="Row Number">       
                  <itemtemplate>                   
                        <%# (DataGrid1.PageSize*DataGrid1.CurrentPageIndex)+ Container.ItemIndex+1%>
                 </itemtemplate>                 
            </asp:templatecolumn>           
            <asp:boundcolumn   runat="server" DataField="CompanyName" HeaderText="Company Name">                    
            </asp:boundcolumn>                   
            <asp:boundcolumn runat="server" DataField="Address" HeaderText="Address">           
             </asp:boundcolumn>         
    </Columns>
</asp:DataGrid>

Sample code as such is very simple, we will create one extra template column in
our DataGrid and bind to it the value of Container.ItemIndex. The itemindex 
property is zero based so we will add one to it to start from one.

The code is very simple, instead of only using container.itemindex to get the 
sequence number. You need to use Pagesize and currentpageindex to find out the 
starting number of that page and then add container.itemindex to that. 
So we have sequence number in DataGrid. DataGrid will look like this,


Number   Name         Address
------------------------------
  1      Ashvin       Bombay
  2      Kamlesh S    Delhi
  3      Hiren        Pune
------------------------------
Paging : 1 2 3 4 5
------------------------------

Note: you can also get this result from SQL Query, follow this query to get auto number column in Result.


select  
    ROW_NUMBER() OVER(ORDER BY Associate DESC) AS 'Number',
    Name,
    Address 
from dbo.Contact 



Result for this Query 
---------------------

Number   Name         Address
------------------------------
  1      Ashvin       Bombay
  2      Kamlesh S    Delhi
  3      Hiren        Pune

Comments

Kamal said…
Thanks your post is very helpful
December 8, 2009 at 3:05 AM
Post a Comment

Popular posts from this blog

Print Function By JavaScript

-
function PrintContent( Obj) { PrintWin=window.open('','PrintWin','directories=no, location=no, menubar=no, resizable=no, status=no, toolbar=no, scrollbars=no, width=10, height=10, left=1050, top=800'); PrintWin.document.write(" "); PrintWin.document.write(document.getElementById(Obj.id).outerHTML); PrintWin.location.reload(); PrintWin.print(); PrintWin.close(); } /************* Function call ***************/ btnPrint.Attributes.Add( "OnClick", "PrintContent(" + TblPrint.ClientID + ");");
Read more

Page Life Cycle in ASP.NET

-
Image
Life cycle when the page processed during a postback The events associated with the relevant page cycle phases are: Page Initialization: Page_Init View State Loading:LoadViewState Postback data processing: LoadPostData Page Loading: Page_Load PostBack Change Notification: RaisePostDataChangedEvent PostBack Event Handling: RaisePostBackEvent Page Pre Rendering Phase: Page_PreRender View State Saving: SaveViewState Page Rendering: Page_Render Page Unloading: Page_UnLoad The processing sequence in which a page is processed during a postback event is: Initializing: During this phase, the server creates an instance of the server control Loading view state: During this phase, the view state of the control posted by the client is reloaded into the new instance of the control. Loading : During this phase, the instance of the control is loaded onto the page object in which it is defined. Loading the postback data : During this phase, the server s...
Read more

SQL Server 2005 with XML Parameters

-
We frequently have requirement like Passing IDs in comma saperated value to the sql server for further processing. Generally what we do is just create loop and get the value from it and ... But SQL 2005 comes up with XQuery. Using this you can easly pass such type of data also some complex thing too. For example... DECLARE @productIds xml SET @productIds ='<Products><id>9</id><id>18</id><id>27</id></Products>' SELECT ParamValues.ID.value ('.','VARCHAR(20)')FROM @productIds.nodes('/Products/id')as ParamValues(ID) Which gives us the following three rows: 9 18 27
Read more

Variable Value in Top Statement

-
i want create a Procedure that behave like this: declare @cnt int set @cnt =10 select top @cnt * from sw_user Where sw_user contains 20 records, and i want the variable to be the criteria of Top statement. so i can use this for a solution for this type of problem CREATE PROC Top10 @cnt int AS SET ROWCOUNT @cnt SELECT * FROM sw_user but some cases ROWCOUNT might not be work... so what, Note : This statement however is possible in SQL 2005, just add "()" in your variable like so: declare @cnt int set @cnt =10 select top (@cnt) * from sw_user
Read more

Paged Data Source - Custom Paging

-
PagedDataSource , is a class that encapsulates the paging related properties for data-bound controls such as DataGrid, GridView, DataList, DetailsView and FormView that allow it to perform paging. And this article is going to combine both DataList control and PagedDataSource class to explain dynamic or custom paging methods for Asp.Net developers. protected void Page_Load( object sender, EventArgs e) { try { if (!IsPostBack) { LoadPhoto(); } } catch (Exception Exc) { HandleException = Exc; } } // LoadPhoto Function private void LoadPhoto() { PagedDataSource objPhotoPage = new PagedDataSource(); objPhotoPage.AllowPaging = true ; SOBLImageGallery _SOBLImageGallery = new SOBLImageGallery(); DataSet dsImageGallery = _SOBLImageGallery.Select6Records( new SOENTImageGallery()); if (dsImageGallery != null && dsImageGallery.Tables.Count > 0 && dsImageGallery.Tables[0]....
Read more

Email Validation by Javascript

-
function EmailCheck() { var reg = /^([A-Za-z0-9_\-\.])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/; var str =document.getElementById(' ').value; if(reg.test(str) == false) { alert('Invalid Email Address'); document.getElementById(' ').focus(); } }
Read more

LINQ - C# Programming

-
Get DataSource In C# as in most programming languages a variable must be declared before it can be used. In a LINQ query, the from clause comes first in order to introduce the data source (customers) and the range variable (cust). //QEmp is an IEnumerable var QEmp = from e in Emp select e; Filter Probably the most common query operation is to apply a filter in the form of a Boolean expression. The filter causes the query to return only those elements for which the expression is true. The result is produced by using the where clause. The filter in effect specifies which elements to exclude from the source sequence. var QEmp = from e in Emp where e.Country == "India" select e ----AND Condition---- where e.Country == "India" && e.Name == "Ashvin" ----OR Condition---- where e.Country == "India" || e.Name == "Ashvin" Ordering The orderby clause will cause the elements in the...
Read more

Abstract Class and An Interface

-
Abstract Class : The class which cannot be instantiated is known as an Abstract Class . So an object of it cannot be created. Hence it must be inherited. Can't be instantiated. Must be inherited. It may have Concrete Methods & Abstract Methods. An Abstract Class can have only Abstract Method. An Abstract Method must be overridden.     public abstract class AbstractA     {         public abstract string AbstractProperty { get ; set ; }         public abstract void AbstractFunction1();         public virtual void AbstractFunction2()         {             Console .WriteLine( "AbstractA : AbstractFunction2()" );         }         public void AbstractFunct...
Read more