急求
利用Checkbox来选中所要删除的datalist的多个选项的完全代码 --------------------编程问答-------------------- 遍历你的每一行 如果处于选中的话就删 你的每一行的checkbox的value设置成数据的id 或是你要根据删除的列 --------------------编程问答----------------------------------------编程问答-------------------- 上面的:Row.Cells[0].Value == "true"表示你的Check是在第一列
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();
}
}
}
}
string Id = Row.Cells[1].Value.ToString();表示你的ID值显示在第二列,根据LZ的情况不同而不同
--------------------编程问答--------------------
--------------------编程问答-------------------- 这个用Html的checkbox好做 --------------------编程问答-------------------- 先收藏着,明天来了看~~ --------------------编程问答--------------------
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);
}
}
--------------------编程问答--------------------
$(".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("您确定删除所选的记录么");
}
});
补充:.NET技术 , ASP.NET