调用存储过程

 public void insert_itemname(int first_itemid,string second_itemname)
  {
   SqlCommand myCommand = new SqlCommand("insert_second_itemname", myConnection);//存储过程名字

   //指明Sql命令的操作类型是使用存储过程
   myCommand.CommandType = CommandType.StoredProcedure;

   SqlParameter parameterfirst_itemid = new SqlParameter("@first_itemid", SqlDbType.Int,4);
   parameterfirst_itemid.Value = first_itemid;
   myCommand.Parameters.Add(parameterfirst_itemid);

   
   SqlParameter parametersecond_itemname = new SqlParameter("@second_itemname", SqlDbType.NVarChar,50);
   parametersecond_itemname.Value = second_itemname;
   myCommand.Parameters.Add(parametersecond_itemname);

   /*SqlParameter parameterusername = new SqlParameter("@username", SqlDbType.NVarChar,50);
   parameterusername.Value = username;
   myCommand.Parameters.Add(parameterusername);*/

   myCommand.ExecuteNonQuery();
  }