通用存储过程函数-.NET教程,评论及其它

/// <summary>

/// 执行存储过程,cnn数据库连接对象

/// </summary>

/// <param name="parameter">参数数组</param>

/// <param name="procudurename">存储过程名称</param>

public void excupro(string procudurename,parameter [] proparameter)

{

sqlcommand cmd=new sqlcommand();

cmd.commandtype=system.data.commandtype.storedprocedure ;

cmd.commandtext=procudurename;

for(int i=0;i<parameter.length;i++)

cmd.parameters.add(parameter[i]);

cmd.connection=cnn;

try

{

if(cnn.state==system.data.connectionstate.closed)

cnn.open();

return cmd.executereader();

}

catch(system.data.sqlclient.sqlexception e)

{

throw new exception(e.message );

}

finally

{

cmd.dispose();

}

}