|
|
|
|
[ASP.net(C#)]最简单的一个存储过程 |
|
|
|
作者：未知 来源：月光软件站 加入时间：2005-2-28 月光软件站 |
SQL server存储：
======================================
CREATE PROCEDURE AddNew
@content text
AS insert into test values (@content)
GO
======================================
CS调用代码：
======================================
string sqlString = "AddNew";
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["sqlConnection"]);
SqlCommand cmd = new SqlCommand(sqlString,conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = new SqlParameter();
param = cmd.Parameters.Add("@content",SqlDbType.Text);
param.Direction = ParameterDirection.Input;
param.Value= "zzzzzzzzzzzzzzz";
conn.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
===================================
|
|
相关文章：相关软件： |
|
本类阅读TOP10