forum

Home / DeveloperSection / Forums / Compare value of datagrid with value of selected from database

Compare value of datagrid with value of selected from database

Demir ACAR230824-May-2014
  for (int i = 0; i < dataGridView1.RowCount-1; i++)
                if (radioButton1.Checked == true)
                {
                    string strConn = @"Data Source='" + dbconfig.tb1 + "';Initial Catalog='" + dbconfig.tb2 + "';user='" + dbconfig.tb3 + "';pwd='" + dbconfig.tb4 + "'";
                    SqlConnection conn = new SqlConnection(strConn);
                    conn.Open();
                    SqlCommand cmd = new SqlCommand("SELECT CODE  FROM LG_" + dbconfig.tb5 + "_table", conn);
                    cmd.ExecuteNonQuery();
                    SqlDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        if (reader["CODE"].ToString() != dataGridView1.Rows[i++].Cells[2].Value.ToString())
                        {
                            MessageBox.Show(dataGridView1.Rows[i].Cells[2].Value.ToString());
                        }
                    
                    }
                    conn.Close();
            }
        }

Updated on 27-May-2014

Can you answer this question?


Answer

2 Answers

Liked By