Exemplo n.º 1
0
 private void button4_Click(object sender, EventArgs e)
 {
     string _conStr = ConfigurationManager.AppSettings["DB_SK"];
     _conStr += ";Pooling=False";
     EDBConnection connection = new EDBConnection(_conStr);
     connection.Open();
     EDBTransaction tra = connection.BeginTransaction();
     EDBCommand cmd = new EDBCommand("nolstedt01(:p_personnr,:p_contactchannel_id)", connection, tra);
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.Parameters.AddWithValue("p_personnr", "196402230319");
     cmd.Parameters.AddWithValue("p_contactchannel_id", "48AF6816C15B49A9956079BD6D8DE561");
     cmd.Prepare();
     cmd.ExecuteNonQuery();
     tra.Save("apa");
     tra.Commit();
     connection.Close();
 }