Reputation: 0 Apprentice
- New Members
- Active Posts:
- 5 (0.02 per day)
- 22-August 12
- Profile Views:
- Last Active:
- Feb 25 2013 09:44 AM
- Dream Kudos:
Posts I've Made
Posted 25 Feb 2013Actually thanks to your second post I'm now able to output data from the database
I've now got to work out how to make the text box update when I press a button (to navigate to the next record)!
Posted 25 Feb 2013There is a simple example here at MSDN of reading data from a DataReader. Click the Get.. links on the left to obtain other ways to retrieve the field(s) data.
How many fields are retrieved from the table? How many rows?
Do you want to retrieve the data from a specific column or field-name?
Your post states that you want to put the data into a single TextBox; is this correct?
I've had a look at the code and it's not explained, nor does it want to work. OracleCommand (etc) cannot be found and the article does not explain how to solve this. A quick google search indicates that I need to use using System.Data.OracleClient; however OracleClient does not exist in the namespace System.Data.
At the moment it's connected to a very simple database. The database has one table (Test) which has 2 fields with one record ("2 x 1"). The finish product will have multiple tables, each with multiple fields and multiple records. Each textbox in the program will contain the data from one field / records at a time.
I don't know if I've explained that very well. I can draw a diagram if it'll help.
In general it is better to use Data Binding - to link the form to a data-source.
I'll read through this.
Posted 22 Aug 2012I apologise for not using the search function, I was in a hurry when I posted earlier.
Thank you for the links. I'll have a look at them and if I have any further problems I'll post here.
- Member Title:
- New D.I.C Head
- Age Unknown
- Birthday Unknown
Fish-E hasn't added any friends yet.