how to add columns/rows to WebData grid at run time without binding the datase to the grid (Version :2011, vol 1)

110

vineet posted over 12 years ago

Hi,

Software Environment : Visual Studio 2010, Windows XP. Infragistics Web data grid 2011.1.

1) Can we add rows and columns to the web data grid at run time without binding any dataset or datatable to the webdata grid.

2) I have a grid where first 8 rows will have different set of data, which require having drop downs, textboxes, lables etc in cells.

3) From 9th row onwards, i will have a different set of data which require textboxes in grid cells.

4) If this can be done, then pls provide the code snippet for this ?

5) Also, if there is any complete E-book kind of thing for Webdata grid, then pls let me know the link for that. We are new to the webdata grid and not sure whatever approach we are taking is correct not. An e-book on Webdatagrid will help us a lot and will also help Infragistics as our support questions will also come down :)

Thanks
Vineet

Parents

15979

Suggested Answer
Alex E posted over 12 years ago
Hello Vineet,

I will attempt to answer your questions in the order they were asked:

1.      Yes, there are Unbound columns and Template columns that can be used for this purpose. These types of columns do not require Data Source to be applied to them to function correctly. More information about Unbound and Template columns you can find here - http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.1/CLR4.0/html/WebDataGrid_Columns.html
How you can add columns at runtime you can see here - http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.1/CLR4.0/html/WebDataGrid_Add_or_Remove_a_Column.html

2.      In this scenario you can use Template columns. In this type of columns you can insert different type of ASP and HTML controls - http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.1/CLR4.0/html/WebDataGrid_Column_Templates.html

The grid has “InitializeRow” event. This event is fired once for every row on grid initialization. It can be used to show or hide some of the controls inserted in the templates. For example:

<ig:TemplateDataField Key="Button">

    <ItemTemplate>

       <asp:Button id="btn1" Text="test" runat="server" />

              <asp:TextBox ID="tBox1" runat="server" EnableViewState="true" />

    </ItemTemplate>

<Header Text="ASPTextBox" />

</ig:TemplateDataField>

protected void WebDataGrid1_InitializeRow(object sender, Infragistics.Web.UI.GridControls.RowEventArgs e)

    {

        if (e.Row.Index == 3)

        {

            Button btn = (Button)e.Row.Items[4].FindControl("btn1");

            btn.Visible = false; // hides the button inserted in the template

        }



    }

3.      Same as point 2 – you can hide other controls and leave only text boxes.

4.      Provided in point 2.

5.      Documentation for the “WebDataGrid” can be found in the following link - http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.1/CLR4.0/html/Web_WebDataGrid_WebDataGrid.html

Live samples of the grid can be reviewed here - http://samples.infragistics.com/aspnet/ComponentOverview.aspx?cn=data-grid

Let me know if you have additional questions.
Cancel
Reply

Reject Answer

Cancel

Reply

110

vineet posted over 12 years ago in reply to Alex E

Hi,

I created a grid as per ur suggestions. That grid is not bound to any data source. When i run the application, the grid is not visible. I want to do twot things.

1) Every time on page load, i want to display some blank rows. This means, even if there is no data in grid, i should see at least two rows in the grid.

2) On a button click I want to add rows to the grid.

Below is the code i have written in the page

.aspx Page Code:

<%

@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default"
%>
<%

@ Register assembly="Infragistics35.Web.v11.1, Version=11.1.20111.2158, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.Web.UI.GridControls" tagprefix="ig"
%>
<%

@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp"
%>

<!

DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<

html xmlns
="http://www.w3.org/1999/xhtml">
<

head runat
="server">

<title></title
>
</

head
>
<

body
>

<form id="form1" runat
="server">

<div
>

<asp:Button ID="btnSave" Text="Save" runat="server" Visible="true"/>

</div
>

<div
>

<ig:WebDataGrid ID="WebDataGrid1" runat="server" Height="350px" Width="400px"

oninitializerow
="WebDataGrid1_InitializeRow">

<Columns
>

<ig:TemplateDataField Key="RowId" VisibleIndex
="0">

<Header Text="Row Id"
/>

<ItemTemplate
>

<asp:TextBox ID="tBox1" runat="server" EnableViewState="true"
/>

<asp:DropDownList ID="ddlListbox" runat="server" EnableViewState="true"></asp:DropDownList>

</ItemTemplate>

</ig:TemplateDataField
>

<ig:TemplateDataField Key="Title" VisibleIndex
="1">

<Header Text="TemplateField_0"
/>

<ItemTemplate
>

<asp:TextBox ID="TextBox1" runat="server" EnableViewState="true"
/>

<asp:DropDownList ID="DropDownList1" runat="server" EnableViewState="true"></asp:DropDownList>

</ItemTemplate>

</ig:TemplateDataField
>

</Columns
>

</ig:WebDataGrid
>

<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat
="server">

</asp:ToolkitScriptManager
>

</div
>

</form
>
</

body
>
</

html
>

.cs File Code

protected

void WebDataGrid1_InitializeRow(object sender, Infragistics.Web.UI.GridControls.RowEventArgs
e)
{

if
(e.Row.Index<=5)
{

TextBox txtboxcontrol =(TextBox)e.Row.Items[0].FindControl("tBox1"
);

if (txtboxcontrol != null
)
{

txtboxcontrol.Visible =

false
;
}

TextBox txtboxcontrol1 =(TextBox)e.Row.Items[1].FindControl("tBox1"
);

if (txtboxcontrol1 != null
)
{

txtboxcontrol1.Visible =

false
;
}

}

if
(e.Row.Index >= 6)
{

DropDownList ddllist = (DropDownList)e.Row.Items[0].FindControl("ddlListbox"
);

if (ddllist != null
)
{

ddllist.Visible =

false
;
}

DropDownList ddllist1 = (DropDownList)e.Row.Items[1].FindControl("ddlListbox"
);

if (ddllist1 != null
)
{

ddllist1.Visible =

false
;
}

}

// if (e.Row.Index >= 6)

}
Cancel
Reply

Cancel

Children

15979

Suggested Answer
Alex E posted over 12 years ago in reply to vineet

Hello Vineet,

You can add row in the grid from Client-Side like shown here - http://help.infragistics.com/Help/NetAdvantage/ASPNET/2011.2/CLR4.0/html/WebDataGrid_Row_Adding.html

Sample of how to add new row you can download from the following thread - http://community.infragistics.com/forums/p/60543/308040.aspx
Cancel
Reply

Reject Answer

Cancel