[ASP.NET (C #)] The simplest storage process

SQL Server storage:

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

CREATE Procedure AddNew

@Content Text

AS Insert Into Test Values ​​(@content)

Go

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

CS call code:

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

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 = "zzzzzzzzzzzzzzzzz";

Cn.open ();

cmd.executenonquery ();

cmd.dispose ();

CONN.CLOSE ();

Conn.dispose ();

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