Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • Hi.
                                    I want to create a simple application that can open a Microsoft Server table at run time,
                                    and populate a grid with this data.
                                    I want the grid to be able to edit the data (add,update,delete).
                                    Do you have some sample code, or even a sample project that I can use to see the best / easiest way to do this ?
                                    Thanks
                                    Jim

                                0

                                Hi Jim,

                                Thank you for your question. I am afraid that we have no examples specific to a certain database. However, all necessary information is available in the documentation. I suggest that you refer to the following documents:

                                XtraGrid Data Binding Specifics
                                Traditional Data Binding Methods

                                Pleases let us know, if you need any further assistance.

                                Thanks,
                                Uriah

                                0

                                Hi Uriah

                                you mention that you "have no examples specific to a certain database".
                                I'm actually using VistaDB, but happy to have an example using any Database.
                                Your "Traditional Data Binding Methods" mentions Microsoft SQL Server version 7.0 for the SqlDataAdapter.

                                I have asked a lot of questions from DevExpress,
                                and have always been happy with the answer,
                                except for the rather curt answer below.

                                Is there any one else in your team who could provide me with some help ?

                                Thanks
                                Jim

                                0

                                Hi Jim,

                                I am concerned to hear that my answer was not helpful. Would you please clarify in greater detail what difficulty you experience using the approach described in the documentation? In the documentation we describe how to bind GridView to the database using the Microsoft ADO.NET technology that is common for all databases. I believe that the described approach will work if you replace SqlDataAdapter with the VistaDBDataAdapter and SqlConnection with the VistaDbConnection (all these classes are described in the VistaDB online documentation).

                                If you have already tried this, but still experience some difficulties, describe them in greater detail. I will be happy to help you resolve them.

                                There is one more database independent technology to read/update data: eXpress Persistent Objects. You can find a tutorial here: Getting Started. Please check to see whether or not XPO is more convenient for you, than ADO.NET. Let me know if you have any further questions in this regard. I will be happy to answer them.

                                Thanks,
                                Uriah

                                If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2014 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners