I need to create a table structure that will automatically create columns for a collection of objects (the structure of which is pretty flexible). The data in the table will only be read only so I've been looking into using a GridView but can't figure out how to automatically generate the columns - has anyone got an example or a URL expl...
I've got a large set of data in Excel 2007, but the rows should have been columns, and vice-versa. Is there a simply way to "pivot" this spreadsheet, rearranging all cells so that the rows become the columns? ...
Hello, I have a grid view with multiple check box columns and I was wondering if anyone could show me how to select all check boxes in a unique column. I don't want to select a check box in the header and have it select all the check boxes in the grid view. I'm new to jQuery, literally at the beginners stage and was hoping to be able t...
I have a table of data with column names: period, Truck, Car, Boat Where the Columns contain numeric values, and the period column is an identity column having 1 to 48, so there are 48 rows. I would like to massage this table into a format where I have a Name column and a value column as well as the period column eg. period, NameOfV...
Hi all, I've got a table which I'm pulling in from an external website, but I need to be able to hide the first 2 columns, add a class to the 3rd column, add a class to the 6th row and delete the 7th row. I've managed to do the columns, but I'm having problems with the rows.. I'm using the following code to hide the first 2 columns and ...
Is this possible or do I have to list all the columns? INSERT INTO table_name (column1, column3, column2,...) VALUES (value1, value2, value3,...) Do I have to list all the columns in order and have values for each one? ...
I want to join table1 with table2 on column 'Name', but table2.Name has an 'e' in front of all the names (if table1.name=ABC,table2.name=eABC). How am I supposed to use a join for those two? I tried FROM table1 join table2 on 'e'+table1.name = table2.name, but it doesn't work... ...
I have this ListView and I'm using a DataTemplate (as you can see) for items. How can i add column names to the ListView with this ItemTemplate definition? I cannot use that GridViewColumn definition, because this ListView uses lazy data loading, so when there are too many rows, it fetches them on demand. GridViewColumn somehow does not ...
I have a SQL script that I am working on and I run into an issue when I'm creating (or editing) a column and then attempting to modify that new column. For example: BEGIN ALTER TABLE SampleTable ADD ColumnThree int END IF (EXISTS (SELECT * FROM sys.columns WHERE name = 'ColumnThree')) BEGIN UPDATE SampleTable SET ColumnThree ...
My data sheet has filters and hidden columns. When filter(s) applies, I need to loop through all filtered data. I use: Excel.Range visibleRange = this.UsedRange.SpecialCells(XlCellType.xlCellTypeVisible, missing) as Excel.Range; Now visibleRange.Rows.Count is 0; use foreach loop "foreach(Excel.Range row in visibleRange.Row)" row d...
When manipulating DataGridView cells, you typically do: MyGrid.CurrentRow.Cells["EmployeeFirstName"].Value = "John"; which is all fine and dandy, but as complexity rises, you start worrying about spelling errors, refactoring issues etc. Historically, I just made the columns public so I could access them directly in the class instanc...
Hi! does anybody know when the columns are generated of a GridView? After what event? Basically, when I put a breakpoint on RowCreated event handler of my gridview, I can see each time .Rows count is incrremented. But When I check. .Columns.Count property it is zero. so, even my autoGenerateColumns porperty set to true, why the Column...
Hello, I'm trying to accomplish what should be a very simple task using the ListView Control. All I am trying to do is add two Items to a ListView Control. One Item goes under the "Title" Column and the other Item goes under the "Status" Column. I have seen many examples for the ListView Control and none of them cover this particular ne...
Hay Guys, i have a basic string with holds a html table. The table looks like this: <TR> <TD>asdf, dfg</TD><TD>0915</TD><TD>0945</TD><TD></TD><TD>15</TD><TD>45</TD><TD></TD><TD>1315</TD> </TR> <TR> <TD>asdf, dfg</TD><TD>0915</TD><TD>0945</TD><TD></TD><TD>15</TD><TD>45</TD><TD></TD><TD>1315</TD> </TR> <TR> <TD>asdf, dfg</TD>...
I need to sync the column order of two ListViews event when the user changes the order. But it seems there is not a Column reorder event. For the moment I just did a AllowsColumnReorder="False" but that is not a permanent solution. While searching the net I found many people with the same problem but no solution. What can be done? ...
Hi, my question is about how to get number of rows using SqlDataReader in C#. I've seen some answers around the net about this but none were clearly defined except for one that states to do a while loop with Read() method and increment a counter. My problem is that I am trying to fill a multi-dimensional array with the first row being t...
In ruby on rails how do I find the top 3 records of my table called notices ordered by a particular field, in my case I want to order by the position field which is an integer. so my notices table looks like this any help would be greatly appreciated, thanks ...
I have an items control that is bound to a collection of objects. The object has two properties (name, value) that i display in a textblock and textbox respectively. The list is quite long and I would like to show it in two columns. So my question is, is there any way I can get an Itemscontrol to show its items in two columns? P.S: The ...
I have a LINQ entity that I need to create a special string value for. It is 7 different values separated by "-". Some of the fields used are in that table, while some of them are in different tables. I would like to add this field to the entity somehow so that I don't have to create this string myself every time I need it. I was thinki...
We'd like to build a custom type - or simply add custom columns to an existing type - that can be displayed in regular lists (or document library) without requiring a special page or grid view. This column retrieves complex/structured data from an external service and exposes it as the column's "value". I realize that this will prevent...