how stored procedure calling different forms

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Skarthi
    New Member
    • Jun 2007
    • 2

    #1

    how stored procedure calling different forms

    i write a oracle stored procedure in login screen.. its two different type of login employee and employer...in front end assign the procedure in class file... how to call different forms

    my procedure
    cmd = New OracleCommand(" login", con)
    cmd.CommandType = Data.CommandTyp e.StoredProcedu re
    cmd.Parameters. Add("P_USERNAME ", OracleType.VarC har, 45).Value = uid
    cmd.Parameters. Add("P_PASSWORD ", OracleType.VarC har, 45).Value = pwd
    cmd.Parameters. Add("P_LOGIN_TY PE", OracleType.VarC har, 45).Value = "E"
    cmd.Parameters. Add("P_IP_ADDRE SS", OracleType.VarC har, 45).Value = ipadd
    pui = New OracleParameter ("P_PORT_USER_I D", OracleType.VarC har, 25)
    errmsg = New OracleParameter ("P_MESSAGE" , OracleType.VarC har, 25)
    pui.Direction = Data.ParameterD irection.Output
    errmsg.Directio n = Data.ParameterD irection.Output
    da = New OracleDataAdapt er(cmd)
    cmd.Parameters. Add(pui)
    cmd.Parameters. Add(errmsg)
    cmd.ExecuteNonQ uery()

    E variable is assign employee or employer
  • nateraaaa
    Recognized Expert Contributor
    • May 2007
    • 664

    #2
    Originally posted by Skarthi
    i write a oracle stored procedure in login screen.. its two different type of login employee and employer...in front end assign the procedure in class file... how to call different forms

    my procedure
    cmd = New OracleCommand(" login", con)
    cmd.CommandType = Data.CommandTyp e.StoredProcedu re
    cmd.Parameters. Add("P_USERNAME ", OracleType.VarC har, 45).Value = uid
    cmd.Parameters. Add("P_PASSWORD ", OracleType.VarC har, 45).Value = pwd
    cmd.Parameters. Add("P_LOGIN_TY PE", OracleType.VarC har, 45).Value = "E"
    cmd.Parameters. Add("P_IP_ADDRE SS", OracleType.VarC har, 45).Value = ipadd
    pui = New OracleParameter ("P_PORT_USER_I D", OracleType.VarC har, 25)
    errmsg = New OracleParameter ("P_MESSAGE" , OracleType.VarC har, 25)
    pui.Direction = Data.ParameterD irection.Output
    errmsg.Directio n = Data.ParameterD irection.Output
    da = New OracleDataAdapt er(cmd)
    cmd.Parameters. Add(pui)
    cmd.Parameters. Add(errmsg)
    cmd.ExecuteNonQ uery()

    E variable is assign employee or employer
    Could you have the stored procedure return a value such as 1 for an Employee and 2 for an Employer then based on what is returned show the proper form to the logged in user?

    Nathan

    Comment

    Working...