I want to rearrange serial no field after deleting an item from table

[saifulhaque]

Hi dear

I am working with small program. In my project I have Database field S_NO (serial no).I want to rearrange serial no field after deleting an item from that table like( 1,2,3... etc).How can it possible using C# code. Or by updating serial no field


Expecting Help

[MrMancunian]

Write an update query and execute it.

Steven

[saifulhaque]

Can you give an example for updating multiple number of Records ( field name - SL_NO) in single Button_Click Event using C#.

[MrMancunian]

Have you already tried Google or MSDN?

Steven

[saifulhaque]

yes i have

[MrMancunian]

Show us what you've already got, so we can see what's happening.

Steven

[saifulhaque]

When i am deleting a particular item using delete

query,I want to rearrange serial no field

of all items after deleting an item.How it possible

using c# code

[MrMancunian]

The question is clear, we're just not the forum that hands out code like that. We try to encourage you to find it out yourself. If there is a problem with your solution, we're happy to look into it, but if you don't bring any code, you're not getting any.

Try reading the following two articles: How to Use a Database in Your Program Part I and How to Use a Database in Your Program Part II and come back if you have a specific question.

Steven

[Frinavale]

What I don't get is why you want to rearrange your table?

Who cares how the data is stored...sort the contents being displayed to the user based on the column of your choice...

-Frinny

[saifulhaque]

I want move record back and forth by serial no.

[Frinavale]

Do you mean Sort?

[saifulhaque]

No, Not sorting ,I want to display Serial no of 1st record in a textbox , and using back and forth button i want to move record to last and first.I want to rearrange serial no of records when deleting an item.

[Frinavale]

I understand now :)Is this an ASP.NET application or a desktop application?

[saifulhaque]

ASP.NET application