急求

[xiaocao013]

利用Checkbox来选中所要删除的datalist的多个选项的完全代码

[酷儿]

遍历你的每一行 如果处于选中的话就删 你的每一行的checkbox的value设置成数据的id 或是你要根据删除的列

[DataBox-MDX]

private void button1_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow Row in this.dataGridView1)
            {
                List<string> DeleteSqls =new List<string>();
                if (Row.Cells[0].Value == "true")
                {
                    string Id = Row.Cells[1].Value.ToString();
                    string Sql = "Delete From TaleName Where ID="+Id;
                    DeleteSqls.Add(Sql);
                }
            }
            if (MessageBox.Show("确定要全部删除吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            {
                ExecuteNoParameterSQLs(DeleteSqls);
            }
        }
        /// <summary>
        /// 执行多条不带参数的SQl语句，如同时进行多条删除操作的sql语句
        /// </summary>
        /// <param name="sqlstrs"></param>
        /// <returns></returns>
        public static int ExecuteNoParameterSQLs(IList<string> sqlstrs)
        {
            //SqlConnection MyCon = new SqlConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["HZB_DAL_connectionString"].ToString()));
            using (SqlConnection MyCon = new SqlConnection(CON_STR))//执行完期间的代码，将销毁期间定义的所有对象
            {
                using (SqlCommand MyCom = new SqlCommand())
                {
                    int k = 0;
                    MyCom.Connection = MyCon;
                    MyCon.Open();
                    SqlTransaction Mytra = MyCon.BeginTransaction();


                    MyCom.Transaction = Mytra;
                    try
                    {
                        foreach (string sql in sqlstrs)
                        {
                            MyCom.CommandText = sql;
                            k = MyCom.ExecuteNonQuery();
                        }
                        Mytra.Commit();
                        return k;
                    }

                    catch (SqlException ex)
                    {
                        Mytra.Rollback();
                        throw new Exception(ex.Message);
                    }
                    finally
                    {
                        MyCon.Close();
                        MyCon.Dispose();
                    }
                }
            }
        }

[DataBox-MDX]

上面的：Row.Cells[0].Value == "true"表示你的Check是在第一列
string Id = Row.Cells[1].Value.ToString();表示你的ID值显示在第二列，根据LZ的情况不同而不同

[hookyzlr]

CheckBox cb;
        int id;

        foreach (DataListItem item in GRCB.Items)
        {
            id = Int32.Parse(GRCB.DataKeys[item.ItemIndex].ToString());
            cb = (CheckBox)(item.FindControl("CheckBox4"));
            if (cb.Checked)
            {
                myGRCB.Remove(id);
            }
        }

[itrefer]

这个用Html的checkbox好做

[csdnflys]

先收藏着，明天来了看~~

[Tanhualin]

 $(".cssDeleteBtn").click(function () {
        var HasSelected = false;
        for (var i = 0; i < $(".gvModuleRowsCss").length; i++) {
            if ($(".gvModuleHeaderCss").siblings(".gvModuleRowsCss:eq(" + i + ")").find(":checkbox").attr("checked")) {
                HasSelected = true;
            }
            if (HasSelected) {
                break;
            }
        }
        if (!HasSelected) {
            confirm("请选择您要删除的项");
            return false;
        }
        else {
            return confirm("您确定删除所选的记录么");
        }
    });

[智者知已应修善业]