می خوام بعد از ثبط رکورد در بانک ID برگرده.با SP لطفا

[sheervin]

cn = New SqlConnection(ConnectionString)
SqlCmd = New SqlCommand("Sp_InsertName", cn)
SqlCmd.CommandType = CommandType.StoredProcedure
SqlCmd.Parameters.Add("@name", SqlDbType.NChar).Value = Name
SqlCmd.Parameters.Add("@family", SqlDbType.NChar).Value = family
cn.Open()
Dim id As Integer
id = SqlCmd.ExecuteScalar()
Return ID
cn.Close()
------------------------------------------------------------------ALTER proc [dbo].[SP_Insertname]

@name nchar(10),
@family nchar(10)
as
insert into name ([name],family)
values (@name,@family)

declare @M as int
select M=@@IDENTITY




ولی همش مقدار -1 یا false بر میگردونه

[sheervin]

mamnon az dosan.khoedsh hal shod.khodam doros kardam.cheghad dosan lotf daran vaghean inja.

[bastakboys]

ol_cmf = New OleDbCommand("select top 1 IDF from Faktor order by IDF desc", ol_cnf)
LIDF.Text = (ol_cmf.ExecuteScalar()).ToString()


از کد بالا استفاده کن