Dear All,

i am using Starta Frame on my machine. everything is running quite well on machine. Our one more developer is also working on the same project as i am. but when he started the project on his machine a DataAccessLayer Exception is being thrown on his machine with the message that "An error occurred whuke creating a new DataLayer for the Business object." The inner exception is null. The other information i found for exception is "DataSourceKey [] is not defined."

please tell me whats the wrong happening here?

my code is in C# and SetDataSource event handler for the StartaFrame.SetDataSource event is as follows (present in program.cs)

static void StrataFrameApplication_SetDataSources()

{

ConnectionManager.ApplicationKey = "ISOCOM Key";

ConnectionManager.ApplicationDefaultTitle = "ISOCOM Connection";

ConnectionManager.ApplicationDefaultDescription = "This application connection is used by ISOCOM";

// Set the required data source information so that the ConnectionManager can gather it

// SQL Connection

ConnectionManager.AddRequiredDataSourceItem("ISOCOM Key", "SQL Connection", DataSourceTypeOptions.SqlServer, "ISOCOM", "This connection is used by MyApplication.", true);

////SQL Connection

//// Make the call to SetConnections which will gather the connection information, show the connection wizard

//// if needed and set the DataSources collection on the DataLayer class.

ConnectionManager.SetConnections();

}

1) A data source with a DataSourceKey of "" is not required, but recommended.  It's recommended because "" is the default DataSourceKey for business objects (and the DataSourceKey on the business object tells the business object which connection string to use).  So, you don't have ot use "", but if you don't you'll need to change all of the DataSourceKey properties to match throughout your application.

2) You figured this one out

3) Yes, the manual option allows you to retrieve the connection string any way you want to.  You don't have to use the ConnectionManager class at all.  In fact, it's probably only recommended to use when have an internal application where your users will know their own connection string.  So, just change the SetDataSources() method to add the connections manually and acquire the connection string any way you like.  Then, just make sure you don't set any properties or call any methods on the ConnectionManager class (especially the ConnectionManager.SetConnections() method ).

4) Yes, the field must belong to the CurrentDataTable to be able to filter on it.  So, if you add an additional column to the CurrentDataTable and populate that column, you'll be able to filter/sort on it.  But, if you just have a custom field that does not have a backing column in the CurrentDataTable, you will not be able to sort/filter on it.

3) Yes, the manual option allows you to retrieve the connection string any way you want to. You don't have to use the ConnectionManager class at all. (especially the ConnectionManager.SetConnections() method [Wink] ).



I especially not call this method as you say and all work ok (I was thinked that this line cannot have to be supressed )





4) Yes, the field must belong to the CurrentDataTable to be able to filter on it. So, if you add an additional column to the CurrentDataTable and populate that column, you'll be able to filter/sort on it. But, if you just have a custom field that does not have a backing column in the CurrentDataTable, you will not be able to sort/filter on it.



I don´t watched that I don´t need to use Currentview.table

I called my "_ExtraColumnAdd" method after the fill method and voila!







later on my form I can use this column like another



It´s the best thing to do about add a new calculated field that can be filtered?



Thanks Ben and Trent for all the support to learn all the stuff around Strataframe, you are awesome

---

pd: Can I post a sample with a routine that recursively read a DB to fill a treeview on the contribution topic to read some feedback on what is wrong and what can I do in a better manner?



its used to create a tree menu like

1 : Module 1

1.1: ABMs

1.1.1: Customers

1.1.2: Employees / etc)

1.2: Configs

I'm glad you got that working. 

As for the calculated fields, we just implemented logic that allows you to use a calculated field with the AllowNullValuesOnNewRow = False (default) because the row tries to initialize the value and it cannot because it is readonly.  So, if you want to use a calculated field, and you get an error saying that you cannot update a readonly field in the InitializeRow() method, then let me know and I'll post the corrected DLLs for you.

Sure thing   We have the General .NET Discussion forum for just that sort of thing. (http://forum.strataframe.net/Forum14-1.aspx).  You can post anything in there and lots of people will be happy to help you out with it.

Ben, thanks for all the feedback and support, I´m a newbie on .net and I think that Strataframe is the better way of go away from vfp and stay on the road of new technology close to .net.



Two days ago my boss buy the framework for me (I convinced him after four weeks of initial tests and learning) and I have thousand of questions, doubts (and a little of fear) but I happy with all of those because I sure that I choose the correct tool to make the fast as posible the application that he request to me with the great and awesome support that you bring to me and all the comunity on this forum



I have to learn a lot about .net while learning the framework and I try to not disturb you and Trent so much in this path



Thanks Again



- Fabian

[I learn I learn I learn]

We'll you'll never learn unless you're shown or you ask questions.  So, keep asking the questions and we'll keep doing our best to answer them.  We don't know everything about .NET, but if we don't know it, we might have a better idea on what to type in your google search to find it and maybe point you in the right direction.