Dynamic Data Entry with WPF and LINQ

Beth Massi - Sharing the goodness that is VB : Dynamic UI with WPF and LINQ

Beth Massi - Sharing the goodness that is VB : Dynamic UI with WPF and LINQ — Wed, 25 Jun 2008 01:38:13 GMT

PingBack from http://blogs.msdn.com/bethmassi/archive/2008/06/12/dynamic-ui-with-wpf-and-linq.aspx

re: Dynamic Data Entry with WPF and LINQ

Joel — Tue, 01 Jul 2008 21:11:00 GMT

Great stuff. One of the great challenges of a UI is validating the data entered. Not just that it fits in the data table, but that it falls within guidelinles. Have you considered using real-time compilation of .NET code for validation?

re: Dynamic Data Entry with WPF and LINQ

mahmoud — Mon, 07 Jul 2008 11:19:30 GMT

hi can u help to make crystal report

re: Dynamic Data Entry with WPF and LINQ

dceanes — Fri, 11 Jul 2008 22:12:05 GMT

Great stuff Beth!!!

Call me lazy, but is there any similar C# code around????

re: Dynamic Data Entry with WPF and LINQ

LarryC — Thu, 17 Jul 2008 01:44:19 GMT

Very cool, I added this to get images (say from Categories)

Case "image"

Return <Image

Height="150"

Width="150"

Stretch="Fill"

HorizontalAlignment="Left"

Name=<%= "img" & columnInfo.ColumnName %>

Source=<%= "{Binding Path=" & columnInfo.ColumnName & "}" %>/>

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Mon, 21 Jul 2008 18:59:12 GMT

Hi dceanes,

XML literals are not supported in C# so the code would be different. You'd have to build the XAML manually using the LINQ to XML API directly.

-B

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Mon, 21 Jul 2008 18:59:50 GMT

Hi LarryC,

Cool! Thanks for posting that.

-B

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Mon, 21 Jul 2008 19:03:33 GMT

Hi Joel,

That is definitely one way to run managed code business rules dynamically. It works well if the code changes often. But if you have set validation rules (phone number, SSN, common validators, etc.) and just need a way to hook them up and call them then in WPF you can also take a look at the ValidationRules collection. And in Visual Basic you can also look at the CallByName method.

HTH,

-B

基于WPF LINQ的动态数据模型

Joycode@Ab110.com — Mon, 22 Sep 2008 12:15:08 GMT

[原文作者]： Beth Massi [原文链接]： Dynamic Data Entry with WPF and LINQ 上一节我讲到用XML编写动态WPF UI，尽管这里的UI是动态生成的，但仍有一处不尽人意的地方

re: Dynamic Data Entry with WPF and LINQ

khamil from Morroco — Sat, 11 Oct 2008 16:20:50 GMT

All of tutorials af Beth Massi are very very cool. I wish to be a very good programmer like Her. I'm autodidact and I try...

this is my Email : khami_med@hotmail.com

re: Dynamic Data Entry with WPF and LINQ

Railton — Wed, 22 Apr 2009 23:43:03 GMT

Hi,

I have tried loading this project into my environment but when I try to run it I get a large SQL error message that starts:

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.

When executing the following line in Window2.xaml.vb:

taSchema.Fill(Me.TableSchema, Me.TableName)

I can see the NorthwindDataSet in the data sources and I can preview the data.

I am using Visual Basic 2008 Express Edition and SQL Server 2008 Compact Edition.

Any idea's on what the issue is?

Thanks in advance for any help.

Railton.

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Wed, 22 Apr 2009 23:48:45 GMT

Hi Railton,

Did you download and install the Northwind database first?

http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en

re: Dynamic Data Entry with WPF and LINQ

Railton — Thu, 23 Apr 2009 01:41:14 GMT

Hi Beth,

I tried the download but I am not able to use the NORTHWND.MDF in my environment, I get a similar error to the one I mentioned before when testing the connection. Could this be because I only have SQL Server 2008 Compact Edition installed?

Thanks,

Railton

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Thu, 23 Apr 2009 01:50:02 GMT

Hi Railton,

Ah, yes. You need SQL Server or the free SQL Server Express edition: http://www.microsoft.com/express/sql/

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Thu, 23 Apr 2009 01:59:48 GMT

Ok, thanks.

Quick question. Is it possible to use this technique on the compact edition?

I am writing an application which uses the compact edition database and I need a dynamic UI for editing the table data because columns on the tables will not always be the same and I don't want to have to modify the application each time. Your code did exactly what I need so was hoping I could use it.

Thanks again for your help.

Railton

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Thu, 23 Apr 2009 03:59:16 GMT

Hi Railton,

The only thing that won't work with SQL Compact is the GetTableSchema stored procedure. SQL Compact doesn't support stored procs so you'll need another way to get the metadata, like storing it in another table.

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Thu, 23 Apr 2009 10:29:43 GMT

Hi,

Thanks for the steer, however I don't think my skill are deep enough to convert your code :(

Thanks again,

Railton

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Thu, 23 Apr 2009 20:13:09 GMT

Hi Railton,

Just create a table that contains the metadata you need, i.e. TableName, ColumnName, Type, Length, IsPrimaryKey and fill it with the information about each table. Then just query that instead. It's more maintance becuause you need to make sure the schema and the metadata are in sync but it's the easiest approach for SQL Compact.

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Sun, 26 Apr 2009 12:32:47 GMT

Hi,

Thanks for the reply, I'm Ok with the concept of storing meta-data in my own tables and retrieving it via sql.

Looking at the code there are quite a few references to the stored procedure and its result set, the area I think I will struggle is converting these references to use the data returned from the SQL.

Hope this makes sense! :)

Railton.

re: Dynamic Data Entry with WPF and LINQ

Beth Massi — Mon, 27 Apr 2009 19:47:28 GMT

Hi Railton,

There should only be one reference to the GetTableSchema stored proc. All you need to do is change the query on the TableAdapter on the TableSchema dataset. Just right-click and select Configure and then you can change the query to select from your metadata table instead. For more info on configuring TableAdapter queries: http://msdn.microsoft.com/en-us/library/kda44dwy.aspx

HTH,

-B

re: Dynamic Data Entry with WPF and LINQ

Railton — Sat, 02 May 2009 23:32:24 GMT

Hi,

I've just got round to looking at this again. I have managed to get it to work but I had to create a new tableadapter and change the declarations so they included ce for example sqlcedataadapter.

I also found that I get an error on the XamlReader.Load if the column names have a space in them.

Thanks again for your help.

Railton.

re: Dynamic Data Entry with WPF and LINQ

Gilbert — Fri, 06 Nov 2009 20:53:00 GMT

Hello! Beth Massi. I really appreciate all your efforts for helping us to learn in vb. Actually I'm just new in wpf and the two wpf video series help me a lot to learn on it. May i request if you could upload your video more on wpf same as the previous with 26 video. Many Thanks!!