但愿对你有帮助:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
SqlConnection myConnection;
protected void Page_Load(Object Src, EventArgs E)
{
myConnection = new SqlConnection("server=(local)\\NetSDK;
database=pubs;
Trusted_Connection=yes");
if (!IsPostBack)
BindGrid();
}
public void BindGrid()
{
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors",
myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");
MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}
public void Show_Selected( object sender, EventArgs e)
{
foreach( DataGridItem di in MyDataGrid.Items )
{
HtmlInputCheckBox cb = (HtmlInputCheckBox)di.FindControl("contract") ;
if( cb !=null && cb.Checked )
{
Label lb = (Label)di.FindControl("au_fname");
Response.Write( lb.Text +"<br>" );
}
}
}
</script>
<body style="font: 10pt verdana">
<form runat="server" id="form1" name="form1" >
<h3>
<font face="Verdana">
Working with Checkboxes within a DataGrid
</font>
</h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="800" BackColor="#ccccff" BorderColor="black" ShowFooter="false"
CellPadding=3 CellSpacing="0" Font-Name="Verdana" Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd" AutoGenerateColumns="false" >
<Columns>
<asp:TemplateColumn HeaderText="contract" >
<HeaderTemplate>
<input type=checkbox id="checkAll" onclick="CheckAll(this);" runat="server">
Contracts
</HeaderTemplate>
<ItemTemplate>
<input type=checkbox runat="server" id="contract" onclick="UnCheck();"
checked='<%# DataBinder.Eval(Container.DataItem,
"contract") %>'/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="au_id"
DataField="au_id" />
<asp:BoundColumn HeaderText="au_lname"
DataField="au_lname" />
<asp:TemplateColumn HeaderText="au_fname" >
<ItemTemplate>
<asp:Label id="au_fname"
Text='<%# DataBinder.Eval(Container.DataItem, "au_fname") %>'
runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="city"
DataField="city" />
</Columns>
</ASP:DataGrid>
<br>
<asp:button Text="显示选中的项目" runat="server" OnClick="Show_Selected" />
<script >
var frm = document.form1 ;
function CheckAll( checkAllBox )
{
var actVar = checkAllBox.checked ;
for(i=0;i< frm.length;i++)
{
e=frm.elements[i];
if ( e.type=='checkbox' && e.name.indexOf("contract") != -1 )
e.checked= actVar ;
}
}
function UnCheck()
{
for(i=0;i< frm.length;i++)
{
e=frm.elements[i];
if ( e.type=='checkbox' && e.name.indexOf("checkAll") != -1 )
{
e.checked= false ;
break;
}
}
}
</script></form></body></html>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<script language="C#" runat="server">
SqlConnection myConnection;
protected void Page_Load(Object Src, EventArgs E)
{
myConnection = new SqlConnection("server=(local)\\NetSDK;
database=pubs;
Trusted_Connection=yes");
if (!IsPostBack)
BindGrid();
}
public void BindGrid()
{
SqlDataAdapter myCommand = new SqlDataAdapter("select * from Authors",
myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");
MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
}
public void Show_Selected( object sender, EventArgs e)
{
foreach( DataGridItem di in MyDataGrid.Items )
{
HtmlInputCheckBox cb = (HtmlInputCheckBox)di.FindControl("contract") ;
if( cb !=null && cb.Checked )
{
Label lb = (Label)di.FindControl("au_fname");
Response.Write( lb.Text +"<br>" );
}
}
}
</script>
<body style="font: 10pt verdana">
<form runat="server" id="form1" name="form1" >
<h3>
<font face="Verdana">
Working with Checkboxes within a DataGrid
</font>
</h3>
<ASP:DataGrid id="MyDataGrid" runat="server"
Width="800" BackColor="#ccccff" BorderColor="black" ShowFooter="false"
CellPadding=3 CellSpacing="0" Font-Name="Verdana" Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd" AutoGenerateColumns="false" >
<Columns>
<asp:TemplateColumn HeaderText="contract" >
<HeaderTemplate>
<input type=checkbox id="checkAll" onclick="CheckAll(this);" runat="server">
Contracts
</HeaderTemplate>
<ItemTemplate>
<input type=checkbox runat="server" id="contract" onclick="UnCheck();"
checked='<%# DataBinder.Eval(Container.DataItem,
"contract") %>'/>
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="au_id"
DataField="au_id" />
<asp:BoundColumn HeaderText="au_lname"
DataField="au_lname" />
<asp:TemplateColumn HeaderText="au_fname" >
<ItemTemplate>
<asp:Label id="au_fname"
Text='<%# DataBinder.Eval(Container.DataItem, "au_fname") %>'
runat="server" />
</ItemTemplate>
</asp:TemplateColumn>
<asp:BoundColumn HeaderText="city"
DataField="city" />
</Columns>
</ASP:DataGrid>
<br>
<asp:button Text="显示选中的项目" runat="server" OnClick="Show_Selected" />
<script >
var frm = document.form1 ;
function CheckAll( checkAllBox )
{
var actVar = checkAllBox.checked ;
for(i=0;i< frm.length;i++)
{
e=frm.elements[i];
if ( e.type=='checkbox' && e.name.indexOf("contract") != -1 )
e.checked= actVar ;
}
}
function UnCheck()
{
for(i=0;i< frm.length;i++)
{
e=frm.elements[i];
if ( e.type=='checkbox' && e.name.indexOf("checkAll") != -1 )
{
e.checked= false ;
break;
}
}
}
</script></form></body></html>
"<%#(Boolean)Alert(DataBinder.Eval(Container.DataItem,"Alert"))% >
我说清楚些!
因为Alert字段的值有'Y','N','W','P'等!
如何是'Y','W',CheckBox的Checked=true
如果是其他,checked=false;
如何办?
if filename='y' or filename='w' then
return true
else
return false
end if
end sub--------------------------
试试这个!
不要双引号
Checked=<%#Alert(DataBinder.Eval(Container.DataItem,"Alert"))%>