C # access the database using Stored Procedures

Suppose there is a data table named news in the database. The stored PROCEDURE for adding a record is as follows: create procedure AddNews
@ Id int,
@ Title nvarchar (200 ),
@ Content nvarchar (4000 ),
@ Publishtime datetime,
@ Replies int
AS
Insert news (id, title, content, publishtime, replies)
Values
(@ Id, @ title, @ content, @ publishtime, @ replies)

The database access code is as follows: string source =
"Server = 169.254.0.1;" +
"User id = softgroup;" +
"Password = 1234;" +
"Database = newsdb ";

String source =
"Server = 169.254.0.1;" +
"Integrated security = SSPI;" +
"Database = sstinews ";

SqlConnection conn = new SqlConnection (source );

Conn. Open ();
SqlCommand cmd = new SqlCommand ("AddNews", conn );
Cmd. CommandType = CommandType. StoredProcedure;
Cmd. Parameters. Add (new SqlParameter ("@ id", SqlDbType. Int, 4 ));
Cmd. Parameters. Add (new SqlParameter ("@ title", SqlDbType. NVarChar, 200 ));
Cmd. Parameters. Add (new SqlParameter ("@ content", SqlDbType. NVarChar, 4000 ));
Cmd. Parameters. Add (new SqlParameter ("@ publishtime", SqlDbType. DateTime, 8 ));
Cmd. Parameters. Add (new SqlParameter ("@ replies", SqlDbType. Int, 4 ));
Cmd. UpdatedRowSource = UpdateRowSource. None;

Cmd. Parameters ["@ id"]. Value = art. ID;
Cmd. Parameters ["@ title"]. Value = art. Title;
Cmd. Parameters ["@ content"]. Value = art. Content;
Cmd. Parameters ["@ publishtime"]. Value = art. PublishTime;
Cmd. Parameters ["@ replies"]. Value = art. Replies;
Cmd. ExecuteNonQuery ();
Conn. Close ();