The result is as follows:
Front-end JS:
< Script Language = " Javascript " Type = " Text/JavaScript " >
VaR list = Document. getelementsbyname ( " Ch " );
Window. onload = Function ()
{
For (VAR I = 0 ; I < List. length; I ++ )
{
List [I]. onclick = Chkclick;
}
}
Function chkclick ()
{
VaR listvar = "" ;
For (VAR I = 0 ; I < List. length; I ++ )
{
If (List [I]. Checked )
{
Listvar + = List [I]. Value + " , " ;
}
}
Document. getelementbyid ( " Hiddenfield1 " ). Value = Listvar. substring ( 0 , Listvar. Length - 1 );
}
Function allclick ()
{
VaR C = Document. getelementbyid ( " Chk " );
If (C. Checked )
{
VaR listvar = "" ;
For (VAR I = 0 ; I < List. length; I ++ )
{
List [I]. Checked = True ;
Listvar + = List [I]. Value + " , " ;
}
Document. getelementbyid ( " Hiddenfield1 " ). Value = Listvar; // . Substring (0, listvar. Length-1 );
}
Else
{
For (VAR I = 0 ; I < List. length; I ++ )
{
List [I]. Checked = False ;
}
Document. getelementbyid ( " Hiddenfield1 " ). Value = "" ;
}
}
</ Script >
Front-end:
< ASP: gridview ID = " Gridview1 " Autogeneratecolumns = " False " Runat = " Server " >
< Columns >
< ASP: templatefield headertext = " Select All " >
< Itemtemplate >
< Input name = " Ch " Value = " <% # Eval ( " Stu_no " ) %> " Type = " Checkbox " />
</ Itemtemplate >
</ ASP: templatefield >
< ASP: boundfield datafield = " Stu_no " Headertext = " Student ID " />
< ASP: boundfield datafield = " Stu_name " Headertext = " Name " />
< ASP: boundfield datafield = " Stu_sex " Headertext = " Gender " />
</ Columns >
</ ASP: gridview >
< Input ID = " Chk " Onclick = " Allclick () " Type = " Checkbox " /> < ASP: hiddenfield ID = " Hiddenfield1 "
Runat = " Server " />
< ASP: button ID = " Button1 " Runat = " Server " Onclick = " Button#click " Text = " Button " /> </ Div >
BackgroundCode:
View code
Protected Void Button#click ( Object Sender, eventargs E)
{
String S = This . Hiddenfield1.value;
String [] SS = S. Split ( ' , ' );
Sqlconnection con = New Sqlconnection ( @" Data Source =. \ sqlexpress; initial catalog = northwind; Integrated Security = true " );
For ( Int I = 0 ; I < This . Gridview1.rows. Count; I ++ )
{
Sqlcommand cmd = New Sqlcommand ();
Cmd. Connection = Con;
Cmd. commandtext = " Delete from university student information table where stu_no = @ stu_no " ;
Sqlparameter sp = New Sqlparameter ( " @ Stu_no " , Sqldbtype. nchar, 10 );
Sp. Value = Ss [I];
Cmd. Parameters. Add (SP );
Con. open ();
Cmd. executenonquery ();
Con. Close ();
}
Databind ();
}