Cannot Bind Check Box in DataGrid

[Nu2ASP.NET]

I have the following code in my code behind page:

using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
using System.Data.Sql Client;

namespace CheckBoxTest
{
/// <summary>
/// Summary description for WebForm1.
public class WebForm1 : System.Web.UI.P age
{
protected System.Web.UI.W ebControls.Data Grid MyDataGrid;
SqlConnection myConnection;
private void Page_Load(objec t sender, System.EventArg s e)
{
myConnection = new SqlConnection

("Server=localh ost;uid=sa;pwd= preview;databas e=pubs");

if(!IsPostBack)
BindGrid();
}

private void MyDataGrid_Item DataBound(objec t sender,
System.Web.UI.W ebControls.Data GridItemEventAr gs e)
{
CheckBox cb = e.Item.FindCont rol("contract") as CheckBox;

if(cb != null)
{
if(DataBinder.E val(e.Item.Data Item,
"contract")!=DB Null.Value)
{
if(Convert.ToBo olean(DataBinde r.Eval(e.Item.D ataItem,
"contract") ) )
cb.Checked = true;
else
cb.Checked = false;
}
}
}

public void BindGrid()
{
SqlDataAdapter dAdapter = new SqlDataAdapter ("SELECT *
FROM authors ",
myConnection);
DataSet dSet= new DataSet();
dAdapter.Fill(d Set, "authors");

MyDataGrid.Data Source =
dSet.Tables["authors"].DefaultView;
MyDataGrid.Data Bind();
}

#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form
Designer.
//
InitializeCompo nent();
base.OnInit(e);

}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.MyDataGrid .ItemDataBound += new
System.Web.UI.W ebControls.Data GridItemEventHa ndler
(this.MyDataGri d_ItemDataBound );

this.Load += new System.EventHan dler(this.Page_ Load);

}
#endregion
}
}

The problem I'm having is that the checkbox is not properly reflecting
the state of the underlying data field, which, in this case, is an SQL
2000 bit type. All of the checkboxes appear unchecked. (I want the
check box to appear checked if the underlying data field contains a "1"
and unchecked if it contains a "0".)

I added the event handler for the ItemDataBound event to
InitializeCompo nent, since that's where it seemed to make the most
sense.

Am I missing something *really* obviously wrong here?

Thanks!!!

[Elton W]

Try following in MyDataGrid_Item DataBound

if(e.Item.Itemt ype == ListItemType.It em || e.Item.ItemType ==
ListItemType.Al ternatingItem)
{
CheckBox cb = (CheckBox)e.Ite m.FindControl(" contract");
DataRowView drv = (DataRowView)e. Item.DataItem;
if(cb != null && !drv.Row.IsNull ("contract") )
{
cb.Checked = (bool)drv["contract"];

}
}
HTH

Elton Wang
"Nu2ASP.NET " wrote:

I have the following code in my code behind page:

using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
using System.Data.Sql Client;

namespace CheckBoxTest
{
/// <summary>
/// Summary description for WebForm1.
public class WebForm1 : System.Web.UI.P age
{
protected System.Web.UI.W ebControls.Data Grid MyDataGrid;
SqlConnection myConnection;
private void Page_Load(objec t sender, System.EventArg s e)
{
myConnection = new SqlConnection

("Server=localh ost;uid=sa;pwd= preview;databas e=pubs");

if(!IsPostBack)
BindGrid();
}

private void MyDataGrid_Item DataBound(objec t sender,
System.Web.UI.W ebControls.Data GridItemEventAr gs e)
{
CheckBox cb = e.Item.FindCont rol("contract") as CheckBox;

if(cb != null)
{
if(DataBinder.E val(e.Item.Data Item,
"contract")!=DB Null.Value)
{
if(Convert.ToBo olean(DataBinde r.Eval(e.Item.D ataItem,
"contract") ) )
cb.Checked = true;
else
cb.Checked = false;
}
}
}

public void BindGrid()
{
SqlDataAdapter dAdapter = new SqlDataAdapter ("SELECT *
FROM authors ",
myConnection);
DataSet dSet= new DataSet();
dAdapter.Fill(d Set, "authors");

MyDataGrid.Data Source =
dSet.Tables["authors"].DefaultView;
MyDataGrid.Data Bind();
}

#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form
Designer.
//
InitializeCompo nent();
base.OnInit(e);

}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.MyDataGrid .ItemDataBound += new
System.Web.UI.W ebControls.Data GridItemEventHa ndler
(this.MyDataGri d_ItemDataBound );

this.Load += new System.EventHan dler(this.Page_ Load);

}
#endregion
}
}

The problem I'm having is that the checkbox is not properly reflecting
the state of the underlying data field, which, in this case, is an SQL
2000 bit type. All of the checkboxes appear unchecked. (I want the
check box to appear checked if the underlying data field contains a "1"
and unchecked if it contains a "0".)

I added the event handler for the ItemDataBound event to
InitializeCompo nent, since that's where it seemed to make the most
sense.

Am I missing something *really* obviously wrong here?

Thanks!!!

[Patrick.O.Ige]

Nu3Asp.NET try looking through this sample at:-
http://www.dotnetjohn.com/articles.aspx?articleid=76
It should help
Patrick
"Nu2ASP.NET " <ms************ *@yahoo.com> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

I have the following code in my code behind page:

using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
using System.Data.Sql Client;

namespace CheckBoxTest
{
/// <summary>
/// Summary description for WebForm1.
public class WebForm1 : System.Web.UI.P age
{
protected System.Web.UI.W ebControls.Data Grid MyDataGrid;
SqlConnection myConnection;
private void Page_Load(objec t sender, System.EventArg s e)
{
myConnection = new SqlConnection

("Server=localh ost;uid=sa;pwd= preview;databas e=pubs");

if(!IsPostBack)
BindGrid();
}

private void MyDataGrid_Item DataBound(objec t sender,
System.Web.UI.W ebControls.Data GridItemEventAr gs e)
{
CheckBox cb = e.Item.FindCont rol("contract") as CheckBox;

if(cb != null)
{
if(DataBinder.E val(e.Item.Data Item,
"contract")!=DB Null.Value)
{
if(Convert.ToBo olean(DataBinde r.Eval(e.Item.D ataItem,
"contract") ) )
cb.Checked = true;
else
cb.Checked = false;
}
}
}

public void BindGrid()
{
SqlDataAdapter dAdapter = new SqlDataAdapter ("SELECT *
FROM authors ",
myConnection);
DataSet dSet= new DataSet();
dAdapter.Fill(d Set, "authors");

MyDataGrid.Data Source =
dSet.Tables["authors"].DefaultView;
MyDataGrid.Data Bind();
}

#region Web Form Designer generated code
override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form
Designer.
//
InitializeCompo nent();
base.OnInit(e);

}

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeCompo nent()
{
this.MyDataGrid .ItemDataBound += new
System.Web.UI.W ebControls.Data GridItemEventHa ndler
(this.MyDataGri d_ItemDataBound );

this.Load += new System.EventHan dler(this.Page_ Load);

}
#endregion
}
}

The problem I'm having is that the checkbox is not properly reflecting
the state of the underlying data field, which, in this case, is an SQL
2000 bit type. All of the checkboxes appear unchecked. (I want the
check box to appear checked if the underlying data field contains a "1"
and unchecked if it contains a "0".)

I added the event handler for the ItemDataBound event to
InitializeCompo nent, since that's where it seemed to make the most
sense.

Am I missing something *really* obviously wrong here?

Thanks!!!

[Nu2ASP.NET]

Thank you everyone!!!

I have since resolved the issue, but I couldn't have done it without
your help and suggestions.

I really appreciate your input!

[Nu2ASP.NET]

Thank You!

I solved the issue, and now have everthing binding as it should.

Here's my solution (in case anyone is curious):

<%@ Page language="c#" Codebehind="Web Form1.aspx.cs"
AutoEventWireup ="false" Inherits="Check BoxTest.WebForm 1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm1 </title>
<meta content="Micros oft Visual Studio .NET 7.1"
name="GENERATOR ">
<meta content="C#" name="CODE_LANG UAGE">
<meta content="JavaSc ript" name="vs_defaul tClientScript">
<meta content="http://schemas.microso ft.com/intellisense/ie5"
name="vs_target Schema">
</HEAD>
<body MS_POSITIONING= "GridLayout ">
<form id="Form1" method="post" runat="server">
<ASP:DATAGRID id="MyDataGrid " runat="server"
AutoGenerateCol umns="false" HeaderStyle-
BackColor="#aaa add" Font-Size="8pt" Font-Name="Verdana"
CellSpacing="0" CellPadding="3" ShowFooter="fal se"
BorderColor="bl ack" BackColor="#ccc cff"
Width="800" OnItemDataBound ="MyDataGrid_It emDataBound">
<Columns>
<asp:BoundColum n HeaderText="au_ id" DataField="au_i d"/>
<asp:BoundColum n HeaderText="au_ lname"
DataField="au_l name" />
<asp:TemplateCo lumn HeaderText="au_ fname">
<ItemTemplate >
<asp:Label id="au_fname" Text='<%# DataBinder.Eval
(Container.Data Item, "au_fname") %>'
runat="server" />
</ItemTemplate>
</asp:TemplateCol umn>
<asp:BoundColum n HeaderText="cit y" DataField="city " />
<asp:TemplateCo lumn HeaderText="con tract">
<HeaderTemplate >
<input type="checkbox" id="checkAll" runat="server">
Contracts
</HeaderTemplate>
<ItemTemplate >
<asp:CheckBox id="contract" AutoPostBack=Tr ue
runat="server"> </asp:CheckBox>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</ASP:DATAGRID></form>
</body>
</HTML>

Code behind:
using System;
using System.Collecti ons;
using System.Componen tModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.Sess ionState;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.H tmlControls;
using System.Data.Sql Client;

namespace CheckBoxTest
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>

public class WebForm1 : System.Web.UI.P age
{
protected System.Web.UI.W ebControls.Data Grid MyDataGrid;
SqlConnection myConnection;

private void Page_Load(objec t sender, System.EventArg s e)
{
myConnection = new SqlConnection

("Server=localh ost;uid=sa;pwd= preview;databas e=pubs");
if(!IsPostBack)
BindGrid();
}

public void MyDataGrid_Item DataBound(objec t sender,
System.Web.UI.W ebControls.Data GridItemEventAr gs e)
{
if(e.Item.ItemT ype == ListItemType.It em || e.Item.ItemType ==
ListItemType.Al ternatingItem)
{
CheckBox cb = e.Item.FindCont rol("contract") as CheckBox;
DataRowView drv = (DataRowView)e. Item.DataItem;

if(cb != null && !drv.Row.IsNull ("contract") )
{
cb.Checked = (bool)drv["contract"];
}
}

}
public void BindGrid()
{
SqlDataAdapter dAdapter = new SqlDataAdapter ("SELECT * FROM
authors ", myConnection);
DataSet dSet= new DataSet();
dAdapter.Fill(d Set, "authors");
MyDataGrid.Data Source = dSet.Tables["authors"].DefaultView;
MyDataGrid.Data Bind();
}
#region Web Form Designer generated code

override protected void OnInit(EventArg s e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form
// Designer.
//

InitializeCompo nent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>

private void InitializeCompo nent()
{
this.MyDataGrid .ItemDataBound += new
System.Web.UI.W ebControls.Data GridItemEventHa ndler
(this.MyDataGri d_ItemDataBound );
this.Load += new System.EventHan dler(this.Page_ Load);
}

#endregion
}

}

Thanks again to everyone for their help and suggestions. You were all a
great help.

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com