添加序列号列 [英] Add Serial number column
问题描述
大家好
以下是我从数据集打印数据的代码
< pre lang =c#> sr.WriteLine(i.ToString()+ Strings.Space( 3 - Strings.Len(i.ToString()))+ < span class =code-sdkkeyword> String .Format( {0,-6:dd MMM yyyy},ds.Tables [ 0 ]。行[i] [ 1 ] )+ Strings.Space( 13 - Strings.Len( String .Format( {0,-6:dd MMM yyyy},ds.Tables [ 0 ]。行[i] [ 1 ])))+ Strings.Mid(per.ToString(), 1 , 25 )+ Strings.Space((( 35 - Strings.Mid( per.ToString(), 1 , 25 )。长度)))+ ds.Tables [ 0 ]。行[i] [ 3 ]。ToString()+ Strings.Space( 12 - Strings.Len(ds.Tables [ 0 ]。行[i] [ 3 ]。ToString()))+ Strings.Space( 12 - Strings.Len(ds.Tables [ 0 ]。行[i] [ 5 ] .ToString()))+ ds.Tables [ 0 ]。行[i] [ 5 ] .ToString()+ Strings.Space( 12 - Strings.Len(ds.Tables [ 0 ]。行[i] [ 6 ]。ToString()))+ ds.Tables [ 0 ]。行[i] [ 6 ]。ToString()+ Strings.Space( 12 - Strings.Len(ds .Tables [ 0 ]。行[i] [ 7 ]。ToString()))+ ds。标签les [ 0 ]。行[i] [ 7 ]。ToString());
例如记录就是这样来的
日期资料ChequeNo取款存款余额
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
2011年11月01日现金0 0.0000 210.0000 210.00
2011年11月02日现金0 0.0000 15000.0000 15210.00
2011年11月02日至TRF TD / RD / 34 DAMLE AMO 0 6000.0000 0.0000 9210.00
2011年11月15日由KTH ABB Cash BY CASH D 0 0.0000 2813.0000 12023.00
现在我想在日期之前添加序列号。
喜欢
1
2
3 ...
并假设第一次打印7行然后下次序列号应该从8开始。
请告诉我怎么做。
在具有主键的id上设置indentity(1,1)
最简单的方法是向正在读取行的查询添加另一列。你可以使用函数ROW_NUMBER()
。
见一个例子 - 将行号插入数据表/数据集中的列 [ ^ ]
如果您插入下一个数据,那么它将从上一个条目开始
Hi all
Below is the code by which i am printing data from dataset
sr.WriteLine(i.ToString() + Strings.Space(3 - Strings.Len(i.ToString())) + String.Format("{0,-6:dd MMM yyyy}", ds.Tables[0].Rows[i][1]) + Strings.Space(13 - Strings.Len(String.Format("{0,-6:dd MMM yyyy}", ds.Tables[0].Rows[i][1]))) + Strings.Mid(per.ToString(), 1, 25) + Strings.Space(((35 - Strings.Mid(per.ToString(), 1, 25).Length))) + ds.Tables[0].Rows[i][3].ToString() + Strings.Space(12 - Strings.Len(ds.Tables[0].Rows[i][3].ToString())) + Strings.Space(12 - Strings.Len(ds.Tables[0].Rows[i][5].ToString())) + ds.Tables[0].Rows[i][5].ToString() + Strings.Space(12 - Strings.Len(ds.Tables[0].Rows[i][6].ToString())) + ds.Tables[0].Rows[i][6].ToString() + Strings.Space(12 - Strings.Len(ds.Tables[0].Rows[i][7].ToString())) + ds.Tables[0].Rows[i][7].ToString());
e.g. Records are coming like this
Date Particulars ChequeNo Withdrawals Deposite Balance
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
01 Nov 2011 By Cash 0 0.0000 210.0000 210.00
02 Nov 2011 By Cash 0 0.0000 15000.0000 15210.00
02 Nov 2011 To TRF TD/RD/34 DAMLE AMO 0 6000.0000 0.0000 9210.00
15 Nov 2011 By KTH ABB Cash BY CASH D 0 0.0000 2813.0000 12023.00
Now i want to add serial number before the date.
like
1
2
3...
and suppose first time it printed 7 lines then next time the serial number should start from 8.
Please tell me how to do this.
set indentity(1,1) on id which having with primary key
The easiest way is to add another column to the query which is reading the rows. You can use the functionROW_NUMBER()
.
See one example - Insert row number as a column in datatable/dataset[^]
if u insert next data then it will be start from previous entry
这篇关于添加序列号列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!