split single column into multiple column
Hi all,I have table with 2 columns as shown below...id products_list 1 a,b,c2 d,e,f3 g,h,iNow I need a query which will ouput the result as below...id products_list1 products_list2 products_list3
1 a b &...Displaying single column of data across multiple columns..
Okies my problem....
I have a dataset that has a single column, with 100 rows.
I wan't to display this in a table with 4 columns with 25 rows in each column..
Does anyone know of a simple solution?
Thank's in advance.
Hi, you can try the DataList with RepeatColumns property set to 4. Alvin ChooiMicrosoft ASP.NET™ Enthusiast v1.1 / v2.0, Malaysia Blog : http://alvinzc.blogspot.com...Displaying a single Data Window Column in multiple columns
I have a datawindow that is retrieving a single column. Using
Powerbuilder 5.04, is there anyway to display this data in multiple
columns sorted (alphabeticlly) vertically (eliminates n-up). Any help
would be appreciated.
Yehuda wrote in message <3ACB5511.E9262E3C@yahoo.com>...
>I have a datawindow that is retrieving a single column. Using
>Powerbuilder 5.04, is there anyway to display this data in multiple
>columns sorted (alphabeticlly) vertically (eliminates n-up). Any help
>would be appreciated.
&...displaying multiple columns in a gridview populated from a single column
hi, i'm a newbie so my apologies in advance if i am not explaining my problem clearly... i'm happy to repost to help clarify anything.
Problem: i am not able to sort and organize my record set the way i need to to popluate my gridview. i am looking for suggestion on either how to construct my sql statement, or manipulate my gridview.
Environment: i am working in asp.net 2.0 and using a sql server db.
Details: I have a single table called Loans. i need to retrieve three columns from that table: LoanOfficer, LoanState, and LoanKey. The LoanState column contains one of three v...adding 2 columns in a dataset as a single column in datagrid
i am having 2 columns in a table in a dataset.
i want to add those two columns and bind the resultant total as a single column to the datagrid.
is it possible.
if yes, how o acheive this?
please help me.
thanks in advance.
A lot of ways. One is to use a computed column in the dataset, then just bind to that. Another way is to use something like this in your page:
<%= Eval("column1")+Eval("column2") %>...Multiple Hyperlinks Single Datagrid Column
I have a datagrid that loads some information from a database, and I am working with visual basic.net. I have it set up so that one of the columns is a hyperlink named "View Details" that passes an ID value to a page which displays further details called details.aspx. This works fine. My problem is that my website has three frames and this details.aspx is redirected into the main frame, this is what I want but I also want the bottom frame to be redirected to aspx page at the same time that details.aspx is laoded when the "View details" hyperlink is clicked.
...Multiple values in a single datagrid column
I need to pass a 2nd variable to my hyperlink control (I am using the pop up control from metacontrols, but its the same as a normal hyperlink).
I have written for a single field, but need to add a 2nd pulled from the data.
How do I do it?
This is what I have so far, but I need to add another parameter.
<mbrw:RemoteWindow id="Remotewindow2" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Username") %>' NAME="Remotewindow2" WIndowWidth="720" WindowHeight="400" NavigateUrl='<%# DataBinder.E...When is a column not a column?
I have several extremely similar datawindows that I have to maintain that go
against the same table. Recently, I had to add a column to that table, and
also add the column to ALL of these datawindows that go against this table.
I added the column to the first datawindow, set up the edit control style,
etc. I then did a copy/paste of the columns edit control to the remaining
dw's (of course remembering to first add the column in SQL). Everything
(update props, column specs, column props) seems to indicate that the pasted
column is linked to the column I selected, HOWEVER, when I...Setting Datagrid Column to invisible when Column is an AutoGeneratedColumn NOT a bound Column
Just like the title says, I'm trying to set a column to invisible but I'm unable to do so.
If I bound the column I can used the code:
me.datagrid.Column.Item(1).Visible = False
But since I'm wanting the column NOT to be bound (there are a number of sql scripts that populate the same datagrid so I cannot bound all the columns since the columns are different for each script etc etc etc) how do I set an AutoGeneratedColumn to invisible??
I have a textbox that stores a few product names. The data is then stored in a database inside a single column called Product. When I display the records in a datagrid, I would like to display each of the name in the form of a hyperlink.
If there are 3 names, then there will be 3 hyperlinks. Anyone has any suggestions on how to proceed?
Create a template column. Set the value for the template field to a Function/void that inserts a new hyperlink into the cell. To handle more than 1 link per row split the string into an Array & add a new hyperklink for each dimens...multi-column HG index vs. multiple single-column HG index
In IQ 12.4.3, HG index could be created upon multiple columns. My questions
1) in terms of query performance, which one is better -- one
multiple-column HG index or multiple single-column HG indexes?
2) And what about the load performance?
3) If one column is part of a multi-column HG index, do it make sense to
create a seperate HG/LF index for it?
Thanks in advance,
Number one, I don't know (great start, eh?).
Speaking from ignorance, though, I would bet the following are all true:
(1) If your HG index columns correspond exactly to your group ...Using Headers spannig multiple columns & aspbound columns together in the same datagrid
I am trying to format a datagrid to display my data. I have some headers that span multiple columns. I was able to implement this using the following code structure.
<td rowspan="2" colspan="1" width="40%">Model</td>
<td rowspan="1" colspan="4">Sales</td>
<td rowspan="2" colspan="1">Distribution</td>
<td rowspan="2" colspan="1"...How to manipulate images and combe multiple database columns into one column in a GridView control
Hi Folks,I'm hoping someone can help me out with something.I am trying to put together a photo album as a learning exercise and have a GridView control with two columns linked to an Access Data Source. In the left hand column (called Image) I want to display the photo and in the right hand column (called Details) I want to provide details such as Date, Location, People and Comments, Camera Type etc. Each of these is columns is taken from the database I have set up.However, I have am having some problems:1: At the moment I have been able to get the image to display (using an image column ...Column within a column in a DataGrid
I have a DataGrid on which I would like to divide a particular column into 2 to display a number information on the sub column?? Visually I'm speaking something like this below.
| ACCOUNTID | ACCOUNT NO |
| 1000 | | 125364 |
| 1015 | | 125365 |
| 1025 | | 125312 |
My question again is how to see this extra sub column within the ACCOUNTID Column here.
Looking for a quick reply.