DevExpress Grid and SF


Author
Message
Terry Bottorff
Terry Bottorff
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 448, Visits: 12K
I am using the latest version of DevExpress and SF in VS 2008. I created a BO and just by using a break point I found that it does have data in it. I also created a Custom Business Binding Source and put in the code so it does appear on my toolBox. I dropped the BO and the BBS on my form. I also have placed a DevExpress Grid on my form.

Using the little black arrow on the top right of the grid(forgot what it is called) I did the following steps:

1. Choose Data Source.

2. Add Project Data Source.

3. Choose Object as data type.

4. Found my BOLib, found my BBS and selected it.

5. It immediately created the databindingsource and put the columns that I want in the grid.

6. I looked at the columns and they have the correct field names in them.

7. Because of #5 and #6 I think the grid is set up correctly?????

8. Run project and the grid shows with the column titles but no data.



What am I missing? TIA.

Replies
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
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.
Terry Bottorff
Terry Bottorff
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 448, Visits: 12K
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.

Terry Bottorff
Terry Bottorff
StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)StrataFrame VIP (1.1K reputation)
Group: Forum Members
Posts: 448, Visits: 12K
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.
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Terry Bottorff - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Terry Bottorff - 16 Years Ago
Terry Bottorff - 16 Years Ago
Terry Bottorff - 16 Years Ago
Peter Jones - 16 Years Ago
Terry Bottorff - 16 Years Ago
Peter Jones - 16 Years Ago
Terry Bottorff - 16 Years Ago
Peter Jones - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Terry Bottorff - 16 Years Ago
                     No problem, just wanted to make sure that it worked. Thanks. :)
Trent L. Taylor - 16 Years Ago
                     I replaced all the references from 8.2 to 9.1 and rebuilt the...
Terry Bottorff - 16 Years Ago
                         Well, you still have 8.2 references in either the designer file or the...
Trent L. Taylor - 16 Years Ago
                             OK thanks.........
Terry Bottorff - 16 Years Ago
Terry Bottorff - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Peter Jones - 16 Years Ago
Terry Bottorff - 16 Years Ago
Peter Jones - 16 Years Ago
Terry Bottorff - 16 Years Ago
Peter Jones - 16 Years Ago
Trent L. Taylor - 16 Years Ago
                 Thank you so much.
Terry Bottorff - 16 Years Ago
Terry Bottorff - 16 Years Ago
Terry Bottorff - 16 Years Ago
Peter Jones - 16 Years Ago
Peter Jones - 16 Years Ago
Terry Bottorff - 16 Years Ago
Trent L. Taylor - 16 Years Ago
                     I'll try it and let you know. Thank you very much.
Terry Bottorff - 16 Years Ago
                         No problem. :)
Trent L. Taylor - 16 Years Ago
Terry Bottorff - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Terry Bottorff - 16 Years Ago
                     When I started playing with the DevExpress Grid I put in the...
Terry Bottorff - 16 Years Ago
                         Terry,

This post confuses me as the sample I posted SHOWs...
Trent L. Taylor - 16 Years Ago
Terry Bottorff - 16 Years Ago
Terry Bottorff - 16 Years Ago
Trent L. Taylor - 16 Years Ago
                 Yes I did get it. Thanks.
Terry Bottorff - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search