Hi,
I have a ListObject with DataSource a DataTable.. DataTable's columns have set Caption property and ListObject have property AutoSetDataBoundColumnHeaders = true. But caption of Columns from ListObject is column name not column caption.
I try to change mannual ListColumn caption property but i can't find this property.
How can set caption of ListColumn
Thanks,
Marius
ListObject - ListColumn Caption
Hot Topic
- Odd exception new to Nov bits
- first class support for layered windows?
- Visual Studio SDK Tech Preview Now Available
- Problem to display report from SSRS
- Final Year Project in Indigo..
- my vs.net version
- DataGrid (C#) Sample
- Can we generate code?
- VisualBrush + BitmapEffect + Animation = Bug?
- Help with Remoting Sample
Visual Studio
- Troubles with DLINQ
- can i use inputs and outputs
- Diferents Domain Models an Designer Definitions in the same project
- Use Visual Studio 2005 or use VBA in Access or Excel?
- New to this - how to embed in outlook?
- Login Sourc Code Sample
- Add-in TextEditor with syntax coloring and content assistance
- XAML (office 12) Ribbon control
- can I have a macro with VSTO?
- Can I draw something on the report?
ListObject - ListColumn Caption
VMSSanthosh
I'm not sure why the column headers aren't working for you. I have a DataSet bound to a ListObject and the column headers appear. I also tried binding just a DataTable within the DataSet and the headers still appear properly.
My problem with databinding is performance -- I've asked about it in this thread but no one has responded so far. How large is your table Does it take a long time to load into Excel
acole
In column headers I have column name but I want to have column caption. Property of DataColumn ColumnName differ by property Caption and I want to display property caption not column name.
My table is very large (80 columns * ~ 5000 row) and I use paging for display table. Only 50 rows display in excel and in action panel I have 4 button for first page, previous page, next page and last page. First time when open excel file wait ~ 7 seconds, and for change page ~2 second.
Marius
Nick777
Not sure if this is what you want, but you can set the header cells explicitly like this (assuming the header is the first row of your excel spreadsheet):
for (int i = 0; i < myColumns.Count; i++)
((Excel.Range)myWorksheet.Cells[1, i + 1]).Value2 = myColumns[ i ].Caption;If you set it manually, AutoSetDataBoundColumnHeaders needs to be false.