Hello,

Still new to DNN but learning little by little. I have a basic understanding of how DataBind is used to store my modules data on my SQL Server. I have messed around with the single entry I have in the module's table aka presenting the AssignedUserId, CreatedOn, and LastModifiedByUserId ect just because I could. My question is how do I use DataBind to access another table on my server? For instance to access the dbo.Users table?

Another question: is there a simple way to query data from the linked database? Eventually I need to be able to pull data from another server. I've been reading articles and watching the videos but I can't really tell if I'm following what they're trying to accomplish and if it's the same thing I'm trying to do.

Thanks!

That makes sense I'm just unaware at the moment how to go about doing that. You can see the template generated code here:

If I'm reading this correctly it's creating a new controller, linking it to ModuleId (I'm not sure how it knows what that is [420]), then binding that data set.

On the view I think I understand that 'Container.DataItem' points to that module in my case my test module 'DNNModule2_Items' as it appears on my server then searches that table for an ItemId column and posts that to the module.

How does 'Container.DataItem' know that I only want to access rptItemList? Is there not a way to have multiple databinds in a single repeater? 

Sorry I'm just trying to get a basic concept of what I should do. I'm looking at this post here to see if maybe it can help.

Thanks again.

It was a long shot but I took the chance and removed all default code and used a SqlDataSource from the Toolbox->Data then attached a DropDownList to it and I can query whatever table I want. So far I've figured out that as long as they have unique Id's I can have as many of these lists up as I need from different tables at the same time. What I'm messing around with right now:

Seems to be working alright so far. Thanks.