如何忽略datagridview中的空白行 [英] how to ignoring blank rows in datagridview

问题描述

如何在datgridview中停止空白行的循环


这是我的代码

how to stop loop for blank rows in datgridview


here is my code

for (int i = 0; i < dataGridView1.Rows.Count ; )
               {

                       AC_code = dataGridView1[0, i].Value.ToString();

                       SqlCommand cmd3 = new SqlCommand("select AC_CODE from accountd where compcode=''" + Compcls.Gcomp_cd + "''and Name=''" + AC_code + "''", con, trans);
                       AC_cod = cmd3.ExecuteScalar().ToString();
                       string ddd; string eee; string fff; string cno; string cdate; string bank; string branch;
                       ddd = dataGridView1[2, i].Value == null ? string.Empty : dataGridView1[2, i].Value.ToString();
                       eee = dataGridView1[1, i].Value == null ? string.Empty : dataGridView1[1, i].Value.ToString();
                       fff = dataGridView1[3, i].Value == null ? string.Empty : dataGridView1[3, i].Value.ToString();
                       cno = dataGridView1[5, i].Value == null ? string.Empty : dataGridView1[5, i].Value.ToString();
                       cdate = dataGridView1[6, i].Value == null ? string.Empty : dataGridView1[6, i].Value.ToString();
                       bank = dataGridView1[7, i].Value == null ? string.Empty : dataGridView1[7, i].Value.ToString();
                       branch = dataGridView1[8, i].Value == null ? string.Empty : dataGridView1[8, i].Value.ToString();
                       string dgdat = "INSERT INTO VCHAMT (compcode,VOU_TYPE,VOU_NO,AMOUNT,VOU_DT,DR_CR,NARRATION,AC_CODE,CHEQUE_NO,CHEQUE_DT,BANK_NAME,BRANCH)values(''" + Compcls.Gcomp_cd + "'',''" + vctype + "'',''" + txtvoucherno.Text + "'',''" + ddd + "'',''" + (Convert.ToDateTime(dateTimePicker1.Text)).ToString("yyyy/MM/dd") + "'',''" + eee + "'',''" + fff + "'',''" + AC_cod + "'',''" + cno + "'',''" + cdate + "'',''" + bank + "'',''" + branch + "'')";
                       SqlCommand cmd1 = new SqlCommand(dgdat, con, trans);                                                                                                                                 //cash_c_d= sum > 0 ? cash_c_d = "D" : cash_c_d = "C";
                       cmd1.ExecuteNonQuery();

                       i++;
               }
               trans.Commit();
               toolTip1.IsBalloon = true;
               toolTip1.ToolTipIcon = ToolTipIcon.Info;
               toolTip1.ToolTipTitle = "SAVED";
               toolTip1.Show("SAVED", mainpanell, 0, 0, 2000);
           }
           catch (Exception Ex)
           {
               trans.Rollback();
               MessageBox.Show(Ex.Message);
           }

谢谢高级

thanks in advanced

推荐答案

如果所有值均为null或字符串，请不要执行插入查询.空

Don''t execute insert query if all values are null or string.Empty

不确定是否这是最好的方法，但是您可以在插入代码之前放置条件.

Not sure if this is the best way, but you can put condition before insert code.

if(!string.IsNullOrEmpty(ddd) && !string.IsNullOrEmpty(eee)) // check for all the variables
                        {

                        string dgdat = "INSERT INTO VCHAMT (compcode,VOU_TYPE,VOU_NO,AMOUNT,VOU_DT,DR_CR,NARRATION,AC_CODE,CHEQUE_NO,CHEQUE_DT,BANK_NAME,BRANCH)values('" + Compcls.Gcomp_cd + "','" + vctype + "','" + txtvoucherno.Text + "','" + ddd + "','" + (Convert.ToDateTime(dateTimePicker1.Text)).ToString("yyyy/MM/dd") + "','" + eee + "','" + fff + "','" + AC_cod + "','" + cno + "','" + cdate + "','" + bank + "','" + branch + "')";
                        SqlCommand cmd1 = new SqlCommand(dgdat, con, trans);                                                                                                                                
                        cmd1.ExecuteNonQuery();
                        }

这篇关于如何忽略datagridview中的空白行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！