DataGrid boundcolumn problem

[tshad]

I want to use a datagrid with my display, but I don't want to use 1 row per
record.

What I have is a record with up to 6 values -
(answer1,answer 2,answer3,answe r4,answer5,answ er6). I want to display them
with alternating styles. One record may only have the first 3 fields with
data and another with 4 and still another with 6.

I want it to show as:

Answer1
Answer2
Answer3

or

Answer1
Answer2
Answer3
Answer4
Answer5

Can I set up a DataGrid this way?

Thanks,

Tom

[Ken Cox [Microsoft MVP]]

That looks more like a datalist than a datagrid.

Also, for horizontal display, you might want to if this grid is of any use
to you:

http://www.denisbauer.com/ASPNETCont...ierarGrid.aspx
"tshad" <ts**********@f tsolutions.com> wrote in message
news:OC******** ******@TK2MSFTN GP15.phx.gbl...

I want to use a datagrid with my display, but I don't want to use 1 row per
record.

What I have is a record with up to 6 values -
(answer1,answer 2,answer3,answe r4,answer5,answ er6). I want to display them
with alternating styles. One record may only have the first 3 fields with
data and another with 4 and still another with 6.

I want it to show as:

Answer1
Answer2
Answer3

or

Answer1
Answer2
Answer3
Answer4
Answer5

Can I set up a DataGrid this way?

Thanks,

Tom

[Eliyahu Goldin]

Tom,

If I understand you correctly, you want to show one record field per line.
For this you can bind you datagrid (or datalist as Ken has noted) to a
dataset with a table that will have records with one field only. You can
convert your original records to this new table either in a stored procedure
or in the code. In the latter case you will have to get the original table
in a dataset first, loop through the records and add every field with a
value to your new table as a separate row. Then bind the datagrid/datalist
to the new table.

Eliyahu

"tshad" <ts**********@f tsolutions.com> wrote in message
news:OC******** ******@TK2MSFTN GP15.phx.gbl...

I want to use a datagrid with my display, but I don't want to use 1 row per record.

What I have is a record with up to 6 values -
(answer1,answer 2,answer3,answe r4,answer5,answ er6). I want to display them
with alternating styles. One record may only have the first 3 fields with
data and another with 4 and still another with 6.

I want it to show as:

Answer1
Answer2
Answer3

or

Answer1
Answer2
Answer3
Answer4
Answer5

Can I set up a DataGrid this way?

Thanks,

Tom

[tshad]

"Ken Cox [Microsoft MVP]" <BA************ @sympatico.ca> wrote in message
news:O4******** ******@TK2MSFTN GP15.phx.gbl...

That looks more like a datalist than a datagrid.

Also, for horizontal display, you might want to if this grid is of any use
to you:

http://www.denisbauer.com/ASPNETCont...ierarGrid.aspx

This might do what I am trying to do, but it doesn't solve the 6 fields in
one record problem. Here is what I am trying to achieve.

As I added in my last post, my table is:

CREATE TABLE [dbo].[ScreenQuestions] (
[PositionID] [int] NOT NULL ,
[Unique] [int] NOT NULL ,
[Question] [text] NULL ,
[QuestionType] [char] (10) NULL ,
[Answer1] [text] NULL ,
[Answer2] [text] NULL ,
[Answer3] [text] NULL ,
[Answer4] [text] NULL ,
[Answer5] [text] NULL ,
[Answer6] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

What I want to do is set up a datalist that display all the questions., then
if the user pushes a button, it will display the answers below the question.
Something like:

+ Question 1
+ Question 2
+ Question 3

Then like a tree, if you push the "+" on a question, the answers will show
below in a grid, something like:

+ Question 1
- Question2
Answer1
Answer2
Answer3
Answer4
Answer5
+ Question3

Thanks,

Tom
"tshad" <ts**********@f tsolutions.com> wrote in message
news:OC******** ******@TK2MSFTN GP15.phx.gbl...

I want to use a datagrid with my display, but I don't want to use 1 row
per
record.

What I have is a record with up to 6 values -
(answer1,answer 2,answer3,answe r4,answer5,answ er6). I want to display
them
with alternating styles. One record may only have the first 3 fields
with
data and another with 4 and still another with 6.

I want it to show as:

Answer1
Answer2
Answer3

or

Answer1
Answer2
Answer3
Answer4
Answer5

Can I set up a DataGrid this way?

Thanks,

Tom

[tshad]

"Eliyahu Goldin" <re************ *@monarchmed.co m> wrote in message
news:%2******** *******@TK2MSFT NGP12.phx.gbl.. .

Tom,

If I understand you correctly, you want to show one record field per line.
For this you can bind you datagrid (or datalist as Ken has noted) to a
dataset with a table that will have records with one field only. You can
convert your original records to this new table either in a stored
procedure
or in the code. In the latter case you will have to get the original table
in a dataset first, loop through the records and add every field with a
value to your new table as a separate row. Then bind the datagrid/datalist
to the new table.
Are you talking about doing this just for the ASP page?

I assume you are talking about just getting rid of the old table completely
and create 2 (normalize).

CREATE TABLE [dbo].[ScreenQuestions] (
[PositionID] [int] NOT NULL ,
[Unique] [int] NOT NULL ,
[Question] [text] NULL ,
[QuestionType] [char] (10) NULL ,
[Answer1] [text] NULL ,
[Answer2] [text] NULL ,
[Answer3] [text] NULL ,
[Answer4] [text] NULL ,
[Answer5] [text] NULL ,
[Answer6] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

and change it to 2 tables:

CREATE TABLE [dbo].[ScreenQuestions] (
[PositionID] [int] NOT NULL ,
[Unique] [int] NOT NULL ,
[Question] [text] NULL ,
[QuestionType] [char] (10) NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[ScreenAnswers] (
[PositionID] [int] NOT NULL ,
[Unique] [int] NOT NULL ,
[Unique2] [int] NOT NULL,
[Answer] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

I was trying to get away from that, if possible.

At this point, I haven't got much data in the tables, as I am just starting
to set this up.

Thanks,

Tom
Eliyahu

"tshad" <ts**********@f tsolutions.com> wrote in message
news:OC******** ******@TK2MSFTN GP15.phx.gbl...

I want to use a datagrid with my display, but I don't want to use 1 row

per

record.

What I have is a record with up to 6 values -
(answer1,answer 2,answer3,answe r4,answer5,answ er6). I want to display
them
with alternating styles. One record may only have the first 3 fields
with
data and another with 4 and still another with 6.

I want it to show as:

Answer1
Answer2
Answer3

or

Answer1
Answer2
Answer3
Answer4
Answer5

Can I set up a DataGrid this way?

Thanks,

Tom

[Eliyahu Goldin]

Now is it much clearer. You have a standard case of master-details
relationship. Yes, you need 2 tables for this, as you suggest. You don't
need to get away from that. One table is a very bad idea.

Eliyahu

"tshad" <ts**********@f tsolutions.com> wrote in message
news:eO******** ******@TK2MSFTN GP14.phx.gbl...

"Eliyahu Goldin" <re************ *@monarchmed.co m> wrote in message
news:%2******** *******@TK2MSFT NGP12.phx.gbl.. .

Tom,

If I understand you correctly, you want to show one record field per line. For this you can bind you datagrid (or datalist as Ken has noted) to a
dataset with a table that will have records with one field only. You can
convert your original records to this new table either in a stored
procedure
or in the code. In the latter case you will have to get the original table in a dataset first, loop through the records and add every field with a
value to your new table as a separate row. Then bind the datagrid/datalist to the new table.
Are you talking about doing this just for the ASP page?

I assume you are talking about just getting rid of the old table

completely and create 2 (normalize).

CREATE TABLE [dbo].[ScreenQuestions] (
[PositionID] [int] NOT NULL ,
[Unique] [int] NOT NULL ,
[Question] [text] NULL ,
[QuestionType] [char] (10) NULL ,
[Answer1] [text] NULL ,
[Answer2] [text] NULL ,
[Answer3] [text] NULL ,
[Answer4] [text] NULL ,
[Answer5] [text] NULL ,
[Answer6] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

and change it to 2 tables:

CREATE TABLE [dbo].[ScreenQuestions] (
[PositionID] [int] NOT NULL ,
[Unique] [int] NOT NULL ,
[Question] [text] NULL ,
[QuestionType] [char] (10) NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

CREATE TABLE [dbo].[ScreenAnswers] (
[PositionID] [int] NOT NULL ,
[Unique] [int] NOT NULL ,
[Unique2] [int] NOT NULL,
[Answer] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

I was trying to get away from that, if possible.

At this point, I haven't got much data in the tables, as I am just starting to set this up.

Thanks,

Tom

Eliyahu

"tshad" <ts**********@f tsolutions.com> wrote in message
news:OC******** ******@TK2MSFTN GP15.phx.gbl...

I want to use a datagrid with my display, but I don't want to use 1 row

per

record.

What I have is a record with up to 6 values -
(answer1,answer 2,answer3,answe r4,answer5,answ er6). I want to display
them
with alternating styles. One record may only have the first 3 fields
with
data and another with 4 and still another with 6.

I want it to show as:

Answer1
Answer2
Answer3

or

Answer1
Answer2
Answer3
Answer4
Answer5

Can I set up a DataGrid this way?

Thanks,

Tom