Binding a Textbox to a particular column from a DB

Question

0.00/5 (No votes)

See more:

Hey guys, basically what I have are some textboxes that I need to bind to a particular data source. For example, I have a First Name textbox, but I need it to bind to only the column from my MySQL database table that has that same column name (e.g. First Name to FirstName). I set up my UI through some basic XAML, and I simply don't know where to go from here.

On my website http://www.nppetre.com I have attached a ss of my UI demonstrating what I need.

Also, I am not sure where to put this added code within my XAML.
In my <canvas> I have declared this textbox:

<TextBox Canvas.Left="93" Canvas.Top="8" Height="23" x:Name="_arFirstName" Width="120" IsReadOnly="True" />

Posted 26-Oct-10 6:47am

NPP83

Updated 26-Oct-10 7:34am

v3

Add a Solution

Comments

Nish Nishant 26-Oct-10 13:45pm

I have updated my answer based on your edited question.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nish Nishant · Accepted Answer · 2010-10-26T06:49:00

Solution 1

I would very strongly suggest that you use some form of MVVM here. Directly binding to a DB class is not recommended. This is a good starting point:

http://msdn.microsoft.com/en-us/magazine/dd419663.aspx[^]

Also check out MVVM tutorials from Sacha and Pete here on Code Project. They are pretty good write-ups on the topics.

Edit/Update
------------

Okay based on your updated question, you can do this:

XML

<TextBox Binding="{Binding FirstName}" Canvas.Left="93" Canvas.Top="8" Height="23" x:Name="_arFirstName" Width="120" IsReadOnly="True" />.

This assumes you've already set the DataContext appropriately.

Posted 26-Oct-10 6:49am

Nish Nishant

Updated 26-Oct-10 7:44am

v4

Comments

NPP83 26-Oct-10 13:02pm

I am operating through a domain (business object) of the corresponding type name. It isn't a direct link. The insert and update queries done through the textbox to the column are through that domain class. Is this what you are referring to?

Nish Nishant 26-Oct-10 13:05pm

Corresponding to the DB column, the business object should ideally have a matching public property. If you have that, then it's trivial to bind the TextBox to this property. If you don't, I assume it won't be too complicated to add such a property.

NPP83 26-Oct-10 13:25pm

In the Agent business class/domain object FirstName does have a corresponding public property. Why would it be trivial to bind to the property then if the property is the only intermediary between the textbox and the data column?

Nish Nishant 26-Oct-10 13:28pm

If there is a FirstName property, then all you need to do is do something like Text="{Binding FirstName}".

NPP83 26-Oct-10 13:36pm

Is this declared within the XAML where the textbox resides? I guess what I am even more confused about is how to associate the name of the textbox (in this case: _arFirstName) with the binding you described.

Nish Nishant 26-Oct-10 13:38pm

Yeah, the code I showed you shows how the binding can be declared in the Xaml.

Nish Nishant 26-Oct-10 13:42pm

You can bind data using code too, see http://msdn.microsoft.com/en-us/library/ms598270.aspx

NPP83 26-Oct-10 13:48pm

So basically, I have added this into my Canvas: TextBox Text ="{Binding FirstName}". My next and final question is: how does this declaration know to associate the right textbox to the Property it goes with. So, for example, my textbox name is _arFirstName and my Property in code is FirstName. I dont see anywhere in the snippet you gave me a way to tell it to associate the right textbox with the Property name.

Nish Nishant 26-Oct-10 13:51pm

The textbox name has nothing to do with it. The textbox that gets this binding is the one where you inserted the binding on (and if you did it on the one named arFirstName, that'd be the one that gets bound to the data).

If you are new to WPF/databinding, this may seem confusing initially, if so feel free to say so, and I'll try and give you a better example/code snippet.

NPP83 26-Oct-10 14:05pm

I am new. And I see above in your response you did add in a sufficient example. Thank you for all your help and sources.

Abhinav S · Accepted Answer · 2010-10-26T06:54:00

Solution 2

<code><TextBox Text="{Binding FirstName}"/></code>where FirstName will be a property within your model.

Posted 26-Oct-10 6:54am

Abhinav S

Comments

NPP83 26-Oct-10 13:27pm

I am not sure where to declare this piece of code then in my xaml (thats how new I am to this). I understand its linkage to the property in the domain's corresponding business object. And does TextBox "Text" refer to the name of the textbox?

In my declaration on my canvas I have this:
<textbox canvas.left="93" canvas.top="8" height="23" x:name="_arFirstName" width="120" isreadonly="True">
Would your code declaration go in after this?

NPP83 26-Oct-10 13:32pm

Apparently my formatted code won't display in a comment box. See above in my original question for my added code.