.net

Question

Can you explain this code?specially this params SqlParameter[] parms ?

public int insUpdata(string procName, params SqlParameter[] parms)
        {
            //cmd.Connection = conSql;
            OpenConnection();
            cmd = new SqlCommand(procName, conSql);
            if (parms != null)
            {
                foreach (SqlParameter p in parms)
                {
                    if ((p.Direction == ParameterDirection.InputOutput) && (p.Value == null))
                    {
                        p.Value = DBNull.Value;
                    } cmd.Parameters.Add(p);

                }
            }
            cmd.CommandType = CommandType.StoredProcedure;
            int iStatus = cmd.ExecuteNonQuery();
            CloseConnection();
            return iStatus;
        }

Nattudurai Eswaramurthy · Answer

HI There are several ways to create this array. One is to hardcode the number of parameters as follows: view sourceprint? 1. SqlParameter array SqlParameter[] sqlParams = new SqlParameter[5]; An evolution of this is to use an ArrayList ArrayList sqlParams = new ArrayList(); Then add the parameters using sqlParams.Add(…) to add them Then the final step is to use sqlParams.ToArray() and pass that to your SqlHelper. Another evolution would be to use a Generic list of SqlParameters System.Collections.Generic.List sqlParams = new System.Collections.Generic.List (); Its actually SqlParameter [] parameter = { new SqlParameter (...) new SqlParameter (...) new SqlParameter (...) };