如何在VB.Net中自动生成带字符的ID？ [英] How to auto generate ID with character in VB.Net?

问题描述

如何在VB.Net中使用charactor自动生成ID？

例如：C-00001，SV-1



如果此方法正确，那么如何在此方法中包含字符：

（例如：AREA-1）

How to auto generate ID with charactor in VB.Net?
for Example : "C-00001", "SV-1"

if this method is correct then how to contain charactor in this Method:
( for Example : "AREA-1" )

Private Sub auto()

        con = New SqlConnection(cs)
        con.Open()

        Dim ct As String = "select Max(NUM) as NUMS from AREAs"
        cmd = New SqlCommand(ct)
        cmd.Connection = con

        rdr = cmd.ExecuteReader()
        rdr.Read()

        If rdr("NUMS").ToString() <> "" Then
            txtSerID.Text = Integer.Parse(rdr("NUMS").ToString()) + 1
        Else
            txtSerID.Text = 1
        End If
        rdr.Close()
        If con.State = ConnectionState.Open Then
            con.Close()
        End If
        con.Close()
    End Sub

如果此方法正确/可以，那么如何在此方法中包含字符：

（例如：AREA-1

If this method is correct/OK then how to contain character in this Method:
( for Example : "AREA-1"

推荐答案

你应该从sql server端获取这样的数据。



看看这里： SQL中带VARCHAR和NVARCHAR数据类型的自动增量列 [ ^ ]

You should obtain such of data from sql server side.

Take a look here: Auto Incremented Column With VARCHAR and NVARCHAR Data Type in SQL[^]

这篇关于如何在VB.Net中自动生成带字符的ID？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！