C#通过存储过程新增数据

//C#函数 

private static void Insert_T_Name(string strNameid, string strName)
        {
            string strSql = "Data Source=172.0.0.1;Initial Catalog=TEST;Persist Security Info=True;User ID=sa;Password=sa";
            SqlConnection myConn = new SqlConnection(strSql);
            myConn.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = myConn;
            cmd.CommandText = "Insert_T_Name";
            cmd.CommandType = CommandType.StoredProcedure;

            //必须和存储过程声明的变量的名称一致
            cmd.Parameters.Add("@T_NameID", SqlDbType.NChar, 10);
            cmd.Parameters.Add("@T_Name", SqlDbType.NChar,10);

            cmd.Parameters["@T_NameID"].Value = strNameid;
            cmd.Parameters["@T_Name"].Value = strName;
            try
            {
                cmd.ExecuteNonQuery();
                Console.Write("新增成功");
            }
            catch (Exception ex)
            {
                string i = ex.Message;
            }
            finally
            {
                myConn.Close();
            }      
        }

----------------------------------------------------------------------------------------------------------------------------------------

 --存储过程

USE [TEST]
CREATE PROCEDURE [dbo].[Insert_T_Name]
 @T_NameID nchar(10),
 @T_Name nchar(10)
AS
BEGIN
 SET NOCOUNT ON; 
    insert into T_Name(T_NameID,T_Name) values(@T_NameID,@T_Name)
END

--表

USE [TEST]
CREATE TABLE [dbo].[T_Name](
 [T_NameID] [nchar](10) NOT NULL,
 [T_Name] [nchar](10) NULL,
 CONSTRAINT [PK_T_Name] PRIMARY KEY CLUSTERED
(
 [T_NameID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]