GridView generated programmaticall y

[NKaufman]

<asp:GridView ID="Basic" runat="server"
DataKeyNames="Q uestionID,isHea ding" AutoGenerateCol umns="false"
AllowPaging="tr ue" PageSize="100">
<Columns>
<asp:BoundFie ld Visible="false" DataField="Ques tionID"
HeaderText="Que stionID"></asp:BoundField>
<asp:BoundFie ld DataField="Ques tionDesc"
HeaderText="Que stion"
ItemStyle-HorizontalAlign ="Left"></
asp:BoundField>
<asp:TemplateFi eld HeaderText="Ans wer">
<ItemTemplate >
<asp:RadioButto nList
RepeatDirection ="Horizontal " runat="server"
ID="rdAnswer" SelectedIndex=' <%#
SetState(DataBi nder.Eval
(Container.Data Item,"Answer")) %>'>
<asp:ListItem Value="0">Yes</
asp:ListItem>
<asp:ListItem Value="1">No</
asp:ListItem>
</asp:RadioButton List>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
</asp:GridView>

Hello,

I need to create a gridview programmaticall y in code that would be
similar to the above code (in design mode).\

Any pointers?

Thanks,

[John Timney \(MVP\)]

Someones already done it for you.
http://forums.asp.net/thread/1379019.aspx

Not sure why you wouldn't just use a templated gridview though!

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"NKaufman" <na****@hotmail .comwrote in message
news:11******** *************@o 5g2000hsb.googl egroups.com...

<asp:GridView ID="Basic" runat="server"
DataKeyNames="Q uestionID,isHea ding" AutoGenerateCol umns="false"
AllowPaging="tr ue" PageSize="100">
<Columns>
<asp:BoundFie ld Visible="false" DataField="Ques tionID"
HeaderText="Que stionID"></asp:BoundField>
<asp:BoundFie ld DataField="Ques tionDesc"
HeaderText="Que stion"
ItemStyle-HorizontalAlign ="Left"></
asp:BoundField>
<asp:TemplateFi eld HeaderText="Ans wer">
<ItemTemplate >
<asp:RadioButto nList
RepeatDirection ="Horizontal " runat="server"
ID="rdAnswer" SelectedIndex=' <%#
SetState(DataBi nder.Eval
(Container.Data Item,"Answer")) %>'>
<asp:ListItem Value="0">Yes</
asp:ListItem>
<asp:ListItem Value="1">No</
asp:ListItem>
</asp:RadioButton List>
</ItemTemplate>
</asp:TemplateFie ld>
</Columns>
</asp:GridView>

Hello,

I need to create a gridview programmaticall y in code that would be
similar to the above code (in design mode).\

Any pointers?

Thanks,

[NKaufman]

Hello John,

Following are some of the issues in the example you cited:
(1) All columns of datatable will be displayed. In my case, I need
some columns to be visible and some are not.
(2) Does not handle DataKeys that I need
(3) Does not handle adding a control like the radiobuttonlist that I
need

In a post from the same thread - "why not a basic gridview? .....
since one your example you are not doing additional formatting to the
data other than creating bound columns."

Thanks for you assistance.
On Mar 28, 4:09 pm, "John Timney \(MVP\)"
<x_j...@timney. eclipse.co.ukwr ote:

Someones already done it for you.http://forums.asp.net/thread/1379019.aspx

Not sure why you wouldn't just use a templated gridview though!

Regards

John Timney (MVP)http://www.johntimney.comhttp://www.johntimney.com/blog

[John Timney \(MVP\)]

I didn't think the example gave you a perfect solution, only that it would
give you an idea of how to create a datagrid dynamically.

If you use a template against a gridview then you can BIND and EVAL against
any of the datatable values and structure your output as you need it,

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"NKaufman" <na****@hotmail .comwrote in message
news:11******** **************@ y80g2000hsf.goo glegroups.com.. .

Hello John,

Following are some of the issues in the example you cited:
(1) All columns of datatable will be displayed. In my case, I need
some columns to be visible and some are not.
(2) Does not handle DataKeys that I need
(3) Does not handle adding a control like the radiobuttonlist that I
need

In a post from the same thread - "why not a basic gridview? .....
since one your example you are not doing additional formatting to the
data other than creating bound columns."

Thanks for you assistance.
On Mar 28, 4:09 pm, "John Timney \(MVP\)"
<x_j...@timney. eclipse.co.ukwr ote:

>Someones already done it for
you.http://forums.asp.net/thread/1379019.aspx

Not sure why you wouldn't just use a templated gridview though!

Regards

John Timney (MVP)http://www.johntimney.comhttp://www.johntimney.com/blog

[=?Utf-8?B?UGFydmF0aHkgUGFkbWFuYWJoYW4=?=]

Hi,

To generate a gridView programmaticall y, you need to create a GridView
object and assign the properties that you had mentioned.
BoundField objects can be created and added to the gridview object.
Problem comes only when you need to add an ItemTemplate column. I tried a
sample code for the exact same gridView code that you had posted.

//My sample datatable which i am using to bind to the grid view.
DataTable dtSource = new DataTable();
dtSource.Column s.Add("Question ID");
dtSource.Column s.Add("Question Desc");
dtSource.Column s.Add("Answer") ;
dtSource.Column s.Add("isHeadin g");

DataRow dr = dtSource.NewRow ();
dr[0] = "Q1";
dr[1] = "I like reading books ";
dr[2] = "1";
dr[3] = "true";
dtSource.Rows.A dd(dr);

dr = dtSource.NewRow ();
dr[0] = "Q2";
dr[1] = "I watch a lot of TV";
dr[2] = "0";
dr[3] = "false";
dtSource.Rows.A dd(dr);
//Creating a gridView

GridView gvBasic = new GridView();

gvBasic.DataKey Names="Question ID,isHeading".S plit(",".ToChar Array());
gvBasic.AutoGen erateColumns = false;
gvBasic.AllowPa ging = true;
gvBasic.PageSiz e = 100;
gvBasic.DataSou rce = dtSource;

//Your column 1 that is hidden

BoundField objCol1 = new BoundField();
objCol1.Visible = false;
objCol1.DataFie ld = "QuestionID ";
objCol1.HeaderT ext = "QuestionID ";
gvBasic.Columns .Add(objCol1);

//Your column 2 that has the questions

BoundField objCol2 = new BoundField();
objCol2.DataFie ld = "QuestionDe sc";
objCol2.HeaderT ext = "Question";
objCol2.ItemSty le.HorizontalAl ign = HorizontalAlign .Left;
gvBasic.Columns .Add(objCol2);

//ItemTemplate is an Interface in dotnet and hence,
//Create an ItemTemplate class which implements the interface.

// Your column three which has the radiobuttonList on it

TemplateField objCol3 = new TemplateField() ;
objCol3.HeaderT ext = "Answer";
ItemTemplate objTemplate = new ItemTemplate("r dAnswer", dtSource);
objCol3.ItemTem plate = objTemplate;

gvBasic.Columns .Add(objCol3);

gvBasic.DataBin d();
Page.Form.Contr ols.Add(gvBasic );

Code for the ItemTemplate class:
public class ItemTemplate : ITemplate
{

string ControlName = "";
object DataSource = null;

//ControlName: Name of the radio button list.
// DataSource is the datatable to which the gridview is bound to.

public ItemTemplate(st ring ControlName,obj ect DataSource)
{
this.ControlNam e = ControlName;
this.DataSource = DataSource;
}
public void InstantiateIn(C ontrol objContainer)
{
RadioButtonList rdAnswer = new RadioButtonList ();
rdAnswer.ID = this.ControlNam e;

//An event is added to traverse every row that is bound to the
//gridview to fetch the answer column.

rdAnswer.DataBi nding += new EventHandler(th is.OnDataBindin g);
ListItem lst1 = new ListItem("Yes", "0");
ListItem lst2 = new ListItem("No"," 1");
rdAnswer.Items. Add(lst1);
rdAnswer.Items. Add(lst2);
objContainer.Co ntrols.Add(rdAn swer);

}

public void OnDataBinding(o bject sender, EventArgs e)
{
RadioButtonList rdAnswer = (RadioButtonLis t)sender;
GridViewRow container = (GridViewRow)rd Answer.NamingCo ntainer;

//Setting the value of the selected index - This is the replacement for the
eval.

rdAnswer.Select edIndex =
int.Parse(((Dat aRowView)contai ner.DataItem).R ow.ItemArray[2].ToString());

}

}

I guess you shd be all set with this code sample above.

- Parvathy Padmanabhan

[NKaufman]

Parvathy,

Excellent. I will try this and let you know.
Thanks,

On Mar 30, 6:46 pm, Parvathy Padmanabhan
<ParvathyPadman ab...@discussio ns.microsoft.co mwrote:

Hi,

To generate a gridView programmaticall y, you need to create a GridView
object and assign the properties that you had mentioned.
BoundField objects can be created and added to the gridview object.
Problem comes only when you need to add an ItemTemplate column. I tried a
sample code for the exact same gridView code that you had posted.

//My sample datatable which i am using to bind to the grid view.
DataTable dtSource = new DataTable();
dtSource.Column s.Add("Question ID");
dtSource.Column s.Add("Question Desc");
dtSource.Column s.Add("Answer") ;
dtSource.Column s.Add("isHeadin g");

DataRow dr = dtSource.NewRow ();
dr[0] = "Q1";
dr[1] = "I like reading books ";
dr[2] = "1";
dr[3] = "true";
dtSource.Rows.A dd(dr);

dr = dtSource.NewRow ();
dr[0] = "Q2";
dr[1] = "I watch a lot of TV";
dr[2] = "0";
dr[3] = "false";
dtSource.Rows.A dd(dr);

//Creating a gridView

GridView gvBasic = new GridView();

gvBasic.DataKey Names="Question ID,isHeading".S plit(",".ToChar Array());
gvBasic.AutoGen erateColumns = false;
gvBasic.AllowPa ging = true;
gvBasic.PageSiz e = 100;
gvBasic.DataSou rce = dtSource;

//Your column 1 that is hidden

BoundField objCol1 = new BoundField();
objCol1.Visible = false;
objCol1.DataFie ld = "QuestionID ";
objCol1.HeaderT ext = "QuestionID ";
gvBasic.Columns .Add(objCol1);

//Your column 2 that has the questions

BoundField objCol2 = new BoundField();
objCol2.DataFie ld = "QuestionDe sc";
objCol2.HeaderT ext = "Question";
objCol2.ItemSty le.HorizontalAl ign = HorizontalAlign .Left;
gvBasic.Columns .Add(objCol2);

//ItemTemplate is an Interface in dotnet and hence,
//Create an ItemTemplate class which implements the interface.

// Your column three which has the radiobuttonList on it

TemplateField objCol3 = new TemplateField() ;
objCol3.HeaderT ext = "Answer";
ItemTemplate objTemplate = new ItemTemplate("r dAnswer", dtSource);
objCol3.ItemTem plate = objTemplate;

gvBasic.Columns .Add(objCol3);

gvBasic.DataBin d();
Page.Form.Contr ols.Add(gvBasic );

Code for the ItemTemplate class:

public class ItemTemplate : ITemplate
{

string ControlName = "";
object DataSource = null;

//ControlName: Name of the radio button list.
// DataSource is the datatable to which the gridview is bound to.

public ItemTemplate(st ring ControlName,obj ect DataSource)
{
this.ControlNam e = ControlName;
this.DataSource = DataSource;
}

public void InstantiateIn(C ontrol objContainer)
{
RadioButtonList rdAnswer = new RadioButtonList ();
rdAnswer.ID = this.ControlNam e;

//An event is added to traverse every row that is bound to the
//gridview to fetch the answer column.

rdAnswer.DataBi nding += new EventHandler(th is.OnDataBindin g);
ListItem lst1 = new ListItem("Yes", "0");
ListItem lst2 = new ListItem("No"," 1");
rdAnswer.Items. Add(lst1);
rdAnswer.Items. Add(lst2);
objContainer.Co ntrols.Add(rdAn swer);

}

public void OnDataBinding(o bject sender, EventArgs e)
{
RadioButtonList rdAnswer = (RadioButtonLis t)sender;
GridViewRow container = (GridViewRow)rd Answer.NamingCo ntainer;

//Setting the value of the selected index - This is the replacement for the
eval.

rdAnswer.Select edIndex =
int.Parse(((Dat aRowView)contai ner.DataItem).R ow.ItemArray[2].ToString());

}

}

I guess you shd be all set with this code sample above.

- Parvathy Padmanabhan