62,046
社区成员
发帖
与我相关
我的任务
分享
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False" Width="100%"
AllowPaging="True" DataKeyNames="ID" OnPageIndexChanging="GridView1_PageIndexChanging" PageSize="20"
CellPadding="3" Font-Size="9pt" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" >
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="CheckBox1" runat="server" checked='<%# Bind("is_work") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ID" HeaderText="序号" SortExpression="ID" />
<asp:BoundField DataField="parameter_show" HeaderText="备件名称" SortExpression="parameter_show" />
</Columns>
</asp:GridView>
<asp:Button ID="Button1" runat="server" Text="提交" OnClick="Btn_Submit_Click" />
//提交勾选信息
protected void Btn_Submit_Click(object sender, EventArgs e)
{
sqlcon = new SqlConnection(strCon);
SqlCommand sqlcom;
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
CheckBox cbox = GridView1.Rows[i].FindControl("CheckBox1") as CheckBox;
try
{
string sqlstr = "";
if (cbox.Checked == true)
{
sqlstr = "update parameterManager set is_work=1 where ID=" + GridView1.DataKeys[i].Value + "'";
}
else
{
sqlstr = "update parameterManager set is_work=0 where ID=" + GridView1.DataKeys[i].Value + "'";
}
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
}
catch (Exception ex)
{
}
sqlcon.Close();
}
Bind();
}
public void Bind()
{
string sqlstr = "select ID, parameter_show,is_work from parameterManager where parameter_show is not null";
sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "parameterManager");
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "ID" };
GridView1.DataBind();
sqlcon.Close();
}