日期:2014-05-18 浏览次数:21055 次
       for (int i = 0; i < dgv_Data2.Rows.Count - 1; i++)
            {
                for (int j = 1; j < dgv_Data2.Rows.Count - 1; j++)
                {
                    if ((i + j) <= dgv_Data2.Rows.Count)
                    {
                        string value1 = Convert.ToString(dgv_Data2.Rows[i].Cells[2].Value);
                        string value2 = Convert.ToString(dgv_Data2.Rows[i + j].Cells[2].Value);
                        if (value1 == value2)
                        {
                            MessageBox.Show("此货物已存在!");
                        }
                       else
                        {
                            string name = dgv_Data2.Rows[i].Cells[2].Value.ToString();
                            string sql = "select * from MIS_MaterielRegiser where MR_Name='" + name + "'";
                       
                            ocmd = new OleDbCommand(sql, ocnn);
                            OleDbDataReader reader = ocmd.ExecuteReader();
                            reader.Read();
                            dgv_Data2.Rows[i].Cells[1].Value = reader["MR_Number"].ToString();
                            dgv_Data2.Rows[i].Cells[3].Value = reader["MR_Model"].ToString();
                            dgv_Data2.Rows[i].Cells[4].Value = reader["MR_Unit"].ToString();
                        }
                    } 
                    
                }
            }
int length = dgv_Data2.Rows.Count - 1; 
for (int i = 0; i <length ; i++)
            {
                for (int j = length; j > i; j--)
           { 
                       string value1 = Convert.ToString(dgv_Data2.Rows[j].Cells[2].Value);
                       string value2 = Convert.ToString(dgv_Data2.Rows[j-1].Cells[2].Value);
if (value1 == value2)
                        {
                            MessageBox.Show("此货物已存在!");
                        }
                       else
                        {
                            string name = dgv_Data2.Rows[i].Cells[2].Value.ToString();
                            string sql = "select * from MIS_MaterielRegiser where MR_Name='" + name + "'";
                       
                            ocmd = new OleDbCommand(sql, ocnn);
                            OleDbDataReader reader = ocmd.ExecuteReader();
                            reader.Read();
                            dgv_Data2.Rows[i].Cells[1].Value = reader["MR_Number"].ToString();
                            dgv_Data2.Rows[i].Cells[3].Value = reader["MR_Model"].ToString();
                            dgv_Data2.Rows[i].Cells[4].Value = reader["MR_Unit"].ToString();
                        }
               }
            }
------解决方案--------------------
你是要比较所有的行么?
for (int j = 0; j < dgv_Data2.Rows.Count - 1; j++)
               {
                   if (i!=j)
                   {
                      string value1 = Convert.ToString(dgv_Data2.Rows[i].Cells[2].Value);
                      string value2 = Convert.ToString(dgv_Data2.Rows[j].Cells[2].Value);