VBNET i uskladistene procedure

Code:
 
                String cmdStr = "CREATE PROCEDURE getPage"
                    + "(@startrow int,@endrow int ) AS"
                    + " BEGIN"
                    + " SET NOCOUNT ON;"
                    + " select TempLogs.*"
                    + " from"
                    + " (select *, ROW_NUMBER() over (order by transactionNo) as RowNum"
                    + " from TRANSACTION_LOGS_ORDERS"
                    + " )"
                    + "TempLogs "
                    + " where RowNum between @startrow and @endrow"
                    + " order by transactionNo"
                    + " END";

                command = myAccessConn.CreateCommand();
                command.CommandText = cmdStr;
                try
                {
                    command.ExecuteNonQuery();
                }
                catch (Exception e)
                {
                    Console.WriteLine(e.StackTrace);
                }

Code:

Dim PrviParametar As New MySqlParameter("@IDBrojModela", "MODE2009-000000000000000005")
        PrviParametar.Direction = ParameterDirection.Input
        PrviParametar.DbType = MySqlDbType.VarChar
        Dim DrugiParametar As New MySqlParameter("@Rezultat", "2")
        DrugiParametar.Direction = ParameterDirection.Output
        DrugiParametar.DbType = MySqlDbType.VarChar
        Dim oRead As New StreamReader("C:\Documents and Settings\CesareKS\Desktop\ProbniSkript.sql")
        Dim Komanda As New MySqlCommand
        Komanda = Conn.CreateCommand
        Komanda.CommandText = oRead.ReadToEnd
        Komanda.Parameters.Add(PrviParametar)
        Komanda.Parameters.Add(DrugiParametar)
        Komanda.ExecuteNonQuery()
        MsgBox(Komanda.Parameters("@Rezultat").Value.ToString)

Code:

DROP PROCEDURE IF EXISTS `ProveraModela`; 
CREATE PROCEDURE `ProveraModela` (IN IDBrojModela VARCHAR(50),OUT Rezultat VARCHAR(50)); 
BEGIN 
    SELECT Naziv INTO Rezultat WHERE IdBroj=IDBrojModela;
END;