This is a BIG question , in that you can configure a DataGrid in so many
different ways! The right anwser depends on the way you are using the
DataGrid.
I almost always solve such questions in the core SQL itself, by writing the
SQL to match the columns required. Less coding is necessary to bind such
data to a DataGrid object this way, and just about any SQL you write will
work.
If you are creating the DataGrid in code, of if dynamic SQL is not an
option, then leverage static SQL by adding only the required columns to your
DataGrid. There are tons of examples of how to do this on the web. Here
are two starters:
http://odetocode.com/Articles/218.aspx
http://www.c-sharpcorner.com/Database/PlayingWithDataGridTA.asp
Good luck,
Curt
>I am wanting to dynamically display different columns in a DataGrid based
>on
[quoted text clipped - 8 lines]
>
> Thanks in advance for the help.
CanoeGuy - 30 Aug 2005 15:30 GMT
Hi Curt,
Thanks for your reply. Believe it or not it answers the big question that I
had of whether I should handle the data in the SQL or in the DataGrid. Can
you help me on the best way to filter out Null fields in the SQL Statement?
As long as I can get started, I can do the rest of the research.
Thanks,
//Joe

Signature
Joe Goeke
> This is a BIG question , in that you can configure a DataGrid in so many
> different ways! The right anwser depends on the way you are using the
[quoted text clipped - 27 lines]
> >
> > Thanks in advance for the help.