如何将序列号添加到网格 [英] how to add serial number to grid

问题描述

Dim ds As DataSet = ocon.FillSPDataSet(myproc, param)

            Dim col As New DataColumn
            col.ColumnName = "SrNo"
            col.Caption = "Srno"
            ds.Tables(0).Columns.Add(col)
            For i = 0 To ds.Tables(0).Rows.Count - 1
                ds.Tables(0).Rows(i)("SrNo") = 1 + 1

            Next
            If Not ds.Tables(0).Rows.Count = 0 Then
                GridView1.DataSource = ds
                GridView1.DataBind()
            End If

< asp:gridview id ="GridView1" runat =服务器" cellpadding ="2" forecolor =#333333" gridlines ="None"
=" autogeneratecolumns ="False" autogenerateeletebutton ="false" horizo​​ntalalign ="Center" cssclass ="border">
< footerstyle backcolor =#5D7B9D" font-bold ="True" forecolor ="White">
<列>
< asp:templatefield headertext ="Sr.No" sortexpression ="ID" visible ="False">
< itemtemplate>
< asp:label id ="lblid" runat ="server" text =<％#Eval(" SrNo)％>">



< asp:templatefield headertext =注册号" sortexpression ="Inst_Name">
< itemtemplate>
< asp:label id ="lblInstName" runat ="server" text =<％#Eval(" Registration_Number)％>">



< asp:templatefield headertext ="Roll No" sortexpression ="ADMISSION YEAR">
< itemtemplate>
< asp:label id ="lblAyear" runat ="server" text =<％#Eval(" RollNo)％>">



< asp:templatefield headertext ="Name" sortexpression ="COURSE">
< itemtemplate>
< asp:label id ="lblcourse" runat ="server" text =<％#Eval(" Candidate_1stName)％>">



< asp:templatefield headertext =父亲姓名" sortexpression ="BRANCH">
< itemtemplate>
< asp:label id ="lblbranch" runat ="server" text =<％#Eval(" Father_Name)％>">



< asp:templatefield headertext ="DateofBirth" sortexpression ="NAME">
< itemtemplate>
< asp:label id ="lblname" runat ="server" text =<％#Eval(" DateofBirth)％>">



< asp:templatefield headertext =文凭％" sortexpression ="SEX">
< itemtemplate>
< asp:label id ="lblSex" runat ="server" text =<％#Eval(" Acadamic_Diploma_Percentage)％>">




< rowstyle backcolor =#F7F6F3" forecolor =#333333">
< editrowstyle backcolor =#999999">
< selectedrowstyle backcolor =#E2DED6" font-bold ="True" forecolor =#333333">
< pagerstyle backcolor =#284775" forecolor ="White" horizo​​ntalalign ="Center">
< headerstyle backcolor =#5D7B9D" font-bold ="True" forecolor ="White">
< alternatingrowstyle backcolor ="White" forecolor =#284775">

<asp:gridview id="GridView1" runat="server" cellpadding="2" forecolor="#333333" gridlines="None"
="" autogeneratecolumns="False" autogeneratedeletebutton="false" horizontalalign="Center" cssclass="border">
<footerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<columns>
<asp:templatefield headertext=" Sr.No" sortexpression=" ID" visible="False">
<itemtemplate>
<asp:label id="lblid" runat="server" text="<%# Eval("SrNo") %>">



<asp:templatefield headertext="Registration Number" sortexpression="Inst_Name">
<itemtemplate>
<asp:label id="lblInstName" runat="server" text="<%# Eval("Registration_Number") %>">



<asp:templatefield headertext="Roll No" sortexpression="ADMISSION YEAR">
<itemtemplate>
<asp:label id="lblAyear" runat="server" text="<%# Eval("RollNo") %>">



<asp:templatefield headertext="Name" sortexpression="COURSE">
<itemtemplate>
<asp:label id="lblcourse" runat="server" text="<%# Eval("Candidate_1stName") %>">



<asp:templatefield headertext="Father Name" sortexpression="BRANCH">
<itemtemplate>
<asp:label id="lblbranch" runat="server" text="<%# Eval("Father_Name") %>">



<asp:templatefield headertext="DateofBirth" sortexpression="NAME">
<itemtemplate>
<asp:label id="lblname" runat="server" text="<%# Eval("DateofBirth") %>">



<asp:templatefield headertext="Diploma %" sortexpression="SEX">
<itemtemplate>
<asp:label id="lblSex" runat="server" text="<%# Eval("Acadamic_Diploma_Percentage") %>">




<rowstyle backcolor="#F7F6F3" forecolor="#333333">
<editrowstyle backcolor="#999999">
<selectedrowstyle backcolor="#E2DED6" font-bold="True" forecolor="#333333">
<pagerstyle backcolor="#284775" forecolor="White" horizontalalign="Center">
<headerstyle backcolor="#5D7B9D" font-bold="True" forecolor="White">
<alternatingrowstyle backcolor="White" forecolor="#284775">

推荐答案

Dim ds As New DataSet
        Dim adp As New SqlDataAdapter("Select * from admusermaster", con)
        adp.Fill(ds)
        Dim col As New DataColumn
        col.ColumnName = "SerialNumber"
        ds.Tables(0).Columns.Add(col)
        'ds.Tables(0).Columns.
        For i As Integer = 0 To ds.Tables(0).Rows.Count - 1
            ds.Tables(0).Rows(i)("SerialNumber") = i + 1
        Next
        ds.Tables(0).Columns("SerialNumber").SetOrdinal(0)
        GridView1.DataSource = ds.Tables(0)
        GridView1.DataBind()

ds.Tables(0).Rows(i)("SrNo") = i + 1

这应该可以解决问题.

This should do the trick.

这就是您想要的.简单，容易和轻便.只需使用此代码，就可以完成它........它也可以在分页中工作...
< pre>
< asp:TemplateField>
< HeaderTemplate>
序列号</HeaderTemplate>
< ItemTemplate>
< asp:标签ID ="lblSRNO" runat =服务器"
Text =''<％#Container.DataItemIndex + 1％>''>
</asp:标签>
</ItemTemplate>
</asp:TemplateField>
</pre>
你可以问我任何问题，我会尽力的....

完成后告诉我....

快乐的编码
< code> adsfadsf</code>

This is what you are looking for. Simple, easy and lightweight . Just use this code and you will get it done just like that........ and it will work in paging also...
<pre>
<asp:TemplateField>
<HeaderTemplate>
Serial No.</HeaderTemplate>
<ItemTemplate>
<asp:Label ID="lblSRNO" runat="server"
Text=''<%#Container.DataItemIndex+1 %>''>
</asp:Label>
</ItemTemplate>
</asp:TemplateField>
</pre>
you can ask me any questions i will try my hand on that....

tell me after you done....

happy coding
<code>adsfadsf</code>

这篇关于如何将序列号添加到网格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！