求个最简单的存储过程源码，和应用该过程的C#源码

有表persons
内有列string类型的：name,adress,tel
  int类型的：age,id_p
其中id_p是主键列，具有自增1的功能
求一存储过程源码，同时列出利用存储过程的C#代码 把 “李三” “湖北省武汉市蔡甸区” “011-5421545” “23”
这条记录插入到persons表中

SQL code

insert into persons(nae,adress,tel,age) select '李三','湖北省武汉市蔡甸区','011-5421545',23

Insert into persons(nae,adress,tel,age) select '李三','湖北省武汉市蔡甸区','011-5421545',23

我的name写错了

insert into persons(name,adress,tel,age) select '李三','湖北省武汉市蔡甸区','011-5421545',23

SQL code

create proc pr_name(@name varchar(20),
                    @adress varchar(50),
                    @tel varchar(20),
                    @age int,
                    @id_p int)
as
begin
     insert into persons 
       values(@name,@adress,@tel,@age,@id_p)
end

C# code

private SqlConnection con; 
public SqlCommand CreateCommand(string procName, SqlParameter[] prams)
{
  con=new SqlConnection(xxx);  
  con.Open(); 
SqlCommand cmd = new SqlCommand(procName, con); 
cmd.CommandType = CommandType.StoredProcedure; 
foreach (SqlParameter parameter in prams) 
         cmd.Parameters.Add(parameter); 
}
public int ExecProc(string procName, SqlParameter[] prams) 
{ 
SqlCommand cmd = CreateCommand(procName, prams); 
return cmd.ExecuteNonQuery(); 
con.Close();
} 
public void button_click(object o,send e)
{
   SqlParameter[] parameters;
   parameters[0] =new SqlParameter("@name","李三");
   parameters[1] =new SqlParameter("@adress","湖北省武汉市蔡甸区")
   parameters[2] =new SqlParameter("@tel","011-5421545")
   parameters[3] =new SqlParameter("@age","23")
   parameters[4] =new SqlParameter("@id_p","")
  ExecProc("pr_name",parameters)
}