一个循环语句放在存储过程中！！只能提交一条记录！！！

Question

     for (int i = 0; i < dt.Rows.Count; i++)
                  {
                  
                      cmd.CommandType = CommandType.StoredProcedure;
                      cmd.CommandText = "Telephoneshow";
                      cmd.Parameters.Add("@TelephoneNO", SqlDbType.VarChar, 50);
                      cmd.Parameters["@TelephoneNO"].Value = dt.Rows[i][0].ToString();
                      cmd.Parameters.Add("@EnterMomey",SqlDbType.Decimal,9);
                      cmd.Parameters["@EnterMomey"].Value = dt.Rows[i][1].ToString();
                      cmd.Parameters.Add("@UsrNm", SqlDbType.VarChar, 50);
                      cmd.Parameters["@UsrNm"].Value = Session["UsrNm"].ToString();
                      cmd.Parameters.Add("@yunyingsheng", SqlDbType.VarChar, 50);
                      cmd.Parameters["@yunyingsheng"].Value = yunying;
                      cmd.Parameters.Add("@shengfen", SqlDbType.VarChar, 50);
                      cmd.Parameters["@shengfen"].Value = shengfen;
                      cmd.Parameters.Add("@shifu", SqlDbType.VarChar, 50);
                      cmd.Parameters["@shifu"].Value = shifu;              
                      cmd.ExecuteNonQuery();
                      
                  }
第一条数据库可以提交上去!!但是然后就不行提示!!
为过程或函数 Telephoneshow 指定的参数太多。

Answer 1

参数问题
cmd.CommandText   =   "Telephoneshow"; 
cmd.Parameters.Clear();

Answer 2

参数问题
cmd.CommandText   =   "Telephoneshow"; 
cmd.Parameters.Clear();

Answer 3

这样写
cmd.CommandType   =   CommandType.StoredProcedure; 
                                            cmd.CommandText   =   "Telephoneshow"; 
                                            cmd.Parameters.Add("@TelephoneNO",   SqlDbType.VarChar,   50); 
  cmd.Parameters.Add("@EnterMomey",SqlDbType.Decimal,9); 
  cmd.Parameters.Add("@UsrNm",   SqlDbType.VarChar,   50); 
 cmd.Parameters.Add("@yunyingsheng",   SqlDbType.VarChar,   50); 
 cmd.Parameters.Add("@shengfen",   SqlDbType.VarChar,   50); 
 cmd.Parameters.Add("@shifu",   SqlDbType.VarChar,   50);  for   (int   i   =   0;   i   <   dt.Rows.Count;   i++) 
                                    { 
                                    
                                                                                        cmd.Parameters["@TelephoneNO"].Value   =   dt.Rows[i][0].ToString(); 
                                                                                      cmd.Parameters["@EnterMomey"].Value   =   dt.Rows[i][1].ToString(); 
                                                                                      cmd.Parameters["@UsrNm"].Value   =   Session["UsrNm"].ToString(); 
                                                                                       cmd.Parameters["@yunyingsheng"].Value   =   yunying; 
                                                                                       cmd.Parameters["@shengfen"].Value   =   shengfen; 
                                                                                       cmd.Parameters["@shifu"].Value   =   shifu;                             
                                            cmd.ExecuteNonQuery(); 
                                            
                                    }