存储过程问题,急,在线等待!!!
try
{
//查询指标语句
strSqlIndex = " select * from ana_index"+ProPublic.objUserID+" where ana_index_sel ='1' order by ana_index_code ";
//打开连接
SqlConnection conn = ( SqlConnection ) idbmanage.OpenConnection ( true );
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
SqlDataAdapter dataIndex = new SqlDataAdapter( strSqlIndex,conn );
dataIndex.TableMappings.Add ( "Table","Index" );
DataSet ds = new DataSet();
dataIndex.Fill ( ds );
for( int isel =0;isel< ds.Tables["Index"].Rows.Count; isel++ )
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText=ds.Tables["Index"].Rows[isel]["ana_index_proc"].ToString();
cmd.Parameters.Add ( "@strUserId",strUserid );
SqlParameter perResult = cmd.Parameters.Add("@strResult",SqlDbType.Int );
perResult.Direction =ParameterDirection.Output;
cmd.ExecuteNonQuery();
}
}
catch( Exception ex )
{
Console.WriteLine ( ex.Message );
MessageBox.Show ( ex.Message );
}
finally
{
idbmanage.CloseConnection();
}
//------------------- 错误如下:
当纪录 ds.Tables["Index"].Rows.Count =1 的 时候,存储过程可以执行
,当 ds.Tables["Index"].Rows.Count 〉1 的时候存储过程就报错,错误为:
为过程或函数指定的参数太多·!!!