Asp.net.vb gridview manuel ID column

Question

1.00/5 (2 votes)

See more:

merhaba
asp.net vb yaptığım projemde SqlDataSource1 ile verileri gridview' de son 10 kayıt ID sıralaması ile gösteriyorum.

GridView1.Sort("ID", SortDirection.Descending)
(1105,1104,1103,1102,1101,1100.....)

Buraya kadar sorun yok.
Ben tekrardan sol tarafa manuel bir ID colunms oluşturarak sabit kalacak şekilde (10,9,8,7,6,5,4,3,2,1) satır oluşturmak istiyorum.

Bu konu hakkında yardımcı olabilir misiniz.

UPDATE (English translated):
Hi
In my asp.net etc. project, I show the data with SqlDataSource1 in gridview with the last 10 record ID order.

GridView1.Sort ("ID", SortDirection.Descending)
(1105,1104,1103,1102,1101,1100 .....)

So far there is no problem.
I want to create a manual ID colunms on the left side again and create a row (10,9,8,7,6,5,4,3,2,1) that will remain constant.

Can you help with this topic.

What I have tried:

For i = 0 To GridView1.Rows.Count - 1
GridView1.Rows(i).Cells(0).Value = i+1
Next

Posted 5-Sep-20 2:05am

Member 14507998

Updated 10-Sep-20 3:08am

Sandeep Mewara

v2

Add a Solution

2 solutions

Solution 2

merhaba
konu hakkında yardımcı olduğunuz için teşekkür ederim.

Posted 24-Sep-20 22:00pm

Member 14507998

Updated 24-Sep-20 22:23pm

Comments

OriginalGriff 25-Sep-20 4:25am

Don't post comments as solutions: the original poster doesn't get any notification.
Us ethe "Have a Question or Comment?" widget instead, and they will get an email.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Accepted Answer · 2020-09-10T03:08:00

It is really unclear what you are trying to achieve so here are a few suggestions

1. IF you are trying to add a row number column to the Gridview then it is as simple as including the following snippet in your gridview definition

ASP.NET

<asp:TemplateField HeaderText="ID" >
     <ItemTemplate>
     <%# Container.DataItemIndex + 1 %>
     </ItemTemplate>
</asp:TemplateField>

You may have to change the calculation if you want the row number reversed. This suggestion is all over the Internet, which you can find by using the search term

Search for:
asp net gridview label row number

Note that this will always show the GridView row number

2. IF you are trying to assign a row number to the SQL results that you are binding to, then you can use the ROW_NUMBER (Transact-SQL) - SQL Server | Microsoft Docs[^] function. Note this will always show the row number as returned even if you sort the GridView