StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Found Table name for Propriety TextBox for BindingField

Found Table name for Propriety TextBox for BindingField

Rafael — Wed, 20 Aug 2008 12:21:17 GMT

I Need to know a table name for BindingField.
How i do it ?

RE: Found Table name for Propriety TextBox for BindingField

Greg McGuffey — Wed, 20 Aug 2008 12:21:17 GMT

[quote][b]Dustin Taylor (08/20/2008)[/b][hr]You guys do know about the StrataFrame.Tools.Common.KitchenSink(yourDishes) method, right?

That one always seems to get overlooked...[/quote]

DOH! And I just did the dishes by hand! ;)

RE: Found Table name for Propriety TextBox for BindingField

Greg McGuffey — Wed, 20 Aug 2008 12:18:47 GMT

[quote][b]Bill Cunnien (08/20/2008)[/b][hr]...like MicroFour.StrataFrame.Tools.Common.GetEnumDisplayValue(yourEnum)...[/quote]

:P

I seem to recall that when I coded that method, I remember looking at the code to populate a combo in SF source to figure out how to do it. It appears that that code still doesn't use their own method (handles the attributes directly). In any case, I got a bit of experience learning to handle attributes :D

RE: Found Table name for Propriety TextBox for BindingField

Dustin Taylor — Wed, 20 Aug 2008 09:07:14 GMT

You guys do know about the StrataFrame.Tools.Common.KitchenSink(yourDishes) method, right?

That one always seems to get overlooked...

RE: Found Table name for Propriety TextBox for BindingField

Edhy Rijo — Wed, 20 Aug 2008 08:39:43 GMT

Well, I can not agreed with Bill more :) all the time I am re-designing my stuff with the new things posted in the forums.

As a matter of fact, the first project I stared with StrataFrame took me a couple of weeks to have it in a decent stage, after the training class I decided to start it over based on the StrataFlix logic and in a matter of days I have this project in a much better stage inside and outside (good looking :P).

RE: Found Table name for Propriety TextBox for BindingField

Bill Cunnien — Wed, 20 Aug 2008 08:00:22 GMT

Greg, that's perfect! Wow, nearly every day I am amazed at what lurks in this framework (like MicroFour.StrataFrame.Tools.Common.GetEnumDisplayValue(yourEnum), eh? :D :w00t: )!! Good stuff!

Bill

RE: Found Table name for Propriety TextBox for BindingField

Greg McGuffey — Tue, 19 Aug 2008 13:01:41 GMT

Rafael,

Any business object you'd use inherits from BusinessLayer, which has TableName, so:

[codesnippet]' VB
Dim tableName As String = DirectCast(Me.txtABoundTextBox.BusinessObject,BusinessLayer).TableName

// C#
String tableName = ((BusinessLayer)txtABoundTextBox.BusinessObject).TableName[/codesnippet]

RE: Found Table name for Propriety TextBox for BindingField

Rafael — Tue, 19 Aug 2008 10:57:13 GMT

[quote]
private void for_cod_Leave(object sender, EventArgs e)
{
String mTableName = ((MyBO)txtABoundTextBox.BusinessObject).TableName;
}
[/quote]

In variable MyBO( name of BO ), how i do for my code to be dinamic?

RE: Found Table name for Propriety TextBox for BindingField

Rafael — Tue, 19 Aug 2008 10:52:01 GMT

preciso em tempo de programação pegar o conteudo da propriedade que msotra o nome da tabela referenciada ao bo atraves do bindingfield

I need in time of programing to know content the property name of table by BO through in BindingField

RE: Found Table name for Propriety TextBox for BindingField

Bill Cunnien — Tue, 19 Aug 2008 10:46:14 GMT

Rafael,

Would this do it? Sorry for the C# if you are a VB guy...

[codesnippet]String mTableName = ((MyBO)txtABoundTextBox.BusinessObject).TableName;[/codesnippet]

Bill

RE: Found Table name for Propriety TextBox for BindingField

Trent L. Taylor — Tue, 19 Aug 2008 10:29:44 GMT

Rafael,

I don't understand where and what you are referring to. Can you please give me steps, details, etc. I really want to help but I am totally lost as to what you are trying to do...sorry :ermm:

RE: Found Table name for Propriety TextBox for BindingField

Rafael — Tue, 19 Aug 2008 10:05:17 GMT

I need to know table name because i need to pass for my function in visual studio.
In event Leave for textbox to strataframe, i need to know that a table used and pass for my function

RE: Found Table name for Propriety TextBox for BindingField

Trent L. Taylor — Tue, 19 Aug 2008 09:53:23 GMT

Rafael,

I really want to help you, but I am having a hard to understanding your question. The table name would be whatever table to which you are mapping your business object (BO). The database would be is not specified at the textbox level, but is part of your connection that is established in the AppMain.vb or program.cs files. Each BO has a DataSourceKey which is then used to tie itself to the Database Connections setup in the SetDataSources method in your AppMain.vb or program.cs source files. Again, I think that if you would take a look at some of the samples that many of these questions would be answered for you.

RE: Found Table name for Propriety TextBox for BindingField

Rafael — Tue, 19 Aug 2008 09:42:54 GMT

Trent L. Taylor, i need to know what table name in Data Base use in Textbox.

RE: Found Table name for Propriety TextBox for BindingField

Trent L. Taylor — Tue, 19 Aug 2008 09:35:03 GMT

I really don't know what you are asking here. If you are wanting to know how to use the SF data binding, there are many samples that come with the framework and there is a lot of documentation to this point as well. Instead of me explaining all of this in a shortened format, please refer to the samples and the documentation.

But in short, you will need to drop a BO on the form, select the BO for the BusinessObject, once this is done, there will b e adrop down populated with the fields that can be bound to the control. But before you can see any fields, you will have to map that BO within the BO Mapper.