Author: Coolguys | Posted on: 3/9/2010 7:24:35 AM | Views : 314

 
When i click the reset button, the password is updating in the table.
i.e.,  
update UM_USER set password='ahlnhTczpihljbIn', exp_date='01/JAN/2008' , max_sessions=3
 
How to wirte the stored procedure and call the procedure in .Net coding?
 
 
The codes are below:

Imports System Imports System.Web Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Data Imports System.Data.OracleClient Imports System.Configuration Partial Class _Default Inherits System.Web.UI.Page Protected Sub ResetPassword_OnClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles ResetPasswordButton.Click Dim oraConn As New OracleConnection Dim oraCmd As New OracleCommand Dim strConnection, strUserID As String Try 'Get ...

Go to the complete details ...