Terry,



Attached is the exact same sample compiled with the most recent version of DevExpress (9.2.4). The ONLY change that I had to make to this sample for it to run is change the references and the lic file, recompile, and it worked.



Please review this sample as this should get you going. Thanks.

I'll try it and let you know. Thank you very much.

No problem.

I wish I could say No Problem but I can not..... Now I get this error. I have rebuilt the partial, I have gotten v9.2 of devexpress, I have the latest version of SF. I get absolutely no errors when I rebuild the project and it says the partial are rebuilt with no errors but I get this when I run the project:?



ApplicationException

An error occurred while creating the main form

TargetInvocationException

Exception has been thrown by the target of an invocation.

SqlException

Cannot open database "StrataFrameSample" requested by the login. The login failed.

Login failed for user 'TERRY-143C60421\Terry'.



Source : MicroFour StrataFrame UI



Stack Trace:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)

at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(String Statement, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)

at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)

at DevExGrid.CustomersBO.FillTop100() in D:\VSProjects\DevExGrid\DevExGrid\CustomersBO.cs:line 82

at DevExGrid.Form1..ctor() in D:\VSProjects\DevExGrid\DevExGrid\Form1.cs:line 24

at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)

at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)

at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)

at System.Activator.CreateInstance(Type type, Boolean nonPublic)

at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)

at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)

at MicroFour.StrataFrame.Application.StrataFrameApplication.RunApplication()



I can not imagine why login failed for me. I can use SQL Server Management and look at the data when I login the same way??????

Well, the good news is that this is 100% on the connection side. This error is genuine as I have never seen this message to date when it truly cannot connect to SQL. Check the following:



1. That the server is up and running

2. That the named instance is correct

3. You have the proper login credentials

4. If none of the above works, open the program.cs and change the Applicationkey to something other than StrataFrameSample and it will force the connection string wizard to come back up again and allow you to reset your connection.

All right it Works but what I had to do is stop using the machine I was using and moving too another of my laptops. Apparently the connection to the SQLExpress server is somehow hosed or something. I have not tried your suggestions yet but I will and report back.

I do have SqlExpress 2005 and 2008 on that other machine (that does not work) and I use both instances but the strataframesample is attached to the 2008 instance. Could there be something that let's SF look at the 2005 instance even though I tell it that sqlexpress2008 is the instance? I will try and attach to one of my other databases and see what happens with it...............

Trent and Peter thanks for all of your help. At least I know how to get the DevExpress Grid to work now. I did create my own project on my other laptop and it did work also. I just was too lazy to change the ethernet dongle.......

At least I was able to follow directions and make it work which makes me feel better.

When I started playing with the DevExpress Grid I put in the RowUpdated the following to update the data:

Me.CustomersTableAdapter.Update(Me.DSCustomers.Customers)



but how do I do it using a Strataframe BBS? TIA.

Terry,



This post confuses me as the sample I posted SHOWs how to use an SF BBS with a DevExpress grid. At this point I am unsure of what you are getting at. Please provide more details. Thanks.

I'm sorry but I did not find any code in your example to save the data? So if I am correct all of that is handled behind the scene with the BO and BBS??? In my project that did not seem to work.

I got it all working.

Thank you so very much. Now to my other machine to see what is going on there?

Thanks for all your time and energy.