how to get the records fields in sql server like in vb.



x.open("select name,address from abc"),cn..........................





txtname.text=x!name

txtaddress.text=x!address






Max

If you are in a stored proceedure or trigger it is as simple as writing your query. See my answer to you in your other thread and keep in mind that you should really explain what you want versus the few lines that you give.

 

 

 

Good Luck