sheervin
شنبه 21 شهریور 1388, 16:49 عصر
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 بر میگردونه
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 بر میگردونه