I now have several buttons on my Form, which process various Oracle select statements and even display the output in listboxes or labels. Can someone tell me if the items below are also possible in VB.NET? 1. Write a query to support using Join Statements that display data from Multiple Tables. (I was able to do a select statement from two tables and display the results in a textbox). 2. Write a query to support the project using Sub-queries. 3. Write a query to support the project using Reports and SQL statements. 4. Write code to support the project that creates and manages Tables, Tablespaces and Database Objects. (I tried editing the sample and by changing the "select department_name from departments where department_id = 10" to create table emp2 ( emp_First_Name VARCHAR2 (100) PRIMARY KEY, emp_Last_Name VARCHAR2 (100), emp_years DATE, emp_salary NUMBER (8,2) )" but this did not work and generated several syntax errors. 5. Create Users and Manage access to the Oracle Database. (Like add a user and the permissions for that user). 6. Code S-Q-L statements within P-L-/-S-Q-L, built-in S-Q-L functions, Cursors, subprograms, packages, triggers and error handling to support the project. ( I have found some examples on the net, but have not been able to make any work, like the ones in the samples from the link you provided). 7. Write code to employ Composite to support the project. (Is this possible?) 8. Employ and demonstrate Cursors. As you can all see, my basic issue is that I am trying to process various queries using buttons in VB.NET and then display the results in a text box. Any help with this, would be greatly appreciated. Thanks again Joseph!! vbsquire
vbsquire
Posts
-
Newbie ORACL/.NET help again... -
Newbie VB.NET/Oracle questionThanks so much!! I will have a look right now. vbsquire
-
Newbie VB.NET/Oracle questionHello code Gods! I'm a newbie to VB.NET and really need some help. This may seem basic to you all, so please leave out the laughs. Lol I'm trying build a basic VB.NET application that has a datagrid and 2 or 3 buttons. The buttons would be: CreateTable, Alter Table, Drop Table. I want to be able to run Oracle queries and perform these types of actions. I've tried 20 different samples from the net, but none seem to work. It would be great if someone could just help me with the code, for a button that would query the table and display the output in the datagrid. That would give me a great start.(Like select * from emp;). (Or create table store). Obviously I am years away from being able to provide the user the ability to enter the values, which take affect after the button is pressed, but for now, it would be a major win, if the values can at least be hard-coded. This is really hard for a newbie and I'm starting to lose hope. Thanks in advance to all of you! I've read many of your posts and I keep my hope. vbsquire