如何从SQL获取自动递增的数字到VB.NET [英] How can I fetch auto-incremented number from SQL to VB.NET
问题描述
如何从表单加载到标签时从SQL到vb.net窗口中获取自动递增的数字我有列名称caseno,它是自动递增的,当我打开表单时,它应该在我的标签中显示最后一个caseno + 1我在表单中使用了以下代码
我尝试过:
Dim Nextid As String
Dim connection As New SqlConnection(server = madhuresh-pc; database = madhu; integrated security = true)
connection.Open()
Dim cmd As New SqlCommand(SELECT MAX(caseno + 1)As'NextId'FOR case1,connection)
Nextid = cmd.ExecuteScalar()
Label1.Text = Nextid
connection.Close()
how can i fetch auto-incremented number from SQL to vb.net window from when form loads to a label i have column name caseno which is auto-incremented and when i open form it should show last caseno + 1 in my label i used the below code in form load
What I have tried:
Dim Nextid As String
Dim connection As New SqlConnection("server= madhuresh-pc; database= madhu; integrated security= true")
connection.Open()
Dim cmd As New SqlCommand("SELECT MAX(caseno+1) As 'NextId' FROM case1", connection)
Nextid = cmd.ExecuteScalar()
Label1.Text = Nextid
connection.Close()
推荐答案
我已经告诉过你该怎么做了:这根本不是一个好主意,你会给自己造成很大的问题。
获取aut o SQL Server中的执行号 [ ^ ]
I already told you what to do: this is not a good idea at all, you will cause yourself huge problems down the line.
Fetch auto incriment number from SQL server[^]
这篇关于如何从SQL获取自动递增的数字到VB.NET的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!