1public void ModifyData(SqlParameter[] parameters, string ProcName, string ConnectionStringName)
2    {
3        SqlConnection cn;
4        SqlCommand cmd = new SqlCommand();
5
6        cn = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnectionStringName].ToString());
7
8        try
9        {
10            cn.Open();
11            for (int i = 0; i < parameters.Length; i++)
12            {
13                SqlParameter sParam = (SqlParameter)parameters[i];
14                cmd.Parameters.Add(sParam);
15            }
16            cmd.Connection = cn;
17            cmd.CommandType = CommandType.StoredProcedure;
18            cmd.CommandText = ProcName;
19            cmd.ExecuteNonQuery();
20        }
21        catch (Exception ex)
22        {
23            throw ex;
24        }
25        finally
26        {
27            cn.Close();
28        }
29    }