1-) MSSQL RMOS - procedure ile kayıt etme

link -> https://stackoverflow.com/questions/23320701/how-to-create-sqlparametercollection-with-multiple-parameters/23320836

1-) procedure ile kayıt etme

 private void btnKaydet_Click(object sender, EventArgs e)

        {                   

                List<SqlParameter> sp = new List<SqlParameter>(){

    new SqlParameter() {ParameterName = "@uAlanTanim_ad", SqlDbType = SqlDbType.NVarChar, Value= txtAd.EditValue.ToString()},

    new SqlParameter() {ParameterName = "@uAlanTanim_durum", SqlDbType = SqlDbType.Bit, Value = radioAktif.Checked}};

                RHVeritabani.MySetQuery_P("uAlanTanimEkle", sp);

                MyGridDoldur();

            }

            catch (Exception ex)

            {

                RHMesaj.MyMessageError(MyClass, "btnKaydet_Click", "", ex);

            }

        }

2-) sınıfı

public static int MySetQuery_P(string pProcedureName, List<SqlParameter> pSqlParameter = null)

        {

            try

            {

                MyOpen();

                int value = -1;

                SqlCommand command = new SqlCommand(pProcedureName, con);

                command.CommandType = CommandType.StoredProcedure;

                if (pSqlParameter != null)

                {

                    command.Parameters.AddRange(pSqlParameter.ToArray());

                }

                value = command.ExecuteNonQuery();

                MyClose();

                return value;

            }

            catch (Exception ex)

            {

                RHMesaj.MyMessageError(MyClassIsmi, "MySetQuery_P", "Beklenmedik Hata!", ex);

                MyClose();

                return -1;

            }

        }