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...How to display a column data partially but need complete column data for update?
I have a column in my gridview that contains API KEYS for google maps. These keys are huge so i just need to display partial key for viewing purpose. But I need the complete key when user clicks on update button in gridview. How can I achieve this? Any ideas. I am copying part of my gridview aspx code. Rest of the code is coming from my class file for object datasource.
<asp:GridView ID="gvDomains" runat="server" DataSourceID="odsDomains" AutoGenerateColumns="False" DataKeyNames="DomainID" Height="147px" Width="30...Display Multiple Columns into One Column
My first ASP.NET/SQL project. I'm creating an Asset Management DB. I wish to view the Asset number, the full name of the user it's assigned to and the Make and Model of each record in the DB. However assets are split into different categories e.g. monitors, PCs, Preinters etc. and they are all in different tables. The SQL below displays the asset number, Name of person assigned and the model of the asset.
SELECT Hardware.AssetNo, [User].FullName, MonitorModel.Model, PCModel.Model AS Expr1, PrinterModel.Model AS Expr2
FROM Hardware INNER JOIN
[User] ON Hardware.UserID = [User].User...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 &...How to break the datatype TEXT data across multiple VARCHAR(255) columns within a single row in Sybase?
Thank you for your help.
...Create multiple datagrid columns from single column
I have a datagrid that generates a single column of data that is extremely long. I'd like to find a method to create multiple columns from the single column so the data is easier to read.
I have tried the DIV method to create a scroll bar, but it's still a single column of data. The other goal is to make the data printable. If I can crop the column when it hits the bottom of the page, and then start it again on a new column it will be easier to read and printable.
Is this possible? Should I be using a different control other than a datagrid?
Thanks!------------------------------...DDDW Display column VS Data column
I have 2 codes that are different.
like aaa, bbb (data column) but for their description (display column)
it is same. "Test"
and when I choose bbb, it only takes aaa.
It looks like it does not care about data column.
it looks up the display column and then takes the first match.
and itemchanged even won't even get fired.
Is this true about datawindow service? if so, why?
or is there any other way to get around it?
If the display values are the same, how does the user know which one to
choose? You need to make the display values unique.
You could do ...Filter problem in display column and data column
I have a strange situation and needs to solve immediately.
I have a generic window to maintain different tables through different
The datawindows will be assigned dynamically based on the user selection.
I have provided filter functionality in this generic window using PFC
Now, my problem is, in each datawindow some of the columns I am using as
drop down datawindows to display coulmns and data columns on the behind.
When user tries to filter on one column which has drop down datawindow, it
is giving an error as "Invalid filter", which is right ...Sorting columns when displaying single column in DataList
Currently, I am using the DataList to display the data. My DataList code looks something like this:<datalist><itemTemplate><tr><td>Name:</td><td><% DataBinder.....%></td></tr><tr><td>Company:</td><td><% DataBinder.....%></td></tr></itemTemplate></datalist> My question is: How can I have an easy way of sorting this data. I would like the users to be able to sort the data by Name or by Company. I understand I can add AllowSorting to DataList or DataGrid, but then I would have to di...how to display data in multiple columns
Hi, I use DataGrid control to display a table with have 2 fields. I want to display to data in the following format
row# field1 field2 row# field1 field2
1 xxx xxx 4 xxx xxx
2 xxx xxx 5 xxx xxx
3 xxx xxx 6 xxx xxx
how to define the datagrid template to archieve it? Do I need 2 datagrid controls?
Switch to a DataList, and you can display like this by setting RepeatDirection = "Vertical" and RepeatColumns = "2".
...Display multiple columns in Gridview from One Column of SQL table
Hi I have a table in sql with 2 columns and I want to display that in multiple columns in Gridview.
3 &...Display only Columns that have Data in GridView Control
Good evening to the community, thanks for the help that ever provideThe situation is the following:I'm working in a application that have like 50 columns in the Database that represents Earning Codes for employees, but most of the times only 10 are used.What if something can be done to only display in the GridView Control the columns that the value is different than Null. Thanks for any lead evick
If you set the gridview to auto create the columns based on the datasource then when selecting data from the db only return the columns that have data in them. aspro Please m...Display Multiple Columns from the Database in One Column of a Table in the Form
Hi, I have a table with several columns in the database and I want to display this some of these cols in one column. So for example: I have in the table, NameCustomer, TitleCustomer, and DescriptionCustomer and I want to display this info in one col of a table, just like that: NameCustomer TitleCustomer DescriptionCustomer Those three in one col, I do not know if can use a datagrid or something else, Does any body has a suggestion?
Hi Use a repeater to populate your columns. Thanks Wonder is the beginning of wisdom[ If my p...