張小芸的生活記事簿 δ

故事的開端: 一直都用SqlDataSource, but 問題來嚕, 現在要用到剛新增好的資料筆資料, 怎麼辦?!

教主指示SqlDataSource, 只能做一件事而已, 所以只能用StoredProcedure了, 問題又來了,

2005的AuctionCoding 一直都迷有發表, 慘了, 只能摸了, 偏偏書上資訊, 沒有....>
唉, 跟丫姆哥要來一段 C# 的片段程式, 希望能從裡面的 KeyWord 找到一些蛛絲馬跡,

總之, 有弄出來嚕, 分享一下喔!! 這是 asp.net for vb 版喔!!

= = = = = = = = 我的程式 = = = = = = = =
Dim ReturnValue as String
Dim connSettings As ConnectionStringSettings = WebConfigurationManager.ConnectionStrings("連線")
Dim conn As SqlConnection = New SqlConnection(connSettings.ConnectionString)
Dim cmd As New SqlCommand("UserTableAdd", conn)
cmd.CommandType = CommandType.StoredProcedure

'這是值傳回的方法
Dim UserId As SqlParameter = cmd.Parameters.Add("@UserId", SqlDbType.Int)
UserId.Direction = ParameterDirection.Output

'這是值傳入的方法
Dim UserNname As SqlParameter = cmd.Parameters.Add("@UserNname", SqlDbType.NVarChar, 50)
UserNname.Value = "張小芸"

conn.Open()
cmd.ExecuteNonQuery()
ReturnValue = cmd.Parameters("@UserId").Value
conn.Close()

= = = = = = = = 我的 StoredProcedure = = = = = = = =
PROCEDURE [dbo].[UserTableAdd]
(
@UserID int OUTPUT,
@UserName nvarchar(5)
)
AS
BEGIN
INSERT INTO UserTable
(
UserName
)
Values
(
@UserName
)
Select @UserID=@@Identity
END