Newbie

Discussion in 'New Members Introduction' started by Rinjin, Apr 12, 2008.

  1. Rinjin

    Rinjin New Member

    9
    0
    1
    Hi All...

    I am new to this forum and also to .net. I wish to take up certifications in .net..... However, I am not sure which ones to be taken.... I have just about 6 months of experience...

    Please suggest on how I must go about it... I have browsed many websites and have found a couple of them... However I am still confused.... Please advice...:rolleyes:

    Thanks and Regards,
    Rinjin
     
  2. dmarsh
    Honorary Member 500 Likes Award

    dmarsh Petabyte Poster

    4,305
    503
    259
    Ever thought of going to the source ?

    http://www.microsoft.com/learning/mcp/certifications.mspx#TOOLS

    http://blogs.msdn.com/gerryo/archiv...certifications-where-do-i-start-a-series.aspx
    http://blogs.msdn.com/trika/


    depending what you decide you'll probably need one of these :-

    http://www.amazon.com/MCAD-MCSD-Self-Paced-Training-Kit/dp/0735619255/ref=cm_lmf_tit_10_rsrsrs0
    http://www.amazon.com/Self-Paced-Tr...bs_sr_1?ie=UTF8&s=books&qid=1207987983&sr=1-1
    http://www.amazon.com/Self-Paced-Tr...bs_sr_2?ie=UTF8&s=books&qid=1207987983&sr=1-2

    you may even need a few more or supplement with the web / msdn.

    Google is your friend...
     
  3. greenbrucelee
    Highly Decorated Member Award

    greenbrucelee Zettabyte Poster

    14,292
    265
    329
    Hi Welcome :)
     
    Certifications: A+, N+, MCDST, Security+, 70-270
    WIP: 70-620 or 70-680?
  4. Notes_Bloke

    Notes_Bloke Terabyte Poster

    3,230
    54
    146
    Hi & welcome:D

    NB
     
    Certifications: 70-210, 70-215, A+,N+, Security+
    WIP: MCSA
  5. GiddyG

    GiddyG Terabyte Poster Gold Member

    2,471
    42
    140
    Welcome to CF! 8)
     
  6. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,624
    117
    224
    Hi and welcome to CF!

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  7. Rinjin

    Rinjin New Member

    9
    0
    1
    Hello Guys....

    Thanks a ton for your suggestions... I have a database function related question... I am not sure if I can ask it here. However, if I am posting it at the wrong place, hope you will redirect me to the right location...

    I am working on a project for PDA. I have installed Oracle Lite. I wana call a database function. My code is as follows:

    Dim cmd1 As LiteCommand = con.CreateCommand()

    cmd1.CommandText = "fncEncryptPsswd"
    cmd1.CommandType = CommandType.StoredProcedure
    Dim p1 As New OracleParameter("p_input1", DbType.String)
    p1.Value = UCase(Trim(txtPsword.Text))
    p1.Direction = ParameterDirection.Input
    cmd1.Parameters.Add(p1)

    Dim p2 As New OracleParameter("output1", DbType.String)
    p2.Direction = ParameterDirection.ReturnValue
    cmd1.Parameters.Add(p2)
    cmd1.ExecuteNonQuery()

    con.Close()

    It throws the error:

    37000[POL- 5228] syntax error

    I am nto sure what to do

    As an alternative I tried to convert the same function into .net.....

    Original in SQL is :

    FUNCTION Fncencryptpsswd(p_input1 IN VARCHAR2) RETURN VARCHAR2 IS
    x NUMBER := 31;
    s NUMBER := 1;
    r1 NUMBER := 29;
    r2 NUMBER := 31;
    r3 NUMBER := 93;
    ps NUMBER := 0;
    output1 VARCHAR2(100) := NULL;
    BEGIN
    FOR s IN 1..LENGTH(p_input1) LOOP
    x := MOD((((x+TO_NUMBER(ASCII(SUBSTR(p_input1,s,1)))+ ps)*r1)+r2),r3);
    output1 := output1||CHR(x+33);
    ps := x;
    END LOOP;
    output1 := REPLACE(output1,'"','0');
    output1 := REPLACE(output1,'@','a');
    RETURN output1;
    END Fncencryptpsswd;

    Now teh one I have written in .net is :

    For s = 1 To pass.Length


    x = (((x + (Asc(pass.Substring(s, 1))) + ps) * r1) + r2)

    y = x Mod r3

    output = output & Chr(y + 33)

    ps = y
    Next s
    output = Replace(output, " ", "", "0")
    output = Replace(output, "@", "a")

    The output is totally different from teh other....

    Sombody please help me with this..................
     
  8. GiddyG

    GiddyG Terabyte Poster Gold Member

    2,471
    42
    140
    You'll have to excuse me, as I know nothing about coding; however, if you have a "p_input1", shouldn't the "output1" be "p_output1"?

    I also notice you have a value line for p1, but none for p2. Would this make any difference at all?

    Apologies if I am sending you on a wild goose chase...

    Giddy
     
  9. BosonMichael
    Honorary Member Highly Decorated Member Award 500 Likes Award

    BosonMichael Yottabyte Poster

    19,183
    500
    414
    Welcome!
     
    Certifications: CISSP, MCSE+I, MCSE: Security, MCSE: Messaging, MCDST, MCDBA, MCTS, OCP, CCNP, CCDP, CCNA Security, CCNA Voice, CNE, SCSA, Security+, Linux+, Server+, Network+, A+
    WIP: Just about everything!
  10. hbroomhall

    hbroomhall Petabyte Poster Gold Member

    6,624
    117
    224
    I notice that the stored proc name has different capitalization to your reference in the the code.

    On some platforms this will stop it from working.

    Harry.
     
    Certifications: ECDL A+ Network+ i-Net+
    WIP: Server+
  11. stutheview

    stutheview Byte Poster

    173
    2
    25
    Welcome to CF :D
     
    Certifications: A+, N+, MCP 70-270 70-290
    WIP: 70-291
  12. Rinjin

    Rinjin New Member

    9
    0
    1
    Hello Giddy and Harry !!!

    Thanks a ton for taking time and trying to help me out though not from a software back ground.... I am very very thankful....

    Good news is that I got it to work....

    Regards,
    Rinjin...
     

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.