从C#Windows窗体对数据库进行重新排序 [英] database reordering from C# windows forms

问题描述

我在上一个问题中犯了一个错误，请检查此内容

看看我是否有这样的数据库

表标题类别城市Serial_no

表内容经销商Agra 1
经销商Agra 2
经销商Chennai 3

现在，当我添加另一个记录时，经销商Agra 3

然后表格内容应更改为

经销商Agra 1
经销商Agra 2
经销商Agra 3
经销商Chennai 4

应在不使用自动ID的情况下实现

请帮助我....

I did a mistake in previous question please check this

see if i have a database like this

Table Headers Category City Serial_no

Table Content Dealer Agra 1
Dealer Agra 2
Dealer Chennai 3

Now when i add another record Dealer Agra 3

Then the table content should change to

Dealer Agra 1
Dealer Agra 2
Dealer Agra 3
Dealer Chennai 4

This should be achieved without using auto id

please help me....

推荐答案

尝试:

SELECT iD, ROW_NUMBER() OVER (ORDER BY iD) from myTable

您将获得一个从1开始并在结果集中的每一行递增的行号.

The ROW_NUMBER function gives you a row number starting with one and increasing for each row in the result set.

这篇关于从C#Windows窗体对数据库进行重新排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！