程式搜集分享精靈

在sql server 建立一個procedure 

============================================================

use vbook
go
create procedure insertData(@name nvarchar(8),@sex nvarchar(2),@mail nvarchar(255),@subject text,@suggestion text,@time datetime,@motion nvarchar(255),@public nvarchar(50))
as
insert into visitbook(姓名,性別,信箱,主旨,留言,留言時間,心情,公開否) values (@name,@sex,@mail,@subject,@suggestion,@time,@motion,@public)
select SCOPE_IDENTITY()

=============================================================

在asp.net c# 中呼叫 insertData procedure

        int a = 0;
        SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["vbookConnectionString"].ConnectionString);
        SqlCommand cmd = new SqlCommand("insertData", conn);
        cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@name", name.Text);
                cmd.Parameters.AddWithValue("@sex", sex.Text);
                cmd.Parameters.AddWithValue("@mail", email.Text);
                cmd.Parameters.AddWithValue("@suggestion", suggestion.Text);
                cmd.Parameters.AddWithValue("@subject", subject.Text);
                cmd.Parameters.AddWithValue("@time", DateTime.Now);
                cmd.Parameters.AddWithValue("@motion", motion.SelectedItem.ToString());
                cmd.Parameters.AddWithValue("@public", open.Text);
              conn.Open();
             a = Convert.ToInt32(cmd.ExecuteScalar());
             conn.Close();