[code=vb]dim cmd as new sqlclient.sqlco mmand
cmd.commandtext ="select pw from table where usname=' "& texbox1.text &" ' "
cmd.connection= con
con.open()
dim dr as sqldatareader=c md.execunonquer y
while dr.read
label1.text=dr( 0)
end while
dr.close()
con.close[/code]
Leave a comment: