Short version: Can I create a datalayer via a dataset in the App_Code folder, connect it to a ObjectDataSource (ODS), and then connect that source to a gridview in a testpage/module? I try it and the dataset does not appear when I configure the ODS like it normally does!!
Long Version:
Before I was recently introduced to DNN, I was developing pages with VS.NET
A few months agao I had worked through one of Scott Mitchell's tutorials, 'Working with Data in ASP.NET 2.0 :: Creating a Data Access Layer' and was happily (and quickly) creating strongly typed data layers and binding them to GridViews through objectdatasources.
Then I discovered DNN and wow, what a project. I decided to give it a go and try to use it for a project at work. I have worked through a bunch of newbie learning stumbling blocks, and while studying DNN, saw that the 'Provider Model' is used as the DAL+. To be honest, I don't understand it. I think that there is a data provider, asqldtatprovider, and a ton of SPs that all somehow interact. But I didn't get too concerned about it because I figured I could eventually simply add a datalayer in the form of an XSD file in the App_Code folder, as Scott Mitchell does, and then I could go on as usual. WRONG!!
Today I tried it andnow I am panicking because I have made promises at work but now fear I have run into the dreaded dead end. I added a gridview to a test page in the root, created a dataset, in the App_code folder, and when I try to create the datasource, the dataset does not appear in the dropdown list as it normally does.
Does anyone have any experience in this area? If not, I need help understanding how I can create methods to manipulate data that I will be adding in additional data tables in the db.
I am using DNN 4.3.5 with VS.NET 2005