Can a DevExpress XtraGrid be filled using a a Dynamic SELECT statement string

Posted by Gerhard Weiss on Stack Overflow See other posts from Stack Overflow or by Gerhard Weiss
Published on 2010-05-06T19:03:57Z Indexed on 2010/05/07 19:28 UTC
Read the original article Hit count: 599

Filed under:

xtragrid

|

devexpress

|

sql

Can a DevExpress XtraGrid be filled using a a Dynamic SELECT statement string?

i.e. SELECT * FROM Employee
or
SELECT * FROM Dependents

To fill our XtraGrids currently, we use a ORM that creates entities. To do this it takes a lot of steps and time. What is driving me to ask this question is we do a lot of client aquistions where we get hundreds of files. I do not want to create entities for all of these then have to create an XtraGrid for each entity. Ideally if I can just feed it a SELECT statement and the XtraGrid could render it then I could use the XtraGrid very nice data minipulation features (Filter, Group By, etc).

If you have any other ideas or suggestions please to not hesitate to post them.

© Stack Overflow or respective owner

Related posts about xtragrid

Can a DevExpress XtraGrid be filled using a a Dynamic SELECT statement string

as seen on Stack Overflow - Search for 'Stack Overflow'
Can a DevExpress XtraGrid be filled using a a Dynamic SELECT statement string? i.e. SELECT * FROM Employee or SELECT * FROM Dependents To fill our XtraGrids currently, we use a ORM that creates entities. To do this it takes a lot of steps and time. What is driving me to ask this question is we… >>> More
Xtragrid Devexpress SetRowcellValue

as seen on Stack Overflow - Search for 'Stack Overflow'
const int index = 1; object val = repositoryItemComboBox3.Items[index]; gridView2.SetRowCellValue(gridView2.FocusedRowHandle, object w= gridView2.GetRowCellValue(gridView2.FocusedRowHandle, "gridColumn3",val); but w does not gets updated what do I have to do more? >>> More
Is there any Flex dataGrid implementation which has features similar to XtraGrid?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am looking for a Flex datagrid component that has features like grouping, sorting, master/detail display, etc. I am having an application in C# that uses XtraGrid suite to achieve the required datagrid features. I am planning to migrate this application to Flex. If there is no flex component readily… >>> More
How to add CheckBox at DevExpress xtraGrid

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to add CheckBox at DevExpress's xtraGrid columm so for this what should i do >>> More
XtraGrid Suite - is there a way to add a button or hyperlink to a cell?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working with the XtraGrid Suite made by DevExpress. I can't find any sort of functionality to do this, but I'm curious if you can add a button or hyperlink to a grid cell. Context: I've got an Events list. Each Event has a Time, Start/End, and a Category (Utility and Maintenance). There can be… >>> More

Related posts about devexpress

StackOverflowException throws often when .net application built with Debug mode

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an application which access an external webservice often, when i are trying to debug it, means debuging in vistual studio. it often throws out StackOverflowException at the webserverice call point. when building in Release mode , the exception thrown out only occasionally. I checked… >>> More
DevExpress AspxGridView filter in ObjectDataSource

as seen on Stack Overflow - Search for 'Stack Overflow'
Yet another problem with DevExpress AspxGridView :) The context: One Page In the Page, a custom control In the custom Control, a AspxDropDown The AspxDropDown, has a DropDownWindowTemplate In the DropDownItemTemplate, I add a GridView and a paging/sorting/filtering enabled ObjectDataSource When… >>> More
C# DataSet CheckBox Column With DevExpress DataGrid

as seen on Stack Overflow - Search for 'Stack Overflow'
Scenario I have a DevExpress DataGrid which is bound to a DataSet in C#. I want to populate each dataset row to contain a string in the first column and a checkbox in the second. My code below doesn't work quite how I want it to, and I'm not sure why..... The Code As you can see I've declared a… >>> More
How far did DevExpress get with Javascript refactoring?

as seen on Stack Overflow - Search for 'Stack Overflow'
Over a year ago, I remember watching one of DevExpress evangelists previewing or at least promoting rich Javascript refactoring (beyond just limited intellisense) within the Visual Studio shell, I recall part of CodeRush/DevExpress product line. I was excited. On checking today (lmgtfy) I can find… >>> More
DevExpress AspxGridView clientside SelectionChanged problem when using paged ObjectDataSource

as seen on Stack Overflow - Search for 'Stack Overflow'
The context is as follows: One DexExpress AspxGridView with a server-side paging/filtering/sorting mechanism (using ObjectDataSource). I've been having problems with the filter mechanism ( see this stack ). Now, the problem I'm having is this: the client-side events get mangled between DataSource… >>> More