Hi everyone. Sorry if this question is in the wrong area..I posted it on the VB forum and they advised me to post here also.

I have created a visual basic system that is connected to an oracle database.

(I connected through data>Add New Data source>New Connection>Oracle Database etc etc)

I am using the system to create new oracle users with passwords etc.

I have a form called frmAdd and text boxes txtUser and txtPassword

The user of the system will input into txtUser the username they wish to create (eg user1) and then their password (eg password)

they will then click the cmdAdd button.

I wish to send the following command to the oracle databse when they click the button

Create user (txtUser.text)
Default Tablespace users
identified by (txtPassword.text)


There are a lot of other commansd I need to do but I'm sure I can manage it myself after I get help with this one.

Could someone tell me how to go about this please. As it's for a university assignment that needs to be handed in next week.

Regards

Chris