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.
*** Sent via Developersdex http://www.developersdex.com ***