databindings.add password crypt

I have a password column in sql server 2005.

I want save in sql the password crypt by my function Crypt(string).

How to use function in databindings editing:

Private fdaUsuariosAsNew SqlDataAdapter

Private fcbUsuariosAsNew SqlCommandBuilder

Private fbsUsuariosAsNew BindingSource

Private fdsUsuariosAsNew DataSet

'abertura e conex?o da tabela Usuarios

fdaUsuarios.SelectCommand =New SqlCommand("SELECT * FROM Usuarios", zConexao)

fdaUsuarios.FillLoadOption = LoadOption.OverwriteChanges

fdaUsuarios.ContinueUpdateOnError =True

'construtor de comandos sql

fcbUsuarios.DataAdapter = fdaUsuarios

fcbUsuarios.ConflictOption = ConflictOption.OverwriteChanges

zConexao.Open()

fdaUsuarios.Fill(fdsUsuarios,"Usuarios")

zConexao.Close()

'controle para altera??es

fbsUsuarios.DataSource = fdsUsuarios

fbsUsuarios.DataMember ="Usuarios"

fbsUsuarios.Sort ="Usuario"

'padr?es iniciais dos campos

fdsUsuarios.Tables("Usuarios").Columns("Password").DefaultValue =""

Me.txtSenha.DataBindings.Add("Text", fbsUsuarios,"Password")

Thanks,

[3002 byte] By [Marsenne] at [2007-12-20]

SQL Server

Site Classified