You searched for the word(s): userid:627870

More Search Options

RSS Available

• Re: Collecting query results into one "row"

  OK, by understanding the technique underlying the implementation of Pivoting in the above links, I can use dynamic SQL to build a query that corresponds to the days for which I want to display the records in each cell. These links also show the use of the case .. where instruction that can map the record to the correct column. Thanks for the hints! However this solution (if implemented) would not allow databinding of data base to the cells. I think that the best solution ... is the use of the DataList

  Posted to Data Presentation Controls (Forum) by pchan on 4/17/2006

• Re: Guru Question on GridView

  See this post http://forums.asp.net/thread/1259005.aspx

  Posted to Data Presentation Controls (Forum) by pchan on 4/17/2006

• Synchronizing paging on several GridViews

  Hi there! My application has several GridViews having the same rows selected but displaying different things per column. Any hints to synchronize the paging of all views ? Thanks for reading and for replying !

  Posted to Data Presentation Controls (Forum) by pchan on 4/17/2006

• Re: Collecting query results into one "row"

  Thanks for introducing me the concept of PIVOT, converting each row of data table into a column. Just a short question: if the initial data table is updated, will this mechanism track the changes in the new recordset ? However Pivoting is not what I have to do. For 1 year's of Assignments for say 5 resources, I have 5*365 records. I typically display 1 month's of timetable, so I have 30/31 columns in the final display. Each row in my data table has attributes for Row (=resource), Column(=dates in

  Posted to Data Presentation Controls (Forum) by pchan on 4/16/2006

• Collecting query results into one "row"

  Hi, this query select * from Assignments where PersonId='a' and (DateId > '01/01/2006' and DateId < '01/31/2006') would return assignments one by one. I want to collect them and display them in one row of my GridView for each person, showing a timetable e.g. for the various shifts of my employees: 01/01/2006 01/02/2006 01/03/2006 ... 01/31/2006 a Morning Evening Evening ... Night b Off Morning Evening ... Off c Evening Evening Night ... Morning Any questions, comments, suggestions or code snippets

  Posted to Data Presentation Controls (Forum) by pchan on 4/16/2006

• Re: transpose of table

  At the moment I'm trying to find the right method. There's another lead: using an intermediate array, which can be read in from the initial data table, and then be bound to the displayed GridView: Post By Mihail Stefanov : http://www.codeproject.com/cs/database/BindArrayGrid.asp If the data table is updated, can I bind the intermediate array so it's updated (and then to GridView) ? This approach may maintain the updating, but would require lots more memory, whereas that by Jain releases the intermediate

  Posted to Data Presentation Controls (Forum) by pchan on 4/15/2006

• Re: transpose of table

  Very interesting! Could this be done with a GridView ? I've seen the following post (Sep 2003) by Neeraj Jain http://www.codeproject.com/cs/database/Vertical_rows_in_Datagrid.asp But I'm worried that the automatic updating of datasets (when the real records in data base are changed) would not occur with the second dataset actually used to feed the GridView.

  Posted to Data Presentation Controls (Forum) by pchan on 4/15/2006

• Re: Guru Question on GridView

  Very very close to it, just that there are lots more columns (1 per day in the year) and lots more rows (one per resource or per man) ! The rows would be selected as usual (e.g. those in team A, in workshop W, etc.) sorted (by name. etc.) and paged, as supported by GridView. The columns (dates) would be selected by user (in January, etc.). The cells information come from a huge data table: one data row per cell, containing the summary (e.g. History, Maths, Physics) of the assignment. Other columns

  Posted to Data Presentation Controls (Forum) by pchan on 4/15/2006

• Re: Guru Question on GridView

  Thanks for your hints but it doesn't solve my problem. It is not to get many fields of a same record into a cell. It is to get one field of a record into a cell of my GridView. On the same row, many records of my data table are must be bound, one per cell. This table may have a schema such as : ItemId | GVRowId | GVColId | SummaryInfo | DateStart | DateEnd | Activity | etc. 1) GVRowId indicates which row of the GridView the SummaryInfo data should be displayed 2) GVColId indicates which col of the

  Posted to Data Presentation Controls (Forum) by pchan on 4/14/2006

• Re: Guru Question on GridView

  My requirement is very DB oriented. I need to build a query to return for every row, a set of columns where each column corresponds to just one field of a record in a huge table (hundreds of thousands of lines). This query will feed a GridView. In my example, the huge table is that of assignments, keys being PersonId (for each row of my GridView) and PeriodID (for each column of the GridView). This table contains a lot of info. and in particular a summary column which I need to display on the GridView

  Posted to Data Presentation Controls (Forum) by pchan on 4/14/2006