Hi,

I am new to APS.NET and programming in general and was looking for some help.  I am using ASP.NET 2.0 and C# with an Oracle 10g Express Edition database behind my application.

What I am trying to do is retrieve the last 10 entries in the database (I know the SQL to do this) but would like some help on how best to fire the query i.e. would it be ExecuteNonQuery or something different? 

Once I have retrieved the 10 rows of data I want to be able to manipulate certain columns within those different rows, the way I thought I would do this would be to somehow get the data returned from database query into an array? but I do not know how to do this!

Could anyone please give me some advise on how best to proceed in this matter or point me in the direction of some good websites?

Any help would be gratefully received,

Regards

Use ExecuteQuery

File that with DataSet 

you can check http://www.akadia.com/services/dotnet_orablobs.html

 or

http://oliverprodinger.wordpress.com/2007/08/18/simple-oracle-connection-in-c-oracle-10g-xe/ 

or for simpe ado.net

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx 

Thank you Kamran for your quick response.

The example in the website you referenced is as follows, once the data is in the dataset the following line of code is executed:

 cboEmpName.DisplayMember = empDataSet.Tables["emp"].Columns["ename"].ToString();

which from what I can gather, is setting the combo box to list all the values in the ename column of the emp table?  However what I do not under is how I would access a single cell in the column instead of the all values in the column.

Again any help would be gratefully received.

Regards

For that you have loop through the element

for (int i =0;i< empDataSet.Tables["emp"].Rows.Count;i++) 

{

 sring str = empDataSet.Tables[i]["emp"].ToString();

} 

..