/// // / execute stored procedure, CNN database connection object /// /// parameter array /// Stored Procedure Name
Public void excdupro (String Procudurename, parameter [] Proparameter
{
SqlCommand cmd = new SqlCommand (); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = procudureName; for (int i = 0; i
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 ();}}
