1
SqlParameter[] paras
=
new
SqlParameter[
3
];
2
3 paras[ 0 ] = new SqlParameter( " @snrulecode " , rulecode);
4 paras[ 1 ] = new SqlParameter( " @formval " , null );
5 paras[ 2 ] = new SqlParameter( " @resVal " ,SqlDbType.VarChar , 200 ); // 传出参数必须指定大小
6 paras[ 2 ].Direction = ParameterDirection.Output;
7
8 SqlHelper.ExecuteNonQuery( new SqlConnection( this .ConnectString),CommandType.StoredProcedure , " sn_CreatSN " , paras);
2
3 paras[ 0 ] = new SqlParameter( " @snrulecode " , rulecode);
4 paras[ 1 ] = new SqlParameter( " @formval " , null );
5 paras[ 2 ] = new SqlParameter( " @resVal " ,SqlDbType.VarChar , 200 ); // 传出参数必须指定大小
6 paras[ 2 ].Direction = ParameterDirection.Output;
7
8 SqlHelper.ExecuteNonQuery( new SqlConnection( this .ConnectString),CommandType.StoredProcedure , " sn_CreatSN " , paras);