ASP.NET

gridview

Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jul 2009

Posts: 5

Reputation: shireesha1 is an unknown quantity at this point

Solved Threads: 0

shireesha1 shireesha1 is offline

Offline

Newbie Poster

gridview

Jul 2nd, 2009

Hi people,

I am working on a asp.net c# project where i need a drop down list and check boxes in a grid view. can any one help me out how to do this.

thanks in advance
shireesha

•

Join Date: Oct 2008

Posts: 2,721

Reputation: adatapost has much to be proud of

Solved Threads: 501

adatapost

Offline

Posting Maven

Re: gridview

Jul 2nd, 2009

Use TemplatedColumn.

•

Join Date: May 2008

Posts: 43

Reputation: sebastian3 is an unknown quantity at this point

Solved Threads: 1

sebastian3 sebastian3 is offline

Offline

Light Poster

Re: gridview

Jul 2nd, 2009

Follow this example :

Help with Code Tags

(Toggle Plain Text)

<asp:GridView ID="gvStates" AutoGenerateColumns="false"
     runat="server" OnRowCreated="gvStates_RowCreated">
  <Columns>
    <asp:BoundField HeaderText="State" DataField="Name" />
    <asp:TemplateField HeaderText="Cities">
      <ItemTemplate>
        <asp:DropDownList ID="ddlCities"
AutoPostBack="true" runat="server" 
>
        </asp:DropDownList>
      </ItemTemplate>
    </asp:TemplateField>
  </Columns>
</asp:GridView>




protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack)
   {
       // Create states array and bind it to Grid
       ArrayList states = new ArrayList();

       string[] cities = 
           new string[] { "Portland", "Salem", "Eugene" };
       State state = new State("OR", cities);
       states.Add(state);
       cities = 
           new string[] { "Seattle", "Tacoma", "Olympia" };
       state = new State("WA", cities);
       states.Add(state);

       this.gvStates.DataSource = states;
       this.gvStates.DataBind();
   }
}

protected void gvStates_RowCreated(object sender, 
    GridViewRowEventArgs e)
{
   if (!IsPostBack)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
           // Bind drop down to cities
           DropDownList ddl = 
             (DropDownList)e.Row.FindControl("ddlCities");
           ddl.DataSource = ((State)e.Row.DataItem).Cities;
           ddl.DataBind();
       }
   }
}

Tell if it solved.

•

Join Date: Jul 2009

Posts: 5

Reputation: shireesha1 is an unknown quantity at this point

Solved Threads: 0

shireesha1 shireesha1 is offline

Offline

Newbie Poster

Re: gridview

Jul 2nd, 2009

•

Originally Posted by sebastian3

Follow this example :
Help with Code Tags

(Toggle Plain Text)
<asp:GridView ID="gvStates" AutoGenerateColumns="false"
     runat="server" OnRowCreated="gvStates_RowCreated">
  <Columns>
    <asp:BoundField HeaderText="State" DataField="Name" />
    <asp:TemplateField HeaderText="Cities">
      <ItemTemplate>
        <asp:DropDownList ID="ddlCities"
AutoPostBack="true" runat="server" 
>
        </asp:DropDownList>
      </ItemTemplate>
    </asp:TemplateField>
  </Columns>
</asp:GridView>




protected void Page_Load(object sender, EventArgs e)
{
   if (!IsPostBack)
   {
       // Create states array and bind it to Grid
       ArrayList states = new ArrayList();

       string[] cities = 
           new string[] { "Portland", "Salem", "Eugene" };
       State state = new State("OR", cities);
       states.Add(state);
       cities = 
           new string[] { "Seattle", "Tacoma", "Olympia" };
       state = new State("WA", cities);
       states.Add(state);

       this.gvStates.DataSource = states;
       this.gvStates.DataBind();
   }
}

protected void gvStates_RowCreated(object sender, 
    GridViewRowEventArgs e)
{
   if (!IsPostBack)
   {
       if (e.Row.RowType == DataControlRowType.DataRow)
       {
           // Bind drop down to cities
           DropDownList ddl = 
             (DropDownList)e.Row.FindControl("ddlCities");
           ddl.DataSource = ((State)e.Row.DataItem).Cities;
           ddl.DataBind();
       }
   }
}
<asp:GridView ID="gvStates" AutoGenerateColumns="false" runat="server" OnRowCreated="gvStates_RowCreated"> <Columns> <asp:BoundField HeaderText="State" DataField="Name" /> <asp:TemplateField HeaderText="Cities"> <ItemTemplate> <asp:DropDownList ID="ddlCities" AutoPostBack="true" runat="server" > </asp:DropDownList> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Create states array and bind it to Grid ArrayList states = new ArrayList(); string[] cities = new string[] { "Portland", "Salem", "Eugene" }; State state = new State("OR", cities); states.Add(state); cities = new string[] { "Seattle", "Tacoma", "Olympia" }; state = new State("WA", cities); states.Add(state); this.gvStates.DataSource = states; this.gvStates.DataBind(); } } protected void gvStates_RowCreated(object sender, GridViewRowEventArgs e) { if (!IsPostBack) { if (e.Row.RowType == DataControlRowType.DataRow) { // Bind drop down to cities DropDownList ddl = (DropDownList)e.Row.FindControl("ddlCities"); ddl.DataSource = ((State)e.Row.DataItem).Cities; ddl.DataBind(); } } }
Tell if it solved.

can you pl explain me what is State here?
State state = new State("OR", cities);

I am getting an error saying
": CS0246: The type or namespace name 'State' could not be found (are you missing a using directive or an assembly reference?)"

•

Join Date: May 2008

Posts: 43

Reputation: sebastian3 is an unknown quantity at this point

Solved Threads: 1

sebastian3 sebastian3 is offline

Offline

Light Poster

Re: gridview

Jul 3rd, 2009

You have to use your own Datasource instead of states and cities in the line this.gvStates.DataSource = states;
You can use your own function or ObjectDataSource as you like..

Please clarify what you have to do.

•

Join Date: Jun 2009

Posts: 452

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Offline

Posting Pro in Training

Re: gridview

Jul 3rd, 2009

Use this sample

HTML Source(.aspx)

Help with Code Tags

(Toggle Plain Text)

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DemoPage1.aspx.cs" Inherits="DemoPage1" %>
<!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 id="Head1" runat="server">
    <title>GridView Sample By Ramesh S</title>

    <script type="text/javascript">
        function selectUnselectCheckboxes(chkHeaderCtrl, chkBoxIdInGrid, gridViewName) {
            var chkbox = chkBoxIdInGrid;
            gridViewName = document.getElementById(gridViewName);
            var grdCount = gridViewName.rows.length;

            //the controls in the gridview will have the following suffix in their ids 'GridView1_ctl0n'
            //the first element starts with 2 e.g. GridView1_ctl02_chkEmployee(first element)... GridView1_ctl10_chkEmployee(9th element)
            for (i = 2; i <= grdCount; i++) {
                var ctlIndex = eval(i);
                if (ctlIndex < 10)
                    ctlIndex = '0' + ctlIndex;

                var chkBoxIdInGrid = gridViewName.id + '_ctl' + ctlIndex + '_' + chkbox;
                chkBoxIdInGrid = document.getElementById(chkBoxIdInGrid);

                if (chkBoxIdInGrid != null) {
                    //if the header checkbox is checked, then check the checkboxes in the grid
                    if (document.getElementById(chkHeaderCtrl).checked == true)
                        chkBoxIdInGrid.checked = true;
                    else
                        chkBoxIdInGrid.checked = false;
                }
            }
        }  
    
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table width="100%">
            <tr>
                <td>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="500px"
                        BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
                        CellPadding="4" OnRowDataBound="GridView1_RowDataBound">
                        <RowStyle BackColor="White" ForeColor="#003399" />
                        <Columns>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    <asp:CheckBox ID="chkSelectAll" ToolTip="Select/Unselect all employees" onclick="selectUnselectCheckboxes(this.id, 'chkEmployee', 'GridView1');"
                                        runat="server" />
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:CheckBox ID="chkEmployee" runat="server" Checked='<%# Bind("Is_Eligible") %>' />
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Center" />
                                <ItemStyle HorizontalAlign="Center" Width="50px" />
                            </asp:TemplateField>
                            <asp:BoundField DataField="EmpName" HeaderText="Name">
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:BoundField>
                            <asp:BoundField DataField="EmpCode" HeaderText="Code">
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:BoundField>
                            <asp:TemplateField HeaderText="Dept">
                                <ItemTemplate>
                                    <asp:DropDownList ID="ddlDept" DataTextField="Dname" DataValueField="Deptno" DataSource="<%#GetAllDept()%>"
                                        runat="server">
                                    </asp:DropDownList>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
                        <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
                        <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
                        <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
                    </asp:GridView>
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DemoPage1.aspx.cs" Inherits="DemoPage1" %>
<!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 id="Head1" runat="server">
    <title>GridView Sample By Ramesh S</title>

    <script type="text/javascript">
        function selectUnselectCheckboxes(chkHeaderCtrl, chkBoxIdInGrid, gridViewName) {
            var chkbox = chkBoxIdInGrid;
            gridViewName = document.getElementById(gridViewName);
            var grdCount = gridViewName.rows.length;

            //the controls in the gridview will have the following suffix in their ids 'GridView1_ctl0n'
            //the first element starts with 2 e.g. GridView1_ctl02_chkEmployee(first element)... GridView1_ctl10_chkEmployee(9th element)
            for (i = 2; i <= grdCount; i++) {
                var ctlIndex = eval(i);
                if (ctlIndex < 10)
                    ctlIndex = '0' + ctlIndex;

                var chkBoxIdInGrid = gridViewName.id + '_ctl' + ctlIndex + '_' + chkbox;
                chkBoxIdInGrid = document.getElementById(chkBoxIdInGrid);

                if (chkBoxIdInGrid != null) {
                    //if the header checkbox is checked, then check the checkboxes in the grid
                    if (document.getElementById(chkHeaderCtrl).checked == true)
                        chkBoxIdInGrid.checked = true;
                    else
                        chkBoxIdInGrid.checked = false;
                }
            }
        }  
    
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table width="100%">
            <tr>
                <td>
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="500px"
                        BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
                        CellPadding="4" OnRowDataBound="GridView1_RowDataBound">
                        <RowStyle BackColor="White" ForeColor="#003399" />
                        <Columns>
                            <asp:TemplateField>
                                <HeaderTemplate>
                                    <asp:CheckBox ID="chkSelectAll" ToolTip="Select/Unselect all employees" onclick="selectUnselectCheckboxes(this.id, 'chkEmployee', 'GridView1');"
                                        runat="server" />
                                </HeaderTemplate>
                                <ItemTemplate>
                                    <asp:CheckBox ID="chkEmployee" runat="server" Checked='<%# Bind("Is_Eligible") %>' />
                                </ItemTemplate>
                                <HeaderStyle HorizontalAlign="Center" />
                                <ItemStyle HorizontalAlign="Center" Width="50px" />
                            </asp:TemplateField>
                            <asp:BoundField DataField="EmpName" HeaderText="Name">
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:BoundField>
                            <asp:BoundField DataField="EmpCode" HeaderText="Code">
                                <HeaderStyle HorizontalAlign="Left" />
                            </asp:BoundField>
                            <asp:TemplateField HeaderText="Dept">
                                <ItemTemplate>
                                    <asp:DropDownList ID="ddlDept" DataTextField="Dname" DataValueField="Deptno" DataSource="<%#GetAllDept()%>"
                                        runat="server">
                                    </asp:DropDownList>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
                        <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
                        <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
                        <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
                    </asp:GridView>
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

C# code to be placed in code behind

Help with Code Tags

(Toggle Plain Text)

using System;
using System.Collections.Generic;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class DemoPage1 : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGridView();
        }
    }

    private void BindGridView()
    {
        DataTable dtEmp = new DataTable();

        dtEmp.Columns.Add("Is_Eligible", System.Type.GetType("System.Boolean"));
        dtEmp.Columns.Add("EmpName", System.Type.GetType("System.String"));
        dtEmp.Columns.Add("EmpCode", System.Type.GetType("System.Int16"));
        dtEmp.Columns.Add("Deptno", System.Type.GetType("System.Int16"));

        dtEmp.Rows.Add(new object[] { true, "Kannan", 1001, 10 });
        dtEmp.Rows.Add(new object[] { true, "Arun", 1001, 10 });
        dtEmp.Rows.Add(new object[] { false, "Jackson", 1001, 30 });
        dtEmp.Rows.Add(new object[] { true, "Raja", 1001, 20 });
        dtEmp.Rows.Add(new object[] { false, "John", 1001, 30 });

        GridView1.DataSource = dtEmp;
        GridView1.DataBind();
    }

    public DataTable GetAllDept()
    {
        DataTable dtDept = new DataTable();

        dtDept.Columns.Add("Deptno", System.Type.GetType("System.Int16"));
        dtDept.Columns.Add("Dname", System.Type.GetType("System.String"));

        dtDept.Rows.Add(new object[] { 10, "Accounts" });
        dtDept.Rows.Add(new object[] { 20, "Sales" });
        dtDept.Rows.Add(new object[] { 30, "Operations" });

        return dtDept;
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DropDownList ddlDeptNo = (DropDownList)e.Row.FindControl("ddlDept");
            string deptNo = ((System.Data.DataRowView)(e.Row.DataItem)).Row.ItemArray[3].ToString();
            if (ddlDeptNo != null)
            {
                ddlDeptNo.SelectedValue = deptNo;
            }

        }
    }
}

using System;
using System.Collections.Generic;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class DemoPage1 : System.Web.UI.Page
{

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGridView();
        }
    }

    private void BindGridView()
    {
        DataTable dtEmp = new DataTable();

        dtEmp.Columns.Add("Is_Eligible", System.Type.GetType("System.Boolean"));
        dtEmp.Columns.Add("EmpName", System.Type.GetType("System.String"));
        dtEmp.Columns.Add("EmpCode", System.Type.GetType("System.Int16"));
        dtEmp.Columns.Add("Deptno", System.Type.GetType("System.Int16"));

        dtEmp.Rows.Add(new object[] { true, "Kannan", 1001, 10 });
        dtEmp.Rows.Add(new object[] { true, "Arun", 1001, 10 });
        dtEmp.Rows.Add(new object[] { false, "Jackson", 1001, 30 });
        dtEmp.Rows.Add(new object[] { true, "Raja", 1001, 20 });
        dtEmp.Rows.Add(new object[] { false, "John", 1001, 30 });

        GridView1.DataSource = dtEmp;
        GridView1.DataBind();
    }

    public DataTable GetAllDept()
    {
        DataTable dtDept = new DataTable();

        dtDept.Columns.Add("Deptno", System.Type.GetType("System.Int16"));
        dtDept.Columns.Add("Dname", System.Type.GetType("System.String"));

        dtDept.Rows.Add(new object[] { 10, "Accounts" });
        dtDept.Rows.Add(new object[] { 20, "Sales" });
        dtDept.Rows.Add(new object[] { 30, "Operations" });

        return dtDept;
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DropDownList ddlDeptNo = (DropDownList)e.Row.FindControl("ddlDept");
            string deptNo = ((System.Data.DataRowView)(e.Row.DataItem)).Row.ItemArray[3].ToString();
            if (ddlDeptNo != null)
            {
                ddlDeptNo.SelectedValue = deptNo;
            }

        }
    }
}

•

Join Date: Jul 2009

Posts: 5

Reputation: shireesha1 is an unknown quantity at this point

Solved Threads: 0

shireesha1 shireesha1 is offline

Offline

Newbie Poster

Re: gridview

Jul 4th, 2009

what exactly i need is...i am trying to get data from sql server database and populate in grid view and in that grid view i have edit and delete buttons for each row. when i click on edit button the row should become editable like in the first column there will be dropdown and in the second column there will be check box so the user can select the data from drop down and mark the check box and save the row which should get updated back to database and when the user clicks on delete button that row gets deleted from database.This is exact scenario i need. Can any one help me out in this. If any one can give me some links or code to do this , it'l be very helpful..

thanks in advance...