My guess is that you should not be able to connect directly to a SQL server from a partial trust application, for security reasons. I am not an expert in partial trust apps or WCF, so it’s hard for me to guide you. Maybe someone reading this post will have better insight.

Bea

Well, I know the internals of binding because I’ve worked for the WPF Data Binding team for several years. I helped create this API.
If you’re interested in learning about the internals of binding (or any managed technology) I recommend Dot Net Reflector from Lutz Roeder. In his own words, here’s what this tool does:

“Reflector is the class browser, explorer, analyzer and documentation viewer for .NET. Reflector allows to easily view, navigate, search, decompile and analyze .NET assemblies in C#, Visual Basic and IL.”

I find myself using this tool every time I need to write code.

And of course, reading blogs and asking questions is a great way to learn any technology.

I hope you’re making progress with WPF!

Bea

I am new in XAML and WPF. I am trying to use a SQL-SERVER connection in a XBAP I can do it inside a WPF Windows application, but when I try to do the same like Load_Page() ASP.NET I get an error

void mainPage_Loaded(object sender, RoutedEventArgs e)

{

// Connection Fail

}

I have download many good books like:

Applications = Code + Markup: A Guide to the Microsoft® Windows® Presentation Foundation

By Charles Petzold

Programming WCF Services

By Juval Lowy

But no body speak about access data from SQL-SERVER database

may be you can help me.

Excuse my English I speak Spanish .

Thank you

Reiner

reinerra@hotmail.com

I’m assuming you would like to display that hierarchy in a TreeView, right? I’m also assuming the data on the first level of the TreeView is stored in a table in a database, and the second level is stored on some other table.

If that’s the case, I would build a middle data layer that reads the information from the database and creates a hierarchical data structure in the format you want. Then you can bind your TreeView directly to that data structure.

The ideal data structure for this scenario would be a collection of MyMountain objects. MyMountain would contain an int MountainID property and a ObservableCollection Lifts property. MyLift would simply contain a string property with the lift name. Once you have this structure, you can use HierarchicalDataTemplates to help the TreeView display the data.

Let me know if this helps.
Bea

Thanks for the help,
Mike

Thanks for your tips. I find data binding extremely hard to understand, so seeing your examples if very nice. I feel kind of silly asking this question because it seems like it should be very simple, but I can’t seem to get it right.

If I want to build a tree hierarchy from the Lifts table where Mountain_ID designates the parent node and Lift_Name is the child, then how would I do that?

The output would look like this:

1
Big Red Express
Garbanzo Express
Orange chair
2
Tye Mill
Jupiter chair
Southern cross chair
3
Rainier Express
Green Valley

Regarding your question on change notifications and ADO. You should not need to do anything special to notify WPF of changes in the DataTable. It’s strange that you’re seeing something different in your application.

I made a simple sample that shows how adding an item to a DataTable gets reflected automatically in the UI. You can find it here.

Hopefully this will help you find the problem in your app.

Thanks!
Bea

Thank you for providing very good posts on data binding. It has helped me a lot in getting started.
To understand this topic further I’m using Northwind Database and trying to populate a ListView with Employee data. Now I have a Dataset with table “EmployeeData” which has EmployeeID, FirstName and LastName. I’m binding the ListView with Dataset’s table EmployeeData (I’m also using data templates for displaying the data) and the page works fine. My question is If I add a record to the Northwind.Employee table, how can that get updated in the UI. I tried using the INotifyPropertyChanged interface but an not sure on what property should I implement onPropertyChanged event. I tried on the Dataset and that did not work. Every sample that I see on the internet does databinding on simple datatypes. Is it possible to do two way binding on objects.

System.Windows.Data Error: 12 : Cannot get ‘Nr’ value (type ‘String’) from ” (type ‘DataRowViewWrapper’). BindingExpression:Path=Nr; DataItem=’DataRowViewWrapper’ (HashCode=65429669); target element is ‘TextBlock’ (Name=”); target property is ‘Text’ (type ‘String’) InvalidCastException:’System.InvalidCastException: Das Objekt des Typs Bsoft.Berta.DataRowViewWrapper kann nicht in Typ System.Data.DataRowView umgewandelt werden.

I made the jump, scrapped my wrapper and wrote an IListSource, IList, ICustomTypeDescriptor and PropertyDescriptor from scratch, and it works.

Source is ugly as hell right now, need to clean that stuff up until I understand why it works ;)