通过外部按钮，如何将gridview选中的内容批量插入数据库 ，不含不符合未选择的

左手青春右手年华 2016-01-27 11:39:11

按钮在模板里单条选中插入的情况已经OK。
按钮不在模板里的情况，如截图所示功能。 for循环行不通，会把展示的内容都插入。
...全文
238 6 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
左手青春右手年华 2016-01-28
  • 打赏
  • 举报
 回复
引用 2 楼 ymq_2012 的回复:
点击保存按钮的时候去循环处理gridview中选中的数据，根据前面的checkbox是否选中来判断数据是否插入
正解 CheckBox cb; for (int i = 0; i < GridView1.Rows.Count; i++) { cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1"); if (cb.Checked == true) { //FindControl value string pbh = ((Label)GridView1.Rows[i].FindControl("labbm")).Text.ToString(); …… //Exec Sql } else { cb.Checked = false; //Do nothing }
左手青春右手年华 2016-01-27
  • 打赏
  • 举报
 回复
大家给个思路都可以，谢谢
起个好昵称怎么这么难呢 2016-01-27
  • 打赏
  • 举报
 回复
引用 4 楼 jxetv 的回复:
[quote=引用 2 楼 ymq_2012 的回复:] 点击保存按钮的时候去循环处理gridview中选中的数据，根据前面的checkbox是否选中来判断数据是否插入
 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        string storageid = this.DropDownList1.SelectedValue;
        string yhr = this.DropYangHuRen.SelectedItem.Text;
        string yhdt = this.txtyanghurq.Text;
        string cmd = e.CommandName;
        int i = Convert.ToInt32(e.CommandArgument);
     
        if (cmd == "save")
        {
          

            string pbh = ((Label)GridView1.Rows[i].FindControl("labbm")).Text.ToString();
            string pname = ((Label)GridView1.Rows[i].FindControl("labname")).Text.ToString();
            string ppihao = ((Label)GridView1.Rows[i].FindControl("labpihao")).Text.ToString();
            string pzhuce = ((Label)GridView1.Rows[i].FindControl("labzhuce")).Text.ToString();
            string pxiaoqi = ((HiddenField)GridView1.Rows[i].FindControl("HiddenField1")).Value.ToString();
            string pnum = ((Label)GridView1.Rows[i].FindControl("labnumber")).Text.ToString();
            string punitname = ((Label)GridView1.Rows[i].FindControl("labdanwei")).Text.ToString();
            string pspec = ((Label)GridView1.Rows[i].FindControl("labspec")).Text.ToString();
            string pcompany = ((Label)GridView1.Rows[i].FindControl("labcompany")).Text.ToString();
            string psupplier = ((Label)GridView1.Rows[i].FindControl("labsupplier")).Text.ToString();
            string pcuoshi = ((TextBox)GridView1.Rows[i].FindControl("TextBox1")).Text.ToString();
            string pbeizhu = ((TextBox)GridView1.Rows[i].FindControl("TextBox2")).Text.ToString();
            string waiguan = ((DropDownList)GridView1.Rows[i].FindControl("DropWaiGuan")).SelectedItem.Text.ToString();
            string baozhuang = ((DropDownList)GridView1.Rows[i].FindControl("DropBaoZhuang")).SelectedItem.Text.ToString();
            string zhiliang = ((DropDownList)GridView1.Rows[i].FindControl("DropZhiLiang")).SelectedItem.Text.ToString();
            string jieguo = ((DropDownList)GridView1.Rows[i].FindControl("DropResult")).SelectedItem.Text.ToString();

            string sqlfield = "[storageid],[pcode],[p_title],[p_reg],[p_spec],[p_manufactor],[p_unit],[p_count],[p_pihao],[p_xiaoqi],[p_supplier],[waiguan],[baozhuang],[zhiliang],[cuoshi],[result],[beizhu],[yanghu_emp],[yanghu_dt]";
            string sql = "insert into Gsp_YangHu(" + sqlfield + ")values('" + storageid + "','" + pbh + "','" + pname + "','" + pzhuce + "','" + pspec + "','" + pcompany + "','" + punitname + "','" + pnum + "','" + ppihao + "','" + pxiaoqi + "','" + psupplier + "','" + waiguan + "','" + baozhuang + "','" + zhiliang + "','" + pcuoshi + "','" + jieguo + "','" + pbeizhu + "','" + yhr + "','" + yhdt + "')";
            Class1.ExecSql(sql);
            this.WriteLog("添加器械养护记录成功");                    
            ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('添加成功,退出请点击下方【关闭该窗口】')", true);
             
        }
        
            



    }//RowCommand结尾
上述这段代码单独对当前行的插入操作没有任何问题，因为linkbutton在模板里面。 现在button1在gridview之外，所以就不好弄。因为这个不好控制所选行的索引了。具体这部分代码如下： 
  protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            if (this.GridView1.Rows.Count <= 0)
            {
                this.lblMessage.Visible = true;       
                this.lblMessage.Text = "请选择有商品的仓库";
                return;
            }
            else
            {
                this.lblMessage.Visible = false;              
            }

            string storageid = this.DropDownList1.SelectedValue;
            string yhr = this.DropYangHuRen.SelectedItem.Text;
            string yhdt = this.txtyanghurq.Text;
            string str_check = "(";
            string sql;
            CheckBox cb;
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1");
                cb.Checked = true;

                if (cb.Checked == true)
                {
                   
                    str_check = str_check + Convert.ToInt32(GridView1.DataKeys[i].Value) + ",";

                    // str_check = str_check.Substring(0, str_check.Length - 1) + ")";

                    string pbh = ((Label)GridView1.Rows[i].FindControl("labbm")).Text.ToString();
                    string pname = ((Label)GridView1.Rows[i].FindControl("labname")).Text.ToString();
                    string ppihao = ((Label)GridView1.Rows[i].FindControl("labpihao")).Text.ToString();
                    string pzhuce = ((Label)GridView1.Rows[i].FindControl("labzhuce")).Text.ToString();
                    string pxiaoqi = ((HiddenField)GridView1.Rows[i].FindControl("HiddenField1")).Value.ToString();
                    string pnum = ((Label)GridView1.Rows[i].FindControl("labnumber")).Text.ToString();
                    string punitname = ((Label)GridView1.Rows[i].FindControl("labdanwei")).Text.ToString();
                    string pspec = ((Label)GridView1.Rows[i].FindControl("labspec")).Text.ToString();
                    string pcompany = ((Label)GridView1.Rows[i].FindControl("labcompany")).Text.ToString();
                    string psupplier = ((Label)GridView1.Rows[i].FindControl("labsupplier")).Text.ToString();
                    string pcuoshi = ((TextBox)GridView1.Rows[i].FindControl("TextBox1")).Text.ToString();
                    string pbeizhu = ((TextBox)GridView1.Rows[i].FindControl("TextBox2")).Text.ToString();
                    string waiguan = ((DropDownList)GridView1.Rows[i].FindControl("DropWaiGuan")).SelectedItem.Text.ToString();
                    string baozhuang = ((DropDownList)GridView1.Rows[i].FindControl("DropBaoZhuang")).SelectedItem.Text.ToString();
                    string zhiliang = ((DropDownList)GridView1.Rows[i].FindControl("DropZhiLiang")).SelectedItem.Text.ToString();
                    string jieguo = ((DropDownList)GridView1.Rows[i].FindControl("DropResult")).SelectedItem.Text.ToString();

                    //去掉最后的逗号,并且加上右手号  ★示例★
                   // str_check = str_check.Substring(0, str_check.Length - 1) + ")";                  
                    //if noexists (select * from table1 where mid='aa') INSERT INTO table1(mid,name,msg) VALUES('aa','bb','cc')
                    string sqlfield = "[storageid],[pcode],[p_title],[p_reg],[p_spec],[p_manufactor],[p_unit],[p_count],[p_pihao],[p_xiaoqi],[p_supplier],[waiguan],[baozhuang],[zhiliang],[cuoshi],[result],[beizhu],[yanghu_emp],[yanghu_dt]";
                    sql = "insert into Gsp_YangHu(" + sqlfield + ")values('" + storageid + "','" + pbh + "','"+pname+"','" + pzhuce + "','" + pspec + "','" + pcompany + "','" + punitname + "','" + pnum + "','" +ppihao + "','" + pxiaoqi + "','" + psupplier + "','" + waiguan + "','" +baozhuang + "','" + zhiliang + "','" + pcuoshi + "','"+jieguo+"','"+pbeizhu+"','"+yhr+"','"+yhdt+"')";
                    Class1.ExecSql(sql);
                 
                    }
                    else
                    {
                        cb.Checked = false;

                    }
            }

            this.WriteLog("添加器械养护记录成功");                   
            ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('添加成功,退出请点击下方【关闭该窗口】')", true);

        }
        catch(Exception exc)
        {
            this.lblMessage.Visible = true;
            this.lblMessage.Text = exc.ToString();
        }
    }
}
[/quote] cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1"); cb.Checked = true; 你这块为什么直接复制为True,这样的话你的条件一直是成立的，把cb.Checked=true取消掉
左手青春右手年华 2016-01-27
  • 打赏
  • 举报
 回复
引用 2 楼 ymq_2012 的回复:
点击保存按钮的时候去循环处理gridview中选中的数据，根据前面的checkbox是否选中来判断数据是否插入
 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        string storageid = this.DropDownList1.SelectedValue;
        string yhr = this.DropYangHuRen.SelectedItem.Text;
        string yhdt = this.txtyanghurq.Text;
        string cmd = e.CommandName;
        int i = Convert.ToInt32(e.CommandArgument);
     
        if (cmd == "save")
        {
          

            string pbh = ((Label)GridView1.Rows[i].FindControl("labbm")).Text.ToString();
            string pname = ((Label)GridView1.Rows[i].FindControl("labname")).Text.ToString();
            string ppihao = ((Label)GridView1.Rows[i].FindControl("labpihao")).Text.ToString();
            string pzhuce = ((Label)GridView1.Rows[i].FindControl("labzhuce")).Text.ToString();
            string pxiaoqi = ((HiddenField)GridView1.Rows[i].FindControl("HiddenField1")).Value.ToString();
            string pnum = ((Label)GridView1.Rows[i].FindControl("labnumber")).Text.ToString();
            string punitname = ((Label)GridView1.Rows[i].FindControl("labdanwei")).Text.ToString();
            string pspec = ((Label)GridView1.Rows[i].FindControl("labspec")).Text.ToString();
            string pcompany = ((Label)GridView1.Rows[i].FindControl("labcompany")).Text.ToString();
            string psupplier = ((Label)GridView1.Rows[i].FindControl("labsupplier")).Text.ToString();
            string pcuoshi = ((TextBox)GridView1.Rows[i].FindControl("TextBox1")).Text.ToString();
            string pbeizhu = ((TextBox)GridView1.Rows[i].FindControl("TextBox2")).Text.ToString();
            string waiguan = ((DropDownList)GridView1.Rows[i].FindControl("DropWaiGuan")).SelectedItem.Text.ToString();
            string baozhuang = ((DropDownList)GridView1.Rows[i].FindControl("DropBaoZhuang")).SelectedItem.Text.ToString();
            string zhiliang = ((DropDownList)GridView1.Rows[i].FindControl("DropZhiLiang")).SelectedItem.Text.ToString();
            string jieguo = ((DropDownList)GridView1.Rows[i].FindControl("DropResult")).SelectedItem.Text.ToString();

            string sqlfield = "[storageid],[pcode],[p_title],[p_reg],[p_spec],[p_manufactor],[p_unit],[p_count],[p_pihao],[p_xiaoqi],[p_supplier],[waiguan],[baozhuang],[zhiliang],[cuoshi],[result],[beizhu],[yanghu_emp],[yanghu_dt]";
            string sql = "insert into Gsp_YangHu(" + sqlfield + ")values('" + storageid + "','" + pbh + "','" + pname + "','" + pzhuce + "','" + pspec + "','" + pcompany + "','" + punitname + "','" + pnum + "','" + ppihao + "','" + pxiaoqi + "','" + psupplier + "','" + waiguan + "','" + baozhuang + "','" + zhiliang + "','" + pcuoshi + "','" + jieguo + "','" + pbeizhu + "','" + yhr + "','" + yhdt + "')";
            Class1.ExecSql(sql);
            this.WriteLog("添加器械养护记录成功");                    
            ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('添加成功,退出请点击下方【关闭该窗口】')", true);
             
        }
        
            



    }//RowCommand结尾
上述这段代码单独对当前行的插入操作没有任何问题，因为linkbutton在模板里面。 现在button1在gridview之外，所以就不好弄。因为这个不好控制所选行的索引了。具体这部分代码如下： 
  protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            if (this.GridView1.Rows.Count <= 0)
            {
                this.lblMessage.Visible = true;       
                this.lblMessage.Text = "请选择有商品的仓库";
                return;
            }
            else
            {
                this.lblMessage.Visible = false;              
            }

            string storageid = this.DropDownList1.SelectedValue;
            string yhr = this.DropYangHuRen.SelectedItem.Text;
            string yhdt = this.txtyanghurq.Text;
            string str_check = "(";
            string sql;
            CheckBox cb;
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1");
                cb.Checked = true;

                if (cb.Checked == true)
                {
                   
                    str_check = str_check + Convert.ToInt32(GridView1.DataKeys[i].Value) + ",";

                    // str_check = str_check.Substring(0, str_check.Length - 1) + ")";

                    string pbh = ((Label)GridView1.Rows[i].FindControl("labbm")).Text.ToString();
                    string pname = ((Label)GridView1.Rows[i].FindControl("labname")).Text.ToString();
                    string ppihao = ((Label)GridView1.Rows[i].FindControl("labpihao")).Text.ToString();
                    string pzhuce = ((Label)GridView1.Rows[i].FindControl("labzhuce")).Text.ToString();
                    string pxiaoqi = ((HiddenField)GridView1.Rows[i].FindControl("HiddenField1")).Value.ToString();
                    string pnum = ((Label)GridView1.Rows[i].FindControl("labnumber")).Text.ToString();
                    string punitname = ((Label)GridView1.Rows[i].FindControl("labdanwei")).Text.ToString();
                    string pspec = ((Label)GridView1.Rows[i].FindControl("labspec")).Text.ToString();
                    string pcompany = ((Label)GridView1.Rows[i].FindControl("labcompany")).Text.ToString();
                    string psupplier = ((Label)GridView1.Rows[i].FindControl("labsupplier")).Text.ToString();
                    string pcuoshi = ((TextBox)GridView1.Rows[i].FindControl("TextBox1")).Text.ToString();
                    string pbeizhu = ((TextBox)GridView1.Rows[i].FindControl("TextBox2")).Text.ToString();
                    string waiguan = ((DropDownList)GridView1.Rows[i].FindControl("DropWaiGuan")).SelectedItem.Text.ToString();
                    string baozhuang = ((DropDownList)GridView1.Rows[i].FindControl("DropBaoZhuang")).SelectedItem.Text.ToString();
                    string zhiliang = ((DropDownList)GridView1.Rows[i].FindControl("DropZhiLiang")).SelectedItem.Text.ToString();
                    string jieguo = ((DropDownList)GridView1.Rows[i].FindControl("DropResult")).SelectedItem.Text.ToString();

                    //去掉最后的逗号,并且加上右手号  ★示例★
                   // str_check = str_check.Substring(0, str_check.Length - 1) + ")";                  
                    //if noexists (select * from table1 where mid='aa') INSERT INTO table1(mid,name,msg) VALUES('aa','bb','cc')
                    string sqlfield = "[storageid],[pcode],[p_title],[p_reg],[p_spec],[p_manufactor],[p_unit],[p_count],[p_pihao],[p_xiaoqi],[p_supplier],[waiguan],[baozhuang],[zhiliang],[cuoshi],[result],[beizhu],[yanghu_emp],[yanghu_dt]";
                    sql = "insert into Gsp_YangHu(" + sqlfield + ")values('" + storageid + "','" + pbh + "','"+pname+"','" + pzhuce + "','" + pspec + "','" + pcompany + "','" + punitname + "','" + pnum + "','" +ppihao + "','" + pxiaoqi + "','" + psupplier + "','" + waiguan + "','" +baozhuang + "','" + zhiliang + "','" + pcuoshi + "','"+jieguo+"','"+pbeizhu+"','"+yhr+"','"+yhdt+"')";
                    Class1.ExecSql(sql);
                 
                    }
                    else
                    {
                        cb.Checked = false;

                    }
            }

            this.WriteLog("添加器械养护记录成功");                   
            ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "click", "alert('添加成功,退出请点击下方【关闭该窗口】')", true);

        }
        catch(Exception exc)
        {
            this.lblMessage.Visible = true;
            this.lblMessage.Text = exc.ToString();
        }
    }
}
不断学习的ITer 2016-01-27
  • 打赏
  • 举报
 回复
你的for循环处理的不对
起个好昵称怎么这么难呢 2016-01-27
  • 打赏
  • 举报
 回复
点击保存按钮的时候去循环处理gridview中选中的数据，根据前面的checkbox是否选中来判断数据是否插入
ASP.NET程序开发范例宝典(C#)
ASP.NET程序开发范例宝典(ASP.NET程序开发范例宝典(C#)C#)
PowerShell体验记录
创建一个新的别名，可以使用Set-Alias或New-Aliascmdlets。但是需要注意的是，这些别名仅在当前 PowerShell 会话中有效。如果你希望别名在每次启动 PowerShell 时都可用，则需要将其添加到你的 PowerShell 配置文件中。Set-Alias创建可以覆盖已有别名。New-Alias也可以用来创建别名，但它主要用于定义新的别名，而不是覆盖现有的别名。如果尝试用它来覆盖现有的别名，将会失败。因此，更常用的是Set-Alias。
Twitter平台完整数据压缩包文件下载
资源下载链接为： https://pan.quark.cn/s/22ca96b7bd39 小米手机安装 Twitter 时若出现闪退，多与缺失 OBB 扩展文件有关。Google Play 为突破 APK 体积上限，允许把游戏或大型应用的高清资源打包成 main.<包名>.obb，存于 /Android/obb/ 目录。小米系统因权限或优化策略，可能无法自动放置该文件，导致 Twitter 启动即崩溃。 解决思路： 改用整合 APK 与 OBB 的 XAPK 包，借助 XAPK 安装器一键解压到正确路径； 手动把 obb 文件移至 /Android/obb/com.twitter.android/，确认应用有读写存储权限； 若仍失败，关闭 MIUI 优化、检查剩余空间或更新系统与客户端。 下载 XAPK 时务必选择可信来源，避免恶意软件。
RhinoCode521_qwen2-financial-ner-task_4708_1752501073679.zip
RhinoCode521_qwen2-financial-ner-task_4708_1752501073679
监控6805，大卡驱动、软件
监控6805，大卡驱动、软件。
.NET社区

62,243

社区成员

668,998

社区内容

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见，支持健康理性的辩论和互动，反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧

+ 用AI写文章