VB.NET and ADO.NET

[Pinky_n_need_of_a_brian]

The problem I having is a need to extract a value from a database and
place it within my ASP.NET application. The application is written in
ASP.NET and VB.NET using SQL Data provider.

In classic ASP I would have done the following:

Set GetDetails = Server.CreateObject("ADODB.RecordSet")
SQL1 = "sp_Details '" & ValueID & "'"
GetDetails.Open SQL1, connect

Then I could pull the value using <%= GetDetails("Value2")%> and place
it anywhere on a ASP application.

Here’s exactly what I am trying to do. My ASP.NET application is a
document management system. My users upload documents to a user
specified folder on our file server. I am trying to using a treeview to
provide a visual on where the files are stored. For example this is what
I would like display to my users:

• Report (Primary Folder which is stored in a separate table named
(RootFolder) in a database)
o Status (Subfolder which is stored in another table named (SubFolder)
in a database)
 File1.doc (Files which are stored in another table named
(files) in the database.
 File2.doc
o Expense
 File3.xls
 File4.xls
• PowerPoint
o Company Presentation
 File1.ppt
 File2.ppt

Any help is appreciated.

 

[W.G. Ryan MVP]

You can use a DataAdapter to fill a DataTable and just iterate through the
values or bind (you can't use binding with a treeview AFAIK but you can with
grids and most other controls). This will get you through the data access
aspect
http://msdn.microsoft.com/library/d...stemDataSqlClientSqlDataAdapterClassTopic.asp

You can jsut loop through the rows and add values as necessary from there.