Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string _conStr = ConfigurationManager.AppSettings["DB_SM"];

            EDBConnection connection = new EDBConnection(_conStr);
            connection.Open();

            string guid = "b3bd85e7280e446eb97d5d0447e148d5";

            EDBCommand cmd = new EDBCommand("PCK_OFFERT_KONTROLL.HAMTA_MAX_SEKVENSNR", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            EDBParameter p = cmd.Parameters.Add("p_inGuid", EDBTypes.EDBDbType.Varchar);
            p.Value = guid;


          /*p = new EDBParameter();
            p.Direction = ParameterDirection.ReturnValue;
            p.EDBDbType = EDBTypes.EDBDbType.Numeric;
            //p = cmd.Parameters.Add("ret", EDBTypes.EDBDbType.Numeric);
            cmd.Parameters.Add(p);
            */
           
            object o = cmd.ExecuteScalar();
            int sekvensnr = Convert.ToInt32(o);

            connection.Close();

        }