Thanks Sean. I'm already controlling the columns that show in the DataGrid. I just had to have some columns in the table that are only there because they are needed to create aggregate columns (i.e. Rate = Miles/Revenue) and I don't need them (i.e. Miles and Revenue) in the view.
Marshall -----Original Message----- From: Sean Greer (SBI-Chico) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 2:28 PM To: [EMAIL PROTECTED] Subject: Re: [DOTNET] DataView question Sorry, but this is not supported. You can only create a view that is a subset of the rows in the table, not the columns. If you want to limit the columns that are displayed in a datagrid, take a look at DataGridTableStyle. Seang -----Original Message----- From: Marshall Harrison [mailto:[EMAIL PROTECTED]] Sent: Friday, April 26, 2002 11:12 AM To: [EMAIL PROTECTED] Subject: [DOTNET] DataView question I have a DataView created like this: dvwLoads = dstLoads.Tables("loads").DefaultView The underlying table "loads" has some columns that I don't need in the view. Is it possible to create the view and give it a list of columns that I want included? I 've tried several things that don't work and I can find anything in the help aboput this. Thanks Marshall Harriso You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.