subsonic 调用 存储过程

subsonic 调用 存储过程

[csharp]

public static int GetRUID(string tblName)

{

StoredProcedure spd = new StoredProcedure(“GenerateRUID”);

spd.Command.AddParameter("@tblName”, tblName);

spd.Command.AddOutputParameter("@currentnumber”);

spd.Execute();

int currentnumber = int.Parse(spd.OutputValues[0].ToString());

return currentnumber;

}

[/csharp]